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 808: -- cc_id might have many rows in the IBY_pmt_instr_uses_all table

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

Line 877: from IBY_PMT_INSTR_USES_ALL

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

Line 971: -- IBY_PMT_INSTR_USES_ALL table

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

Line 999: UPDATE IBY_PMT_INSTR_USES_ALL

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

Line 1004: print_debug_log('Updated IBY_PMT_INSTR_USES_ALL');

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

Line 1010: UPDATE iby_pmt_instr_uses_all

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

Line 1019: FROM iby_pmt_instr_uses_all

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

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

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

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

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

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

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

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

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

Line 1095: INSERT INTO IBY_PMT_INSTR_USES_ALL(

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

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

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