[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pos_bank_payee_bo(payee.ext_payee_id,
payee.payee_party_id,
payee.payment_function,
payee.exclusive_payment_flag,
payee.created_by,
payee.creation_date,
payee.last_updated_by,
payee.last_update_date,
payee.last_update_login,
payee.object_version_number,
payee.party_site_id,
payee.supplier_site_id,
payee.org_id,
payee.org_type,
payee.default_payment_method_code,
payee.ece_tp_location_code,
payee.bank_charge_bearer,
payee.bank_instruction1_code,
payee.bank_instruction2_code,
payee.bank_instruction_details,
payee.payment_reason_code,
payee.payment_reason_comments,
payee.inactive_date,
payee.payment_text_message1,
payee.payment_text_message2,
payee.payment_text_message3,
payee.delivery_channel_code,
payee.payment_format_code,
payee.settlement_priority,
payee.remit_advice_delivery_method,
payee.remit_advice_email,
payee.remit_advice_fax,
NULL,
NULL,
NULL,
NULL,
instr.instrument_id, -- Bug 12903268: add bank account id into the object
instr.order_of_preference, -- Bug 13529064: add account details
instr.start_date,
instr.end_date) BULK COLLECT
INTO l_pos_bank_payee_bo_tbl
FROM iby_external_payees_all payee, iby_pmt_instr_uses_all instr
WHERE payee_party_id = l_party_id
AND payee.ext_payee_id = instr.ext_pmt_party_id (+); -- Bug 12903268: Associate bank account id with payee.
p_create_update_flag IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
v_row_exists NUMBER := 0;
x_ext_payee_update_status_tab iby_disbursement_setup_pub.Ext_Payee_Update_Tab_Type;
IF p_create_update_flag = 'U' THEN
iby_disbursement_setup_pub.update_external_payee(p_api_version,
p_init_msg_list,
p_ext_payee_tab,
p_ext_payee_id_tab,
x_return_status,
x_msg_count,
x_msg_data,
x_ext_payee_update_status_tab);
ELSIF p_create_update_flag = 'C' THEN
iby_disbursement_setup_pub.create_external_payee(p_api_version,
p_init_msg_list,
p_ext_payee_tab,
x_return_status,
x_msg_count,
x_msg_data,
x_ext_payee_id_tab,
x_ext_payee_status_tab);