APPS.JL_CMERGE dependencies on STANDARD

Line 122: , last_updated_by=arp_standard.profile.user_id

118: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
119: UPDATE JL_BR_AR_BANK_RETURNS yt SET
120: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
121: , LAST_UPDATE_DATE=SYSDATE
122: , last_updated_by=arp_standard.profile.user_id
123: , last_update_login=arp_standard.profile.last_update_login
124: WHERE RETURN_ID=PRIMARY_KEY_ID_LIST(I)
125: ;
126: l_count := l_count + SQL%ROWCOUNT;

Line 123: , last_update_login=arp_standard.profile.last_update_login

119: UPDATE JL_BR_AR_BANK_RETURNS yt SET
120: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
121: , LAST_UPDATE_DATE=SYSDATE
122: , last_updated_by=arp_standard.profile.user_id
123: , last_update_login=arp_standard.profile.last_update_login
124: WHERE RETURN_ID=PRIMARY_KEY_ID_LIST(I)
125: ;
126: l_count := l_count + SQL%ROWCOUNT;
127: IF l_last_fetch THEN

Line 273: , last_updated_by=arp_standard.profile.user_id

269: UPDATE JL_BR_AR_OCCURRENCE_DOCS yt SET
270: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
271: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
272: , LAST_UPDATE_DATE=SYSDATE
273: , last_updated_by=arp_standard.profile.user_id
274: , last_update_login=arp_standard.profile.last_update_login
275: WHERE OCCURRENCE_ID=PRIMARY_KEY_ID_LIST(I)
276: ;
277: l_count := l_count + SQL%ROWCOUNT;

Line 274: , last_update_login=arp_standard.profile.last_update_login

270: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
271: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
272: , LAST_UPDATE_DATE=SYSDATE
273: , last_updated_by=arp_standard.profile.user_id
274: , last_update_login=arp_standard.profile.last_update_login
275: WHERE OCCURRENCE_ID=PRIMARY_KEY_ID_LIST(I)
276: ;
277: l_count := l_count + SQL%ROWCOUNT;
278: IF l_last_fetch THEN

Line 668: last_updated_by = arp_standard.profile.user_id,

664: AND m.process_flag = 'N'
665: AND m.request_id = req_id
666: AND m.set_number = set_num),
667: last_update_date = SYSDATE,
668: last_updated_by = arp_standard.profile.user_id,
669: last_update_login = arp_standard.profile.last_update_login,
670: JOURNAL_BALANCE_FLAG = 'N'
671: WHERE (personnel_id) IN (SELECT unique m.duplicate_id
672: FROM ra_customer_merges m

Line 669: last_update_login = arp_standard.profile.last_update_login,

665: AND m.request_id = req_id
666: AND m.set_number = set_num),
667: last_update_date = SYSDATE,
668: last_updated_by = arp_standard.profile.user_id,
669: last_update_login = arp_standard.profile.last_update_login,
670: JOURNAL_BALANCE_FLAG = 'N'
671: WHERE (personnel_id) IN (SELECT unique m.duplicate_id
672: FROM ra_customer_merges m
673: WHERE m.process_flag = 'N'

Line 784: ,last_updated_by = arp_standard.profile.user_id

780: SET
781: PERSONNEL_ID=NUM_COL1_NEW_LIST(I)
782: ,JOURNAL_BALANCE_FLAG=VCHAR_COL1_NEW_LIST(I)
783: ,last_update_date = SYSDATE
784: ,last_updated_by = arp_standard.profile.user_id
785: ,last_update_login = arp_standard.profile.last_update_login
786: WHERE personnel_id = NUM_COL1_ORIG_LIST(I)
787: AND application_id=222;
788:

Line 785: ,last_update_login = arp_standard.profile.last_update_login

781: PERSONNEL_ID=NUM_COL1_NEW_LIST(I)
782: ,JOURNAL_BALANCE_FLAG=VCHAR_COL1_NEW_LIST(I)
783: ,last_update_date = SYSDATE
784: ,last_updated_by = arp_standard.profile.user_id
785: ,last_update_login = arp_standard.profile.last_update_login
786: WHERE personnel_id = NUM_COL1_ORIG_LIST(I)
787: AND application_id=222;
788:
789: l_count := l_count + SQL%ROWCOUNT;