DBA Data[Home] [Help]

APPS.XDP_PARTY_MERGE dependencies on STANDARD

Line 127: , last_updated_by=arp_standard.profile.user_id

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
129: -- , REQUEST_ID=request_id
130: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
131: -- , PROGRAM_ID=arp_standard.profile.program_id

Line 128: , last_update_login=arp_standard.profile.last_update_login

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
129: -- , REQUEST_ID=request_id
130: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
131: -- , PROGRAM_ID=arp_standard.profile.program_id
132: -- , PROGRAM_UPDATE_DATE=SYSDATE

Line 130: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

126: , LAST_UPDATE_DATE=SYSDATE
127: , last_updated_by=arp_standard.profile.user_id
128: , last_update_login=arp_standard.profile.last_update_login
129: -- , REQUEST_ID=request_id
130: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
131: -- , PROGRAM_ID=arp_standard.profile.program_id
132: -- , PROGRAM_UPDATE_DATE=SYSDATE
133: WHERE ORDER_ID=PRIMARY_KEY_ID_LIST(I)
134: ;

Line 131: -- , PROGRAM_ID=arp_standard.profile.program_id

127: , last_updated_by=arp_standard.profile.user_id
128: , last_update_login=arp_standard.profile.last_update_login
129: -- , REQUEST_ID=request_id
130: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
131: -- , PROGRAM_ID=arp_standard.profile.program_id
132: -- , PROGRAM_UPDATE_DATE=SYSDATE
133: WHERE ORDER_ID=PRIMARY_KEY_ID_LIST(I)
134: ;
135: l_count := l_count + SQL%ROWCOUNT;

Line 205: , last_updated_by=arp_standard.profile.user_id

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
207: -- , REQUEST_ID=request_id
208: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
209: -- , PROGRAM_ID=arp_standard.profile.program_id

Line 206: , last_update_login=arp_standard.profile.last_update_login

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
207: -- , REQUEST_ID=request_id
208: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
209: -- , PROGRAM_ID=arp_standard.profile.program_id
210: -- , PROGRAM_UPDATE_DATE=SYSDATE

Line 208: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

204: , LAST_UPDATE_DATE=SYSDATE
205: , last_updated_by=arp_standard.profile.user_id
206: , last_update_login=arp_standard.profile.last_update_login
207: -- , REQUEST_ID=request_id
208: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
209: -- , PROGRAM_ID=arp_standard.profile.program_id
210: -- , PROGRAM_UPDATE_DATE=SYSDATE
211: WHERE LINE_ITEM_ID=PRIMARY_KEY_ID_LIST1(I)
212: ;

Line 209: -- , PROGRAM_ID=arp_standard.profile.program_id

205: , last_updated_by=arp_standard.profile.user_id
206: , last_update_login=arp_standard.profile.last_update_login
207: -- , REQUEST_ID=request_id
208: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
209: -- , PROGRAM_ID=arp_standard.profile.program_id
210: -- , PROGRAM_UPDATE_DATE=SYSDATE
211: WHERE LINE_ITEM_ID=PRIMARY_KEY_ID_LIST1(I)
212: ;
213: l_count := l_count + SQL%ROWCOUNT;