eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CMERGE_ARCPF dependencies on HZ_CUST_PROFILE_AMTS

Line 461: FROM HZ_CUST_PROFILE_AMTS, ra_customer_merges m

457:
458: --cursor c1 and c2 work in inactive mode.
459: CURSOR c1 is
460: SELECT CUST_ACCT_PROFILE_AMT_ID
461: FROM HZ_CUST_PROFILE_AMTS, ra_customer_merges m
462: WHERE site_use_id = m.duplicate_site_id
463: AND m.process_flag = 'N'
464: AND m.request_id = req_id
465: AND m.set_number = set_num

Line 471: FROM HZ_CUST_PROFILE_AMTS yt, ra_customer_merges m

467: FOR UPDATE NOWAIT;
468:
469: CURSOR c2 is
470: SELECT CUST_ACCT_PROFILE_AMT_ID
471: FROM HZ_CUST_PROFILE_AMTS yt, ra_customer_merges m
472: WHERE cust_account_id = m.duplicate_id
473: AND m.process_flag = 'N'
474: AND m.request_id = req_id
475: AND m.set_number = set_num

Line 492: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

488:
489: IF process_mode = 'LOCK' THEN
490:
491: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE' );
492: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
493:
494: OPEN c1;
495: CLOSE c1;
496:

Line 506: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

502: /*************** 'inactivate' mode ***************/
503:
504: --site level inactivate
505: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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,

Line 508: UPDATE HZ_CUST_PROFILE_AMTS yt

504: --site level inactivate
505: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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,

Line 531: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

527: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
528:
529: --customer level inactivate
530: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
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,

Line 533: UPDATE HZ_CUST_PROFILE_AMTS yt

529: --customer level inactivate
530: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
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,

Line 616: FROM HZ_CUST_PROFILE_AMTS, ra_customer_merges m

612: FOR UPDATE NOWAIT;
613:
614: CURSOR profile_amt_site IS
615: SELECT CUST_ACCT_PROFILE_AMT_ID
616: FROM HZ_CUST_PROFILE_AMTS, ra_customer_merges m
617: WHERE site_use_id = m.duplicate_site_id
618: AND m.process_flag = 'N'
619: AND m.request_id = req_id
620: AND m.set_number = set_num

Line 626: FROM HZ_CUST_PROFILE_AMTS yt, ra_customer_merges m

622: FOR UPDATE NOWAIT;
623:
624: CURSOR profile_amt_acct IS
625: SELECT CUST_ACCT_PROFILE_AMT_ID
626: FROM HZ_CUST_PROFILE_AMTS yt, ra_customer_merges m
627: WHERE cust_account_id = m.duplicate_id
628: AND m.process_flag = 'N'
629: AND m.request_id = req_id
630: AND m.set_number = set_num

Line 679: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

675:
676: /*****************************************************/
677:
678: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
679: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
680:
681: OPEN profile_amt_site;
682: CLOSE profile_amt_site;
683:

Line 688: DELETE FROM HZ_CUST_PROFILE_AMTS yt

684: OPEN profile_amt_acct;
685: CLOSE profile_amt_acct;
686:
687: --site level
688: DELETE FROM HZ_CUST_PROFILE_AMTS yt
689: WHERE site_use_id IN (
690: SELECT m.duplicate_site_id
691: FROM ra_customer_merges m
692: WHERE m.process_flag = 'N'

Line 703: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

699: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
700: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
701:
702: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
703: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
704:
705: --account level
706: DELETE FROM HZ_CUST_PROFILE_AMTS yt
707: WHERE cust_account_id IN (

Line 706: DELETE FROM HZ_CUST_PROFILE_AMTS yt

702: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
703: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
704:
705: --account level
706: DELETE FROM HZ_CUST_PROFILE_AMTS yt
707: WHERE cust_account_id IN (
708: SELECT m.duplicate_id
709: FROM ra_customer_merges m
710: WHERE m.process_flag = 'N'