APPS.PN_EXP_PAYMENT_ITEMS_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 33: FROM PN_PAYMENT_ITEMS_ALL

29: RATE,
30: DUE_DATE,
31: AP_INVOICE_NUM,
32: GROUPING_RULE_ID
33: FROM PN_PAYMENT_ITEMS_ALL
34: WHERE PAYMENT_ITEM_ID = X_PAYMENT_ITEM_ID
35: FOR UPDATE OF PAYMENT_ITEM_ID NOWAIT;
36:
37: CURSOR c2 IS

Line 110: -- Updated accounted_amount in pn_payment_items_all as

106: -- GROUPING_RULE_ID and AP_INVOICE_NUM
107: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced PN_PAYMENT_ITEMS with _ALL table
108: -- 24-NOV-05 Kiran o round amount before insert/update into term/item
109: -- 10-AUG-06 sdmahesh o Bug 5283912
110: -- Updated accounted_amount in pn_payment_items_all as
111: -- actual_amount * x_rate
112: --------------------------------------------------------------------------------
113:
114: PROCEDURE UPDATE_ROW (

Line 159: UPDATE PN_PAYMENT_ITEMS_ALL

155: END IF;
156:
157: l_info_text := 'updating normalized item amount';
158: IF X_NORM_ITM_ID IS NOT NULL THEN
159: UPDATE PN_PAYMENT_ITEMS_ALL
160: SET export_currency_amount = l_norm_export_amt,
161: export_currency_code = x_export_currency_code,
162: rate = x_rate,
163: accounted_amount = actual_amount * x_rate,

Line 171: UPDATE PN_PAYMENT_ITEMS_ALL

167: WHERE payment_item_id = x_norm_itm_id;
168: END IF;
169:
170: l_info_text := 'updating cash item data';
171: UPDATE PN_PAYMENT_ITEMS_ALL
172: SET EXPORT_TO_AP_FLAG = X_EXPORT_TO_AP_FLAG,
173: EXPORT_TO_AR_FLAG = X_EXPORT_TO_AR_FLAG,
174: EXPORT_CURRENCY_AMOUNT = l_export_amt,
175: EXPORT_CURRENCY_CODE = X_EXPORT_CURRENCY_CODE,