APPS.ARP_CMERGE_ARTRX dependencies on AR_RECEIVABLE_APPLICATIONS

Line 665: -- Bug 9155869 Added this procudure to update ar_receivable_applications table.

661: RAISE;
662: END ra_ctl;
663:
664:
665: -- Bug 9155869 Added this procudure to update ar_receivable_applications table.
666: PROCEDURE ar_ra (
667: req_id NUMBER,
668: set_num NUMBER,
669: process_mode VARCHAR2) IS

Line 677: ar_receivable_applications.receivable_application_id%TYPE

673: INDEX BY BINARY_INTEGER;
674: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
675:
676: TYPE ra_id_LIST_TYPE IS TABLE OF
677: ar_receivable_applications.receivable_application_id%TYPE
678: INDEX BY BINARY_INTEGER;
679: PRIMARY_KEY_ID_LIST ra_id_LIST_TYPE;
680:
681: TYPE cust_id_LIST_TYPE IS TABLE OF

Line 682: ar_receivable_applications.on_acct_cust_id%TYPE

678: INDEX BY BINARY_INTEGER;
679: PRIMARY_KEY_ID_LIST ra_id_LIST_TYPE;
680:
681: TYPE cust_id_LIST_TYPE IS TABLE OF
682: ar_receivable_applications.on_acct_cust_id%TYPE
683: INDEX BY BINARY_INTEGER;
684: NUM_COL1_ORIG_LIST cust_id_LIST_TYPE;
685: NUM_COL1_NEW_LIST cust_id_LIST_TYPE;
686:

Line 688: ar_receivable_applications.on_acct_cust_site_use_id%TYPE

684: NUM_COL1_ORIG_LIST cust_id_LIST_TYPE;
685: NUM_COL1_NEW_LIST cust_id_LIST_TYPE;
686:
687: TYPE cust_site_use_id_LIST_TYPE IS TABLE OF
688: ar_receivable_applications.on_acct_cust_site_use_id%TYPE
689: INDEX BY BINARY_INTEGER;
690: NUM_COL2_ORIG_LIST cust_site_use_id_LIST_TYPE;
691: NUM_COL2_NEW_LIST cust_site_use_id_LIST_TYPE;
692:

Line 700: FROM ar_receivable_applications yt, ra_customer_merges m

696: SELECT distinct CUSTOMER_MERGE_HEADER_ID
697: ,receivable_application_id
698: ,on_acct_cust_id
699: ,on_acct_cust_site_use_id
700: FROM ar_receivable_applications yt, ra_customer_merges m
701: WHERE (yt.on_acct_cust_id = m.DUPLICATE_ID AND
702: nvl(yt.on_acct_cust_site_use_id,m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID)
703: AND m.process_flag = 'N'
704: AND m.request_id = req_id

Line 714: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ar_receivable_applications',FALSE);

710: IF process_mode='LOCK' THEN
711: NULL;
712: ELSE
713: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
714: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ar_receivable_applications',FALSE);
715: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
716: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
717:
718: open merged_records;

Line 755: 'ar_receivable_applications',

751: LAST_UPDATE_LOGIN,
752: LAST_UPDATE_DATE,
753: LAST_UPDATED_BY
754: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
755: 'ar_receivable_applications',
756: MERGE_HEADER_ID_LIST(I),
757: PRIMARY_KEY_ID_LIST(I),
758: NUM_COL1_ORIG_LIST(I),
759: NUM_COL1_NEW_LIST(I),

Line 773: UPDATE ar_receivable_applications yt SET

769: );
770: END IF;
771:
772: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
773: UPDATE ar_receivable_applications yt SET
774: on_acct_cust_id=NUM_COL1_NEW_LIST(I)
775: ,on_acct_cust_site_use_id=NUM_COL2_NEW_LIST(I)
776: , LAST_UPDATE_DATE=SYSDATE
777: , last_updated_by=arp_standard.profile.user_id