DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARATC dependencies on STANDARD

Line 118: , last_updated_by=arp_standard.profile.user_id

114: UPDATE AR_INTERIM_CASH_RECEIPTS yt SET
115: pay_from_customer=NUM_COL1_NEW_LIST(I)
116: ,site_use_id=NUM_COL2_NEW_LIST(I)
117: , LAST_UPDATE_DATE=SYSDATE
118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id

Line 119: , last_update_login=arp_standard.profile.last_update_login

115: pay_from_customer=NUM_COL1_NEW_LIST(I)
116: ,site_use_id=NUM_COL2_NEW_LIST(I)
117: , LAST_UPDATE_DATE=SYSDATE
118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id
123: , PROGRAM_UPDATE_DATE=SYSDATE

Line 121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

117: , LAST_UPDATE_DATE=SYSDATE
118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id
123: , PROGRAM_UPDATE_DATE=SYSDATE
124: WHERE cash_receipt_id=PRIMARY_KEY_ID_LIST(I)
125: ;

Line 122: , PROGRAM_ID=arp_standard.profile.program_id

118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id
123: , PROGRAM_UPDATE_DATE=SYSDATE
124: WHERE cash_receipt_id=PRIMARY_KEY_ID_LIST(I)
125: ;
126: l_count := l_count + SQL%ROWCOUNT;

Line 244: , last_updated_by=arp_standard.profile.user_id

240: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
241: UPDATE AR_INTERIM_CASH_RECEIPT_LINES yt SET
242: sold_to_customer=NUM_COL1_NEW_LIST(I)
243: , LAST_UPDATE_DATE=SYSDATE
244: , last_updated_by=arp_standard.profile.user_id
245: , last_update_login=arp_standard.profile.last_update_login
246: , REQUEST_ID=req_id
247: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
248: , PROGRAM_ID=arp_standard.profile.program_id

Line 245: , last_update_login=arp_standard.profile.last_update_login

241: UPDATE AR_INTERIM_CASH_RECEIPT_LINES yt SET
242: sold_to_customer=NUM_COL1_NEW_LIST(I)
243: , LAST_UPDATE_DATE=SYSDATE
244: , last_updated_by=arp_standard.profile.user_id
245: , last_update_login=arp_standard.profile.last_update_login
246: , REQUEST_ID=req_id
247: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
248: , PROGRAM_ID=arp_standard.profile.program_id
249: , PROGRAM_UPDATE_DATE=SYSDATE

Line 247: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

243: , LAST_UPDATE_DATE=SYSDATE
244: , last_updated_by=arp_standard.profile.user_id
245: , last_update_login=arp_standard.profile.last_update_login
246: , REQUEST_ID=req_id
247: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
248: , PROGRAM_ID=arp_standard.profile.program_id
249: , PROGRAM_UPDATE_DATE=SYSDATE
250: WHERE cash_receipt_id=PRIMARY_KEY1_LIST(I)
251: AND cash_receipt_line_id=PRIMARY_KEY2_LIST(I)

Line 248: , PROGRAM_ID=arp_standard.profile.program_id

244: , last_updated_by=arp_standard.profile.user_id
245: , last_update_login=arp_standard.profile.last_update_login
246: , REQUEST_ID=req_id
247: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
248: , PROGRAM_ID=arp_standard.profile.program_id
249: , PROGRAM_UPDATE_DATE=SYSDATE
250: WHERE cash_receipt_id=PRIMARY_KEY1_LIST(I)
251: AND cash_receipt_line_id=PRIMARY_KEY2_LIST(I)
252: ;