289: UPDATE pn_payment_items_all ppi
290: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
291: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
292: ppi.last_update_date = SYSDATE,
293: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
294: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
295: WHERE ppi.payment_schedule_id = g_norm_item_tbl(i).schedule_id
296: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
297: AND ppi.payment_term_id = p_term_id;
290: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
291: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
292: ppi.last_update_date = SYSDATE,
293: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
294: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
295: WHERE ppi.payment_schedule_id = g_norm_item_tbl(i).schedule_id
296: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
297: AND ppi.payment_term_id = p_term_id;
298:
332: VALUES
333: (
334: PN_PAYMENT_ITEMS_S.NEXTVAL,
335: SYSDATE,
336: NVL(fnd_profile.value('USER_ID'),0),
337: SYSDATE,
338: NVL(fnd_profile.value('USER_ID'),0),
339: NVL(fnd_profile.value('LOGIN_ID'),0),
340: g_norm_item_tbl(i).normalized_amount,
334: PN_PAYMENT_ITEMS_S.NEXTVAL,
335: SYSDATE,
336: NVL(fnd_profile.value('USER_ID'),0),
337: SYSDATE,
338: NVL(fnd_profile.value('USER_ID'),0),
339: NVL(fnd_profile.value('LOGIN_ID'),0),
340: g_norm_item_tbl(i).normalized_amount,
341: NULL,
342: g_norm_item_tbl(i).schedule_date,
335: SYSDATE,
336: NVL(fnd_profile.value('USER_ID'),0),
337: SYSDATE,
338: NVL(fnd_profile.value('USER_ID'),0),
339: NVL(fnd_profile.value('LOGIN_ID'),0),
340: g_norm_item_tbl(i).normalized_amount,
341: NULL,
342: g_norm_item_tbl(i).schedule_date,
343: 'NORMALIZED',
748: UPDATE pn_payment_items_all ppi
749: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
750: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
751: ppi.last_update_date = SYSDATE,
752: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
753: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
754: WHERE ppi.payment_schedule_id = g_norm_item_tbl(i).schedule_id
755: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
756: AND ppi.payment_term_id = p_term_id;
749: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
750: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
751: ppi.last_update_date = SYSDATE,
752: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
753: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
754: WHERE ppi.payment_schedule_id = g_norm_item_tbl(i).schedule_id
755: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
756: AND ppi.payment_term_id = p_term_id;
757:
788: org_id)
789: VALUES
790: (PN_PAYMENT_ITEMS_S.NEXTVAL,
791: SYSDATE,
792: NVL(fnd_profile.value('USER_ID'),0),
793: SYSDATE,
794: NVL(fnd_profile.value('USER_ID'),0),
795: NVL(fnd_profile.value('LOGIN_ID'),0),
796: g_norm_item_tbl(i).normalized_amount,
790: (PN_PAYMENT_ITEMS_S.NEXTVAL,
791: SYSDATE,
792: NVL(fnd_profile.value('USER_ID'),0),
793: SYSDATE,
794: NVL(fnd_profile.value('USER_ID'),0),
795: NVL(fnd_profile.value('LOGIN_ID'),0),
796: g_norm_item_tbl(i).normalized_amount,
797: NULL,
798: g_norm_item_tbl(i).schedule_date,
791: SYSDATE,
792: NVL(fnd_profile.value('USER_ID'),0),
793: SYSDATE,
794: NVL(fnd_profile.value('USER_ID'),0),
795: NVL(fnd_profile.value('LOGIN_ID'),0),
796: g_norm_item_tbl(i).normalized_amount,
797: NULL,
798: g_norm_item_tbl(i).schedule_date,
799: 'NORMALIZED',