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 884: from IBY_EXTERNAL_PAYERS_ALL

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

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

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

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

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

Line 1051: select IBY_EXTERNAL_PAYERS_ALL_S.Nextval into l_ext_payer_id

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

Line 1054: INSERT INTO IBY_EXTERNAL_PAYERS_ALL(

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

Line 1077: from IBY_EXTERNAL_PAYERS_ALL

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

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

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