APPS.ARP_CMERGE_ARCON dependencies on AR_CONS_INV

Line 21: AR_CONS_INV.cons_inv_id%TYPE

17: INDEX BY BINARY_INTEGER;
18: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
19:
20: TYPE cons_inv_id_LIST_TYPE IS TABLE OF
21: AR_CONS_INV.cons_inv_id%TYPE
22: INDEX BY BINARY_INTEGER;
23: PRIMARY_KEY_ID_LIST cons_inv_id_LIST_TYPE;
24:
25: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 26: AR_CONS_INV.customer_id%TYPE

22: INDEX BY BINARY_INTEGER;
23: PRIMARY_KEY_ID_LIST cons_inv_id_LIST_TYPE;
24:
25: TYPE customer_id_LIST_TYPE IS TABLE OF
26: AR_CONS_INV.customer_id%TYPE
27: INDEX BY BINARY_INTEGER;
28: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
29: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
30:

Line 32: AR_CONS_INV.site_use_id%TYPE

28: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
29: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
30:
31: TYPE site_use_id_LIST_TYPE IS TABLE OF
32: AR_CONS_INV.site_use_id%TYPE
33: INDEX BY BINARY_INTEGER;
34: NUM_COL2_ORIG_LIST site_use_id_LIST_TYPE;
35: NUM_COL2_NEW_LIST site_use_id_LIST_TYPE;
36:

Line 43: FROM AR_CONS_INV yt, ra_customer_merges m

39: SELECT distinct CUSTOMER_MERGE_HEADER_ID
40: ,cons_inv_id
41: ,yt.customer_id
42: ,site_use_id
43: FROM AR_CONS_INV yt, ra_customer_merges m
44: WHERE ( yt.customer_id = m.DUPLICATE_ID AND
45: yt.site_use_id = m.DUPLICATE_SITE_ID)
46: AND m.process_flag = 'N'
47: AND m.request_id = req_id

Line 56: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CONS_INV',FALSE);

52: IF process_mode='LOCK' THEN
53: NULL;
54: ELSE
55: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
56: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CONS_INV',FALSE);
57: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
58: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
59:
60: open merged_records;

Line 97: 'AR_CONS_INV',

93: LAST_UPDATE_LOGIN,
94: LAST_UPDATE_DATE,
95: LAST_UPDATED_BY
96: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
97: 'AR_CONS_INV',
98: MERGE_HEADER_ID_LIST(I),
99: PRIMARY_KEY_ID_LIST(I),
100: NUM_COL1_ORIG_LIST(I),
101: NUM_COL1_NEW_LIST(I),

Line 122: -- merged and latest ar_cons_inv record.

118: END IF;
119: END LOOP;
120:
121: -- bug2778646 added the update stmt which set 'MERGE_PENDING' status to
122: -- merged and latest ar_cons_inv record.
123: -- bug3123397 added 'group by' to sub-query to update status of all site's
124: -- latest CBI.
125: UPDATE ar_cons_inv ci
126: SET status = 'MERGE_PENDING'

Line 125: UPDATE ar_cons_inv ci

121: -- bug2778646 added the update stmt which set 'MERGE_PENDING' status to
122: -- merged and latest ar_cons_inv record.
123: -- bug3123397 added 'group by' to sub-query to update status of all site's
124: -- latest CBI.
125: UPDATE ar_cons_inv ci
126: SET status = 'MERGE_PENDING'
127: WHERE (cons_inv_id) in
128: (SELECT max(ci2.cons_inv_id)
129: FROM ar_cons_inv ci2,

Line 129: FROM ar_cons_inv ci2,

125: UPDATE ar_cons_inv ci
126: SET status = 'MERGE_PENDING'
127: WHERE (cons_inv_id) in
128: (SELECT max(ci2.cons_inv_id)
129: FROM ar_cons_inv ci2,
130: ra_customer_merges m
131: WHERE ci2.site_use_id = m.duplicate_site_id
132: AND m.process_flag = 'N'
133: AND m.request_id = req_id

Line 141: UPDATE AR_CONS_INV yt SET

137:
138: -- bug2778646 added "status" column and move outside the FOR loop.
139: -- added where clause to prevent from updating unrelated record.
140: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
141: UPDATE AR_CONS_INV yt SET
142: customer_id=NUM_COL1_NEW_LIST(I)
143: ,site_use_id=NUM_COL2_NEW_LIST(I)
144: , LAST_UPDATE_DATE=SYSDATE
145: , last_updated_by=arp_standard.profile.user_id