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_IMPORT_PMT_ACK_DATA_PUB dependencies on IBY_ACK_PMT_ALL

Line 57: (p_bank_status_code IN iby_ack_pmt_all.bank_status_code%TYPE)

53: END Payment_Reference_Exists;
54:
55:
56: FUNCTION Bank_Status_Exists
57: (p_bank_status_code IN iby_ack_pmt_all.bank_status_code%TYPE)
58: RETURN BOOLEAN
59: IS
60: l_count NUMBER;
61: l_dbg_mod VARCHAR2(100) := G_PKG_NAME || '.Bank_Status_Exists';

Line 64: (ci_bank_status IN iby_ack_pmt_all.bank_status_code%TYPE)

60: l_count NUMBER;
61: l_dbg_mod VARCHAR2(100) := G_PKG_NAME || '.Bank_Status_Exists';
62:
63: CURSOR c_bank_status
64: (ci_bank_status IN iby_ack_pmt_all.bank_status_code%TYPE)
65: IS
66: SELECT count(1)
67: FROM iby_bank_ack_statuses
68: WHERE bank_ack_status_code = p_bank_status_code

Line 94: (p_bank_status_code IN iby_ack_pmt_all.bank_status_code%TYPE)

90: END Bank_Status_Exists;
91:
92:
93: FUNCTION Get_Payment_Ack_ASatus
94: (p_bank_status_code IN iby_ack_pmt_all.bank_status_code%TYPE)
95: RETURN VARCHAR2
96: IS
97: l_ack_status VARCHAR2(200);
98: l_dbg_mod VARCHAR2(100) := G_PKG_NAME || '.Get_Payment_Ack_ASatus';

Line 101: (ci_bank_status IN iby_ack_pmt_all.bank_status_code%TYPE)

97: l_ack_status VARCHAR2(200);
98: l_dbg_mod VARCHAR2(100) := G_PKG_NAME || '.Get_Payment_Ack_ASatus';
99:
100: CURSOR c_pmt_ack_status
101: (ci_bank_status IN iby_ack_pmt_all.bank_status_code%TYPE)
102: IS
103: SELECT payment_ack_status
104: FROM iby_bank_ack_statuses
105: WHERE bank_ack_status_code = ci_bank_status;

Line 205: l_pmt_ack_status iby_ack_pmt_all.payment_ack_status%TYPE;

201: l_calculated_amt NUMBER;
202: l_calculated_bank_charge_amt NUMBER;
203: l_ack_pmt_id NUMBER;
204: l_pmt_id NUMBER;
205: l_pmt_ack_status iby_ack_pmt_all.payment_ack_status%TYPE;
206: l_counter NUMBER;
207:
208: l_resp_id fnd_responsibility_tl.responsibility_id%TYPE;
209:

Line 307: -- Inserting record in to IBY_ACK_PMT_ALL

303: l_calculated_amt := P_PAYMENT_AMOUNT * P_EXCHANGE_RATE;
304: l_calculated_bank_charge_amt := P_BANK_CHARGE_AMOUNT * P_EXCHANGE_RATE;
305: l_pmt_ack_status := Get_Payment_Ack_ASatus(P_BANK_STATUS_CODE);
306:
307: -- Inserting record in to IBY_ACK_PMT_ALL
308:
309: select iby_ack_pmt_all_s.NEXTVAL into l_ack_pmt_id from dual;
310:
311: INSERT INTO iby_ack_pmt_all

Line 309: select iby_ack_pmt_all_s.NEXTVAL into l_ack_pmt_id from dual;

305: l_pmt_ack_status := Get_Payment_Ack_ASatus(P_BANK_STATUS_CODE);
306:
307: -- Inserting record in to IBY_ACK_PMT_ALL
308:
309: select iby_ack_pmt_all_s.NEXTVAL into l_ack_pmt_id from dual;
310:
311: INSERT INTO iby_ack_pmt_all
312: ( ack_pmt_id, payment_ref_number,payment_instruction_ref_number
313: ,bank_status_code,payment_ack_status,acknowledgement_date,bank_assigned_ref_code1, bank_assigned_ref_code2

Line 311: INSERT INTO iby_ack_pmt_all

307: -- Inserting record in to IBY_ACK_PMT_ALL
308:
309: select iby_ack_pmt_all_s.NEXTVAL into l_ack_pmt_id from dual;
310:
311: INSERT INTO iby_ack_pmt_all
312: ( ack_pmt_id, payment_ref_number,payment_instruction_ref_number
313: ,bank_status_code,payment_ack_status,acknowledgement_date,bank_assigned_ref_code1, bank_assigned_ref_code2
314: ,payer_name,payer_bank_name,payer_bank_branch_name,payer_bank_swift_code,payer_bank_account_number,payer_bank_iban_number
315: ,payee_name,payee_bank_name,payee_bank_branch_name,payee_bank_swift_code,payee_bank_account_number,payee_bank_iban_number