4: -- Record Types
5:
6: -- External payee record and table
7: Type External_Payee_Rec_Type IS Record(
8: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
9: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
10: Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE,
11: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
12: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
5:
6: -- External payee record and table
7: Type External_Payee_Rec_Type IS Record(
8: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
9: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
10: Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE,
11: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
12: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
6: -- External payee record and table
7: Type External_Payee_Rec_Type IS Record(
8: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
9: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
10: Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE,
11: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
12: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
14: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
7: Type External_Payee_Rec_Type IS Record(
8: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
9: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
10: Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE,
11: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
12: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
14: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
15: Default_Pmt_method IBY_PAYMENT_METHODS_B.payment_method_code%TYPE,
8: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
9: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
10: Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE,
11: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
12: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
14: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
15: Default_Pmt_method IBY_PAYMENT_METHODS_B.payment_method_code%TYPE,
16: ECE_TP_Loc_Code IBY_EXTERNAL_PAYEES_ALL.ece_tp_location_code%TYPE,
9: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
10: Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE,
11: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
12: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
14: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
15: Default_Pmt_method IBY_PAYMENT_METHODS_B.payment_method_code%TYPE,
16: ECE_TP_Loc_Code IBY_EXTERNAL_PAYEES_ALL.ece_tp_location_code%TYPE,
17: Bank_Charge_Bearer IBY_EXTERNAL_PAYEES_ALL.bank_charge_bearer%TYPE,
10: Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE,
11: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
12: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
14: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
15: Default_Pmt_method IBY_PAYMENT_METHODS_B.payment_method_code%TYPE,
16: ECE_TP_Loc_Code IBY_EXTERNAL_PAYEES_ALL.ece_tp_location_code%TYPE,
17: Bank_Charge_Bearer IBY_EXTERNAL_PAYEES_ALL.bank_charge_bearer%TYPE,
18: Bank_Instr1_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
12: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
14: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
15: Default_Pmt_method IBY_PAYMENT_METHODS_B.payment_method_code%TYPE,
16: ECE_TP_Loc_Code IBY_EXTERNAL_PAYEES_ALL.ece_tp_location_code%TYPE,
17: Bank_Charge_Bearer IBY_EXTERNAL_PAYEES_ALL.bank_charge_bearer%TYPE,
18: Bank_Instr1_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
19: Bank_Instr2_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
20: Bank_Instr_Detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE,
13: Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
14: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
15: Default_Pmt_method IBY_PAYMENT_METHODS_B.payment_method_code%TYPE,
16: ECE_TP_Loc_Code IBY_EXTERNAL_PAYEES_ALL.ece_tp_location_code%TYPE,
17: Bank_Charge_Bearer IBY_EXTERNAL_PAYEES_ALL.bank_charge_bearer%TYPE,
18: Bank_Instr1_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
19: Bank_Instr2_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
20: Bank_Instr_Detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE,
21: Pay_Reason_Code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE,
14: Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
15: Default_Pmt_method IBY_PAYMENT_METHODS_B.payment_method_code%TYPE,
16: ECE_TP_Loc_Code IBY_EXTERNAL_PAYEES_ALL.ece_tp_location_code%TYPE,
17: Bank_Charge_Bearer IBY_EXTERNAL_PAYEES_ALL.bank_charge_bearer%TYPE,
18: Bank_Instr1_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
19: Bank_Instr2_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
20: Bank_Instr_Detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE,
21: Pay_Reason_Code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE,
22: Pay_Reason_Com IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE,
15: Default_Pmt_method IBY_PAYMENT_METHODS_B.payment_method_code%TYPE,
16: ECE_TP_Loc_Code IBY_EXTERNAL_PAYEES_ALL.ece_tp_location_code%TYPE,
17: Bank_Charge_Bearer IBY_EXTERNAL_PAYEES_ALL.bank_charge_bearer%TYPE,
18: Bank_Instr1_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
19: Bank_Instr2_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
20: Bank_Instr_Detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE,
21: Pay_Reason_Code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE,
22: Pay_Reason_Com IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE,
23: Inactive_Date IBY_EXTERNAL_PAYEES_ALL.inactive_date%TYPE,
16: ECE_TP_Loc_Code IBY_EXTERNAL_PAYEES_ALL.ece_tp_location_code%TYPE,
17: Bank_Charge_Bearer IBY_EXTERNAL_PAYEES_ALL.bank_charge_bearer%TYPE,
18: Bank_Instr1_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
19: Bank_Instr2_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
20: Bank_Instr_Detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE,
21: Pay_Reason_Code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE,
22: Pay_Reason_Com IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE,
23: Inactive_Date IBY_EXTERNAL_PAYEES_ALL.inactive_date%TYPE,
24: Pay_Message1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
17: Bank_Charge_Bearer IBY_EXTERNAL_PAYEES_ALL.bank_charge_bearer%TYPE,
18: Bank_Instr1_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
19: Bank_Instr2_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
20: Bank_Instr_Detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE,
21: Pay_Reason_Code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE,
22: Pay_Reason_Com IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE,
23: Inactive_Date IBY_EXTERNAL_PAYEES_ALL.inactive_date%TYPE,
24: Pay_Message1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
25: Pay_Message2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
18: Bank_Instr1_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
19: Bank_Instr2_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
20: Bank_Instr_Detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE,
21: Pay_Reason_Code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE,
22: Pay_Reason_Com IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE,
23: Inactive_Date IBY_EXTERNAL_PAYEES_ALL.inactive_date%TYPE,
24: Pay_Message1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
25: Pay_Message2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
26: Pay_Message3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
19: Bank_Instr2_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
20: Bank_Instr_Detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE,
21: Pay_Reason_Code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE,
22: Pay_Reason_Com IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE,
23: Inactive_Date IBY_EXTERNAL_PAYEES_ALL.inactive_date%TYPE,
24: Pay_Message1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
25: Pay_Message2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
26: Pay_Message3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
27: Delivery_Channel IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE,
20: Bank_Instr_Detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE,
21: Pay_Reason_Code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE,
22: Pay_Reason_Com IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE,
23: Inactive_Date IBY_EXTERNAL_PAYEES_ALL.inactive_date%TYPE,
24: Pay_Message1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
25: Pay_Message2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
26: Pay_Message3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
27: Delivery_Channel IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE,
28: Pmt_Format IBY_FORMATS_B.format_code%TYPE,
21: Pay_Reason_Code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE,
22: Pay_Reason_Com IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE,
23: Inactive_Date IBY_EXTERNAL_PAYEES_ALL.inactive_date%TYPE,
24: Pay_Message1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
25: Pay_Message2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
26: Pay_Message3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
27: Delivery_Channel IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE,
28: Pmt_Format IBY_FORMATS_B.format_code%TYPE,
29: Settlement_Priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE
22: Pay_Reason_Com IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE,
23: Inactive_Date IBY_EXTERNAL_PAYEES_ALL.inactive_date%TYPE,
24: Pay_Message1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
25: Pay_Message2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
26: Pay_Message3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
27: Delivery_Channel IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE,
28: Pmt_Format IBY_FORMATS_B.format_code%TYPE,
29: Settlement_Priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE
30: );
23: Inactive_Date IBY_EXTERNAL_PAYEES_ALL.inactive_date%TYPE,
24: Pay_Message1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
25: Pay_Message2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
26: Pay_Message3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
27: Delivery_Channel IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE,
28: Pmt_Format IBY_FORMATS_B.format_code%TYPE,
29: Settlement_Priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE
30: );
31:
25: Pay_Message2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
26: Pay_Message3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
27: Delivery_Channel IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE,
28: Pmt_Format IBY_FORMATS_B.format_code%TYPE,
29: Settlement_Priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE
30: );
31:
32: TYPE r_vendor_rec_type IS RECORD(
33: VENDOR_ID PO_VENDORS.VENDOR_ID%TYPE,