APPS.OKS_HZ_MERGE_PUB dependencies on STANDARD

Line 210: , last_updated_by=arp_standard.profile.user_id

206: UPDATE OKS_BILLING_PROFILES_B yt SET
207: DEPENDENT_CUST_ACCT_ID1=NUM_COL1_NEW_LIST(I)
208: ,OBJECT_VERSION_NUMBER=NUM_COL2_NEW_LIST(I)
209: , LAST_UPDATE_DATE=SYSDATE
210: , last_updated_by=arp_standard.profile.user_id
211: , last_update_login=arp_standard.profile.last_update_login
212: WHERE ID=PRIMARY_KEY_ID1_LIST(I)
213: ;
214: l_count := l_count + SQL%ROWCOUNT;

Line 211: , last_update_login=arp_standard.profile.last_update_login

207: DEPENDENT_CUST_ACCT_ID1=NUM_COL1_NEW_LIST(I)
208: ,OBJECT_VERSION_NUMBER=NUM_COL2_NEW_LIST(I)
209: , LAST_UPDATE_DATE=SYSDATE
210: , last_updated_by=arp_standard.profile.user_id
211: , last_update_login=arp_standard.profile.last_update_login
212: WHERE ID=PRIMARY_KEY_ID1_LIST(I)
213: ;
214: l_count := l_count + SQL%ROWCOUNT;
215: IF l_last_fetch THEN

Line 264: , last_updated_by=arp_standard.profile.user_id

260: AND DEPENDENT_CUST_ACCT_ID1 = NUM_COL1_ORIG
261: and rownum <2
262: )
263: , LAST_UPDATE_DATE=SYSDATE
264: , last_updated_by=arp_standard.profile.user_id
265: , last_update_login=arp_standard.profile.last_update_login
266: WHERE (ID) in (
267: SELECT PRIMARY_KEY_ID
268: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h

Line 265: , last_update_login=arp_standard.profile.last_update_login

261: and rownum <2
262: )
263: , LAST_UPDATE_DATE=SYSDATE
264: , last_updated_by=arp_standard.profile.user_id
265: , last_update_login=arp_standard.profile.last_update_login
266: WHERE (ID) in (
267: SELECT PRIMARY_KEY_ID
268: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h
269: WHERE h.CUSTOMER_MERGE_HEADER_ID = l1.MERGE_HEADER_ID

Line 420: , last_updated_by=arp_standard.profile.user_id

416: UPDATE OKS_BILLING_PROFILES_B yt SET
417: BILL_TO_ADDRESS_ID1=NUM_COL3_NEW_LIST(I)
418: ,OBJECT_VERSION_NUMBER=NUM_COL4_NEW_LIST(I)
419: , LAST_UPDATE_DATE=SYSDATE
420: , last_updated_by=arp_standard.profile.user_id
421: , last_update_login=arp_standard.profile.last_update_login
422: WHERE ID=PRIMARY_KEY_ID1_LIST(I)
423: ;
424:

Line 421: , last_update_login=arp_standard.profile.last_update_login

417: BILL_TO_ADDRESS_ID1=NUM_COL3_NEW_LIST(I)
418: ,OBJECT_VERSION_NUMBER=NUM_COL4_NEW_LIST(I)
419: , LAST_UPDATE_DATE=SYSDATE
420: , last_updated_by=arp_standard.profile.user_id
421: , last_update_login=arp_standard.profile.last_update_login
422: WHERE ID=PRIMARY_KEY_ID1_LIST(I)
423: ;
424:
425: --l_count := l_count + SQL%ROWCOUNT;

Line 498: , last_updated_by=arp_standard.profile.user_id

494: UPDATE OKS_K_HEADERS_B yt SET
495: QUOTE_TO_SITE_ID=NUM_COL1_NEW_LIST_QUOTE(I)
496: ,OBJECT_VERSION_NUMBER=NUM_COL2_NEW_LIST_QUOTE(I)
497: , LAST_UPDATE_DATE=SYSDATE
498: , last_updated_by=arp_standard.profile.user_id
499: , last_update_login=arp_standard.profile.last_update_login
500: WHERE ID=PRIMARY_KEY_ID1_LIST_QUOTE(I);
501:
502: l_count := SQL%ROWCOUNT;

Line 499: , last_update_login=arp_standard.profile.last_update_login

495: QUOTE_TO_SITE_ID=NUM_COL1_NEW_LIST_QUOTE(I)
496: ,OBJECT_VERSION_NUMBER=NUM_COL2_NEW_LIST_QUOTE(I)
497: , LAST_UPDATE_DATE=SYSDATE
498: , last_updated_by=arp_standard.profile.user_id
499: , last_update_login=arp_standard.profile.last_update_login
500: WHERE ID=PRIMARY_KEY_ID1_LIST_QUOTE(I);
501:
502: l_count := SQL%ROWCOUNT;
503: arp_message.set_name('AR','AR_ROWS_UPDATED');