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.IBY_MERGE dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 15: account_id iby_external_payers_all.cust_account_id%TYPE,

11: |--------------------------------------------------------------*/
12:
13: FUNCTION GET_EXTERNAL_PAYER_ID
14: (
15: account_id iby_external_payers_all.cust_account_id%TYPE,
16: account_site_use_id iby_external_payers_all.acct_site_use_id%TYPE
17: ) RETURN NUMBER IS
18: ext_payer_id iby_external_payers_all.ext_payer_id%TYPE;
19: BEGIN

Line 16: account_site_use_id iby_external_payers_all.acct_site_use_id%TYPE

12:
13: FUNCTION GET_EXTERNAL_PAYER_ID
14: (
15: account_id iby_external_payers_all.cust_account_id%TYPE,
16: account_site_use_id iby_external_payers_all.acct_site_use_id%TYPE
17: ) RETURN NUMBER IS
18: ext_payer_id iby_external_payers_all.ext_payer_id%TYPE;
19: BEGIN
20: OPEN cur_get_ext_payer_id(account_id,account_site_use_id);

Line 18: ext_payer_id iby_external_payers_all.ext_payer_id%TYPE;

14: (
15: account_id iby_external_payers_all.cust_account_id%TYPE,
16: account_site_use_id iby_external_payers_all.acct_site_use_id%TYPE
17: ) RETURN NUMBER IS
18: ext_payer_id iby_external_payers_all.ext_payer_id%TYPE;
19: BEGIN
20: OPEN cur_get_ext_payer_id(account_id,account_site_use_id);
21: FETCH cur_get_ext_payer_id INTO ext_payer_id;
22: CLOSE cur_get_ext_payer_id;

Line 764: | Account merge procedure for the table, IBY_EXTERNAL_PAYERS_ALL

760: |
761: | PROCEDURE
762: | MERGE
763: | DESCRIPTION :
764: | Account merge procedure for the table, IBY_EXTERNAL_PAYERS_ALL
765: |
766: | ******************************
767: |
768: |--------------------------------------------------------------*/

Line 783: iby_external_payers_all.cust_account_id%TYPE

779:
780: primary_key_id_list ext_payer_id_list_type;
781:
782: TYPE cust_account_id_list_type IS TABLE OF
783: iby_external_payers_all.cust_account_id%TYPE
784: INDEX BY BINARY_INTEGER;
785: num_col1_orig_list cust_account_id_list_type;
786: num_col1_new_list cust_account_id_list_type;
787:

Line 789: iby_external_payers_all.acct_site_use_id%TYPE

785: num_col1_orig_list cust_account_id_list_type;
786: num_col1_new_list cust_account_id_list_type;
787:
788: TYPE acct_site_use_id_list_type IS TABLE OF
789: iby_external_payers_all.acct_site_use_id%TYPE
790: INDEX BY BINARY_INTEGER;
791: num_col2_orig_list acct_site_use_id_list_type;
792: num_col2_new_list acct_site_use_id_list_type;
793:

Line 807: FROM iby_external_payers_all yt, ra_customer_merges m

803: SELECT DISTINCT customer_merge_header_id
804: ,ext_payer_id
805: ,cust_account_id
806: ,acct_site_use_id
807: FROM iby_external_payers_all yt, ra_customer_merges m
808: WHERE (
809: ( yt.cust_account_id = m.duplicate_id
810: AND yt.acct_site_use_id is null
811: AND m.customer_id <> m.duplicate_id )

Line 824: l_dup_payer IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;

820: l_last_fetch BOOLEAN := FALSE;
821: l_count NUMBER;
822: l_payer_transferred BOOLEAN;
823:
824: l_dup_payer IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
825: l_payer_count NUMBER;
826:
827: BEGIN
828: IF process_mode='LOCK' THEN

Line 832: arp_message.set_token('TABLE_NAME','IBY_EXTERNAL_PAYERS_ALL',FALSE);

828: IF process_mode='LOCK' THEN
829: NULL;
830: ELSE
831: arp_message.set_name('AR','AR_UPDATING_TABLE');
832: arp_message.set_token('TABLE_NAME','IBY_EXTERNAL_PAYERS_ALL',FALSE);
833: hz_acct_merge_util.load_set(set_num, req_id);
834: l_profile_val := fnd_profile.value('HZ_AUDIT_ACCT_MERGE');
835:
836: open merged_records;

Line 884: 'IBY_EXTERNAL_PAYERS_ALL',

880: last_update_login,
881: last_update_date,
882: last_updated_by
883: ) VALUES ( hz_customer_merge_log_s.nextval,
884: 'IBY_EXTERNAL_PAYERS_ALL',
885: merge_header_id_list(i),
886: primary_key_id_list(i),
887: num_col1_orig_list(i),
888: num_col1_new_list(i),

Line 918: FROM IBY_EXTERNAL_PAYERS_ALL

914: iby_debug_pub.Add( '*** num_col1_new_list(i) ' || num_col1_new_list(i));
915: iby_debug_pub.Add( '*** num_col2_new_list(i) ' || num_col2_new_list(i));
916:
917: SELECT count(ext_payer_id) into l_payer_count
918: FROM IBY_EXTERNAL_PAYERS_ALL
919: WHERE cust_account_id = num_col1_new_list(i)
920: AND acct_site_use_id = num_col2_new_list(i)
921: AND ext_payer_from_list(i) is not null
922: AND ext_payer_to_list(i) is null;

Line 930: FROM IBY_EXTERNAL_PAYERS_ALL

926:
927: IF( l_payer_count > 0)
928: THEN
929: SELECT ext_payer_id into l_dup_payer
930: FROM IBY_EXTERNAL_PAYERS_ALL
931: WHERE cust_account_id = num_col1_new_list(i)
932: AND acct_site_use_id = num_col2_new_list(i)
933: AND ext_payer_from_list(i) is not null
934: AND ext_payer_to_list(i) is null;

Line 950: UPDATE IBY_EXTERNAL_PAYERS_ALL yt SET

946: iby_debug_pub.Add( '*** primary_key_id_list(i) ' || primary_key_id_list(i));
947: iby_debug_pub.Add( '*** ext_payer_from_list(i) ' || ext_payer_from_list(i));
948: iby_debug_pub.Add( '*** ext_payer_to_list(i) added ' || ext_payer_to_list(i));
949:
950: UPDATE IBY_EXTERNAL_PAYERS_ALL yt SET
951: cust_account_id=num_col1_new_list(i)
952: ,acct_site_use_id=num_col2_new_list(i)
953: , last_update_date=SYSDATE
954: , last_updated_by=arp_standard.profile.user_id