APPS.AP_APXINUPD_XMLP_PKG dependencies on AP_RECURRING_PAYMENTS

Line 508: AP_RECURRING_PAYMENTS_ALL ARP1

504: SELECT
505: COUNT(*)
506: INTO L_NUM_DUP_RECURRING
507: FROM
508: AP_RECURRING_PAYMENTS_ALL ARP1
509: WHERE VENDOR_ID = C_DUP_VENDOR_ID
510: AND VENDOR_SITE_ID = C_DUP_VENDOR_SITE_ID
511: AND EXISTS (
512: SELECT

Line 515: AP_RECURRING_PAYMENTS_ALL ARP2

511: AND EXISTS (
512: SELECT
513: 'this would be a duplicate'
514: FROM
515: AP_RECURRING_PAYMENTS_ALL ARP2
516: WHERE ARP2.VENDOR_ID = C_VENDOR_ID
517: AND ARP2.VENDOR_SITE_ID = C_VENDOR_SITE_ID
518: AND ARP2.RECURRING_PAY_NUM = ARP1.RECURRING_PAY_NUM );
519: RETURN (L_NUM_DUP_RECURRING);

Line 534: AP_RECURRING_PAYMENTS arp1

530: DECLARE
531: L_NUM_RECURRING NUMBER;
532: BEGIN
533: UPDATE
534: AP_RECURRING_PAYMENTS arp1
535: SET
536: VENDOR_ID = C_VENDOR_ID
537: ,VENDOR_SITE_ID = C_VENDOR_SITE_ID
538: ,LAST_UPDATED_BY = P_LAST_UPDATED_BY_T

Line 546: AP_RECURRING_PAYMENTS ARP2

542: AND NOT EXISTS (
543: SELECT
544: 'this would be a duplicate'
545: FROM
546: AP_RECURRING_PAYMENTS ARP2
547: WHERE ARP2.VENDOR_ID = C_VENDOR_ID
548: AND ARP2.VENDOR_SITE_ID = C_VENDOR_SITE_ID
549: AND ARP2.RECURRING_PAY_NUM = ARP1.RECURRING_PAY_NUM );
550: L_NUM_RECURRING := SQL%ROWCOUNT;