OKS_AUTH_UTIL_PUB.COMPUTE_PRICE_MULTIPLE_LINE API in Service Contracts

Here is sample piece of code, for the APIOKS_AUTH_UTIL_PUB.COMPUTE_PRICE_MULTIPLE_LINE in Service Contracts.

DECLARE

   l_multi_line_tbl   apps.oks_auth_util_pub.multi_line_tbl;

   l_return_status    VARCHAR2 (1);

   l_status_tbl       apps.oks_qp_int_pvt.pricing_status_tbl;

BEGIN

   l_multi_line_tbl (0).ID := 100;      -- ID column from okc_k_lines_b table

   l_multi_line_tbl (0).lse_id := 46;               -- Line Type SUBSCRIPTION

   l_multi_line_tbl (0).line_pl_flag := 'Y';           -- Partial Update Flag

   l_return_status := NULL;

   -- Call the API to Reprice the Multiple lines

   apps.oks_auth_util_pub.compute_price_multiple_line

                                         (p_api_version        => 1.0,

                                          p_detail_tbl         => l_multi_line_tbl,

                                          x_return_status      => l_return_status,

                                          x_status_tbl         => l_status_tbl

                                         );

   IF NVL (l_return_status, 'E') = 'S'

   THEN

      DBMS_OUTPUT.put_line ('Price Updated Successfully');

   ELSE

      DBMS_OUTPUT.put_line ('Error in Updating Price Adjustment ');

   END IF;

END;