43:
44: -- Payment Method Record
45: Type Payment_Method_Rec_Type is Record
46: (
47: Payment_Method_Name IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_NAME%TYPE,
48: Payment_Method_Code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE,
49: Bill_Payable_Flag IBY_PAYMENT_METHODS_VL.SUPPORT_BILLS_PAYABLE_FLAG%TYPE,
50: Maturity_Date_Offset IBY_PAYMENT_METHODS_VL.MATURITY_DATE_OFFSET_DAYS%TYPE,
51: DESCRIPTION IBY_PAYMENT_METHODS_VL.DESCRIPTION%TYPE
44: -- Payment Method Record
45: Type Payment_Method_Rec_Type is Record
46: (
47: Payment_Method_Name IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_NAME%TYPE,
48: Payment_Method_Code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE,
49: Bill_Payable_Flag IBY_PAYMENT_METHODS_VL.SUPPORT_BILLS_PAYABLE_FLAG%TYPE,
50: Maturity_Date_Offset IBY_PAYMENT_METHODS_VL.MATURITY_DATE_OFFSET_DAYS%TYPE,
51: DESCRIPTION IBY_PAYMENT_METHODS_VL.DESCRIPTION%TYPE
52: );
45: Type Payment_Method_Rec_Type is Record
46: (
47: Payment_Method_Name IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_NAME%TYPE,
48: Payment_Method_Code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE,
49: Bill_Payable_Flag IBY_PAYMENT_METHODS_VL.SUPPORT_BILLS_PAYABLE_FLAG%TYPE,
50: Maturity_Date_Offset IBY_PAYMENT_METHODS_VL.MATURITY_DATE_OFFSET_DAYS%TYPE,
51: DESCRIPTION IBY_PAYMENT_METHODS_VL.DESCRIPTION%TYPE
52: );
53:
46: (
47: Payment_Method_Name IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_NAME%TYPE,
48: Payment_Method_Code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE,
49: Bill_Payable_Flag IBY_PAYMENT_METHODS_VL.SUPPORT_BILLS_PAYABLE_FLAG%TYPE,
50: Maturity_Date_Offset IBY_PAYMENT_METHODS_VL.MATURITY_DATE_OFFSET_DAYS%TYPE,
51: DESCRIPTION IBY_PAYMENT_METHODS_VL.DESCRIPTION%TYPE
52: );
53:
54: -- Payment Profile Drivers Record
47: Payment_Method_Name IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_NAME%TYPE,
48: Payment_Method_Code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE,
49: Bill_Payable_Flag IBY_PAYMENT_METHODS_VL.SUPPORT_BILLS_PAYABLE_FLAG%TYPE,
50: Maturity_Date_Offset IBY_PAYMENT_METHODS_VL.MATURITY_DATE_OFFSET_DAYS%TYPE,
51: DESCRIPTION IBY_PAYMENT_METHODS_VL.DESCRIPTION%TYPE
52: );
53:
54: -- Payment Profile Drivers Record
55: Type PPP_Drivers_Rec_Type IS Record(
175: );
176:
177: -- Payment Field Properties Record
178: Type Applicable_Pmt_Attrs_Rec_Type is Record(
179: Payment_Reason_Comnt_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_comnt_apl_flag%TYPE,
180: Remittance_Message1_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message1_apl_flag%TYPE,
181: Remittance_Message2_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message2_apl_flag%TYPE,
182: Remittance_Message3_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message3_apl_flag%TYPE,
183:
176:
177: -- Payment Field Properties Record
178: Type Applicable_Pmt_Attrs_Rec_Type is Record(
179: Payment_Reason_Comnt_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_comnt_apl_flag%TYPE,
180: Remittance_Message1_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message1_apl_flag%TYPE,
181: Remittance_Message2_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message2_apl_flag%TYPE,
182: Remittance_Message3_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message3_apl_flag%TYPE,
183:
184: Unique_Remittance_apl_flag IBY_PAYMENT_METHODS_VL.unique_remittance_id_apl_flag%TYPE,
177: -- Payment Field Properties Record
178: Type Applicable_Pmt_Attrs_Rec_Type is Record(
179: Payment_Reason_Comnt_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_comnt_apl_flag%TYPE,
180: Remittance_Message1_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message1_apl_flag%TYPE,
181: Remittance_Message2_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message2_apl_flag%TYPE,
182: Remittance_Message3_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message3_apl_flag%TYPE,
183:
184: Unique_Remittance_apl_flag IBY_PAYMENT_METHODS_VL.unique_remittance_id_apl_flag%TYPE,
185: URI_CheckDigit_apl_flag IBY_PAYMENT_METHODS_VL.uri_check_digit_apl_flag%TYPE,
178: Type Applicable_Pmt_Attrs_Rec_Type is Record(
179: Payment_Reason_Comnt_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_comnt_apl_flag%TYPE,
180: Remittance_Message1_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message1_apl_flag%TYPE,
181: Remittance_Message2_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message2_apl_flag%TYPE,
182: Remittance_Message3_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message3_apl_flag%TYPE,
183:
184: Unique_Remittance_apl_flag IBY_PAYMENT_METHODS_VL.unique_remittance_id_apl_flag%TYPE,
185: URI_CheckDigit_apl_flag IBY_PAYMENT_METHODS_VL.uri_check_digit_apl_flag%TYPE,
186: Payment_Format_apl_flag IBY_PAYMENT_METHODS_VL.payment_format_apl_flag%TYPE,
180: Remittance_Message1_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message1_apl_flag%TYPE,
181: Remittance_Message2_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message2_apl_flag%TYPE,
182: Remittance_Message3_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message3_apl_flag%TYPE,
183:
184: Unique_Remittance_apl_flag IBY_PAYMENT_METHODS_VL.unique_remittance_id_apl_flag%TYPE,
185: URI_CheckDigit_apl_flag IBY_PAYMENT_METHODS_VL.uri_check_digit_apl_flag%TYPE,
186: Payment_Format_apl_flag IBY_PAYMENT_METHODS_VL.payment_format_apl_flag%TYPE,
187: Delivery_Channel_apl_flag IBY_PAYMENT_METHODS_VL.delivery_channel_apl_flag%TYPE,
188:
181: Remittance_Message2_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message2_apl_flag%TYPE,
182: Remittance_Message3_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message3_apl_flag%TYPE,
183:
184: Unique_Remittance_apl_flag IBY_PAYMENT_METHODS_VL.unique_remittance_id_apl_flag%TYPE,
185: URI_CheckDigit_apl_flag IBY_PAYMENT_METHODS_VL.uri_check_digit_apl_flag%TYPE,
186: Payment_Format_apl_flag IBY_PAYMENT_METHODS_VL.payment_format_apl_flag%TYPE,
187: Delivery_Channel_apl_flag IBY_PAYMENT_METHODS_VL.delivery_channel_apl_flag%TYPE,
188:
189: Bank_Charge_Bearer_apl_flag IBY_PAYMENT_METHODS_VL.bank_charge_bearer_apl_flag%TYPE,
182: Remittance_Message3_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message3_apl_flag%TYPE,
183:
184: Unique_Remittance_apl_flag IBY_PAYMENT_METHODS_VL.unique_remittance_id_apl_flag%TYPE,
185: URI_CheckDigit_apl_flag IBY_PAYMENT_METHODS_VL.uri_check_digit_apl_flag%TYPE,
186: Payment_Format_apl_flag IBY_PAYMENT_METHODS_VL.payment_format_apl_flag%TYPE,
187: Delivery_Channel_apl_flag IBY_PAYMENT_METHODS_VL.delivery_channel_apl_flag%TYPE,
188:
189: Bank_Charge_Bearer_apl_flag IBY_PAYMENT_METHODS_VL.bank_charge_bearer_apl_flag%TYPE,
190: Settlement_Priority_apl_flag IBY_PAYMENT_METHODS_VL.settlement_priority_apl_flag%TYPE,
183:
184: Unique_Remittance_apl_flag IBY_PAYMENT_METHODS_VL.unique_remittance_id_apl_flag%TYPE,
185: URI_CheckDigit_apl_flag IBY_PAYMENT_METHODS_VL.uri_check_digit_apl_flag%TYPE,
186: Payment_Format_apl_flag IBY_PAYMENT_METHODS_VL.payment_format_apl_flag%TYPE,
187: Delivery_Channel_apl_flag IBY_PAYMENT_METHODS_VL.delivery_channel_apl_flag%TYPE,
188:
189: Bank_Charge_Bearer_apl_flag IBY_PAYMENT_METHODS_VL.bank_charge_bearer_apl_flag%TYPE,
190: Settlement_Priority_apl_flag IBY_PAYMENT_METHODS_VL.settlement_priority_apl_flag%TYPE,
191: Payment_Reason_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_apl_flag%TYPE,
185: URI_CheckDigit_apl_flag IBY_PAYMENT_METHODS_VL.uri_check_digit_apl_flag%TYPE,
186: Payment_Format_apl_flag IBY_PAYMENT_METHODS_VL.payment_format_apl_flag%TYPE,
187: Delivery_Channel_apl_flag IBY_PAYMENT_METHODS_VL.delivery_channel_apl_flag%TYPE,
188:
189: Bank_Charge_Bearer_apl_flag IBY_PAYMENT_METHODS_VL.bank_charge_bearer_apl_flag%TYPE,
190: Settlement_Priority_apl_flag IBY_PAYMENT_METHODS_VL.settlement_priority_apl_flag%TYPE,
191: Payment_Reason_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_apl_flag%TYPE,
192: external_bank_acct_apl_flag IBY_PAYMENT_METHODS_VL.external_bank_acct_apl_flag%TYPE,
193: exclusive_pmt_apl_flag IBY_PAYMENT_METHODS_VL.exclusive_pmt_apl_flag%TYPE,
186: Payment_Format_apl_flag IBY_PAYMENT_METHODS_VL.payment_format_apl_flag%TYPE,
187: Delivery_Channel_apl_flag IBY_PAYMENT_METHODS_VL.delivery_channel_apl_flag%TYPE,
188:
189: Bank_Charge_Bearer_apl_flag IBY_PAYMENT_METHODS_VL.bank_charge_bearer_apl_flag%TYPE,
190: Settlement_Priority_apl_flag IBY_PAYMENT_METHODS_VL.settlement_priority_apl_flag%TYPE,
191: Payment_Reason_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_apl_flag%TYPE,
192: external_bank_acct_apl_flag IBY_PAYMENT_METHODS_VL.external_bank_acct_apl_flag%TYPE,
193: exclusive_pmt_apl_flag IBY_PAYMENT_METHODS_VL.exclusive_pmt_apl_flag%TYPE,
194: Inactive_Date IBY_PAYMENT_METHODS_VL.inactive_date%TYPE
187: Delivery_Channel_apl_flag IBY_PAYMENT_METHODS_VL.delivery_channel_apl_flag%TYPE,
188:
189: Bank_Charge_Bearer_apl_flag IBY_PAYMENT_METHODS_VL.bank_charge_bearer_apl_flag%TYPE,
190: Settlement_Priority_apl_flag IBY_PAYMENT_METHODS_VL.settlement_priority_apl_flag%TYPE,
191: Payment_Reason_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_apl_flag%TYPE,
192: external_bank_acct_apl_flag IBY_PAYMENT_METHODS_VL.external_bank_acct_apl_flag%TYPE,
193: exclusive_pmt_apl_flag IBY_PAYMENT_METHODS_VL.exclusive_pmt_apl_flag%TYPE,
194: Inactive_Date IBY_PAYMENT_METHODS_VL.inactive_date%TYPE
195:
188:
189: Bank_Charge_Bearer_apl_flag IBY_PAYMENT_METHODS_VL.bank_charge_bearer_apl_flag%TYPE,
190: Settlement_Priority_apl_flag IBY_PAYMENT_METHODS_VL.settlement_priority_apl_flag%TYPE,
191: Payment_Reason_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_apl_flag%TYPE,
192: external_bank_acct_apl_flag IBY_PAYMENT_METHODS_VL.external_bank_acct_apl_flag%TYPE,
193: exclusive_pmt_apl_flag IBY_PAYMENT_METHODS_VL.exclusive_pmt_apl_flag%TYPE,
194: Inactive_Date IBY_PAYMENT_METHODS_VL.inactive_date%TYPE
195:
196: );
189: Bank_Charge_Bearer_apl_flag IBY_PAYMENT_METHODS_VL.bank_charge_bearer_apl_flag%TYPE,
190: Settlement_Priority_apl_flag IBY_PAYMENT_METHODS_VL.settlement_priority_apl_flag%TYPE,
191: Payment_Reason_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_apl_flag%TYPE,
192: external_bank_acct_apl_flag IBY_PAYMENT_METHODS_VL.external_bank_acct_apl_flag%TYPE,
193: exclusive_pmt_apl_flag IBY_PAYMENT_METHODS_VL.exclusive_pmt_apl_flag%TYPE,
194: Inactive_Date IBY_PAYMENT_METHODS_VL.inactive_date%TYPE
195:
196: );
197:
190: Settlement_Priority_apl_flag IBY_PAYMENT_METHODS_VL.settlement_priority_apl_flag%TYPE,
191: Payment_Reason_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_apl_flag%TYPE,
192: external_bank_acct_apl_flag IBY_PAYMENT_METHODS_VL.external_bank_acct_apl_flag%TYPE,
193: exclusive_pmt_apl_flag IBY_PAYMENT_METHODS_VL.exclusive_pmt_apl_flag%TYPE,
194: Inactive_Date IBY_PAYMENT_METHODS_VL.inactive_date%TYPE
195:
196: );
197:
198: -- Start of comments
499: PROCEDURE Get_Payment_Field_Properties (
500: p_api_version IN NUMBER,
501: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
502: p_payment_method_id IN
503: IBY_PAYMENT_METHODS_VL.payment_method_code%TYPE,
504: x_return_status OUT NOCOPY VARCHAR2,
505: x_msg_count OUT NOCOPY NUMBER,
506: x_msg_data OUT NOCOPY VARCHAR2,
507: x_Payment_Field_Properties OUT NOCOPY Applicable_Pmt_Attrs_Rec_Type