DBA Data[Home] [Help]

APPS.GML_OP_CUST_MST_PKG dependencies on OP_UPDT_BAL_WK

Line 13: # To update the customer balances in op_cust_mst and op_updt_bal_wk

9: #
10: # DESCRIPTION
11: #
12: #
13: # To update the customer balances in op_cust_mst and op_updt_bal_wk
14: #
15: #
16: # MODIFICATION HISTORY
17: #

Line 131: INSERT INTO op_updt_bal_wk (session_id, cust_no, cust_name, error_message,

127: ELSE
128: X_currency := X_base_currency;
129: END IF;
130: IF(X_currency IS NULL) THEN
131: INSERT INTO op_updt_bal_wk (session_id, cust_no, cust_name, error_message,
132: created_by, creation_date, last_update_date, last_updated_by,
133: last_update_login) VALUES
134: (
135: V_session_id,

Line 155: INSERT INTO op_updt_bal_wk (session_id, cust_no, cust_name, error_message,

151: CLOSE Cur_get_exchange_rate;
152: X_exch_rate := X_exchange_rate_rec.exchange_rate;
153: END IF;
154: IF(X_exch_rate IS NULL) THEN
155: INSERT INTO op_updt_bal_wk (session_id, cust_no, cust_name, error_message,
156: created_by, creation_date, last_update_date, last_updated_by,
157: last_update_login) VALUES
158: (
159: V_session_id,