APPS.XDP_PARTY_MERGE dependencies on XDP_ORDER_HEADERS

Line 18: XDP_ORDER_HEADERS.ORDER_ID%TYPE

14: INDEX BY BINARY_INTEGER;
15: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
16:
17: TYPE ORDER_ID_LIST_TYPE IS TABLE OF
18: XDP_ORDER_HEADERS.ORDER_ID%TYPE
19: INDEX BY BINARY_INTEGER;
20: PRIMARY_KEY_ID_LIST ORDER_ID_LIST_TYPE;
21:
22: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 23: XDP_ORDER_HEADERS.CUST_ACCOUNT_ID%TYPE

19: INDEX BY BINARY_INTEGER;
20: PRIMARY_KEY_ID_LIST ORDER_ID_LIST_TYPE;
21:
22: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
23: XDP_ORDER_HEADERS.CUST_ACCOUNT_ID%TYPE
24: INDEX BY BINARY_INTEGER;
25: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
26: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
27:

Line 33: FROM XDP_ORDER_HEADERS yt, ra_customer_merges m

29: CURSOR merged_records IS
30: SELECT distinct CUSTOMER_MERGE_HEADER_ID
31: ,ORDER_ID
32: ,CUST_ACCOUNT_ID
33: FROM XDP_ORDER_HEADERS yt, ra_customer_merges m
34: WHERE (
35: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
36: ) AND m.process_flag = 'N'
37: AND m.request_id = request_id

Line 71: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','XDP_ORDER_HEADERS',FALSE);

67: IF process_mode='LOCK' THEN
68: NULL;
69: ELSE
70: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
71: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','XDP_ORDER_HEADERS',FALSE);
72: HZ_ACCT_MERGE_UTIL.load_set(set_number, request_id);
73: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
74:
75: open merged_records;

Line 108: 'XDP_ORDER_HEADERS',

104: LAST_UPDATE_LOGIN,
105: LAST_UPDATE_DATE,
106: LAST_UPDATED_BY
107: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
108: 'XDP_ORDER_HEADERS',
109: MERGE_HEADER_ID_LIST(I),
110: PRIMARY_KEY_ID_LIST(I),
111: NUM_COL1_ORIG_LIST(I),
112: NUM_COL1_NEW_LIST(I),

Line 124: UPDATE XDP_ORDER_HEADERS yt SET

120: );
121:
122: END IF;
123: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
124: UPDATE XDP_ORDER_HEADERS yt SET
125: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
126: , LAST_UPDATE_DATE=SYSDATE
127: , last_updated_by=arp_standard.profile.user_id
128: , last_update_login=arp_standard.profile.last_update_login