APPS.ARP_CMERGE_ARTRX dependencies on AR_DISTRIBUTIONS

Line 812: AR_DISTRIBUTIONS.line_id%TYPE

808: INDEX BY BINARY_INTEGER;
809: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
810:
811: TYPE line_id_LIST_TYPE IS TABLE OF
812: AR_DISTRIBUTIONS.line_id%TYPE
813: INDEX BY BINARY_INTEGER;
814: PRIMARY_KEY_ID_LIST line_id_LIST_TYPE;
815:
816: TYPE third_party_id_LIST_TYPE IS TABLE OF

Line 817: AR_DISTRIBUTIONS.third_party_id%TYPE

813: INDEX BY BINARY_INTEGER;
814: PRIMARY_KEY_ID_LIST line_id_LIST_TYPE;
815:
816: TYPE third_party_id_LIST_TYPE IS TABLE OF
817: AR_DISTRIBUTIONS.third_party_id%TYPE
818: INDEX BY BINARY_INTEGER;
819: NUM_COL1_ORIG_LIST third_party_id_LIST_TYPE;
820: NUM_COL1_NEW_LIST third_party_id_LIST_TYPE;
821:

Line 823: AR_DISTRIBUTIONS.third_party_sub_id%TYPE

819: NUM_COL1_ORIG_LIST third_party_id_LIST_TYPE;
820: NUM_COL1_NEW_LIST third_party_id_LIST_TYPE;
821:
822: TYPE third_party_sub_id_LIST_TYPE IS TABLE OF
823: AR_DISTRIBUTIONS.third_party_sub_id%TYPE
824: INDEX BY BINARY_INTEGER;
825: NUM_COL2_ORIG_LIST third_party_sub_id_LIST_TYPE;
826: NUM_COL2_NEW_LIST third_party_sub_id_LIST_TYPE;
827:

Line 834: FROM AR_DISTRIBUTIONS yt, ra_customer_merges m

830: SELECT distinct CUSTOMER_MERGE_HEADER_ID
831: ,line_id
832: ,third_party_id
833: ,third_party_sub_id
834: FROM AR_DISTRIBUTIONS yt, ra_customer_merges m
835: WHERE ( (yt.third_party_id = m.DUPLICATE_ID AND
836: nvl(yt.third_party_sub_id,m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID))
837: AND m.process_flag = 'N'
838: AND m.request_id = req_id

Line 847: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_DISTRIBUTIONS',FALSE);

843: IF process_mode='LOCK' THEN
844: NULL;
845: ELSE
846: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
847: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_DISTRIBUTIONS',FALSE);
848: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
849: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
850:
851: open merged_records;

Line 888: 'AR_DISTRIBUTIONS',

884: LAST_UPDATE_LOGIN,
885: LAST_UPDATE_DATE,
886: LAST_UPDATED_BY
887: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
888: 'AR_DISTRIBUTIONS',
889: MERGE_HEADER_ID_LIST(I),
890: PRIMARY_KEY_ID_LIST(I),
891: NUM_COL1_ORIG_LIST(I),
892: NUM_COL1_NEW_LIST(I),

Line 905: UPDATE AR_DISTRIBUTIONS yt SET

901: hz_utility_pub.LAST_UPDATED_BY
902: );
903:
904: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
905: UPDATE AR_DISTRIBUTIONS yt SET
906: third_party_id=NUM_COL1_NEW_LIST(I)
907: ,third_party_sub_id=NUM_COL2_NEW_LIST(I)
908: , LAST_UPDATE_DATE=SYSDATE
909: , last_updated_by=arp_standard.profile.user_id