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

Line 882: from IBY_EXTERNAL_PAYERS_ALL

878: where INSTRUMENT_PAYMENT_USE_ID = c_assignment_id;
879:
880: cursor c_check_ext_payer_id (c_party_id NUMBER) is
881: select EXT_PAYER_ID
882: from IBY_EXTERNAL_PAYERS_ALL
883: where party_id = c_party_id
884: AND org_id IS NULL
885: AND cust_account_id IS NULL
886: AND acct_site_use_id IS NULL;

Line 1034: -- IBY_EXTERNAL_PAYERS_ALL table so that the corresponding identifer could be

1030:
1031: /*--iii) if this row does not exist, create an assignment for the partyId of the user
1032: -- with order_of_preference = 1 by directly inserting into IBY assignment table:
1033: -- IBY_PMT_INSTR_USES_ALL. A record might also need to be created in
1034: -- IBY_EXTERNAL_PAYERS_ALL table so that the corresponding identifer could be
1035: -- substitued in ext_pmt_party_id column of the iby_pmt_instr_uses all table.*/
1036: IF p_debug_flag = 'T' THEN
1037: print_debug_log('Going for direct inserts into IBY_EXTERNAL_PAYERS_ALL');
1038: END IF;

Line 1037: print_debug_log('Going for direct inserts into IBY_EXTERNAL_PAYERS_ALL');

1033: -- IBY_PMT_INSTR_USES_ALL. A record might also need to be created in
1034: -- IBY_EXTERNAL_PAYERS_ALL table so that the corresponding identifer could be
1035: -- substitued in ext_pmt_party_id column of the iby_pmt_instr_uses all table.*/
1036: IF p_debug_flag = 'T' THEN
1037: print_debug_log('Going for direct inserts into IBY_EXTERNAL_PAYERS_ALL');
1038: END IF;
1039:
1040: FOR rec_check_ext_payer_id in c_check_ext_payer_id(l_party_to_use) LOOP
1041:

Line 1049: select IBY_EXTERNAL_PAYERS_ALL_S.Nextval into l_ext_payer_id

1045:
1046: IF (l_EXT_PAYER_ID is NULL ) THEN
1047:
1048:
1049: select IBY_EXTERNAL_PAYERS_ALL_S.Nextval into l_ext_payer_id
1050: from dual;
1051:
1052: INSERT INTO IBY_EXTERNAL_PAYERS_ALL(
1053: EXT_PAYER_ID ,

Line 1052: INSERT INTO IBY_EXTERNAL_PAYERS_ALL(

1048:
1049: select IBY_EXTERNAL_PAYERS_ALL_S.Nextval into l_ext_payer_id
1050: from dual;
1051:
1052: INSERT INTO IBY_EXTERNAL_PAYERS_ALL(
1053: EXT_PAYER_ID ,
1054: PAYMENT_FUNCTION ,
1055: PARTY_ID ,
1056: CREATED_BY ,

Line 1075: from IBY_EXTERNAL_PAYERS_ALL

1071: fnd_global.USER_ID ,
1072: 1 );
1073:
1074: Select ext_payer_id into l_ext_payer_id_verify
1075: from IBY_EXTERNAL_PAYERS_ALL
1076: where ext_payer_id = l_ext_payer_id;
1077:
1078: IF p_debug_flag = 'T' THEN
1079: print_debug_log('Successfully inserted into IBY_EXTERNAL_PAYERS_ALL');

Line 1079: print_debug_log('Successfully inserted into IBY_EXTERNAL_PAYERS_ALL');

1075: from IBY_EXTERNAL_PAYERS_ALL
1076: where ext_payer_id = l_ext_payer_id;
1077:
1078: IF p_debug_flag = 'T' THEN
1079: print_debug_log('Successfully inserted into IBY_EXTERNAL_PAYERS_ALL');
1080: print_debug_log('Record ID inserted : '||l_ext_payer_id_verify);
1081: END IF;
1082:
1083: