[Home] [Help]
70:
71: l_fail_dop_tbl failDocsOfPaymentTabType;
72: l_fail_docs_tbl failDocsTabType;
73:
74: pmt_id IBY_PAYMENTS_ALL.PAYMENT_ID%TYPE;
75: pmt_amt IBY_PAYMENTS_ALL.PAYMENT_AMOUNT%TYPE;
76:
77:
78: TYPE resetErrtblType IS TABLE OF IBY_PAYMENTS_ALL.PAYMENT_SERVICE_REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
71: l_fail_dop_tbl failDocsOfPaymentTabType;
72: l_fail_docs_tbl failDocsTabType;
73:
74: pmt_id IBY_PAYMENTS_ALL.PAYMENT_ID%TYPE;
75: pmt_amt IBY_PAYMENTS_ALL.PAYMENT_AMOUNT%TYPE;
76:
77:
78: TYPE resetErrtblType IS TABLE OF IBY_PAYMENTS_ALL.PAYMENT_SERVICE_REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
79:
74: pmt_id IBY_PAYMENTS_ALL.PAYMENT_ID%TYPE;
75: pmt_amt IBY_PAYMENTS_ALL.PAYMENT_AMOUNT%TYPE;
76:
77:
78: TYPE resetErrtblType IS TABLE OF IBY_PAYMENTS_ALL.PAYMENT_SERVICE_REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
79:
80: resetErrtbl resetErrtblType;
81:
82:
85:
86:
87:
88: TYPE l_payer_info_rec IS RECORD(
89: payer_party_number IBY_PAYMENTS_ALL.PAYER_PARTY_NUMBER%TYPE,
90: payer_party_site_name IBY_PAYMENTS_ALL.PAYER_PARTY_SITE_NAME%TYPE,
91: payer_legal_entity_name IBY_PAYMENTS_ALL.PAYER_LEGAL_ENTITY_NAME%TYPE,
92: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE,
93: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE,
86:
87:
88: TYPE l_payer_info_rec IS RECORD(
89: payer_party_number IBY_PAYMENTS_ALL.PAYER_PARTY_NUMBER%TYPE,
90: payer_party_site_name IBY_PAYMENTS_ALL.PAYER_PARTY_SITE_NAME%TYPE,
91: payer_legal_entity_name IBY_PAYMENTS_ALL.PAYER_LEGAL_ENTITY_NAME%TYPE,
92: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE,
93: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE,
94: payer_party_id IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE,
87:
88: TYPE l_payer_info_rec IS RECORD(
89: payer_party_number IBY_PAYMENTS_ALL.PAYER_PARTY_NUMBER%TYPE,
90: payer_party_site_name IBY_PAYMENTS_ALL.PAYER_PARTY_SITE_NAME%TYPE,
91: payer_legal_entity_name IBY_PAYMENTS_ALL.PAYER_LEGAL_ENTITY_NAME%TYPE,
92: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE,
93: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE,
94: payer_party_id IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE,
95: payer_location_id IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE,
88: TYPE l_payer_info_rec IS RECORD(
89: payer_party_number IBY_PAYMENTS_ALL.PAYER_PARTY_NUMBER%TYPE,
90: payer_party_site_name IBY_PAYMENTS_ALL.PAYER_PARTY_SITE_NAME%TYPE,
91: payer_legal_entity_name IBY_PAYMENTS_ALL.PAYER_LEGAL_ENTITY_NAME%TYPE,
92: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE,
93: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE,
94: payer_party_id IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE,
95: payer_location_id IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE,
96: payer_party_attr_category IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE,
89: payer_party_number IBY_PAYMENTS_ALL.PAYER_PARTY_NUMBER%TYPE,
90: payer_party_site_name IBY_PAYMENTS_ALL.PAYER_PARTY_SITE_NAME%TYPE,
91: payer_legal_entity_name IBY_PAYMENTS_ALL.PAYER_LEGAL_ENTITY_NAME%TYPE,
92: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE,
93: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE,
94: payer_party_id IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE,
95: payer_location_id IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE,
96: payer_party_attr_category IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE,
97: payer_le_attr_category IBY_PAYMENTS_ALL.PAYER_LE_ATTR_CATEGORY%TYPE,
90: payer_party_site_name IBY_PAYMENTS_ALL.PAYER_PARTY_SITE_NAME%TYPE,
91: payer_legal_entity_name IBY_PAYMENTS_ALL.PAYER_LEGAL_ENTITY_NAME%TYPE,
92: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE,
93: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE,
94: payer_party_id IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE,
95: payer_location_id IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE,
96: payer_party_attr_category IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE,
97: payer_le_attr_category IBY_PAYMENTS_ALL.PAYER_LE_ATTR_CATEGORY%TYPE,
98: payer_abbreviated_agency_code IBY_PAYMENTS_ALL.PAYER_ABBREVIATED_AGENCY_CODE%TYPE,
91: payer_legal_entity_name IBY_PAYMENTS_ALL.PAYER_LEGAL_ENTITY_NAME%TYPE,
92: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE,
93: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE,
94: payer_party_id IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE,
95: payer_location_id IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE,
96: payer_party_attr_category IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE,
97: payer_le_attr_category IBY_PAYMENTS_ALL.PAYER_LE_ATTR_CATEGORY%TYPE,
98: payer_abbreviated_agency_code IBY_PAYMENTS_ALL.PAYER_ABBREVIATED_AGENCY_CODE%TYPE,
99: payer_federal_us_employer_id IBY_PAYMENTS_ALL.PAYER_FEDERAL_US_EMPLOYER_ID%TYPE
92: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE,
93: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE,
94: payer_party_id IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE,
95: payer_location_id IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE,
96: payer_party_attr_category IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE,
97: payer_le_attr_category IBY_PAYMENTS_ALL.PAYER_LE_ATTR_CATEGORY%TYPE,
98: payer_abbreviated_agency_code IBY_PAYMENTS_ALL.PAYER_ABBREVIATED_AGENCY_CODE%TYPE,
99: payer_federal_us_employer_id IBY_PAYMENTS_ALL.PAYER_FEDERAL_US_EMPLOYER_ID%TYPE
100: );
93: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE,
94: payer_party_id IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE,
95: payer_location_id IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE,
96: payer_party_attr_category IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE,
97: payer_le_attr_category IBY_PAYMENTS_ALL.PAYER_LE_ATTR_CATEGORY%TYPE,
98: payer_abbreviated_agency_code IBY_PAYMENTS_ALL.PAYER_ABBREVIATED_AGENCY_CODE%TYPE,
99: payer_federal_us_employer_id IBY_PAYMENTS_ALL.PAYER_FEDERAL_US_EMPLOYER_ID%TYPE
100: );
101:
94: payer_party_id IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE,
95: payer_location_id IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE,
96: payer_party_attr_category IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE,
97: payer_le_attr_category IBY_PAYMENTS_ALL.PAYER_LE_ATTR_CATEGORY%TYPE,
98: payer_abbreviated_agency_code IBY_PAYMENTS_ALL.PAYER_ABBREVIATED_AGENCY_CODE%TYPE,
99: payer_federal_us_employer_id IBY_PAYMENTS_ALL.PAYER_FEDERAL_US_EMPLOYER_ID%TYPE
100: );
101:
102: TYPE l_payer_info_tbl_type IS TABLE OF l_payer_info_rec INDEX BY BINARY_INTEGER;
95: payer_location_id IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE,
96: payer_party_attr_category IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE,
97: payer_le_attr_category IBY_PAYMENTS_ALL.PAYER_LE_ATTR_CATEGORY%TYPE,
98: payer_abbreviated_agency_code IBY_PAYMENTS_ALL.PAYER_ABBREVIATED_AGENCY_CODE%TYPE,
99: payer_federal_us_employer_id IBY_PAYMENTS_ALL.PAYER_FEDERAL_US_EMPLOYER_ID%TYPE
100: );
101:
102: TYPE l_payer_info_tbl_type IS TABLE OF l_payer_info_rec INDEX BY BINARY_INTEGER;
103: l_payer_info_tbl l_payer_info_tbl_type;
105:
106:
107: TYPE l_payer_acct_info_rec IS RECORD(
108:
109: int_bank_name IBY_PAYMENTS_ALL.INT_BANK_NAME%TYPE,
110: int_bank_number IBY_PAYMENTS_ALL.INT_BANK_NUMBER%TYPE,
111: int_bank_branch_number IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NUMBER%TYPE,
112: int_bank_branch_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE,
113: int_eft_swift_code IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE,
106:
107: TYPE l_payer_acct_info_rec IS RECORD(
108:
109: int_bank_name IBY_PAYMENTS_ALL.INT_BANK_NAME%TYPE,
110: int_bank_number IBY_PAYMENTS_ALL.INT_BANK_NUMBER%TYPE,
111: int_bank_branch_number IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NUMBER%TYPE,
112: int_bank_branch_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE,
113: int_eft_swift_code IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE,
114: int_bank_account_number IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE,
107: TYPE l_payer_acct_info_rec IS RECORD(
108:
109: int_bank_name IBY_PAYMENTS_ALL.INT_BANK_NAME%TYPE,
110: int_bank_number IBY_PAYMENTS_ALL.INT_BANK_NUMBER%TYPE,
111: int_bank_branch_number IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NUMBER%TYPE,
112: int_bank_branch_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE,
113: int_eft_swift_code IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE,
114: int_bank_account_number IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE,
115: int_bank_account_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE,
108:
109: int_bank_name IBY_PAYMENTS_ALL.INT_BANK_NAME%TYPE,
110: int_bank_number IBY_PAYMENTS_ALL.INT_BANK_NUMBER%TYPE,
111: int_bank_branch_number IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NUMBER%TYPE,
112: int_bank_branch_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE,
113: int_eft_swift_code IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE,
114: int_bank_account_number IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE,
115: int_bank_account_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE,
116: int_bank_account_iban IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_IBAN%TYPE,
109: int_bank_name IBY_PAYMENTS_ALL.INT_BANK_NAME%TYPE,
110: int_bank_number IBY_PAYMENTS_ALL.INT_BANK_NUMBER%TYPE,
111: int_bank_branch_number IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NUMBER%TYPE,
112: int_bank_branch_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE,
113: int_eft_swift_code IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE,
114: int_bank_account_number IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE,
115: int_bank_account_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE,
116: int_bank_account_iban IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_IBAN%TYPE,
117: int_bank_acct_agency_loc_code IBY_PAYMENTS_ALL.INT_BANK_ACCT_AGENCY_LOC_CODE%TYPE,
110: int_bank_number IBY_PAYMENTS_ALL.INT_BANK_NUMBER%TYPE,
111: int_bank_branch_number IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NUMBER%TYPE,
112: int_bank_branch_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE,
113: int_eft_swift_code IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE,
114: int_bank_account_number IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE,
115: int_bank_account_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE,
116: int_bank_account_iban IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_IBAN%TYPE,
117: int_bank_acct_agency_loc_code IBY_PAYMENTS_ALL.INT_BANK_ACCT_AGENCY_LOC_CODE%TYPE,
118: int_bank_branch_party_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_PARTY_ID%TYPE,
111: int_bank_branch_number IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NUMBER%TYPE,
112: int_bank_branch_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE,
113: int_eft_swift_code IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE,
114: int_bank_account_number IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE,
115: int_bank_account_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE,
116: int_bank_account_iban IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_IBAN%TYPE,
117: int_bank_acct_agency_loc_code IBY_PAYMENTS_ALL.INT_BANK_ACCT_AGENCY_LOC_CODE%TYPE,
118: int_bank_branch_party_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_PARTY_ID%TYPE,
119: int_bank_alt_name IBY_PAYMENTS_ALL.INT_BANK_ALT_NAME%TYPE,
112: int_bank_branch_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE,
113: int_eft_swift_code IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE,
114: int_bank_account_number IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE,
115: int_bank_account_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE,
116: int_bank_account_iban IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_IBAN%TYPE,
117: int_bank_acct_agency_loc_code IBY_PAYMENTS_ALL.INT_BANK_ACCT_AGENCY_LOC_CODE%TYPE,
118: int_bank_branch_party_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_PARTY_ID%TYPE,
119: int_bank_alt_name IBY_PAYMENTS_ALL.INT_BANK_ALT_NAME%TYPE,
120: int_bank_branch_alt_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_ALT_NAME%TYPE,
113: int_eft_swift_code IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE,
114: int_bank_account_number IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE,
115: int_bank_account_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE,
116: int_bank_account_iban IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_IBAN%TYPE,
117: int_bank_acct_agency_loc_code IBY_PAYMENTS_ALL.INT_BANK_ACCT_AGENCY_LOC_CODE%TYPE,
118: int_bank_branch_party_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_PARTY_ID%TYPE,
119: int_bank_alt_name IBY_PAYMENTS_ALL.INT_BANK_ALT_NAME%TYPE,
120: int_bank_branch_alt_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_ALT_NAME%TYPE,
121: int_bank_account_alt_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_ALT_NAME%TYPE,
114: int_bank_account_number IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE,
115: int_bank_account_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE,
116: int_bank_account_iban IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_IBAN%TYPE,
117: int_bank_acct_agency_loc_code IBY_PAYMENTS_ALL.INT_BANK_ACCT_AGENCY_LOC_CODE%TYPE,
118: int_bank_branch_party_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_PARTY_ID%TYPE,
119: int_bank_alt_name IBY_PAYMENTS_ALL.INT_BANK_ALT_NAME%TYPE,
120: int_bank_branch_alt_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_ALT_NAME%TYPE,
121: int_bank_account_alt_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_ALT_NAME%TYPE,
122: int_bank_account_num_elec IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUM_ELEC%TYPE,
115: int_bank_account_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE,
116: int_bank_account_iban IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_IBAN%TYPE,
117: int_bank_acct_agency_loc_code IBY_PAYMENTS_ALL.INT_BANK_ACCT_AGENCY_LOC_CODE%TYPE,
118: int_bank_branch_party_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_PARTY_ID%TYPE,
119: int_bank_alt_name IBY_PAYMENTS_ALL.INT_BANK_ALT_NAME%TYPE,
120: int_bank_branch_alt_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_ALT_NAME%TYPE,
121: int_bank_account_alt_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_ALT_NAME%TYPE,
122: int_bank_account_num_elec IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUM_ELEC%TYPE,
123: int_bank_branch_location_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_LOCATION_ID%TYPE,
116: int_bank_account_iban IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_IBAN%TYPE,
117: int_bank_acct_agency_loc_code IBY_PAYMENTS_ALL.INT_BANK_ACCT_AGENCY_LOC_CODE%TYPE,
118: int_bank_branch_party_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_PARTY_ID%TYPE,
119: int_bank_alt_name IBY_PAYMENTS_ALL.INT_BANK_ALT_NAME%TYPE,
120: int_bank_branch_alt_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_ALT_NAME%TYPE,
121: int_bank_account_alt_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_ALT_NAME%TYPE,
122: int_bank_account_num_elec IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUM_ELEC%TYPE,
123: int_bank_branch_location_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_LOCATION_ID%TYPE,
124: int_bank_branch_eft_user_num IBY_PAYMENTS_ALL.INT_BANK_BRANCH_EFT_USER_NUM%TYPE,
117: int_bank_acct_agency_loc_code IBY_PAYMENTS_ALL.INT_BANK_ACCT_AGENCY_LOC_CODE%TYPE,
118: int_bank_branch_party_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_PARTY_ID%TYPE,
119: int_bank_alt_name IBY_PAYMENTS_ALL.INT_BANK_ALT_NAME%TYPE,
120: int_bank_branch_alt_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_ALT_NAME%TYPE,
121: int_bank_account_alt_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_ALT_NAME%TYPE,
122: int_bank_account_num_elec IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUM_ELEC%TYPE,
123: int_bank_branch_location_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_LOCATION_ID%TYPE,
124: int_bank_branch_eft_user_num IBY_PAYMENTS_ALL.INT_BANK_BRANCH_EFT_USER_NUM%TYPE,
125: int_bank_branch_rfc_identifier IBY_PAYMENTS_ALL.INT_BANK_BRANCH_RFC_IDENTIFIER%TYPE
118: int_bank_branch_party_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_PARTY_ID%TYPE,
119: int_bank_alt_name IBY_PAYMENTS_ALL.INT_BANK_ALT_NAME%TYPE,
120: int_bank_branch_alt_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_ALT_NAME%TYPE,
121: int_bank_account_alt_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_ALT_NAME%TYPE,
122: int_bank_account_num_elec IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUM_ELEC%TYPE,
123: int_bank_branch_location_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_LOCATION_ID%TYPE,
124: int_bank_branch_eft_user_num IBY_PAYMENTS_ALL.INT_BANK_BRANCH_EFT_USER_NUM%TYPE,
125: int_bank_branch_rfc_identifier IBY_PAYMENTS_ALL.INT_BANK_BRANCH_RFC_IDENTIFIER%TYPE
126: );
119: int_bank_alt_name IBY_PAYMENTS_ALL.INT_BANK_ALT_NAME%TYPE,
120: int_bank_branch_alt_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_ALT_NAME%TYPE,
121: int_bank_account_alt_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_ALT_NAME%TYPE,
122: int_bank_account_num_elec IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUM_ELEC%TYPE,
123: int_bank_branch_location_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_LOCATION_ID%TYPE,
124: int_bank_branch_eft_user_num IBY_PAYMENTS_ALL.INT_BANK_BRANCH_EFT_USER_NUM%TYPE,
125: int_bank_branch_rfc_identifier IBY_PAYMENTS_ALL.INT_BANK_BRANCH_RFC_IDENTIFIER%TYPE
126: );
127:
120: int_bank_branch_alt_name IBY_PAYMENTS_ALL.INT_BANK_BRANCH_ALT_NAME%TYPE,
121: int_bank_account_alt_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_ALT_NAME%TYPE,
122: int_bank_account_num_elec IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUM_ELEC%TYPE,
123: int_bank_branch_location_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_LOCATION_ID%TYPE,
124: int_bank_branch_eft_user_num IBY_PAYMENTS_ALL.INT_BANK_BRANCH_EFT_USER_NUM%TYPE,
125: int_bank_branch_rfc_identifier IBY_PAYMENTS_ALL.INT_BANK_BRANCH_RFC_IDENTIFIER%TYPE
126: );
127:
128: TYPE l_payer_acct_info_tbl_type IS TABLE OF l_payer_acct_info_rec INDEX BY BINARY_INTEGER;
121: int_bank_account_alt_name IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_ALT_NAME%TYPE,
122: int_bank_account_num_elec IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUM_ELEC%TYPE,
123: int_bank_branch_location_id IBY_PAYMENTS_ALL.INT_BANK_BRANCH_LOCATION_ID%TYPE,
124: int_bank_branch_eft_user_num IBY_PAYMENTS_ALL.INT_BANK_BRANCH_EFT_USER_NUM%TYPE,
125: int_bank_branch_rfc_identifier IBY_PAYMENTS_ALL.INT_BANK_BRANCH_RFC_IDENTIFIER%TYPE
126: );
127:
128: TYPE l_payer_acct_info_tbl_type IS TABLE OF l_payer_acct_info_rec INDEX BY BINARY_INTEGER;
129: l_payer_acct_info_tbl l_payer_acct_info_tbl_type;
130:
131:
132:
133: TYPE l_vendor_info_rec IS RECORD(
134: payee_site_alternate_name IBY_PAYMENTS_ALL.PAYEE_SITE_ALTERNATE_NAME%TYPE,
135: payee_supplier_number IBY_PAYMENTS_ALL.PAYEE_SUPPLIER_NUMBER%TYPE,
136: payee_first_party_reference IBY_PAYMENTS_ALL.PAYEE_FIRST_PARTY_REFERENCE%TYPE,
137: payee_supplier_attr_category IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
138: payee_supplier_id IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
131:
132:
133: TYPE l_vendor_info_rec IS RECORD(
134: payee_site_alternate_name IBY_PAYMENTS_ALL.PAYEE_SITE_ALTERNATE_NAME%TYPE,
135: payee_supplier_number IBY_PAYMENTS_ALL.PAYEE_SUPPLIER_NUMBER%TYPE,
136: payee_first_party_reference IBY_PAYMENTS_ALL.PAYEE_FIRST_PARTY_REFERENCE%TYPE,
137: payee_supplier_attr_category IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
138: payee_supplier_id IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
139: payee_le_registration_num IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
132:
133: TYPE l_vendor_info_rec IS RECORD(
134: payee_site_alternate_name IBY_PAYMENTS_ALL.PAYEE_SITE_ALTERNATE_NAME%TYPE,
135: payee_supplier_number IBY_PAYMENTS_ALL.PAYEE_SUPPLIER_NUMBER%TYPE,
136: payee_first_party_reference IBY_PAYMENTS_ALL.PAYEE_FIRST_PARTY_REFERENCE%TYPE,
137: payee_supplier_attr_category IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
138: payee_supplier_id IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
139: payee_le_registration_num IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
140: payee_supplier_site_name IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
133: TYPE l_vendor_info_rec IS RECORD(
134: payee_site_alternate_name IBY_PAYMENTS_ALL.PAYEE_SITE_ALTERNATE_NAME%TYPE,
135: payee_supplier_number IBY_PAYMENTS_ALL.PAYEE_SUPPLIER_NUMBER%TYPE,
136: payee_first_party_reference IBY_PAYMENTS_ALL.PAYEE_FIRST_PARTY_REFERENCE%TYPE,
137: payee_supplier_attr_category IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
138: payee_supplier_id IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
139: payee_le_registration_num IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
140: payee_supplier_site_name IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
141: payee_spplr_site_attr_category IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE
134: payee_site_alternate_name IBY_PAYMENTS_ALL.PAYEE_SITE_ALTERNATE_NAME%TYPE,
135: payee_supplier_number IBY_PAYMENTS_ALL.PAYEE_SUPPLIER_NUMBER%TYPE,
136: payee_first_party_reference IBY_PAYMENTS_ALL.PAYEE_FIRST_PARTY_REFERENCE%TYPE,
137: payee_supplier_attr_category IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
138: payee_supplier_id IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
139: payee_le_registration_num IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
140: payee_supplier_site_name IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
141: payee_spplr_site_attr_category IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE
142: );
135: payee_supplier_number IBY_PAYMENTS_ALL.PAYEE_SUPPLIER_NUMBER%TYPE,
136: payee_first_party_reference IBY_PAYMENTS_ALL.PAYEE_FIRST_PARTY_REFERENCE%TYPE,
137: payee_supplier_attr_category IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
138: payee_supplier_id IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
139: payee_le_registration_num IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
140: payee_supplier_site_name IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
141: payee_spplr_site_attr_category IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE
142: );
143:
136: payee_first_party_reference IBY_PAYMENTS_ALL.PAYEE_FIRST_PARTY_REFERENCE%TYPE,
137: payee_supplier_attr_category IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
138: payee_supplier_id IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
139: payee_le_registration_num IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
140: payee_supplier_site_name IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
141: payee_spplr_site_attr_category IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE
142: );
143:
144: TYPE l_vendor_info_tbl_type IS TABLE OF l_vendor_info_rec INDEX BY VARCHAR2(4000);
137: payee_supplier_attr_category IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
138: payee_supplier_id IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
139: payee_le_registration_num IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
140: payee_supplier_site_name IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
141: payee_spplr_site_attr_category IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE
142: );
143:
144: TYPE l_vendor_info_tbl_type IS TABLE OF l_vendor_info_rec INDEX BY VARCHAR2(4000);
145: l_vendor_info_tbl l_vendor_info_tbl_type;
144: TYPE l_vendor_info_tbl_type IS TABLE OF l_vendor_info_rec INDEX BY VARCHAR2(4000);
145: l_vendor_info_tbl l_vendor_info_tbl_type;
146:
147: TYPE l_vendor_tax_reg_info_rec IS RECORD(
148: payee_tax_registration_num IBY_PAYMENTS_ALL.payee_tax_registration_num%TYPE
149: );
150:
151: type l_vendor_tax_reg_info_tbl_type is table of l_vendor_tax_reg_info_rec index by varchar2(4000);
152: l_vendor_tax_reg_info_tbl l_vendor_tax_reg_info_tbl_type;
151: type l_vendor_tax_reg_info_tbl_type is table of l_vendor_tax_reg_info_rec index by varchar2(4000);
152: l_vendor_tax_reg_info_tbl l_vendor_tax_reg_info_tbl_type;
153:
154: TYPE l_payee_info_rec IS RECORD(
155: payee_party_number IBY_PAYMENTS_ALL.payee_party_number%TYPE,
156: payee_party_name IBY_PAYMENTS_ALL.payee_party_name%TYPE,
157: payee_name IBY_PAYMENTS_ALL.payee_name%TYPE,
158: payee_alt_name IBY_PAYMENTS_ALL.PAYEE_ALTERNATE_NAME%TYPE,
159: payee_party_atr_cat IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
152: l_vendor_tax_reg_info_tbl l_vendor_tax_reg_info_tbl_type;
153:
154: TYPE l_payee_info_rec IS RECORD(
155: payee_party_number IBY_PAYMENTS_ALL.payee_party_number%TYPE,
156: payee_party_name IBY_PAYMENTS_ALL.payee_party_name%TYPE,
157: payee_name IBY_PAYMENTS_ALL.payee_name%TYPE,
158: payee_alt_name IBY_PAYMENTS_ALL.PAYEE_ALTERNATE_NAME%TYPE,
159: payee_party_atr_cat IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
160: beneficiary_name IBY_PAYMENTS_ALL.BENEFICIARY_name%TYPE
153:
154: TYPE l_payee_info_rec IS RECORD(
155: payee_party_number IBY_PAYMENTS_ALL.payee_party_number%TYPE,
156: payee_party_name IBY_PAYMENTS_ALL.payee_party_name%TYPE,
157: payee_name IBY_PAYMENTS_ALL.payee_name%TYPE,
158: payee_alt_name IBY_PAYMENTS_ALL.PAYEE_ALTERNATE_NAME%TYPE,
159: payee_party_atr_cat IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
160: beneficiary_name IBY_PAYMENTS_ALL.BENEFICIARY_name%TYPE
161:
154: TYPE l_payee_info_rec IS RECORD(
155: payee_party_number IBY_PAYMENTS_ALL.payee_party_number%TYPE,
156: payee_party_name IBY_PAYMENTS_ALL.payee_party_name%TYPE,
157: payee_name IBY_PAYMENTS_ALL.payee_name%TYPE,
158: payee_alt_name IBY_PAYMENTS_ALL.PAYEE_ALTERNATE_NAME%TYPE,
159: payee_party_atr_cat IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
160: beneficiary_name IBY_PAYMENTS_ALL.BENEFICIARY_name%TYPE
161:
162: );
155: payee_party_number IBY_PAYMENTS_ALL.payee_party_number%TYPE,
156: payee_party_name IBY_PAYMENTS_ALL.payee_party_name%TYPE,
157: payee_name IBY_PAYMENTS_ALL.payee_name%TYPE,
158: payee_alt_name IBY_PAYMENTS_ALL.PAYEE_ALTERNATE_NAME%TYPE,
159: payee_party_atr_cat IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
160: beneficiary_name IBY_PAYMENTS_ALL.BENEFICIARY_name%TYPE
161:
162: );
163:
156: payee_party_name IBY_PAYMENTS_ALL.payee_party_name%TYPE,
157: payee_name IBY_PAYMENTS_ALL.payee_name%TYPE,
158: payee_alt_name IBY_PAYMENTS_ALL.PAYEE_ALTERNATE_NAME%TYPE,
159: payee_party_atr_cat IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
160: beneficiary_name IBY_PAYMENTS_ALL.BENEFICIARY_name%TYPE
161:
162: );
163:
164: TYPE l_payee_info_tbl_type IS TABLE OF l_payee_info_rec INDEX BY BINARY_INTEGER;
165: l_payee_info_tbl l_payee_info_tbl_type;
166:
167:
168: TYPE l_payee_site_rec IS RECORD(
169: payee_spplr_site_attr_category IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
170: payee_party_site_name IBY_PAYMENTS_ALL.payee_party_site_name%TYPE,
171: payee_addressee IBY_PAYMENTS_ALL.payee_addressee%TYPE
172: );
173:
166:
167:
168: TYPE l_payee_site_rec IS RECORD(
169: payee_spplr_site_attr_category IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
170: payee_party_site_name IBY_PAYMENTS_ALL.payee_party_site_name%TYPE,
171: payee_addressee IBY_PAYMENTS_ALL.payee_addressee%TYPE
172: );
173:
174: TYPE l_payee_site_tbl_type IS TABLE OF l_payee_site_rec INDEX BY BINARY_INTEGER;
167:
168: TYPE l_payee_site_rec IS RECORD(
169: payee_spplr_site_attr_category IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
170: payee_party_site_name IBY_PAYMENTS_ALL.payee_party_site_name%TYPE,
171: payee_addressee IBY_PAYMENTS_ALL.payee_addressee%TYPE
172: );
173:
174: TYPE l_payee_site_tbl_type IS TABLE OF l_payee_site_rec INDEX BY BINARY_INTEGER;
175: l_payee_site_tbl l_payee_site_tbl_type;
174: TYPE l_payee_site_tbl_type IS TABLE OF l_payee_site_rec INDEX BY BINARY_INTEGER;
175: l_payee_site_tbl l_payee_site_tbl_type;
176:
177: TYPE l_payee_addr_rec IS RECORD(
178: payee_address1 IBY_PAYMENTS_ALL.payee_address1%TYPE,
179: payee_address2 IBY_PAYMENTS_ALL.payee_address2%TYPE,
180: payee_address3 IBY_PAYMENTS_ALL.payee_address3%TYPE,
181: payee_address4 IBY_PAYMENTS_ALL.payee_address4%TYPE,
182: payee_city IBY_PAYMENTS_ALL.payee_city%TYPE,
175: l_payee_site_tbl l_payee_site_tbl_type;
176:
177: TYPE l_payee_addr_rec IS RECORD(
178: payee_address1 IBY_PAYMENTS_ALL.payee_address1%TYPE,
179: payee_address2 IBY_PAYMENTS_ALL.payee_address2%TYPE,
180: payee_address3 IBY_PAYMENTS_ALL.payee_address3%TYPE,
181: payee_address4 IBY_PAYMENTS_ALL.payee_address4%TYPE,
182: payee_city IBY_PAYMENTS_ALL.payee_city%TYPE,
183: payee_county IBY_PAYMENTS_ALL.payee_county%TYPE,
176:
177: TYPE l_payee_addr_rec IS RECORD(
178: payee_address1 IBY_PAYMENTS_ALL.payee_address1%TYPE,
179: payee_address2 IBY_PAYMENTS_ALL.payee_address2%TYPE,
180: payee_address3 IBY_PAYMENTS_ALL.payee_address3%TYPE,
181: payee_address4 IBY_PAYMENTS_ALL.payee_address4%TYPE,
182: payee_city IBY_PAYMENTS_ALL.payee_city%TYPE,
183: payee_county IBY_PAYMENTS_ALL.payee_county%TYPE,
184: payee_province IBY_PAYMENTS_ALL.payee_province%TYPE,
177: TYPE l_payee_addr_rec IS RECORD(
178: payee_address1 IBY_PAYMENTS_ALL.payee_address1%TYPE,
179: payee_address2 IBY_PAYMENTS_ALL.payee_address2%TYPE,
180: payee_address3 IBY_PAYMENTS_ALL.payee_address3%TYPE,
181: payee_address4 IBY_PAYMENTS_ALL.payee_address4%TYPE,
182: payee_city IBY_PAYMENTS_ALL.payee_city%TYPE,
183: payee_county IBY_PAYMENTS_ALL.payee_county%TYPE,
184: payee_province IBY_PAYMENTS_ALL.payee_province%TYPE,
185: payee_state IBY_PAYMENTS_ALL.payee_state%TYPE,
178: payee_address1 IBY_PAYMENTS_ALL.payee_address1%TYPE,
179: payee_address2 IBY_PAYMENTS_ALL.payee_address2%TYPE,
180: payee_address3 IBY_PAYMENTS_ALL.payee_address3%TYPE,
181: payee_address4 IBY_PAYMENTS_ALL.payee_address4%TYPE,
182: payee_city IBY_PAYMENTS_ALL.payee_city%TYPE,
183: payee_county IBY_PAYMENTS_ALL.payee_county%TYPE,
184: payee_province IBY_PAYMENTS_ALL.payee_province%TYPE,
185: payee_state IBY_PAYMENTS_ALL.payee_state%TYPE,
186: payee_country IBY_PAYMENTS_ALL.payee_country%TYPE,
179: payee_address2 IBY_PAYMENTS_ALL.payee_address2%TYPE,
180: payee_address3 IBY_PAYMENTS_ALL.payee_address3%TYPE,
181: payee_address4 IBY_PAYMENTS_ALL.payee_address4%TYPE,
182: payee_city IBY_PAYMENTS_ALL.payee_city%TYPE,
183: payee_county IBY_PAYMENTS_ALL.payee_county%TYPE,
184: payee_province IBY_PAYMENTS_ALL.payee_province%TYPE,
185: payee_state IBY_PAYMENTS_ALL.payee_state%TYPE,
186: payee_country IBY_PAYMENTS_ALL.payee_country%TYPE,
187: payee_postal_code IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
180: payee_address3 IBY_PAYMENTS_ALL.payee_address3%TYPE,
181: payee_address4 IBY_PAYMENTS_ALL.payee_address4%TYPE,
182: payee_city IBY_PAYMENTS_ALL.payee_city%TYPE,
183: payee_county IBY_PAYMENTS_ALL.payee_county%TYPE,
184: payee_province IBY_PAYMENTS_ALL.payee_province%TYPE,
185: payee_state IBY_PAYMENTS_ALL.payee_state%TYPE,
186: payee_country IBY_PAYMENTS_ALL.payee_country%TYPE,
187: payee_postal_code IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
188: payee_address_concat IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
181: payee_address4 IBY_PAYMENTS_ALL.payee_address4%TYPE,
182: payee_city IBY_PAYMENTS_ALL.payee_city%TYPE,
183: payee_county IBY_PAYMENTS_ALL.payee_county%TYPE,
184: payee_province IBY_PAYMENTS_ALL.payee_province%TYPE,
185: payee_state IBY_PAYMENTS_ALL.payee_state%TYPE,
186: payee_country IBY_PAYMENTS_ALL.payee_country%TYPE,
187: payee_postal_code IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
188: payee_address_concat IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
189: );
182: payee_city IBY_PAYMENTS_ALL.payee_city%TYPE,
183: payee_county IBY_PAYMENTS_ALL.payee_county%TYPE,
184: payee_province IBY_PAYMENTS_ALL.payee_province%TYPE,
185: payee_state IBY_PAYMENTS_ALL.payee_state%TYPE,
186: payee_country IBY_PAYMENTS_ALL.payee_country%TYPE,
187: payee_postal_code IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
188: payee_address_concat IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
189: );
190:
183: payee_county IBY_PAYMENTS_ALL.payee_county%TYPE,
184: payee_province IBY_PAYMENTS_ALL.payee_province%TYPE,
185: payee_state IBY_PAYMENTS_ALL.payee_state%TYPE,
186: payee_country IBY_PAYMENTS_ALL.payee_country%TYPE,
187: payee_postal_code IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
188: payee_address_concat IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
189: );
190:
191: TYPE l_payee_addr_tbl_type IS TABLE OF l_payee_addr_rec INDEX BY VARCHAR2(200);
184: payee_province IBY_PAYMENTS_ALL.payee_province%TYPE,
185: payee_state IBY_PAYMENTS_ALL.payee_state%TYPE,
186: payee_country IBY_PAYMENTS_ALL.payee_country%TYPE,
187: payee_postal_code IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
188: payee_address_concat IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
189: );
190:
191: TYPE l_payee_addr_tbl_type IS TABLE OF l_payee_addr_rec INDEX BY VARCHAR2(200);
192: l_payee_addr_tbl l_payee_addr_tbl_type;
192: l_payee_addr_tbl l_payee_addr_tbl_type;
193:
194:
195: TYPE l_payee_acct_rec IS RECORD(
196: ext_bank_name IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
197: ext_bank_number IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
198: ext_branch_number IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
199: ext_bank_branch_name IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
200: ext_bank_account_number IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
193:
194:
195: TYPE l_payee_acct_rec IS RECORD(
196: ext_bank_name IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
197: ext_bank_number IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
198: ext_branch_number IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
199: ext_bank_branch_name IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
200: ext_bank_account_number IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
201: ext_bank_account_name IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
194:
195: TYPE l_payee_acct_rec IS RECORD(
196: ext_bank_name IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
197: ext_bank_number IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
198: ext_branch_number IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
199: ext_bank_branch_name IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
200: ext_bank_account_number IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
201: ext_bank_account_name IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
202: ext_bank_account_iban_number IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
195: TYPE l_payee_acct_rec IS RECORD(
196: ext_bank_name IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
197: ext_bank_number IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
198: ext_branch_number IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
199: ext_bank_branch_name IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
200: ext_bank_account_number IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
201: ext_bank_account_name IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
202: ext_bank_account_iban_number IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
203: ext_eft_swift_code IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
196: ext_bank_name IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
197: ext_bank_number IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
198: ext_branch_number IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
199: ext_bank_branch_name IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
200: ext_bank_account_number IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
201: ext_bank_account_name IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
202: ext_bank_account_iban_number IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
203: ext_eft_swift_code IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
204: ext_bank_account_type IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
197: ext_bank_number IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
198: ext_branch_number IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
199: ext_bank_branch_name IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
200: ext_bank_account_number IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
201: ext_bank_account_name IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
202: ext_bank_account_iban_number IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
203: ext_eft_swift_code IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
204: ext_bank_account_type IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
205: ext_bank_acct_pmt_factor_flag IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
198: ext_branch_number IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
199: ext_bank_branch_name IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
200: ext_bank_account_number IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
201: ext_bank_account_name IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
202: ext_bank_account_iban_number IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
203: ext_eft_swift_code IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
204: ext_bank_account_type IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
205: ext_bank_acct_pmt_factor_flag IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
206: ext_bank_acct_owner_party_id IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
199: ext_bank_branch_name IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
200: ext_bank_account_number IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
201: ext_bank_account_name IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
202: ext_bank_account_iban_number IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
203: ext_eft_swift_code IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
204: ext_bank_account_type IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
205: ext_bank_acct_pmt_factor_flag IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
206: ext_bank_acct_owner_party_id IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
207: ext_bank_branch_party_id IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
200: ext_bank_account_number IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
201: ext_bank_account_name IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
202: ext_bank_account_iban_number IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
203: ext_eft_swift_code IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
204: ext_bank_account_type IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
205: ext_bank_acct_pmt_factor_flag IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
206: ext_bank_acct_owner_party_id IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
207: ext_bank_branch_party_id IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
208: ext_bank_alt_name IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
201: ext_bank_account_name IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
202: ext_bank_account_iban_number IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
203: ext_eft_swift_code IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
204: ext_bank_account_type IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
205: ext_bank_acct_pmt_factor_flag IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
206: ext_bank_acct_owner_party_id IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
207: ext_bank_branch_party_id IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
208: ext_bank_alt_name IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
209: ext_bank_branch_alt_name IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
202: ext_bank_account_iban_number IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
203: ext_eft_swift_code IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
204: ext_bank_account_type IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
205: ext_bank_acct_pmt_factor_flag IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
206: ext_bank_acct_owner_party_id IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
207: ext_bank_branch_party_id IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
208: ext_bank_alt_name IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
209: ext_bank_branch_alt_name IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
210: ext_bank_account_alt_name IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
203: ext_eft_swift_code IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
204: ext_bank_account_type IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
205: ext_bank_acct_pmt_factor_flag IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
206: ext_bank_acct_owner_party_id IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
207: ext_bank_branch_party_id IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
208: ext_bank_alt_name IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
209: ext_bank_branch_alt_name IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
210: ext_bank_account_alt_name IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
211: ext_bank_account_num_elec IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
204: ext_bank_account_type IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
205: ext_bank_acct_pmt_factor_flag IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
206: ext_bank_acct_owner_party_id IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
207: ext_bank_branch_party_id IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
208: ext_bank_alt_name IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
209: ext_bank_branch_alt_name IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
210: ext_bank_account_alt_name IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
211: ext_bank_account_num_elec IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
212: ext_bank_branch_location_id IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
205: ext_bank_acct_pmt_factor_flag IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
206: ext_bank_acct_owner_party_id IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
207: ext_bank_branch_party_id IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
208: ext_bank_alt_name IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
209: ext_bank_branch_alt_name IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
210: ext_bank_account_alt_name IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
211: ext_bank_account_num_elec IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
212: ext_bank_branch_location_id IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
213: ext_bank_acct_owner_party_name IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE
206: ext_bank_acct_owner_party_id IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
207: ext_bank_branch_party_id IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
208: ext_bank_alt_name IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
209: ext_bank_branch_alt_name IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
210: ext_bank_account_alt_name IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
211: ext_bank_account_num_elec IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
212: ext_bank_branch_location_id IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
213: ext_bank_acct_owner_party_name IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE
214: );
207: ext_bank_branch_party_id IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
208: ext_bank_alt_name IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
209: ext_bank_branch_alt_name IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
210: ext_bank_account_alt_name IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
211: ext_bank_account_num_elec IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
212: ext_bank_branch_location_id IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
213: ext_bank_acct_owner_party_name IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE
214: );
215:
208: ext_bank_alt_name IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
209: ext_bank_branch_alt_name IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
210: ext_bank_account_alt_name IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
211: ext_bank_account_num_elec IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
212: ext_bank_branch_location_id IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
213: ext_bank_acct_owner_party_name IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE
214: );
215:
216: TYPE l_payee_acct_tbl_type IS TABLE OF l_payee_acct_rec INDEX BY BINARY_INTEGER;
209: ext_bank_branch_alt_name IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
210: ext_bank_account_alt_name IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
211: ext_bank_account_num_elec IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
212: ext_bank_branch_location_id IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
213: ext_bank_acct_owner_party_name IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE
214: );
215:
216: TYPE l_payee_acct_tbl_type IS TABLE OF l_payee_acct_rec INDEX BY BINARY_INTEGER;
217: l_payee_acct_tbl l_payee_acct_tbl_type;
216: TYPE l_payee_acct_tbl_type IS TABLE OF l_payee_acct_rec INDEX BY BINARY_INTEGER;
217: l_payee_acct_tbl l_payee_acct_tbl_type;
218:
219: TYPE l_remit_rec IS RECORD(
220: remit_advice_delivery_method IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
221: remit_advice_email IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
222: remit_advice_fax IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
223: declaration_exch_rate_type IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
224: declaration_format IBY_PAYMENTS_ALL.declaration_format%TYPE,
217: l_payee_acct_tbl l_payee_acct_tbl_type;
218:
219: TYPE l_remit_rec IS RECORD(
220: remit_advice_delivery_method IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
221: remit_advice_email IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
222: remit_advice_fax IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
223: declaration_exch_rate_type IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
224: declaration_format IBY_PAYMENTS_ALL.declaration_format%TYPE,
225: bank_instruction1_format_value IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
218:
219: TYPE l_remit_rec IS RECORD(
220: remit_advice_delivery_method IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
221: remit_advice_email IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
222: remit_advice_fax IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
223: declaration_exch_rate_type IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
224: declaration_format IBY_PAYMENTS_ALL.declaration_format%TYPE,
225: bank_instruction1_format_value IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
226: bank_instruction2_format_value IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
219: TYPE l_remit_rec IS RECORD(
220: remit_advice_delivery_method IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
221: remit_advice_email IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
222: remit_advice_fax IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
223: declaration_exch_rate_type IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
224: declaration_format IBY_PAYMENTS_ALL.declaration_format%TYPE,
225: bank_instruction1_format_value IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
226: bank_instruction2_format_value IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
227: payment_profile_acct_name IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
220: remit_advice_delivery_method IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
221: remit_advice_email IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
222: remit_advice_fax IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
223: declaration_exch_rate_type IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
224: declaration_format IBY_PAYMENTS_ALL.declaration_format%TYPE,
225: bank_instruction1_format_value IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
226: bank_instruction2_format_value IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
227: payment_profile_acct_name IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
228: payment_profile_sys_name IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE
221: remit_advice_email IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
222: remit_advice_fax IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
223: declaration_exch_rate_type IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
224: declaration_format IBY_PAYMENTS_ALL.declaration_format%TYPE,
225: bank_instruction1_format_value IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
226: bank_instruction2_format_value IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
227: payment_profile_acct_name IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
228: payment_profile_sys_name IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE
229: );
222: remit_advice_fax IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
223: declaration_exch_rate_type IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
224: declaration_format IBY_PAYMENTS_ALL.declaration_format%TYPE,
225: bank_instruction1_format_value IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
226: bank_instruction2_format_value IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
227: payment_profile_acct_name IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
228: payment_profile_sys_name IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE
229: );
230:
223: declaration_exch_rate_type IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
224: declaration_format IBY_PAYMENTS_ALL.declaration_format%TYPE,
225: bank_instruction1_format_value IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
226: bank_instruction2_format_value IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
227: payment_profile_acct_name IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
228: payment_profile_sys_name IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE
229: );
230:
231: TYPE l_remit_tbl_type IS TABLE OF l_remit_rec INDEX BY BINARY_INTEGER;
224: declaration_format IBY_PAYMENTS_ALL.declaration_format%TYPE,
225: bank_instruction1_format_value IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
226: bank_instruction2_format_value IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
227: payment_profile_acct_name IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
228: payment_profile_sys_name IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE
229: );
230:
231: TYPE l_remit_tbl_type IS TABLE OF l_remit_rec INDEX BY BINARY_INTEGER;
232: l_remit_tbl l_remit_tbl_type;
231: TYPE l_remit_tbl_type IS TABLE OF l_remit_rec INDEX BY BINARY_INTEGER;
232: l_remit_tbl l_remit_tbl_type;
233:
234: TYPE l_ppr_rec IS RECORD(
235: payment_process_request_name IBY_PAYMENTS_ALL.payment_process_request_name%TYPE,
236: source_product IBY_PAYMENTS_ALL.source_product%TYPE
237: );
238:
239: TYPE l_ppr_tbl_type IS TABLE OF l_ppr_rec INDEX BY BINARY_INTEGER;
232: l_remit_tbl l_remit_tbl_type;
233:
234: TYPE l_ppr_rec IS RECORD(
235: payment_process_request_name IBY_PAYMENTS_ALL.payment_process_request_name%TYPE,
236: source_product IBY_PAYMENTS_ALL.source_product%TYPE
237: );
238:
239: TYPE l_ppr_tbl_type IS TABLE OF l_ppr_rec INDEX BY BINARY_INTEGER;
240: l_ppr_tbl l_ppr_tbl_type;
239: TYPE l_ppr_tbl_type IS TABLE OF l_ppr_rec INDEX BY BINARY_INTEGER;
240: l_ppr_tbl l_ppr_tbl_type;
241:
242: TYPE l_del_rec IS RECORD(
243: delivery_channel_format_value IBY_PAYMENTS_ALL.DELIVERY_CHANNEL_FORMAT_VALUE%TYPE
244: );
245:
246:
247: TYPE l_del_tbl_type IS TABLE OF l_del_rec INDEX BY VARCHAR2(300);
247: TYPE l_del_tbl_type IS TABLE OF l_del_rec INDEX BY VARCHAR2(300);
248: l_del_tbl l_del_tbl_type;
249:
250: TYPE l_org_rec IS RECORD(
251: org_name IBY_PAYMENTS_ALL.org_name%TYPE
252: );
253:
254:
255: TYPE l_org_tbl_type IS TABLE OF l_org_rec INDEX BY BINARY_INTEGER;
256: l_org_tbl l_org_tbl_type;
257:
258:
259: TYPE l_pmt_reason_rec IS RECORD(
260: payment_reason_format_value IBY_PAYMENTS_ALL.payment_reason_format_value%TYPE
261: );
262:
263:
264: TYPE l_pmt_reason_tbl_type IS TABLE OF l_pmt_reason_rec INDEX BY VARCHAR2(300);
268: /* DS for audit payment data caching */
269:
270: /*Bug 8209474 Type is being created to hold payee id for Invalid Payees*/
271:
272: TYPE l_payee_tbl_type IS TABLE OF IBY_PAYMENTS_ALL.ext_payee_id%TYPE index by binary_integer;
273: l_payeeTab l_payee_tbl_type; --To Hold Validation Failed payment's Payee information
274: l_invalid_payee_index BINARY_INTEGER;
275: /*Type is being created to hold payeedid for Invalid Payees*/
276:
274: l_invalid_payee_index BINARY_INTEGER;
275: /*Type is being created to hold payeedid for Invalid Payees*/
276:
277: --AWT Enh 16296267
278: TYPE l_payee_tbl_type_awt IS TABLE OF IBY_PAYMENTS_ALL.payment_reference_number%TYPE index by binary_integer;
279: l_payeeAwt l_payee_tbl_type_awt; --To Hold Validation Failed payment's Payee information that has range based awt
280: l_invalid_payee_awt_index BINARY_INTEGER;
281:
282:
368: l_trx_audit_index IN BINARY_INTEGER
369: )
370: IS
371: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||'.updateCommonAttribues';
372: l_settlement_pr iby_payments_all.SETTLEMENT_PRIORITY%type;
373:
374: BEGIN
375: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
376: print_debuginfo(l_module_name, 'ENTER');
477: SELECT
478: payment_id,
479: payment_status
480: FROM
481: iby_payments_all
482: WHERE payment_service_request_id = p_pmt_service_req_id
483: ;
484:
485: BEGIN
671: /*
672: * Fix for bug 5935493:
673: *
674: * Payment validations are dependent upon finding the
675: * payments in the IBY_PAYMENTS_ALL table. Therefore, insert
676: * the payments from the PLSQL table into the
677: * IBY_PAYMENTS_ALL table.
678: *
679: * Central bank reporting could be implemented via a hook
673: *
674: * Payment validations are dependent upon finding the
675: * payments in the IBY_PAYMENTS_ALL table. Therefore, insert
676: * the payments from the PLSQL table into the
677: * IBY_PAYMENTS_ALL table.
678: *
679: * Central bank reporting could be implemented via a hook
680: * that is expecting payments to be populated in
681: * IBY_PAYMENTS_ALL table. Therefore, payments need to
677: * IBY_PAYMENTS_ALL table.
678: *
679: * Central bank reporting could be implemented via a hook
680: * that is expecting payments to be populated in
681: * IBY_PAYMENTS_ALL table. Therefore, payments need to
682: * inserted before performing central bank reporting as well.
683: */
684:
685: /* not needed now as updateDocsWithPaymentID is moved up and we are not inserting
682: * inserted before performing central bank reporting as well.
683: */
684:
685: /* not needed now as updateDocsWithPaymentID is moved up and we are not inserting
686: * into IBY_PAYMENTS_ALL table now
687: */
688:
689: /*
690:
1021: INTO l_calc_jp_bank_charges
1022: FROM dual
1023: WHERE EXISTS (SELECT 1
1024: FROM ap_system_parameters_all asp
1025: , IBY_PAYMENTS_ALL pmt
1026: WHERE pmt.PAYMENT_SERVICE_REQUEST_ID = p_payment_request_id
1027: AND pmt.org_id = asp.org_id
1028: AND nvl(asp.use_bank_charge_flag,'N') = 'Y');
1029: EXCEPTION
1052: INTO l_call_ap_awt_callout
1053: FROM dual
1054: WHERE EXISTS (SELECT 1
1055: FROM ap_system_parameters_all asp,
1056: IBY_PAYMENTS_ALL pmt
1057: WHERE pmt.PAYMENT_SERVICE_REQUEST_ID = p_payment_request_id
1058: AND pmt.org_id = asp.org_id
1059: AND nvl(asp.allow_awt_flag,'N') = 'Y');
1060: EXCEPTION
1085: * advice.
1086: */
1087: --flagSeparateRemitAdvicePmts(l_paymentTab);
1088:
1089: -- calling the API without any parameters, as IBY PAYMENTS ALL table is used to fetch data */
1090:
1091: flagSeparateRemitAdvicePmts(l_ca_payreq_cd, p_payment_request_id);
1092:
1093: /*
1242: * Pass in the current ppr status. This is used
1243: * to determine the next status in some cases.
1244: */
1245: x_return_status := l_payreq_status;
1246: -- deleting the pmtTable DS and repopulating with just payment status from iby_payments_all
1247:
1248:
1249: /*OPEN c_pmtIdStatus(p_payment_request_id);
1250: FETCH c_pmtIdStatus BULK COLLECT INTO
1361: */
1362: l_impossible_date DATE := TO_DATE('01/01/5100 10:25:55',
1363: 'MM/DD/YYYY HH24:MI:SS');
1364:
1365: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
1366: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
1367: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
1368: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
1369: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
1362: l_impossible_date DATE := TO_DATE('01/01/5100 10:25:55',
1363: 'MM/DD/YYYY HH24:MI:SS');
1364:
1365: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
1366: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
1367: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
1368: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
1369: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
1370:
1363: 'MM/DD/YYYY HH24:MI:SS');
1364:
1365: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
1366: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
1367: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
1368: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
1369: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
1370:
1371: l_processing_type VARCHAR2(100); -- CHECK | ELECTRONIC
1364:
1365: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
1366: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
1367: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
1368: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
1369: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
1370:
1371: l_processing_type VARCHAR2(100); -- CHECK | ELECTRONIC
1372: l_calc_doc_detail VARCHAR2(1000); -- Stores details for a single doc
1365: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
1366: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
1367: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
1368: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
1369: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
1370:
1371: l_processing_type VARCHAR2(100); -- CHECK | ELECTRONIC
1372: l_calc_doc_detail VARCHAR2(1000); -- Stores details for a single doc
1373:
1392: /* rejection level system options */
1393: l_rejection_level VARCHAR2(200);
1394: l_review_pmts_flag VARCHAR2(1) := 'N';
1395:
1396: l_paymentRec IBY_PAYMENTS_ALL%ROWTYPE;
1397: l_docsInPmtRec IBY_PAYGROUP_PUB.docsInPaymentRecType;
1398:
1399:
1400: /*
1398:
1399:
1400: /*
1401: * These two are related data structures. Each row in paymentTabType
1402: * PLSQL table is used in inserting a row into the IBY_PAYMENTS_ALL
1403: * table.
1404: *
1405: * Since the IBY_PAYMENTS_ALL table does not contain a document id, a
1406: * separate data structure is needed to keep track of the documents
1401: * These two are related data structures. Each row in paymentTabType
1402: * PLSQL table is used in inserting a row into the IBY_PAYMENTS_ALL
1403: * table.
1404: *
1405: * Since the IBY_PAYMENTS_ALL table does not contain a document id, a
1406: * separate data structure is needed to keep track of the documents
1407: * that are part of a payment. This information is tracked in the
1408: * docsInPaymentTabType table. The rows in docsInPaymentTabType are
1409: * used to update the rows in IBY_DOCS_PAYABLE_ALL table with
1409: * used to update the rows in IBY_DOCS_PAYABLE_ALL table with
1410: * payment ids.
1411: *
1412: * x_paymentTab x_docsInPmtTab
1413: * (insert into IBY_PAYMENTS_ALL) (update IBY_DOCS_PAYABLE)
1414: * /-------------------------------------\ /------------\
1415: * |Payment|Payment|..|Payment|Docs |..| |Payment|Doc |
1416: * |Id |Profile|..|Amount |Payable|..| |Id |Id |
1417: * | |Id |..| |Count |..| | | |
2360: l_calc_doc_detail := null;
2361: END IF;
2362:
2363: /*
2364: * The length of the payment details field in IBY_PAYMENTS_ALL
2365: * table is 240 chars. This imposes a hard limit for the
2366: * length of payment details that can be stored against a
2367: * payment.
2368: *
3441: */
3442: l_impossible_date DATE := TO_DATE('01/01/5100 10:25:55',
3443: 'MM/DD/YYYY HH24:MI:SS');
3444:
3445: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
3446: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
3447: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
3448: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
3449: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
3442: l_impossible_date DATE := TO_DATE('01/01/5100 10:25:55',
3443: 'MM/DD/YYYY HH24:MI:SS');
3444:
3445: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
3446: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
3447: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
3448: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
3449: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
3450:
3443: 'MM/DD/YYYY HH24:MI:SS');
3444:
3445: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
3446: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
3447: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
3448: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
3449: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
3450:
3451: l_processing_type VARCHAR2(100); -- CHECK | ELECTRONIC
3444:
3445: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
3446: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
3447: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
3448: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
3449: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
3450:
3451: l_processing_type VARCHAR2(100); -- CHECK | ELECTRONIC
3452: l_calc_doc_detail VARCHAR2(1000); -- Stores details for a single doc
3445: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
3446: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
3447: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
3448: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
3449: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
3450:
3451: l_processing_type VARCHAR2(100); -- CHECK | ELECTRONIC
3452: l_calc_doc_detail VARCHAR2(1000); -- Stores details for a single doc
3453:
3472: /* rejection level system options */
3473: l_rejection_level VARCHAR2(200);
3474: l_review_pmts_flag VARCHAR2(1) := 'N';
3475:
3476: l_paymentRec IBY_PAYMENTS_ALL%ROWTYPE;
3477: l_docsInPmtRec IBY_PAYGROUP_PUB.docsInPaymentRecType;
3478:
3479: /*
3480: * These two are related data structures. Each row in paymentTabType
3477: l_docsInPmtRec IBY_PAYGROUP_PUB.docsInPaymentRecType;
3478:
3479: /*
3480: * These two are related data structures. Each row in paymentTabType
3481: * PLSQL table is used in inserting a row into the IBY_PAYMENTS_ALL
3482: * table.
3483: *
3484: * Since the IBY_PAYMENTS_ALL table does not contain a document id, a
3485: * separate data structure is needed to keep track of the documents
3480: * These two are related data structures. Each row in paymentTabType
3481: * PLSQL table is used in inserting a row into the IBY_PAYMENTS_ALL
3482: * table.
3483: *
3484: * Since the IBY_PAYMENTS_ALL table does not contain a document id, a
3485: * separate data structure is needed to keep track of the documents
3486: * that are part of a payment. This information is tracked in the
3487: * docsInPaymentTabType table. The rows in docsInPaymentTabType are
3488: * used to update the rows in IBY_DOCS_PAYABLE_ALL table with
3488: * used to update the rows in IBY_DOCS_PAYABLE_ALL table with
3489: * payment ids.
3490: *
3491: * x_paymentTab x_docsInPmtTab
3492: * (insert into IBY_PAYMENTS_ALL) (update IBY_DOCS_PAYABLE)
3493: * /-------------------------------------\ /------------\
3494: * |Payment|Payment|..|Payment|Docs |..| |Payment|Doc |
3495: * |Id |Profile|..|Amount |Payable|..| |Id |Id |
3496: * | |Id |..| |Count |..| | | |
4483: l_calc_doc_detail := null;
4484: END IF;
4485:
4486: /*
4487: * The length of the payment details field in IBY_PAYMENTS_ALL
4488: * table is 240 chars. This imposes a hard limit for the
4489: * length of payment details that can be stored against a
4490: * payment.
4491: *
5574: | NOTES:
5575: |
5576: *---------------------------------------------------------------------*/
5577: PROCEDURE insertDocIntoPayment(
5578: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
5579: x_paymentTab IN OUT NOCOPY paymentTabType,
5580: p_calcDocInfo IN VARCHAR2,
5581: p_newPaymentFlag IN BOOLEAN,
5582: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
5578: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
5579: x_paymentTab IN OUT NOCOPY paymentTabType,
5580: p_calcDocInfo IN VARCHAR2,
5581: p_newPaymentFlag IN BOOLEAN,
5582: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
5583: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
5584: x_docsInPmtRec IN OUT NOCOPY docsInPaymentRecType,
5585: x_docsInPmtCount IN OUT NOCOPY NUMBER
5586: )
5775: | NOTES:
5776: |
5777: *---------------------------------------------------------------------*/
5778: PROCEDURE insertDocIntoPayment(
5779: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
5780: x_paymentTab IN OUT NOCOPY paymentTabType,
5781: p_calcDocInfo IN VARCHAR2,
5782: p_newPaymentFlag IN BOOLEAN,
5783: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
5779: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
5780: x_paymentTab IN OUT NOCOPY paymentTabType,
5781: p_calcDocInfo IN VARCHAR2,
5782: p_newPaymentFlag IN BOOLEAN,
5783: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
5784: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
5785: x_docsInPmtRec IN OUT NOCOPY docsInPaymentRecType,
5786: x_docsInPmtCount IN OUT NOCOPY NUMBER,
5787: x_commonAttributes IN OUT NOCOPY commonAttributesTabType
6076: | NOTES:
6077: |
6078: *---------------------------------------------------------------------*/
6079: PROCEDURE insertDocIntoPayment(
6080: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
6081: --x_paymentTab IN OUT NOCOPY paymentTabType,
6082: p_calcDocInfo IN VARCHAR2,
6083: p_newPaymentFlag IN BOOLEAN,
6084: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
6080: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
6081: --x_paymentTab IN OUT NOCOPY paymentTabType,
6082: p_calcDocInfo IN VARCHAR2,
6083: p_newPaymentFlag IN BOOLEAN,
6084: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
6085: x_docsInPmtCount IN OUT NOCOPY NUMBER,
6086: x_commonAttributes IN OUT NOCOPY commonAttributesTabType,
6087: p_trx_line_index IN BINARY_INTEGER
6088: )
6869: | insertPayments
6870: |
6871: | PURPOSE:
6872: | Performs a bulk insert of all created payments from PLSQL
6873: | table into IBY_PAYMENTS_ALL table.
6874: |
6875: | PARAMETERS:
6876: | IN
6877: |
6888: p_paymentTab IN paymentTabType
6889: )
6890: IS
6891: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.insertPayments';
6892: TYPE tax_regis_num IS TABLE OF iby_payments_all.payee_tax_registration_num%TYPE INDEX BY BINARY_INTEGER;
6893: l_tax_registration_num tax_regis_num;
6894:
6895: BEGIN
6896:
6902: /* Normally, this shouldn't happen */
6903: IF (p_paymentTab.COUNT = 0) THEN
6904: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6905: print_debuginfo(l_module_name, 'After grouping, no payments'
6906: || ' were found to insert into IBY_PAYMENTS_ALL table.'
6907: || ' Possible data corruption issue.');
6908:
6909: END IF;
6910: RETURN;
7280: END LOOP;
7281:
7282:
7283: /*
7284: * Bulk insert into IBY_PAYMENTS_ALL table using the
7285: * named columns syntax. This avoids any dependencies on
7286: * column order.
7287: */
7288: FORALL i in nvl(paymentTab.payment_id.FIRST,0) .. nvl(paymentTab.payment_id.LAST,-99)
7285: * named columns syntax. This avoids any dependencies on
7286: * column order.
7287: */
7288: FORALL i in nvl(paymentTab.payment_id.FIRST,0) .. nvl(paymentTab.payment_id.LAST,-99)
7289: INSERT INTO IBY_PAYMENTS_ALL
7290: (
7291: payment_id,
7292: payment_method_code,
7293: payment_service_request_id,
7629: | insertPayments
7630: |
7631: | PURPOSE:
7632: | Performs a bulk insert of all created payments from PLSQL
7633: | table into IBY_PAYMENTS_ALL table.
7634: |
7635: | PARAMETERS:
7636: | IN
7637: |
7646: *---------------------------------------------------------------------*/
7647: PROCEDURE insertPayments
7648: IS
7649: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.insertPayments';
7650: TYPE tax_regis_num IS TABLE OF iby_payments_all.payee_tax_registration_num%TYPE INDEX BY BINARY_INTEGER;
7651: l_tax_registration_num tax_regis_num;
7652:
7653: /* CHANGE FOR BUG : 14348326 - START */
7654: errors NUMBER;
7667: /*
7668: IF (p_paymentTab.COUNT = 0) THEN
7669: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7670: print_debuginfo(l_module_name, 'After grouping, no payments'
7671: || ' were found to insert into IBY_PAYMENTS_ALL table.'
7672: || ' Possible data corruption issue.');
7673:
7674: END IF;
7675: RETURN;
7682: * array. These column arrays will be used in the bulk insert.
7683: */
7684: /* Removing the code to copy data into paymentTab, as we
7685: * already have record of table to directly copy into
7686: * IBY_PAYMENTS_ALL table */
7687:
7688:
7689:
7690: /*
7687:
7688:
7689:
7690: /*
7691: * Bulk insert into IBY_PAYMENTS_ALL table using the
7692: * named columns syntax. This avoids any dependencies on
7693: * column order.
7694: */
7695: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7932: END IF;
7933: /* CHANGE FOR BUG : 14348326 - START */
7934: FORALL i in nvl(IBY_PAYGROUP_PUB.pmtTable.payment_id.FIRST,0) .. nvl(IBY_PAYGROUP_PUB.pmtTable.payment_id.LAST,-99) SAVE EXCEPTIONS
7935: /* CHANGE FOR BUG : 14348326 - END */
7936: INSERT INTO IBY_PAYMENTS_ALL
7937: (
7938: payment_id,
7939: payment_method_code,
7940: payment_service_request_id,
8905: | updatePayments
8906: |
8907: | PURPOSE:
8908: | Performs an update of all created payments from PLSQL
8909: | table into IBY_PAYMENTS_ALL table.
8910: |
8911: | The created payments have already been inserted into
8912: | IBY_PAYMENTS_ALL after grouping. So we only need to update
8913: | certain fields of the payment that have been changed
8908: | Performs an update of all created payments from PLSQL
8909: | table into IBY_PAYMENTS_ALL table.
8910: |
8911: | The created payments have already been inserted into
8912: | IBY_PAYMENTS_ALL after grouping. So we only need to update
8913: | certain fields of the payment that have been changed
8914: | after the grouping was performed.
8915: |
8916: | PARAMETERS:
8939: /* Normally, this shouldn't happen */
8940: IF (p_paymentTab.COUNT = 0) THEN
8941: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8942: print_debuginfo(l_module_name, 'No payments'
8943: || ' were found to update IBY_PAYMENTS_ALL table.');
8944: END IF;
8945:
8946: RETURN;
8947: END IF;
8948:
8949: FOR i in p_paymentTab.FIRST..p_paymentTab.LAST LOOP
8950:
8951: UPDATE
8952: IBY_PAYMENTS_ALL
8953: SET
8954: payment_status = p_paymentTab(i).payment_status,
8955: payment_amount = p_paymentTab(i).payment_amount,
8956: discount_amount_taken = p_paymentTab(i).discount_amount_taken,
8981: | updatePayments
8982: |
8983: | PURPOSE:
8984: | Performs an update of all created payments from PLSQL
8985: | table into IBY_PAYMENTS_ALL table.
8986: |
8987: | The created payments have already been inserted into
8988: | IBY_PAYMENTS_ALL after grouping. So we only need to update
8989: | certain fields of the payment that have been changed
8984: | Performs an update of all created payments from PLSQL
8985: | table into IBY_PAYMENTS_ALL table.
8986: |
8987: | The created payments have already been inserted into
8988: | IBY_PAYMENTS_ALL after grouping. So we only need to update
8989: | certain fields of the payment that have been changed
8990: | after the grouping was performed.
8991: |
8992: | PARAMETERS:
9023:
9024: /* FOR i in p_paymentTab.FIRST..p_paymentTab.LAST LOOP
9025:
9026: UPDATE
9027: IBY_PAYMENTS_ALL
9028: SET
9029: payment_status = p_paymentTab(i).payment_status,
9030: payment_amount = p_paymentTab(i).payment_amount,
9031: discount_amount_taken = p_paymentTab(i).discount_amount_taken,
9044:
9045: /* CHANGE FOR BUG : 14348326 - START */
9046: FORALL i in nvl(IBY_PAYGROUP_PUB.pmtTable.payment_id.FIRST,0) .. nvl(IBY_PAYGROUP_PUB.pmtTable.payment_id.LAST,-99) SAVE EXCEPTIONS
9047: /* CHANGE FOR BUG : 14348326 - END */
9048: UPDATE IBY_PAYMENTS_ALL
9049: SET
9050: payment_id= IBY_PAYGROUP_PUB.pmtTable.payment_id(i),
9051: payment_method_code= IBY_PAYGROUP_PUB.pmtTable.payment_method_code(i),
9052: payment_service_request_id= IBY_PAYGROUP_PUB.pmtTable.payment_service_request_id(i),
9342: | NOTES:
9343: |
9344: *---------------------------------------------------------------------*/
9345: PROCEDURE getNextPaymentID(
9346: x_paymentID IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE
9347: )
9348: IS
9349:
9350: BEGIN
9348: IS
9349:
9350: BEGIN
9351:
9352: SELECT IBY_PAYMENTS_ALL_S.nextval INTO x_paymentID
9353: FROM DUAL;
9354:
9355: END getNextPaymentID;
9356:
9569: IS
9570:
9571: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME
9572: || '.performCentralBankReporting';
9573: l_pmt_fx_amount iby_payments_all.payment_amount%TYPE := -1;
9574: l_return_status VARCHAR2(200);
9575: l_declare_flag VARCHAR2(1);
9576: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;
9577:
9901: IS
9902:
9903: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME
9904: || '.performCentralBankReporting';
9905: l_pmt_fx_amount iby_payments_all.payment_amount%TYPE := -1;
9906: l_return_status VARCHAR2(200);
9907: l_declare_flag VARCHAR2(1);
9908: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;
9909:
10961: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
10962: )
10963: IS
10964:
10965: l_orig_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
10966: l_orig_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
10967: l_orig_pmt_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
10968:
10969: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
10965: l_orig_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
10966: l_orig_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
10967: l_orig_pmt_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
10968:
10969: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
10970: l_compare_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
10971:
10972: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
10973:
12229: last_update_date,
12230: last_update_login,
12231: object_version_number
12232: FROM
12233: IBY_PAYMENTS_ALL
12234: where
12235: payment_status <> PAY_STATUS_REJECTED AND
12236: PAYMENT_SERVICE_REQUEST_ID = p_ppr_id
12237: );
12981: l_pmts_tab_count NUMBER;
12982: l_posthook_count NUMBER;
12983: hookPmtsTab hookPaymentTabType;
12984:
12985: l_hook_pmt_amt iby_payments_all.payment_amount%type;
12986: l_pmt_amt iby_payments_all.payment_amount%type;
12987: l_trx_cbr_index BINARY_INTEGER;
12988:
12989: CURSOR c_fail_docs_of_payment
12982: l_posthook_count NUMBER;
12983: hookPmtsTab hookPaymentTabType;
12984:
12985: l_hook_pmt_amt iby_payments_all.payment_amount%type;
12986: l_pmt_amt iby_payments_all.payment_amount%type;
12987: l_trx_cbr_index BINARY_INTEGER;
12988:
12989: CURSOR c_fail_docs_of_payment
12990: IS
13020: select
13021: payment_id,
13022: payment_amount
13023: from
13024: iby_payments_all A
13025: where payment_amount =
13026: (select B.payment_amount from IBY_HOOK_PAYMENTS_T B where A.payment_id = B.payment_id
13027: AND A.payment_service_request_id = B.payment_service_request_id)
13028: ;
13344: CLOSE check_hook_pmt;
13345: */
13346:
13347:
13348: /* Copy all the data changed by calling app into IBY_PAYMENTS_ALL table */
13349:
13350: /*
13351: UPDATE IBY_PAYMENTS_ALL A
13352: SET (PAYMENT_AMOUNT, DISCOUNT_AMOUNT_TAKEN, bank_charge_amount)
13347:
13348: /* Copy all the data changed by calling app into IBY_PAYMENTS_ALL table */
13349:
13350: /*
13351: UPDATE IBY_PAYMENTS_ALL A
13352: SET (PAYMENT_AMOUNT, DISCOUNT_AMOUNT_TAKEN, bank_charge_amount)
13353: =
13354: (SELECT NVL(B.PAYMENT_AMOUNT,PAYMENT_AMOUNT),B.DISCOUNT_AMOUNT_TAKEN,B.bank_charge_amount
13355: from IBY_HOOK_PAYMENTS_T B
13358:
13359:
13360: /*
13361:
13362: UPDATE IBY_PAYMENTS_ALL A
13363: SET PAYMENT_AMOUNT = (SELECT B.PAYMENT_AMOUNT
13364: from IBY_HOOK_PAYMENTS_T B
13365: where A.PAYMENT_ID= B.PAYMENT_ID);
13366: */
13365: where A.PAYMENT_ID= B.PAYMENT_ID);
13366: */
13367:
13368: /*
13369: UPDATE IBY_PAYMENTS_ALL A
13370: SET
13371: DISCOUNT_AMOUNT_TAKEN= (SELECT B.DISCOUNT_AMOUNT_TAKEN
13372: from IBY_HOOK_PAYMENTS_T B
13373: where A.PAYMENT_ID= B.PAYMENT_ID),
13376: where A.PAYMENT_ID= B.PAYMENT_ID)
13377: ; */
13378:
13379: MERGE /*+ leading(ihp) */
13380: INTO IBY_PAYMENTS_ALL ibpa
13381: USING IBY_HOOK_PAYMENTS_T ihp ON(ibpa.payment_id = ihp.payment_id
13382: AND ibpa.payment_service_request_id = ihp.payment_service_request_id)
13383: WHEN MATCHED THEN UPDATE
13384: SET ibpa.PAYMENT_AMOUNT = ihp.PAYMENT_AMOUNT,
13386: ibpa.bank_charge_amount = ihp.bank_charge_amount;
13387:
13388:
13389: /*
13390: UPDATE IBY_PAYMENTS_ALL A
13391: SET PAYMENT_STATUS =
13392: (SELECT PAY_STATUS_CA_FAILED FROM
13393: IBY_HOOK_PAYMENTS_T B
13394: WHERE A.PAYMENT_ID= B.PAYMENT_ID AND
13396: ;
13397: */
13398:
13399: MERGE /*+ leading(ihp)*/
13400: INTO IBY_PAYMENTS_ALL ibpa
13401: USING IBY_HOOK_PAYMENTS_T ihp ON(ibpa.payment_id = ihp.payment_id
13402: AND ibpa.payment_service_request_id = ihp.payment_service_request_id
13403: AND ihp.DONT_PAY_FLAG ='Y')
13404: WHEN MATCHED THEN UPDATE
13429: || ' has been retrieved in PostHook Process');
13430: END IF;
13431: select payment_amount
13432: into l_pmt_amt
13433: from iby_payments_all
13434: where payment_id = hookPmtsTab(j).payment_id;
13435: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13436: print_debuginfo(l_module_name, 'Payment Amount: '
13437: || l_hook_pmt_amt
13471:
13472: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_cbr_index) := PAY_STATUS_CA_FAILED;
13473:
13474: /*
13475: UPDATE IBY_PAYMENTS_ALL
13476: SET PAYMENT_STATUS = PAY_STATUS_CA_FAILED
13477: WHERE PAYMENT_ID = hookPmtsTab(j).payment_id;
13478: */
13479:
14226: IBY_PAYGROUP_PUB.pmtTable.payment_amount(k)
14227: - sdap_tbl(IBY_PAYGROUP_PUB.pmtTable.payment_id(k));
14228: */
14229:
14230: UPDATE IBY_PAYMENTS_ALL
14231: SET PAYMENT_AMOUNT = PAYMENT_AMOUNT -
14232: sdap_tbl(IBY_PAYGROUP_PUB.pmtTable.payment_id(k))
14233: WHERE
14234: PAYMENT_ID = IBY_PAYGROUP_PUB.pmtTable.payment_id(k);
15588: | NOTES:
15589: |
15590: *---------------------------------------------------------------------*/
15591: PROCEDURE failDocsOfPayment(
15592: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
15593: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
15594: document_status%TYPE,
15595: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
15596: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
15686: | NOTES:
15687: |
15688: *---------------------------------------------------------------------*/
15689: PROCEDURE failDocsOfPayment(
15690: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
15691: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
15692: document_status%TYPE,
15693: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
15694: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
15700: l_sql_string VARCHAR2(4000) := '';
15701:
15702: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
15703:
15704: CURSOR c_fail_docs_of_payment(p_paymentId IBY_PAYMENTS_ALL.payment_id%TYPE)
15705: IS
15706: SELECT idpt.payment_id,
15707: idpt.document_payable_id,
15708: idpt.document_status,
16124:
16125: FROM
16126: IBY_REMIT_ADVICE_SETUP advice,
16127: IBY_PAYMENT_PROFILES ppp,
16128: IBY_PAYMENTS_ALL pmt,
16129: IBY_DOCS_PAYABLE_ALL docs
16130:
16131: WHERE
16132: remittance_advice_format_code IS NOT NULL
16285:
16286: --x_paymentTab(i).separate_remit_advice_req_flag
16287: -- := 'Y';
16288:
16289: UPDATE IBY_PAYMENTS_ALL
16290: SET separate_remit_advice_req_flag = 'Y'
16291: WHERE
16292: PAYMENT_ID =l_remitAdvicesSetupTab(j).payment_id;
16293:
16326:
16327: -- x_paymentTab(i).separate_remit_advice_req_flag
16328: -- := 'Y';
16329:
16330: UPDATE IBY_PAYMENTS_ALL
16331: SET separate_remit_advice_req_flag = 'Y'
16332: WHERE
16333: PAYMENT_ID = l_remitAdvicesSetupTab(j).payment_id;
16334:
16356: END IF;
16357:
16358: --x_paymentTab(i).separate_remit_advice_req_flag
16359: -- := 'Y';
16360: UPDATE IBY_PAYMENTS_ALL
16361: SET separate_remit_advice_req_flag = 'Y'
16362: WHERE
16363: PAYMENT_ID = l_remitAdvicesSetupTab(j).payment_id;
16364:
16596: l_request_status VARCHAR2(200);
16597: l_orig_req_status VARCHAR2(200);
16598:
16599: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
16600: l_triggering_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
16601:
16602: BEGIN
16603: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
16604: print_debuginfo(l_module_name, 'ENTER');
17234: l_orig_req_status VARCHAR2(200);
17235:
17236: l_pmt_count NUMBER;
17237: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
17238: l_triggering_pmt_id IBY_PAYMENTS_ALL.payment_reference_number%TYPE;
17239:
17240: l_validpayment_flag VARCHAR2(1) := 'N'; --bug 13854619
17241:
17242: l_error_code VARCHAR2(100); -- AWT Enh 16296267
17292: SELECT 'N'
17293: INTO l_allsuccess_flag
17294: from DUAL
17295: WHERE EXISTS
17296: (SELECT 1 FROM IBY_PAYMENTS_ALL
17297: WHERE PAYMENT_STATUS NOT IN (PAY_STATUS_CREATED, PAY_STATUS_REMOVED)
17298: AND payment_service_request_id =p_payreq_id
17299: );
17300: EXCEPTION
17304: END;
17305:
17306: select count(payment_id)
17307: into l_pmt_count
17308: from iby_payments_all
17309: where payment_service_request_id = p_payreq_id
17310: AND payment_status <> PAY_STATUS_CREATED
17311: ;
17312: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17335: SELECT 'N'
17336: INTO l_allfailed_flag
17337: from DUAL
17338: WHERE EXISTS
17339: (SELECT 1 FROM IBY_PAYMENTS_ALL
17340: WHERE PAYMENT_STATUS = PAY_STATUS_CREATED
17341: AND payment_service_request_id =p_payreq_id
17342: );
17343:
18113: /*
18114: * Pick up all validation sets applicable to a particular payment.
18115: */
18116:
18117: CURSOR c_pmt_val_sets(p_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE,
18118: p_payment_method_code IBY_PAYMENTS_ALL.payment_method_code%TYPE,
18119: p_int_bank_acct_id IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE,
18120: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
18121: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
18114: * Pick up all validation sets applicable to a particular payment.
18115: */
18116:
18117: CURSOR c_pmt_val_sets(p_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE,
18118: p_payment_method_code IBY_PAYMENTS_ALL.payment_method_code%TYPE,
18119: p_int_bank_acct_id IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE,
18120: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
18121: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
18122: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,
18115: */
18116:
18117: CURSOR c_pmt_val_sets(p_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE,
18118: p_payment_method_code IBY_PAYMENTS_ALL.payment_method_code%TYPE,
18119: p_int_bank_acct_id IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE,
18120: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
18121: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
18122: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,
18123: p_country CE_BANK_BRANCHES_V.country%TYPE)
19121: | NOTES:
19122: |
19123: *---------------------------------------------------------------------*/
19124: FUNCTION checkIfPmtAlreadyFailed(
19125: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
19126: p_paymentTab IN paymentTabType
19127: )
19128: RETURN BOOLEAN
19129: IS
19169: | NOTES:
19170: |
19171: *---------------------------------------------------------------------*/
19172: FUNCTION checkIfPmtAlreadyAdded(
19173: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
19174: p_paymentTab IN pmtIdsTab
19175: )
19176: RETURN BOOLEAN
19177: IS
21109: | NOTES:
21110: |
21111: *---------------------------------------------------------------------*/
21112: FUNCTION getMaturityDaysForPmtMethod(
21113: p_pmt_method_code IN IBY_PAYMENTS_ALL.payment_method_code%TYPE,
21114: p_maturityDaysTab IN pmtMethodMaturityDaysTab
21115: ) RETURN NUMBER
21116: IS
21117: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE
21177: | NOTES:
21178: |
21179: *---------------------------------------------------------------------*/
21180: FUNCTION getMaturityDaysForPmtMethod(
21181: p_pmt_method_code IN IBY_PAYMENTS_ALL.payment_method_code%TYPE
21182: -- p_maturityDaysTab IN pmtMethodMaturityDaysTab
21183: ) RETURN NUMBER
21184: IS
21185: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE := -1;
21258: | NOTES:
21259: |
21260: *---------------------------------------------------------------------*/
21261: PROCEDURE refreshDocAndPmtAmounts(
21262: p_adjustedPmtId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
21263: p_adjustedNegDocsTab IN docsInPaymentTabType,
21264: x_paymentTab IN OUT NOCOPY paymentTabType,
21265: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType
21266: )
22452: * Stores the documents payable for a single payment.
22453: */
22454: l_docsForPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;
22455:
22456: l_pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE;
22457:
22458: /*
22459: * For storing central bank reporting information related to
22460: * each payment.
22469: IS
22470: SELECT
22471: *
22472: FROM
22473: IBY_PAYMENTS_ALL
22474: WHERE
22475: payment_service_request_id = p_payment_request_id AND
22476:
22477: /*
22555: prof.declaration_curr_fx_rate_type,
22556: prof.declaration_currency_code,
22557: prof.declaration_threshold_amount
22558: FROM
22559: IBY_PAYMENTS_ALL pmt,
22560: IBY_PAYMENT_PROFILES prof
22561: WHERE
22562: pmt.payment_id = p_payment_id AND
22563: pmt.payment_profile_id = prof.payment_profile_id
22817: * Stores the documents payable for a single payment.
22818: */
22819: -- l_docsForPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;
22820:
22821: l_pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE;
22822:
22823: /*
22824: * For storing central bank reporting information related to
22825: * each payment.
22834: IS
22835: SELECT
22836: *
22837: FROM
22838: IBY_PAYMENTS_ALL
22839: WHERE
22840: payment_service_request_id = p_payment_request_id AND
22841:
22842: /*
22868: prof.declaration_curr_fx_rate_type,
22869: prof.declaration_currency_code,
22870: prof.declaration_threshold_amount
22871: FROM
22872: IBY_PAYMENTS_ALL pmt,
22873: IBY_PAYMENT_PROFILES prof
22874: WHERE
22875: pmt.payment_id = p_payment_id AND
22876: pmt.payment_profile_id = prof.payment_profile_id
22959: 'N',
22960: null,
22961: null
22962: FROM
22963: IBY_DOCS_PAYABLE_ALL idpa, IBY_PAYMENTS_ALL ibpa
22964: WHERE
22965: idpa.payment_service_request_id = p_payment_request_id
22966: AND idpa.payment_service_request_id = ibpa.payment_service_request_id
22967: AND idpa.payment_id = ibpa.payment_id
23040: IF( l_paymentTab(i).payment_status = PAY_STATUS_MODIFIED) THEN
23041: l_paymentTab(i).payment_status := PAY_STATUS_CREATED;
23042: END IF;
23043:
23044: update iby_payments_all set payment_amount = l_pmt_amount,
23045: payment_status = l_paymentTab(i).payment_status
23046: where payment_id = l_paymentTab(i).payment_id;
23047:
23048: END LOOP;
23204: IF (p_auditPmtTab.COUNT = 0) THEN
23205:
23206: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
23207: print_debuginfo(l_module_name, 'No audit data '
23208: || 'was provided to update IBY_PAYMENTS_ALL table. '
23209: || 'Exiting ..'
23210: );
23211:
23212: print_debuginfo(l_module_name, 'EXIT');
23218:
23219: FOR i IN p_auditPmtTab.FIRST .. p_auditPmtTab.LAST LOOP
23220:
23221: UPDATE
23222: IBY_PAYMENTS_ALL
23223: SET
23224: payer_party_number = p_auditPmtTab(i).
23225: payer_party_number,
23226: payer_party_site_name = p_auditPmtTab(i).
25927: IS
25928: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
25929: '.GET_ORG_INFO';
25930: l_org_index BINARY_INTEGER;
25931: l_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
25932: l_inv_payee_party_id IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE;
25933: l_inv_party_site_id IBY_PAYMENTS_ALL.inv_party_site_id%TYPE;
25934: l_inv_supplier_site_id IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE;
25935: l_inv_beneficiary_party IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE;
25928: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
25929: '.GET_ORG_INFO';
25930: l_org_index BINARY_INTEGER;
25931: l_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
25932: l_inv_payee_party_id IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE;
25933: l_inv_party_site_id IBY_PAYMENTS_ALL.inv_party_site_id%TYPE;
25934: l_inv_supplier_site_id IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE;
25935: l_inv_beneficiary_party IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE;
25936:
25929: '.GET_ORG_INFO';
25930: l_org_index BINARY_INTEGER;
25931: l_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
25932: l_inv_payee_party_id IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE;
25933: l_inv_party_site_id IBY_PAYMENTS_ALL.inv_party_site_id%TYPE;
25934: l_inv_supplier_site_id IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE;
25935: l_inv_beneficiary_party IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE;
25936:
25937: CURSOR c_org_info(l_trx_index BINARY_INTEGER) IS
25930: l_org_index BINARY_INTEGER;
25931: l_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
25932: l_inv_payee_party_id IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE;
25933: l_inv_party_site_id IBY_PAYMENTS_ALL.inv_party_site_id%TYPE;
25934: l_inv_supplier_site_id IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE;
25935: l_inv_beneficiary_party IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE;
25936:
25937: CURSOR c_org_info(l_trx_index BINARY_INTEGER) IS
25938: SELECT
25931: l_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
25932: l_inv_payee_party_id IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE;
25933: l_inv_party_site_id IBY_PAYMENTS_ALL.inv_party_site_id%TYPE;
25934: l_inv_supplier_site_id IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE;
25935: l_inv_beneficiary_party IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE;
25936:
25937: CURSOR c_org_info(l_trx_index BINARY_INTEGER) IS
25938: SELECT
25939: org.name
26181:
26182: END GET_PMTREASON_INFO;
26183:
26184:
26185: PROCEDURE populatepmtTable(ppr_id IN IBY_PAYMENTS_ALL.PAYMENT_SERVICE_REQUEST_ID%type)
26186: IS
26187: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.populatePmtTable';
26188:
26189: CURSOR c_pmts_rebuild(ppr_id IBY_PAYMENTS_ALL.PAYMENT_SERVICE_REQUEST_ID%TYPE) IS
26185: PROCEDURE populatepmtTable(ppr_id IN IBY_PAYMENTS_ALL.PAYMENT_SERVICE_REQUEST_ID%type)
26186: IS
26187: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.populatePmtTable';
26188:
26189: CURSOR c_pmts_rebuild(ppr_id IBY_PAYMENTS_ALL.PAYMENT_SERVICE_REQUEST_ID%TYPE) IS
26190: SELECT
26191: payment_id,
26192: payment_method_code,
26193: payment_service_request_id,
26420: payment_process_request_name ,
26421: source_product
26422:
26423: FROM
26424: IBY_PAYMENTS_ALL
26425: where payment_service_request_id =ppr_id;
26426:
26427: BEGIN
26428: