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.AP_VENDOR_PUB_PKG dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 7838: l_pymt_method_code iby_external_payees_all.default_payment_method_code%TYPE;

7834: l_ext_payee_rec IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE;
7835:
7836: -- Bug#7506443 start
7837: l_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
7838: l_pymt_method_code iby_external_payees_all.default_payment_method_code%TYPE;
7839: l_inactive_date iby_external_payees_all.Inactive_Date%TYPE;
7840: l_Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE;
7841: -- Debug Bug 8769088 start
7842: l_delivery_channel_code IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE;

Line 7839: l_inactive_date iby_external_payees_all.Inactive_Date%TYPE;

7835:
7836: -- Bug#7506443 start
7837: l_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
7838: l_pymt_method_code iby_external_payees_all.default_payment_method_code%TYPE;
7839: l_inactive_date iby_external_payees_all.Inactive_Date%TYPE;
7840: l_Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE;
7841: -- Debug Bug 8769088 start
7842: l_delivery_channel_code IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE;
7843: l_bank_instruction1_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;

Line 7840: l_Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE;

7836: -- Bug#7506443 start
7837: l_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
7838: l_pymt_method_code iby_external_payees_all.default_payment_method_code%TYPE;
7839: l_inactive_date iby_external_payees_all.Inactive_Date%TYPE;
7840: l_Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE;
7841: -- Debug Bug 8769088 start
7842: l_delivery_channel_code IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE;
7843: l_bank_instruction1_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
7844: l_bank_instruction2_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;

Line 7842: l_delivery_channel_code IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE;

7838: l_pymt_method_code iby_external_payees_all.default_payment_method_code%TYPE;
7839: l_inactive_date iby_external_payees_all.Inactive_Date%TYPE;
7840: l_Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE;
7841: -- Debug Bug 8769088 start
7842: l_delivery_channel_code IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE;
7843: l_bank_instruction1_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
7844: l_bank_instruction2_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
7845: l_bank_instr_detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE;
7846: l_settlement_priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE;

Line 7843: l_bank_instruction1_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;

7839: l_inactive_date iby_external_payees_all.Inactive_Date%TYPE;
7840: l_Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE;
7841: -- Debug Bug 8769088 start
7842: l_delivery_channel_code IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE;
7843: l_bank_instruction1_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
7844: l_bank_instruction2_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
7845: l_bank_instr_detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE;
7846: l_settlement_priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE;
7847: l_payment_text_msg1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE;

Line 7844: l_bank_instruction2_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;

7840: l_Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE;
7841: -- Debug Bug 8769088 start
7842: l_delivery_channel_code IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE;
7843: l_bank_instruction1_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
7844: l_bank_instruction2_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
7845: l_bank_instr_detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE;
7846: l_settlement_priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE;
7847: l_payment_text_msg1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE;
7848: l_payment_text_msg2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE;

Line 7845: l_bank_instr_detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE;

7841: -- Debug Bug 8769088 start
7842: l_delivery_channel_code IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE;
7843: l_bank_instruction1_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
7844: l_bank_instruction2_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
7845: l_bank_instr_detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE;
7846: l_settlement_priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE;
7847: l_payment_text_msg1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE;
7848: l_payment_text_msg2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE;
7849: l_payment_text_msg3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE;

Line 7846: l_settlement_priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE;

7842: l_delivery_channel_code IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE;
7843: l_bank_instruction1_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
7844: l_bank_instruction2_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
7845: l_bank_instr_detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE;
7846: l_settlement_priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE;
7847: l_payment_text_msg1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE;
7848: l_payment_text_msg2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE;
7849: l_payment_text_msg3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE;
7850: l_payment_reason_code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE;

Line 7847: l_payment_text_msg1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE;

7843: l_bank_instruction1_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
7844: l_bank_instruction2_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
7845: l_bank_instr_detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE;
7846: l_settlement_priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE;
7847: l_payment_text_msg1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE;
7848: l_payment_text_msg2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE;
7849: l_payment_text_msg3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE;
7850: l_payment_reason_code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE;
7851: l_paymt_rsn_comts IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE;

Line 7848: l_payment_text_msg2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE;

7844: l_bank_instruction2_code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
7845: l_bank_instr_detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE;
7846: l_settlement_priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE;
7847: l_payment_text_msg1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE;
7848: l_payment_text_msg2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE;
7849: l_payment_text_msg3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE;
7850: l_payment_reason_code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE;
7851: l_paymt_rsn_comts IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE;
7852: l_pmt_format IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;

Line 7849: l_payment_text_msg3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE;

7845: l_bank_instr_detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE;
7846: l_settlement_priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE;
7847: l_payment_text_msg1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE;
7848: l_payment_text_msg2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE;
7849: l_payment_text_msg3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE;
7850: l_payment_reason_code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE;
7851: l_paymt_rsn_comts IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE;
7852: l_pmt_format IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
7853: l_remt_advc_dlvry_mthd IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;

Line 7850: l_payment_reason_code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE;

7846: l_settlement_priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE;
7847: l_payment_text_msg1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE;
7848: l_payment_text_msg2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE;
7849: l_payment_text_msg3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE;
7850: l_payment_reason_code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE;
7851: l_paymt_rsn_comts IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE;
7852: l_pmt_format IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
7853: l_remt_advc_dlvry_mthd IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;
7854: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;

Line 7851: l_paymt_rsn_comts IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE;

7847: l_payment_text_msg1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE;
7848: l_payment_text_msg2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE;
7849: l_payment_text_msg3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE;
7850: l_payment_reason_code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE;
7851: l_paymt_rsn_comts IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE;
7852: l_pmt_format IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
7853: l_remt_advc_dlvry_mthd IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;
7854: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;
7855: l_remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.remit_advice_fax%TYPE;

Line 7852: l_pmt_format IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;

7848: l_payment_text_msg2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE;
7849: l_payment_text_msg3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE;
7850: l_payment_reason_code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE;
7851: l_paymt_rsn_comts IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE;
7852: l_pmt_format IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
7853: l_remt_advc_dlvry_mthd IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;
7854: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;
7855: l_remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.remit_advice_fax%TYPE;
7856: l_ext_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

Line 7853: l_remt_advc_dlvry_mthd IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;

7849: l_payment_text_msg3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE;
7850: l_payment_reason_code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE;
7851: l_paymt_rsn_comts IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE;
7852: l_pmt_format IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
7853: l_remt_advc_dlvry_mthd IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;
7854: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;
7855: l_remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.remit_advice_fax%TYPE;
7856: l_ext_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
7857: -- Debug Bug 8769088 end

Line 7854: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;

7850: l_payment_reason_code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE;
7851: l_paymt_rsn_comts IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE;
7852: l_pmt_format IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
7853: l_remt_advc_dlvry_mthd IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;
7854: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;
7855: l_remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.remit_advice_fax%TYPE;
7856: l_ext_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
7857: -- Debug Bug 8769088 end
7858: -- Bug#7506443 start

Line 7855: l_remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.remit_advice_fax%TYPE;

7851: l_paymt_rsn_comts IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE;
7852: l_pmt_format IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
7853: l_remt_advc_dlvry_mthd IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;
7854: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;
7855: l_remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.remit_advice_fax%TYPE;
7856: l_ext_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
7857: -- Debug Bug 8769088 end
7858: -- Bug#7506443 start
7859:

Line 7856: l_ext_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

7852: l_pmt_format IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
7853: l_remt_advc_dlvry_mthd IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;
7854: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;
7855: l_remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.remit_advice_fax%TYPE;
7856: l_ext_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
7857: -- Debug Bug 8769088 end
7858: -- Bug#7506443 start
7859:
7860: l_sync_return_status VARCHAR2(50);

Line 7898: FROM iBy_External_Payees_All iep

7894: iep.remit_advice_email, -- separate remittance advice delivery
7895: iep.remit_advice_fax, -- separate remittance advice delivery
7896: -- Bug 8769088 end
7897: iep.ext_payee_id
7898: FROM iBy_External_Payees_All iep
7899: WHERE iep.Payee_Party_Id = p_prty_id
7900: AND Party_Site_Id IS NULL
7901: AND Supplier_Site_Id IS NULL;
7902: