DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARCPF dependencies on STANDARD

Line 311: last_updated_by = arp_standard.profile.user_id,

307:
308: UPDATE hz_customer_profiles yt
309: SET status = 'I',
310: last_update_date = sysdate,
311: last_updated_by = arp_standard.profile.user_id,
312: last_update_login = arp_standard.profile.last_update_login,
313: request_id = req_id,
314: program_application_id = arp_standard.profile.program_application_id,
315: program_id = arp_standard.profile.program_id,

Line 312: last_update_login = arp_standard.profile.last_update_login,

308: UPDATE hz_customer_profiles yt
309: SET status = 'I',
310: last_update_date = sysdate,
311: last_updated_by = arp_standard.profile.user_id,
312: last_update_login = arp_standard.profile.last_update_login,
313: request_id = req_id,
314: program_application_id = arp_standard.profile.program_application_id,
315: program_id = arp_standard.profile.program_id,
316: program_update_date = sysdate

Line 314: program_application_id = arp_standard.profile.program_application_id,

310: last_update_date = sysdate,
311: last_updated_by = arp_standard.profile.user_id,
312: last_update_login = arp_standard.profile.last_update_login,
313: request_id = req_id,
314: program_application_id = arp_standard.profile.program_application_id,
315: program_id = arp_standard.profile.program_id,
316: program_update_date = sysdate
317: WHERE site_use_id IN (
318: SELECT m.duplicate_site_id

Line 315: program_id = arp_standard.profile.program_id,

311: last_updated_by = arp_standard.profile.user_id,
312: last_update_login = arp_standard.profile.last_update_login,
313: request_id = req_id,
314: program_application_id = arp_standard.profile.program_application_id,
315: program_id = arp_standard.profile.program_id,
316: program_update_date = sysdate
317: WHERE site_use_id IN (
318: SELECT m.duplicate_site_id
319: FROM ra_customer_merges m

Line 337: last_updated_by = arp_standard.profile.user_id,

333:
334: UPDATE hz_customer_profiles yt
335: SET status = 'I',
336: last_update_date = sysdate,
337: last_updated_by = arp_standard.profile.user_id,
338: last_update_login = arp_standard.profile.last_update_login,
339: request_id = req_id,
340: program_application_id = arp_standard.profile.program_application_id,
341: program_id = arp_standard.profile.program_id,

Line 338: last_update_login = arp_standard.profile.last_update_login,

334: UPDATE hz_customer_profiles yt
335: SET status = 'I',
336: last_update_date = sysdate,
337: last_updated_by = arp_standard.profile.user_id,
338: last_update_login = arp_standard.profile.last_update_login,
339: request_id = req_id,
340: program_application_id = arp_standard.profile.program_application_id,
341: program_id = arp_standard.profile.program_id,
342: program_update_date = sysdate

Line 340: program_application_id = arp_standard.profile.program_application_id,

336: last_update_date = sysdate,
337: last_updated_by = arp_standard.profile.user_id,
338: last_update_login = arp_standard.profile.last_update_login,
339: request_id = req_id,
340: program_application_id = arp_standard.profile.program_application_id,
341: program_id = arp_standard.profile.program_id,
342: program_update_date = sysdate
343: WHERE cust_account_id IN (
344: SELECT m.duplicate_id

Line 341: program_id = arp_standard.profile.program_id,

337: last_updated_by = arp_standard.profile.user_id,
338: last_update_login = arp_standard.profile.last_update_login,
339: request_id = req_id,
340: program_application_id = arp_standard.profile.program_application_id,
341: program_id = arp_standard.profile.program_id,
342: program_update_date = sysdate
343: WHERE cust_account_id IN (
344: SELECT m.duplicate_id
345: FROM ra_customer_merges m

Line 510: last_updated_by = arp_standard.profile.user_id,

506: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
507:
508: UPDATE HZ_CUST_PROFILE_AMTS yt
509: SET last_update_date = sysdate,
510: last_updated_by = arp_standard.profile.user_id,
511: last_update_login = arp_standard.profile.last_update_login,
512: request_id = req_id,
513: program_application_id = arp_standard.profile.program_application_id,
514: program_id = arp_standard.profile.program_id,

Line 511: last_update_login = arp_standard.profile.last_update_login,

507:
508: UPDATE HZ_CUST_PROFILE_AMTS yt
509: SET last_update_date = sysdate,
510: last_updated_by = arp_standard.profile.user_id,
511: last_update_login = arp_standard.profile.last_update_login,
512: request_id = req_id,
513: program_application_id = arp_standard.profile.program_application_id,
514: program_id = arp_standard.profile.program_id,
515: program_update_date = sysdate

Line 513: program_application_id = arp_standard.profile.program_application_id,

509: SET last_update_date = sysdate,
510: last_updated_by = arp_standard.profile.user_id,
511: last_update_login = arp_standard.profile.last_update_login,
512: request_id = req_id,
513: program_application_id = arp_standard.profile.program_application_id,
514: program_id = arp_standard.profile.program_id,
515: program_update_date = sysdate
516: WHERE site_use_id IN (
517: SELECT m.duplicate_site_id

Line 514: program_id = arp_standard.profile.program_id,

510: last_updated_by = arp_standard.profile.user_id,
511: last_update_login = arp_standard.profile.last_update_login,
512: request_id = req_id,
513: program_application_id = arp_standard.profile.program_application_id,
514: program_id = arp_standard.profile.program_id,
515: program_update_date = sysdate
516: WHERE site_use_id IN (
517: SELECT m.duplicate_site_id
518: FROM ra_customer_merges m

Line 535: last_updated_by = arp_standard.profile.user_id,

531: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
532:
533: UPDATE HZ_CUST_PROFILE_AMTS yt
534: SET last_update_date = sysdate,
535: last_updated_by = arp_standard.profile.user_id,
536: last_update_login = arp_standard.profile.last_update_login,
537: request_id = req_id,
538: program_application_id = arp_standard.profile.program_application_id,
539: program_id = arp_standard.profile.program_id,

Line 536: last_update_login = arp_standard.profile.last_update_login,

532:
533: UPDATE HZ_CUST_PROFILE_AMTS yt
534: SET last_update_date = sysdate,
535: last_updated_by = arp_standard.profile.user_id,
536: last_update_login = arp_standard.profile.last_update_login,
537: request_id = req_id,
538: program_application_id = arp_standard.profile.program_application_id,
539: program_id = arp_standard.profile.program_id,
540: program_update_date = sysdate

Line 538: program_application_id = arp_standard.profile.program_application_id,

534: SET last_update_date = sysdate,
535: last_updated_by = arp_standard.profile.user_id,
536: last_update_login = arp_standard.profile.last_update_login,
537: request_id = req_id,
538: program_application_id = arp_standard.profile.program_application_id,
539: program_id = arp_standard.profile.program_id,
540: program_update_date = sysdate
541: WHERE cust_account_id IN (
542: SELECT m.duplicate_id

Line 539: program_id = arp_standard.profile.program_id,

535: last_updated_by = arp_standard.profile.user_id,
536: last_update_login = arp_standard.profile.last_update_login,
537: request_id = req_id,
538: program_application_id = arp_standard.profile.program_application_id,
539: program_id = arp_standard.profile.program_id,
540: program_update_date = sysdate
541: WHERE cust_account_id IN (
542: SELECT m.duplicate_id
543: FROM ra_customer_merges m