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_PMT_INSTR_USES_ALL

Line 810: -- cc_id might have many rows in the IBY_pmt_instr_uses_all table

806:
807: --d) We will store assignment_id value for the Express Checkout Settings going forward because:
808: -- we eventually have to pass the assignment_id to the ASO api's to create the Express
809: -- Checkout cart and, using cc_id, it's difficult to derive the assignment_id because one
810: -- cc_id might have many rows in the IBY_pmt_instr_uses_all table
811: -- because it might be assigned to the party or party-acct or party-org combinations.
812:
813: -- log old and new values before the update
814: IF l_iby_debug = 'T' THEN

Line 879: from IBY_PMT_INSTR_USES_ALL

875: AND acct_site_use_id IS NULL;
876:
877: cursor c_find_instr_payment_use(c_assignment_id NUMBER) is
878: Select INSTRUMENT_PAYMENT_USE_ID
879: from IBY_PMT_INSTR_USES_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

Line 973: -- IBY_PMT_INSTR_USES_ALL table

969: l_party_to_use := l_customer_id;
970: END IF;
971:
972: --c) next, use the new cc_id and the partyId to find the corresponding row in the
973: -- IBY_PMT_INSTR_USES_ALL table
974:
975: FOR rec_check_assignment_id in c_check_assignment_id(l_instrument_id, l_party_to_use) LOOP
976: l_instrument_assignment_id := rec_check_assignment_id.instr_assignment_id;
977: l_order_of_preference := rec_check_assignment_id.order_of_preference;

Line 1001: UPDATE IBY_PMT_INSTR_USES_ALL

997: END LOOP;
998:
999: IF(l_instrument_payment_use_id is not null) THEN
1000:
1001: UPDATE IBY_PMT_INSTR_USES_ALL
1002: SET order_of_preference = 1
1003: WHERE INSTRUMENT_PAYMENT_USE_ID = l_INSTRUMENT_PAYMENT_USE_ID;
1004:
1005: IF p_debug_flag = 'T' THEN

Line 1006: print_debug_log('Updated IBY_PMT_INSTR_USES_ALL');

1002: SET order_of_preference = 1
1003: WHERE INSTRUMENT_PAYMENT_USE_ID = l_INSTRUMENT_PAYMENT_USE_ID;
1004:
1005: IF p_debug_flag = 'T' THEN
1006: print_debug_log('Updated IBY_PMT_INSTR_USES_ALL');
1007: print_debug_log(' Old value of Order_of_preference = '||l_order_of_preference);
1008: print_debug_log(' New value of Order_of_preference = 1');
1009: print_debug_log(' INSTRUMENT_PAYMENT_USE_ID Record updated: '||l_instrument_assignment_id);
1010: END IF;

Line 1012: UPDATE iby_pmt_instr_uses_all

1008: print_debug_log(' New value of Order_of_preference = 1');
1009: print_debug_log(' INSTRUMENT_PAYMENT_USE_ID Record updated: '||l_instrument_assignment_id);
1010: END IF;
1011:
1012: UPDATE iby_pmt_instr_uses_all
1013: SET order_of_preference = order_of_preference + 1,
1014: last_updated_by = fnd_global.user_id,
1015: last_update_date = SYSDATE,
1016: last_update_login = fnd_global.login_id,

Line 1021: FROM iby_pmt_instr_uses_all

1017: object_version_number = object_version_number + 1
1018: WHERE instrument_payment_use_id IN
1019: (
1020: SELECT instrument_payment_use_id
1021: FROM iby_pmt_instr_uses_all
1022: WHERE (ext_pmt_party_id = l_party_to_use)
1023: AND (payment_flow = 'FUNDS_CAPTURE')
1024: START WITH order_of_preference = l_order_of_preference
1025: AND (ext_pmt_party_id = l_party_to_use)

Line 1035: -- IBY_PMT_INSTR_USES_ALL. A record might also need to be created in

1031: ELSE
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');

Line 1037: -- substitued in ext_pmt_party_id column of the iby_pmt_instr_uses all table.*/

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;
1041:

Line 1087: -- if the above query returns any value, use that in the insert to IBY_PMT_INSTR_USES_ALL

1083: END IF;
1084:
1085:
1086:
1087: -- if the above query returns any value, use that in the insert to IBY_PMT_INSTR_USES_ALL
1088: -- as mentioned in (iii) above.
1089: --log the new values inserted
1090:
1091: IF(l_ext_payer_id_verify is not null) THEN

Line 1094: print_debug_log('Doing a direct insert into IBY_PMT_INSTR_USES_ALL');

1090:
1091: IF(l_ext_payer_id_verify is not null) THEN
1092:
1093: IF p_debug_flag = 'T' THEN
1094: print_debug_log('Doing a direct insert into IBY_PMT_INSTR_USES_ALL');
1095: END IF;
1096:
1097: INSERT INTO IBY_PMT_INSTR_USES_ALL(
1098: INSTRUMENT_PAYMENT_USE_ID ,

Line 1097: INSERT INTO IBY_PMT_INSTR_USES_ALL(

1093: IF p_debug_flag = 'T' THEN
1094: print_debug_log('Doing a direct insert into IBY_PMT_INSTR_USES_ALL');
1095: END IF;
1096:
1097: INSERT INTO IBY_PMT_INSTR_USES_ALL(
1098: INSTRUMENT_PAYMENT_USE_ID ,
1099: PAYMENT_FLOW ,
1100: EXT_PMT_PARTY_ID ,
1101: INSTRUMENT_TYPE ,

Line 1132: print_debug_log('Inserted a record in IBY_PMT_INSTR_USES_ALL');

1128:
1129: END IF; --l_ext_payer_id_verify is not null
1130:
1131: IF p_debug_flag = 'T' THEN
1132: print_debug_log('Inserted a record in IBY_PMT_INSTR_USES_ALL');
1133: print_debug_log('Inserted a record for l_instrument_assignment_use_id '||l_instrument_assignment_id);
1134: print_debug_log('Inserted a record for l_instrument_id '||l_instrument_id);
1135: END IF;
1136: END IF; -- l_EXT_PAYER_ID