APPS.GMS_CMERGE dependencies on STANDARD

Line 188: , last_updated_by=arp_standard.profile.user_id

184: ,LOC_SHIP_TO_ADDRESS_ID=NUM_COL4_NEW_LIST(I)
185: ,BILL_TO_CUSTOMER_ID=NUM_COL5_NEW_LIST(I)
186: ,FUNDING_SOURCE_ID=NUM_COL6_NEW_LIST(I)
187: , LAST_UPDATE_DATE=SYSDATE
188: , last_updated_by=arp_standard.profile.user_id
189: , last_update_login=arp_standard.profile.last_update_login
190: WHERE AWARD_ID=PRIMARY_KEY_ID_LIST(I)
191: ;
192: l_count := l_count + SQL%ROWCOUNT;

Line 189: , last_update_login=arp_standard.profile.last_update_login

185: ,BILL_TO_CUSTOMER_ID=NUM_COL5_NEW_LIST(I)
186: ,FUNDING_SOURCE_ID=NUM_COL6_NEW_LIST(I)
187: , LAST_UPDATE_DATE=SYSDATE
188: , last_updated_by=arp_standard.profile.user_id
189: , last_update_login=arp_standard.profile.last_update_login
190: WHERE AWARD_ID=PRIMARY_KEY_ID_LIST(I)
191: ;
192: l_count := l_count + SQL%ROWCOUNT;
193: IF l_last_fetch THEN

Line 336: , last_updated_by=arp_standard.profile.user_id

332: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
333: UPDATE GMS_AWARDS_CONTACTS yt SET
334: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
335: , LAST_UPDATE_DATE=SYSDATE
336: , last_updated_by=arp_standard.profile.user_id
337: , last_update_login=arp_standard.profile.last_update_login
338: WHERE AWARD_ID=PRIMARY_KEY1_LIST(I)
339: AND CUSTOMER_ID=PRIMARY_KEY2_LIST(I)
340: AND CONTACT_ID=PRIMARY_KEY3_LIST(I)

Line 337: , last_update_login=arp_standard.profile.last_update_login

333: UPDATE GMS_AWARDS_CONTACTS yt SET
334: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
335: , LAST_UPDATE_DATE=SYSDATE
336: , last_updated_by=arp_standard.profile.user_id
337: , last_update_login=arp_standard.profile.last_update_login
338: WHERE AWARD_ID=PRIMARY_KEY1_LIST(I)
339: AND CUSTOMER_ID=PRIMARY_KEY2_LIST(I)
340: AND CONTACT_ID=PRIMARY_KEY3_LIST(I)
341: AND USAGE_CODE=PRIMARY_KEY4_LIST(I)

Line 463: , last_updated_by=arp_standard.profile.user_id

459: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
460: UPDATE GMS_REPORTS yt SET
461: SITE_USE_ID=NUM_COL1_NEW_LIST(I)
462: , LAST_UPDATE_DATE=SYSDATE
463: , last_updated_by=arp_standard.profile.user_id
464: , last_update_login=arp_standard.profile.last_update_login
465: WHERE REPORT_ID=PRIMARY_KEY_ID_LIST(I)
466: ;
467: l_count := l_count + SQL%ROWCOUNT;

Line 464: , last_update_login=arp_standard.profile.last_update_login

460: UPDATE GMS_REPORTS yt SET
461: SITE_USE_ID=NUM_COL1_NEW_LIST(I)
462: , LAST_UPDATE_DATE=SYSDATE
463: , last_updated_by=arp_standard.profile.user_id
464: , last_update_login=arp_standard.profile.last_update_login
465: WHERE REPORT_ID=PRIMARY_KEY_ID_LIST(I)
466: ;
467: l_count := l_count + SQL%ROWCOUNT;
468: IF l_last_fetch THEN

Line 587: , last_updated_by=arp_standard.profile.user_id

583: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
584: UPDATE GMS_DEFAULT_REPORTS yt SET
585: SITE_USE_ID=NUM_COL1_NEW_LIST(I)
586: , LAST_UPDATE_DATE=SYSDATE
587: , last_updated_by=arp_standard.profile.user_id
588: , last_update_login=arp_standard.profile.last_update_login
589: WHERE DEFAULT_REPORT_ID=PRIMARY_KEY_ID_LIST(I)
590: ;
591: l_count := l_count + SQL%ROWCOUNT;

Line 588: , last_update_login=arp_standard.profile.last_update_login

584: UPDATE GMS_DEFAULT_REPORTS yt SET
585: SITE_USE_ID=NUM_COL1_NEW_LIST(I)
586: , LAST_UPDATE_DATE=SYSDATE
587: , last_updated_by=arp_standard.profile.user_id
588: , last_update_login=arp_standard.profile.last_update_login
589: WHERE DEFAULT_REPORT_ID=PRIMARY_KEY_ID_LIST(I)
590: ;
591: l_count := l_count + SQL%ROWCOUNT;
592: IF l_last_fetch THEN