APPS.PNT_PAYMENT_ITEMS_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 71: FROM PN_PAYMENT_ITEMS_ALL

67: IS
68:
69: CURSOR c IS
70: SELECT ROWID
71: FROM PN_PAYMENT_ITEMS_ALL
72: WHERE PAYMENT_ITEM_ID = X_PAYMENT_ITEM_ID;
73:
74: l_org_id NUMBER;
75:

Line 113: INSERT INTO pn_payment_items_all (

109: l_org_ID := x_org_ID;
110: END IF;
111: END IF;
112:
113: INSERT INTO pn_payment_items_all (
114: PAYMENT_ITEM_ID,
115: LAST_UPDATE_DATE,
116: LAST_UPDATED_BY,
117: CREATION_DATE,

Line 272: FROM pn_payment_items_all

268: IS
269:
270: CURSOR c1 IS
271: SELECT *
272: FROM pn_payment_items_all
273: WHERE payment_item_id = x_payment_item_id
274: FOR UPDATE OF payment_item_id NOWAIT;
275:
276: tlinfo c1%ROWTYPE;

Line 492: SELECT currency_code FROM pn_payment_items_all WHERE payment_item_id = X_PAYMENT_ITEM_ID;

488: l_ext_precision NUMBER;
489: l_min_acct_unit NUMBER;
490:
491: CURSOR currency_cur IS
492: SELECT currency_code FROM pn_payment_items_all WHERE payment_item_id = X_PAYMENT_ITEM_ID;
493: BEGIN
494:
495: PNP_DEBUG_PKG.debug ('PN_PAYMENT_ITEMS_PKG.update_row (+)');
496:

Line 505: UPDATE pn_payment_items_all

501: ,ext_precision => l_ext_precision
502: ,min_acct_unit => l_min_acct_unit);
503: END LOOP;
504:
505: UPDATE pn_payment_items_all
506: SET VENDOR_ID = X_VENDOR_ID,
507: DUE_DATE = X_DUE_DATE,
508: CUSTOMER_ID = X_CUSTOMER_ID,
509: VENDOR_SITE_ID = X_VENDOR_SITE_ID,

Line 571: DELETE FROM pn_payment_items_all

567: )
568: IS
569: BEGIN
570:
571: DELETE FROM pn_payment_items_all
572: WHERE payment_item_id = x_payment_item_id;
573:
574: IF (SQL%NOTFOUND) THEN
575: RAISE NO_DATA_FOUND;