APPS.XDP_PARTY_MERGE dependencies on XDP_ORDER_LINE_ITEMS

Line 43: XDP_ORDER_LINE_ITEMS.LINE_ITEM_ID%TYPE

39: l_last_fetch BOOLEAN := FALSE;
40: l_count NUMBER;
41:
42: TYPE LINE_ITEM_ID_LIST_TYPE IS TABLE OF
43: XDP_ORDER_LINE_ITEMS.LINE_ITEM_ID%TYPE
44: INDEX BY BINARY_INTEGER;
45: PRIMARY_KEY_ID_LIST1 LINE_ITEM_ID_LIST_TYPE;
46:
47: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF

Line 48: XDP_ORDER_LINE_ITEMS.SITE_USE_ID%TYPE

44: INDEX BY BINARY_INTEGER;
45: PRIMARY_KEY_ID_LIST1 LINE_ITEM_ID_LIST_TYPE;
46:
47: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF
48: XDP_ORDER_LINE_ITEMS.SITE_USE_ID%TYPE
49: INDEX BY BINARY_INTEGER;
50: NUM_COL1_ORIG_LIST1 SITE_USE_ID_LIST_TYPE;
51: NUM_COL1_NEW_LIST1 SITE_USE_ID_LIST_TYPE;
52:

Line 57: FROM XDP_ORDER_LINE_ITEMS yt, ra_customer_merges m

53: CURSOR merged_records1 IS
54: SELECT distinct CUSTOMER_MERGE_HEADER_ID
55: ,LINE_ITEM_ID
56: ,SITE_USE_ID
57: FROM XDP_ORDER_LINE_ITEMS yt, ra_customer_merges m
58: WHERE (
59: yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
60: ) AND m.process_flag = 'N'
61: AND m.request_id = request_id

Line 149: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','XDP_ORDER_LINE_ITEMS',FALSE);

145: IF process_mode='LOCK' THEN
146: NULL;
147: ELSE
148: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
149: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','XDP_ORDER_LINE_ITEMS',FALSE);
150: HZ_ACCT_MERGE_UTIL.load_set(set_number, request_id);
151: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
152:
153: open merged_records1;

Line 186: 'XDP_ORDER_LINE_ITEMS',

182: LAST_UPDATE_LOGIN,
183: LAST_UPDATE_DATE,
184: LAST_UPDATED_BY
185: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
186: 'XDP_ORDER_LINE_ITEMS',
187: MERGE_HEADER_ID_LIST(I),
188: PRIMARY_KEY_ID_LIST1(I),
189: NUM_COL1_ORIG_LIST1(I),
190: NUM_COL1_NEW_LIST1(I),

Line 202: UPDATE XDP_ORDER_LINE_ITEMS yt SET

198: );
199:
200: END IF;
201: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
202: UPDATE XDP_ORDER_LINE_ITEMS yt SET
203: SITE_USE_ID=NUM_COL1_NEW_LIST1(I)
204: , LAST_UPDATE_DATE=SYSDATE
205: , last_updated_by=arp_standard.profile.user_id
206: , last_update_login=arp_standard.profile.last_update_login