eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYINSTR_PUB dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 90: p_admin_assigned_ref IN IBY_PAY_INSTRUCTIONS_ALL.

86: p_print_now_flag IN VARCHAR2,
87: p_transmit_now_flag IN VARCHAR2,
88:
89: /*-- user/admin assigned criteria --*/
90: p_admin_assigned_ref IN IBY_PAY_INSTRUCTIONS_ALL.
91: pay_admin_assigned_ref_code%TYPE,
92: p_comments IN IBY_PAY_INSTRUCTIONS_ALL.
93: comments%TYPE,
94:

Line 92: p_comments IN IBY_PAY_INSTRUCTIONS_ALL.

88:
89: /*-- user/admin assigned criteria --*/
90: p_admin_assigned_ref IN IBY_PAY_INSTRUCTIONS_ALL.
91: pay_admin_assigned_ref_code%TYPE,
92: p_comments IN IBY_PAY_INSTRUCTIONS_ALL.
93: comments%TYPE,
94:
95: /*-- selection criteria --*/
96: p_payment_profile_id IN IBY_PAYMENTS_ALL.

Line 169: * PLSQL table is used in inserting a row into the IBY_PAY_INSTRUCTIONS_ALL

165: l_ca_id NUMBER(15) := 0;
166:
167: /*
168: * These two are related data structures. Each row in instrTabType
169: * PLSQL table is used in inserting a row into the IBY_PAY_INSTRUCTIONS_ALL
170: * table.
171: *
172: * Since the IBY_PAY_INSTRUCTIONS_ALL table does not contain a payment id,
173: * a separate data structure is needed to keep track of the payments

Line 172: * Since the IBY_PAY_INSTRUCTIONS_ALL table does not contain a payment id,

168: * These two are related data structures. Each row in instrTabType
169: * PLSQL table is used in inserting a row into the IBY_PAY_INSTRUCTIONS_ALL
170: * table.
171: *
172: * Since the IBY_PAY_INSTRUCTIONS_ALL table does not contain a payment id,
173: * a separate data structure is needed to keep track of the payments
174: * that are part of a payment instruction. This information is tracked
175: * in the pmtsInInstrTabType table. The rows in pmtsInInstrTabType are
176: * used to update the rows in IBY_PAYMENTS_ALL table with payment instruction

Line 180: * (insert into IBY_PAY_INSTRUCTIONS_ALL) (update IBY_PAYMENTS_ALL)

176: * used to update the rows in IBY_PAYMENTS_ALL table with payment instruction
177: * ids.
178: *
179: * l_instrTab l_pmtsInInstrTab
180: * (insert into IBY_PAY_INSTRUCTIONS_ALL) (update IBY_PAYMENTS_ALL)
181: * /--------------------------------------\ /-------------\
182: * |Payment |Payment|..|Instr |Payment|..| |Payment |Pmt |
183: * |Instr Id|Profile|..|Status |Count |..| |Instr Id|Id |
184: * | |Id |..| | |..| | | |

Line 204: l_pmtInstrRec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;

200: * because you cannot directly use the combined data structure for
201: * bulk updates.
202: */
203:
204: l_pmtInstrRec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
205: l_pmtInstrTab pmtInstrTabType;
206:
207: l_pmtsInInstrRec pmtsInPmtInstrRecType;
208: l_pmtsInInstrTab pmtsInPmtInstrTabType;

Line 1719: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%

1715: | NOTES:
1716: |
1717: *---------------------------------------------------------------------*/
1718: PROCEDURE recreatePaymentInstruction(
1719: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%
1720: ROWTYPE,
1721: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
1722: docErrorTabType,
1723: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.

Line 1733: l_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;

1729:
1730: l_doc_seq_flag BOOLEAN;
1731: l_pmt_ref_flag BOOLEAN;
1732:
1733: l_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
1734: l_profile_id IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;
1735:
1736: /* maps profile ids to system profile codes */
1737: l_profile_map IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType;

Line 1734: l_profile_id IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;

1730: l_doc_seq_flag BOOLEAN;
1731: l_pmt_ref_flag BOOLEAN;
1732:
1733: l_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
1734: l_profile_id IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;
1735:
1736: /* maps profile ids to system profile codes */
1737: l_profile_map IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType;
1738:

Line 2010: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

2006: | NOTES:
2007: |
2008: *---------------------------------------------------------------------*/
2009: PROCEDURE insertPmtIntoInstruction(
2010: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
2011: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
2012: p_newPmtInstrFlag IN BOOLEAN,
2013: x_currentPmtInstrId IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL.
2014: payment_instruction_id%TYPE,

Line 2013: x_currentPmtInstrId IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL.

2009: PROCEDURE insertPmtIntoInstruction(
2010: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
2011: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
2012: p_newPmtInstrFlag IN BOOLEAN,
2013: x_currentPmtInstrId IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL.
2014: payment_instruction_id%TYPE,
2015: x_pmtsInPmtInstrTab IN OUT NOCOPY pmtsInPmtInstrTabType,
2016: x_pmtsInPmtInstrRec IN OUT NOCOPY pmtsInPmtInstrRecType,
2017: x_pmtsInPmtInstrCount IN OUT NOCOPY NUMBER,

Line 2205: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE

2201: IS
2202: l_module_name VARCHAR2(200) := G_PKG_NAME || '.insertPaymentInstructions';
2203:
2204: TYPE t_payment_instruction_id IS TABLE OF
2205: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE
2206: INDEX BY BINARY_INTEGER;
2207: TYPE t_payment_profile_id IS TABLE OF
2208: IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE
2209: INDEX BY BINARY_INTEGER;

Line 2208: IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE

2204: TYPE t_payment_instruction_id IS TABLE OF
2205: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE
2206: INDEX BY BINARY_INTEGER;
2207: TYPE t_payment_profile_id IS TABLE OF
2208: IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE
2209: INDEX BY BINARY_INTEGER;
2210: TYPE t_process_type IS TABLE OF
2211: IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE
2212: INDEX BY BINARY_INTEGER;

Line 2211: IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE

2207: TYPE t_payment_profile_id IS TABLE OF
2208: IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE
2209: INDEX BY BINARY_INTEGER;
2210: TYPE t_process_type IS TABLE OF
2211: IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE
2212: INDEX BY BINARY_INTEGER;
2213: TYPE t_payment_instruction_status IS TABLE OF
2214: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE
2215: INDEX BY BINARY_INTEGER;

Line 2214: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE

2210: TYPE t_process_type IS TABLE OF
2211: IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE
2212: INDEX BY BINARY_INTEGER;
2213: TYPE t_payment_instruction_status IS TABLE OF
2214: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE
2215: INDEX BY BINARY_INTEGER;
2216: TYPE t_payments_complete_code IS TABLE OF
2217: IBY_PAY_INSTRUCTIONS_ALL.payments_complete_code%TYPE
2218: INDEX BY BINARY_INTEGER;

Line 2217: IBY_PAY_INSTRUCTIONS_ALL.payments_complete_code%TYPE

2213: TYPE t_payment_instruction_status IS TABLE OF
2214: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE
2215: INDEX BY BINARY_INTEGER;
2216: TYPE t_payments_complete_code IS TABLE OF
2217: IBY_PAY_INSTRUCTIONS_ALL.payments_complete_code%TYPE
2218: INDEX BY BINARY_INTEGER;
2219: TYPE t_gen_sep_remit_advice_flag IS TABLE OF
2220: IBY_PAY_INSTRUCTIONS_ALL.generate_sep_remit_advice_flag%TYPE
2221: INDEX BY BINARY_INTEGER;

Line 2220: IBY_PAY_INSTRUCTIONS_ALL.generate_sep_remit_advice_flag%TYPE

2216: TYPE t_payments_complete_code IS TABLE OF
2217: IBY_PAY_INSTRUCTIONS_ALL.payments_complete_code%TYPE
2218: INDEX BY BINARY_INTEGER;
2219: TYPE t_gen_sep_remit_advice_flag IS TABLE OF
2220: IBY_PAY_INSTRUCTIONS_ALL.generate_sep_remit_advice_flag%TYPE
2221: INDEX BY BINARY_INTEGER;
2222: TYPE t_remit_advice_created_flag IS TABLE OF
2223: IBY_PAY_INSTRUCTIONS_ALL.remittance_advice_created_flag%TYPE
2224: INDEX BY BINARY_INTEGER;

Line 2223: IBY_PAY_INSTRUCTIONS_ALL.remittance_advice_created_flag%TYPE

2219: TYPE t_gen_sep_remit_advice_flag IS TABLE OF
2220: IBY_PAY_INSTRUCTIONS_ALL.generate_sep_remit_advice_flag%TYPE
2221: INDEX BY BINARY_INTEGER;
2222: TYPE t_remit_advice_created_flag IS TABLE OF
2223: IBY_PAY_INSTRUCTIONS_ALL.remittance_advice_created_flag%TYPE
2224: INDEX BY BINARY_INTEGER;
2225: TYPE t_regul_rpt_created_flag IS TABLE OF
2226: IBY_PAY_INSTRUCTIONS_ALL.regulatory_report_created_flag%TYPE
2227: INDEX BY BINARY_INTEGER;

Line 2226: IBY_PAY_INSTRUCTIONS_ALL.regulatory_report_created_flag%TYPE

2222: TYPE t_remit_advice_created_flag IS TABLE OF
2223: IBY_PAY_INSTRUCTIONS_ALL.remittance_advice_created_flag%TYPE
2224: INDEX BY BINARY_INTEGER;
2225: TYPE t_regul_rpt_created_flag IS TABLE OF
2226: IBY_PAY_INSTRUCTIONS_ALL.regulatory_report_created_flag%TYPE
2227: INDEX BY BINARY_INTEGER;
2228: TYPE t_bill_payable_flag IS TABLE OF
2229: IBY_PAY_INSTRUCTIONS_ALL.bill_payable_flag%TYPE
2230: INDEX BY BINARY_INTEGER;

Line 2229: IBY_PAY_INSTRUCTIONS_ALL.bill_payable_flag%TYPE

2225: TYPE t_regul_rpt_created_flag IS TABLE OF
2226: IBY_PAY_INSTRUCTIONS_ALL.regulatory_report_created_flag%TYPE
2227: INDEX BY BINARY_INTEGER;
2228: TYPE t_bill_payable_flag IS TABLE OF
2229: IBY_PAY_INSTRUCTIONS_ALL.bill_payable_flag%TYPE
2230: INDEX BY BINARY_INTEGER;
2231: TYPE t_legal_entity_id IS TABLE OF
2232: IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE
2233: INDEX BY BINARY_INTEGER;

Line 2232: IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE

2228: TYPE t_bill_payable_flag IS TABLE OF
2229: IBY_PAY_INSTRUCTIONS_ALL.bill_payable_flag%TYPE
2230: INDEX BY BINARY_INTEGER;
2231: TYPE t_legal_entity_id IS TABLE OF
2232: IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE
2233: INDEX BY BINARY_INTEGER;
2234: TYPE t_payment_count IS TABLE OF
2235: IBY_PAY_INSTRUCTIONS_ALL.payment_count%TYPE
2236: INDEX BY BINARY_INTEGER;

Line 2235: IBY_PAY_INSTRUCTIONS_ALL.payment_count%TYPE

2231: TYPE t_legal_entity_id IS TABLE OF
2232: IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE
2233: INDEX BY BINARY_INTEGER;
2234: TYPE t_payment_count IS TABLE OF
2235: IBY_PAY_INSTRUCTIONS_ALL.payment_count%TYPE
2236: INDEX BY BINARY_INTEGER;
2237: TYPE t_pos_pay_file_created_flag IS TABLE OF
2238: IBY_PAY_INSTRUCTIONS_ALL.positive_pay_file_created_flag%TYPE
2239: INDEX BY BINARY_INTEGER;

Line 2238: IBY_PAY_INSTRUCTIONS_ALL.positive_pay_file_created_flag%TYPE

2234: TYPE t_payment_count IS TABLE OF
2235: IBY_PAY_INSTRUCTIONS_ALL.payment_count%TYPE
2236: INDEX BY BINARY_INTEGER;
2237: TYPE t_pos_pay_file_created_flag IS TABLE OF
2238: IBY_PAY_INSTRUCTIONS_ALL.positive_pay_file_created_flag%TYPE
2239: INDEX BY BINARY_INTEGER;
2240: TYPE t_print_instruction_immed_flag IS TABLE OF
2241: IBY_PAY_INSTRUCTIONS_ALL.print_instruction_immed_flag%TYPE
2242: INDEX BY BINARY_INTEGER;

Line 2241: IBY_PAY_INSTRUCTIONS_ALL.print_instruction_immed_flag%TYPE

2237: TYPE t_pos_pay_file_created_flag IS TABLE OF
2238: IBY_PAY_INSTRUCTIONS_ALL.positive_pay_file_created_flag%TYPE
2239: INDEX BY BINARY_INTEGER;
2240: TYPE t_print_instruction_immed_flag IS TABLE OF
2241: IBY_PAY_INSTRUCTIONS_ALL.print_instruction_immed_flag%TYPE
2242: INDEX BY BINARY_INTEGER;
2243: TYPE t_transmit_instr_immed_flag IS TABLE OF
2244: IBY_PAY_INSTRUCTIONS_ALL.transmit_instr_immed_flag%TYPE
2245: INDEX BY BINARY_INTEGER;

Line 2244: IBY_PAY_INSTRUCTIONS_ALL.transmit_instr_immed_flag%TYPE

2240: TYPE t_print_instruction_immed_flag IS TABLE OF
2241: IBY_PAY_INSTRUCTIONS_ALL.print_instruction_immed_flag%TYPE
2242: INDEX BY BINARY_INTEGER;
2243: TYPE t_transmit_instr_immed_flag IS TABLE OF
2244: IBY_PAY_INSTRUCTIONS_ALL.transmit_instr_immed_flag%TYPE
2245: INDEX BY BINARY_INTEGER;
2246: TYPE t_created_by IS TABLE OF
2247: IBY_PAY_INSTRUCTIONS_ALL.created_by%TYPE
2248: INDEX BY BINARY_INTEGER;

Line 2247: IBY_PAY_INSTRUCTIONS_ALL.created_by%TYPE

2243: TYPE t_transmit_instr_immed_flag IS TABLE OF
2244: IBY_PAY_INSTRUCTIONS_ALL.transmit_instr_immed_flag%TYPE
2245: INDEX BY BINARY_INTEGER;
2246: TYPE t_created_by IS TABLE OF
2247: IBY_PAY_INSTRUCTIONS_ALL.created_by%TYPE
2248: INDEX BY BINARY_INTEGER;
2249: TYPE t_creation_date IS TABLE OF
2250: IBY_PAY_INSTRUCTIONS_ALL.creation_date%TYPE
2251: INDEX BY BINARY_INTEGER;

Line 2250: IBY_PAY_INSTRUCTIONS_ALL.creation_date%TYPE

2246: TYPE t_created_by IS TABLE OF
2247: IBY_PAY_INSTRUCTIONS_ALL.created_by%TYPE
2248: INDEX BY BINARY_INTEGER;
2249: TYPE t_creation_date IS TABLE OF
2250: IBY_PAY_INSTRUCTIONS_ALL.creation_date%TYPE
2251: INDEX BY BINARY_INTEGER;
2252: TYPE t_last_updated_by IS TABLE OF
2253: IBY_PAY_INSTRUCTIONS_ALL.last_updated_by%TYPE
2254: INDEX BY BINARY_INTEGER;

Line 2253: IBY_PAY_INSTRUCTIONS_ALL.last_updated_by%TYPE

2249: TYPE t_creation_date IS TABLE OF
2250: IBY_PAY_INSTRUCTIONS_ALL.creation_date%TYPE
2251: INDEX BY BINARY_INTEGER;
2252: TYPE t_last_updated_by IS TABLE OF
2253: IBY_PAY_INSTRUCTIONS_ALL.last_updated_by%TYPE
2254: INDEX BY BINARY_INTEGER;
2255: TYPE t_last_update_date IS TABLE OF
2256: IBY_PAY_INSTRUCTIONS_ALL.last_update_date%TYPE
2257: INDEX BY BINARY_INTEGER;

Line 2256: IBY_PAY_INSTRUCTIONS_ALL.last_update_date%TYPE

2252: TYPE t_last_updated_by IS TABLE OF
2253: IBY_PAY_INSTRUCTIONS_ALL.last_updated_by%TYPE
2254: INDEX BY BINARY_INTEGER;
2255: TYPE t_last_update_date IS TABLE OF
2256: IBY_PAY_INSTRUCTIONS_ALL.last_update_date%TYPE
2257: INDEX BY BINARY_INTEGER;
2258: TYPE t_last_update_login IS TABLE OF
2259: IBY_PAY_INSTRUCTIONS_ALL.last_update_login%TYPE
2260: INDEX BY BINARY_INTEGER;

Line 2259: IBY_PAY_INSTRUCTIONS_ALL.last_update_login%TYPE

2255: TYPE t_last_update_date IS TABLE OF
2256: IBY_PAY_INSTRUCTIONS_ALL.last_update_date%TYPE
2257: INDEX BY BINARY_INTEGER;
2258: TYPE t_last_update_login IS TABLE OF
2259: IBY_PAY_INSTRUCTIONS_ALL.last_update_login%TYPE
2260: INDEX BY BINARY_INTEGER;
2261: TYPE t_object_version_number IS TABLE OF
2262: IBY_PAY_INSTRUCTIONS_ALL.object_version_number%TYPE
2263: INDEX BY BINARY_INTEGER;

Line 2262: IBY_PAY_INSTRUCTIONS_ALL.object_version_number%TYPE

2258: TYPE t_last_update_login IS TABLE OF
2259: IBY_PAY_INSTRUCTIONS_ALL.last_update_login%TYPE
2260: INDEX BY BINARY_INTEGER;
2261: TYPE t_object_version_number IS TABLE OF
2262: IBY_PAY_INSTRUCTIONS_ALL.object_version_number%TYPE
2263: INDEX BY BINARY_INTEGER;
2264: TYPE t_internal_bank_account_id IS TABLE OF
2265: IBY_PAY_INSTRUCTIONS_ALL.internal_bank_account_id%TYPE
2266: INDEX BY BINARY_INTEGER;

Line 2265: IBY_PAY_INSTRUCTIONS_ALL.internal_bank_account_id%TYPE

2261: TYPE t_object_version_number IS TABLE OF
2262: IBY_PAY_INSTRUCTIONS_ALL.object_version_number%TYPE
2263: INDEX BY BINARY_INTEGER;
2264: TYPE t_internal_bank_account_id IS TABLE OF
2265: IBY_PAY_INSTRUCTIONS_ALL.internal_bank_account_id%TYPE
2266: INDEX BY BINARY_INTEGER;
2267: TYPE t_pay_admin_assigned_ref_code IS TABLE OF
2268: IBY_PAY_INSTRUCTIONS_ALL.pay_admin_assigned_ref_code%TYPE
2269: INDEX BY BINARY_INTEGER;

Line 2268: IBY_PAY_INSTRUCTIONS_ALL.pay_admin_assigned_ref_code%TYPE

2264: TYPE t_internal_bank_account_id IS TABLE OF
2265: IBY_PAY_INSTRUCTIONS_ALL.internal_bank_account_id%TYPE
2266: INDEX BY BINARY_INTEGER;
2267: TYPE t_pay_admin_assigned_ref_code IS TABLE OF
2268: IBY_PAY_INSTRUCTIONS_ALL.pay_admin_assigned_ref_code%TYPE
2269: INDEX BY BINARY_INTEGER;
2270: TYPE t_transmission_date IS TABLE OF
2271: IBY_PAY_INSTRUCTIONS_ALL.transmission_date%TYPE
2272: INDEX BY BINARY_INTEGER;

Line 2271: IBY_PAY_INSTRUCTIONS_ALL.transmission_date%TYPE

2267: TYPE t_pay_admin_assigned_ref_code IS TABLE OF
2268: IBY_PAY_INSTRUCTIONS_ALL.pay_admin_assigned_ref_code%TYPE
2269: INDEX BY BINARY_INTEGER;
2270: TYPE t_transmission_date IS TABLE OF
2271: IBY_PAY_INSTRUCTIONS_ALL.transmission_date%TYPE
2272: INDEX BY BINARY_INTEGER;
2273: TYPE t_acknowledgement_date IS TABLE OF
2274: IBY_PAY_INSTRUCTIONS_ALL.acknowledgement_date%TYPE
2275: INDEX BY BINARY_INTEGER;

Line 2274: IBY_PAY_INSTRUCTIONS_ALL.acknowledgement_date%TYPE

2270: TYPE t_transmission_date IS TABLE OF
2271: IBY_PAY_INSTRUCTIONS_ALL.transmission_date%TYPE
2272: INDEX BY BINARY_INTEGER;
2273: TYPE t_acknowledgement_date IS TABLE OF
2274: IBY_PAY_INSTRUCTIONS_ALL.acknowledgement_date%TYPE
2275: INDEX BY BINARY_INTEGER;
2276: TYPE t_comments IS TABLE OF
2277: IBY_PAY_INSTRUCTIONS_ALL.comments%TYPE
2278: INDEX BY BINARY_INTEGER;

Line 2277: IBY_PAY_INSTRUCTIONS_ALL.comments%TYPE

2273: TYPE t_acknowledgement_date IS TABLE OF
2274: IBY_PAY_INSTRUCTIONS_ALL.acknowledgement_date%TYPE
2275: INDEX BY BINARY_INTEGER;
2276: TYPE t_comments IS TABLE OF
2277: IBY_PAY_INSTRUCTIONS_ALL.comments%TYPE
2278: INDEX BY BINARY_INTEGER;
2279: TYPE t_bank_assigned_ref_code IS TABLE OF
2280: IBY_PAY_INSTRUCTIONS_ALL.bank_assigned_ref_code%TYPE
2281: INDEX BY BINARY_INTEGER;

Line 2280: IBY_PAY_INSTRUCTIONS_ALL.bank_assigned_ref_code%TYPE

2276: TYPE t_comments IS TABLE OF
2277: IBY_PAY_INSTRUCTIONS_ALL.comments%TYPE
2278: INDEX BY BINARY_INTEGER;
2279: TYPE t_bank_assigned_ref_code IS TABLE OF
2280: IBY_PAY_INSTRUCTIONS_ALL.bank_assigned_ref_code%TYPE
2281: INDEX BY BINARY_INTEGER;
2282: TYPE t_org_id IS TABLE OF
2283: IBY_PAY_INSTRUCTIONS_ALL.org_id%TYPE
2284: INDEX BY BINARY_INTEGER;

Line 2283: IBY_PAY_INSTRUCTIONS_ALL.org_id%TYPE

2279: TYPE t_bank_assigned_ref_code IS TABLE OF
2280: IBY_PAY_INSTRUCTIONS_ALL.bank_assigned_ref_code%TYPE
2281: INDEX BY BINARY_INTEGER;
2282: TYPE t_org_id IS TABLE OF
2283: IBY_PAY_INSTRUCTIONS_ALL.org_id%TYPE
2284: INDEX BY BINARY_INTEGER;
2285: TYPE t_org_type IS TABLE OF
2286: IBY_PAY_INSTRUCTIONS_ALL.org_type%TYPE
2287: INDEX BY BINARY_INTEGER;

Line 2286: IBY_PAY_INSTRUCTIONS_ALL.org_type%TYPE

2282: TYPE t_org_id IS TABLE OF
2283: IBY_PAY_INSTRUCTIONS_ALL.org_id%TYPE
2284: INDEX BY BINARY_INTEGER;
2285: TYPE t_org_type IS TABLE OF
2286: IBY_PAY_INSTRUCTIONS_ALL.org_type%TYPE
2287: INDEX BY BINARY_INTEGER;
2288: TYPE t_payment_date IS TABLE OF
2289: IBY_PAY_INSTRUCTIONS_ALL.payment_date%TYPE
2290: INDEX BY BINARY_INTEGER;

Line 2289: IBY_PAY_INSTRUCTIONS_ALL.payment_date%TYPE

2285: TYPE t_org_type IS TABLE OF
2286: IBY_PAY_INSTRUCTIONS_ALL.org_type%TYPE
2287: INDEX BY BINARY_INTEGER;
2288: TYPE t_payment_date IS TABLE OF
2289: IBY_PAY_INSTRUCTIONS_ALL.payment_date%TYPE
2290: INDEX BY BINARY_INTEGER;
2291: TYPE t_payment_currency_code IS TABLE OF
2292: IBY_PAY_INSTRUCTIONS_ALL.payment_currency_code%TYPE
2293: INDEX BY BINARY_INTEGER;

Line 2292: IBY_PAY_INSTRUCTIONS_ALL.payment_currency_code%TYPE

2288: TYPE t_payment_date IS TABLE OF
2289: IBY_PAY_INSTRUCTIONS_ALL.payment_date%TYPE
2290: INDEX BY BINARY_INTEGER;
2291: TYPE t_payment_currency_code IS TABLE OF
2292: IBY_PAY_INSTRUCTIONS_ALL.payment_currency_code%TYPE
2293: INDEX BY BINARY_INTEGER;
2294: TYPE t_payment_service_request_id IS TABLE OF
2295: IBY_PAY_INSTRUCTIONS_ALL.payment_service_request_id%TYPE
2296: INDEX BY BINARY_INTEGER;

Line 2295: IBY_PAY_INSTRUCTIONS_ALL.payment_service_request_id%TYPE

2291: TYPE t_payment_currency_code IS TABLE OF
2292: IBY_PAY_INSTRUCTIONS_ALL.payment_currency_code%TYPE
2293: INDEX BY BINARY_INTEGER;
2294: TYPE t_payment_service_request_id IS TABLE OF
2295: IBY_PAY_INSTRUCTIONS_ALL.payment_service_request_id%TYPE
2296: INDEX BY BINARY_INTEGER;
2297: TYPE t_payment_function IS TABLE OF
2298: IBY_PAY_INSTRUCTIONS_ALL.payment_function%TYPE
2299: INDEX BY BINARY_INTEGER;

Line 2298: IBY_PAY_INSTRUCTIONS_ALL.payment_function%TYPE

2294: TYPE t_payment_service_request_id IS TABLE OF
2295: IBY_PAY_INSTRUCTIONS_ALL.payment_service_request_id%TYPE
2296: INDEX BY BINARY_INTEGER;
2297: TYPE t_payment_function IS TABLE OF
2298: IBY_PAY_INSTRUCTIONS_ALL.payment_function%TYPE
2299: INDEX BY BINARY_INTEGER;
2300: TYPE t_payment_reason_code IS TABLE OF
2301: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_code%TYPE
2302: INDEX BY BINARY_INTEGER;

Line 2301: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_code%TYPE

2297: TYPE t_payment_function IS TABLE OF
2298: IBY_PAY_INSTRUCTIONS_ALL.payment_function%TYPE
2299: INDEX BY BINARY_INTEGER;
2300: TYPE t_payment_reason_code IS TABLE OF
2301: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_code%TYPE
2302: INDEX BY BINARY_INTEGER;
2303: TYPE t_rfc_identifier IS TABLE OF
2304: IBY_PAY_INSTRUCTIONS_ALL.rfc_identifier%TYPE
2305: INDEX BY BINARY_INTEGER;

Line 2304: IBY_PAY_INSTRUCTIONS_ALL.rfc_identifier%TYPE

2300: TYPE t_payment_reason_code IS TABLE OF
2301: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_code%TYPE
2302: INDEX BY BINARY_INTEGER;
2303: TYPE t_rfc_identifier IS TABLE OF
2304: IBY_PAY_INSTRUCTIONS_ALL.rfc_identifier%TYPE
2305: INDEX BY BINARY_INTEGER;
2306: TYPE t_pmt_method_code IS TABLE OF
2307: IBY_PAY_INSTRUCTIONS_ALL.payment_method_code%TYPE
2308: INDEX BY BINARY_INTEGER;

Line 2307: IBY_PAY_INSTRUCTIONS_ALL.payment_method_code%TYPE

2303: TYPE t_rfc_identifier IS TABLE OF
2304: IBY_PAY_INSTRUCTIONS_ALL.rfc_identifier%TYPE
2305: INDEX BY BINARY_INTEGER;
2306: TYPE t_pmt_method_code IS TABLE OF
2307: IBY_PAY_INSTRUCTIONS_ALL.payment_method_code%TYPE
2308: INDEX BY BINARY_INTEGER;
2309: TYPE t_payment_reason_comments IS TABLE OF
2310: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_comments%TYPE
2311: INDEX BY BINARY_INTEGER;

Line 2310: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_comments%TYPE

2306: TYPE t_pmt_method_code IS TABLE OF
2307: IBY_PAY_INSTRUCTIONS_ALL.payment_method_code%TYPE
2308: INDEX BY BINARY_INTEGER;
2309: TYPE t_payment_reason_comments IS TABLE OF
2310: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_comments%TYPE
2311: INDEX BY BINARY_INTEGER;
2312: TYPE t_payment_document_id IS TABLE OF
2313: IBY_PAY_INSTRUCTIONS_ALL.payment_document_id%TYPE
2314: INDEX BY BINARY_INTEGER;

Line 2313: IBY_PAY_INSTRUCTIONS_ALL.payment_document_id%TYPE

2309: TYPE t_payment_reason_comments IS TABLE OF
2310: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_comments%TYPE
2311: INDEX BY BINARY_INTEGER;
2312: TYPE t_payment_document_id IS TABLE OF
2313: IBY_PAY_INSTRUCTIONS_ALL.payment_document_id%TYPE
2314: INDEX BY BINARY_INTEGER;
2315: TYPE t_printer_name IS TABLE OF
2316: IBY_PAY_INSTRUCTIONS_ALL.printer_name%TYPE
2317: INDEX BY BINARY_INTEGER;

Line 2316: IBY_PAY_INSTRUCTIONS_ALL.printer_name%TYPE

2312: TYPE t_payment_document_id IS TABLE OF
2313: IBY_PAY_INSTRUCTIONS_ALL.payment_document_id%TYPE
2314: INDEX BY BINARY_INTEGER;
2315: TYPE t_printer_name IS TABLE OF
2316: IBY_PAY_INSTRUCTIONS_ALL.printer_name%TYPE
2317: INDEX BY BINARY_INTEGER;
2318: TYPE t_attribute_category IS TABLE OF
2319: IBY_PAY_INSTRUCTIONS_ALL.attribute_category%TYPE
2320: INDEX BY BINARY_INTEGER;

Line 2319: IBY_PAY_INSTRUCTIONS_ALL.attribute_category%TYPE

2315: TYPE t_printer_name IS TABLE OF
2316: IBY_PAY_INSTRUCTIONS_ALL.printer_name%TYPE
2317: INDEX BY BINARY_INTEGER;
2318: TYPE t_attribute_category IS TABLE OF
2319: IBY_PAY_INSTRUCTIONS_ALL.attribute_category%TYPE
2320: INDEX BY BINARY_INTEGER;
2321: TYPE t_attribute1 IS TABLE OF
2322: IBY_PAY_INSTRUCTIONS_ALL.attribute1%TYPE
2323: INDEX BY BINARY_INTEGER;

Line 2322: IBY_PAY_INSTRUCTIONS_ALL.attribute1%TYPE

2318: TYPE t_attribute_category IS TABLE OF
2319: IBY_PAY_INSTRUCTIONS_ALL.attribute_category%TYPE
2320: INDEX BY BINARY_INTEGER;
2321: TYPE t_attribute1 IS TABLE OF
2322: IBY_PAY_INSTRUCTIONS_ALL.attribute1%TYPE
2323: INDEX BY BINARY_INTEGER;
2324: TYPE t_attribute2 IS TABLE OF
2325: IBY_PAY_INSTRUCTIONS_ALL.attribute2%TYPE
2326: INDEX BY BINARY_INTEGER;

Line 2325: IBY_PAY_INSTRUCTIONS_ALL.attribute2%TYPE

2321: TYPE t_attribute1 IS TABLE OF
2322: IBY_PAY_INSTRUCTIONS_ALL.attribute1%TYPE
2323: INDEX BY BINARY_INTEGER;
2324: TYPE t_attribute2 IS TABLE OF
2325: IBY_PAY_INSTRUCTIONS_ALL.attribute2%TYPE
2326: INDEX BY BINARY_INTEGER;
2327: TYPE t_attribute3 IS TABLE OF
2328: IBY_PAY_INSTRUCTIONS_ALL.attribute3%TYPE
2329: INDEX BY BINARY_INTEGER;

Line 2328: IBY_PAY_INSTRUCTIONS_ALL.attribute3%TYPE

2324: TYPE t_attribute2 IS TABLE OF
2325: IBY_PAY_INSTRUCTIONS_ALL.attribute2%TYPE
2326: INDEX BY BINARY_INTEGER;
2327: TYPE t_attribute3 IS TABLE OF
2328: IBY_PAY_INSTRUCTIONS_ALL.attribute3%TYPE
2329: INDEX BY BINARY_INTEGER;
2330: TYPE t_attribute4 IS TABLE OF
2331: IBY_PAY_INSTRUCTIONS_ALL.attribute4%TYPE
2332: INDEX BY BINARY_INTEGER;

Line 2331: IBY_PAY_INSTRUCTIONS_ALL.attribute4%TYPE

2327: TYPE t_attribute3 IS TABLE OF
2328: IBY_PAY_INSTRUCTIONS_ALL.attribute3%TYPE
2329: INDEX BY BINARY_INTEGER;
2330: TYPE t_attribute4 IS TABLE OF
2331: IBY_PAY_INSTRUCTIONS_ALL.attribute4%TYPE
2332: INDEX BY BINARY_INTEGER;
2333: TYPE t_attribute5 IS TABLE OF
2334: IBY_PAY_INSTRUCTIONS_ALL.attribute5%TYPE
2335: INDEX BY BINARY_INTEGER;

Line 2334: IBY_PAY_INSTRUCTIONS_ALL.attribute5%TYPE

2330: TYPE t_attribute4 IS TABLE OF
2331: IBY_PAY_INSTRUCTIONS_ALL.attribute4%TYPE
2332: INDEX BY BINARY_INTEGER;
2333: TYPE t_attribute5 IS TABLE OF
2334: IBY_PAY_INSTRUCTIONS_ALL.attribute5%TYPE
2335: INDEX BY BINARY_INTEGER;
2336: TYPE t_attribute6 IS TABLE OF
2337: IBY_PAY_INSTRUCTIONS_ALL.attribute6%TYPE
2338: INDEX BY BINARY_INTEGER;

Line 2337: IBY_PAY_INSTRUCTIONS_ALL.attribute6%TYPE

2333: TYPE t_attribute5 IS TABLE OF
2334: IBY_PAY_INSTRUCTIONS_ALL.attribute5%TYPE
2335: INDEX BY BINARY_INTEGER;
2336: TYPE t_attribute6 IS TABLE OF
2337: IBY_PAY_INSTRUCTIONS_ALL.attribute6%TYPE
2338: INDEX BY BINARY_INTEGER;
2339: TYPE t_attribute7 IS TABLE OF
2340: IBY_PAY_INSTRUCTIONS_ALL.attribute7%TYPE
2341: INDEX BY BINARY_INTEGER;

Line 2340: IBY_PAY_INSTRUCTIONS_ALL.attribute7%TYPE

2336: TYPE t_attribute6 IS TABLE OF
2337: IBY_PAY_INSTRUCTIONS_ALL.attribute6%TYPE
2338: INDEX BY BINARY_INTEGER;
2339: TYPE t_attribute7 IS TABLE OF
2340: IBY_PAY_INSTRUCTIONS_ALL.attribute7%TYPE
2341: INDEX BY BINARY_INTEGER;
2342: TYPE t_attribute8 IS TABLE OF
2343: IBY_PAY_INSTRUCTIONS_ALL.attribute8%TYPE
2344: INDEX BY BINARY_INTEGER;

Line 2343: IBY_PAY_INSTRUCTIONS_ALL.attribute8%TYPE

2339: TYPE t_attribute7 IS TABLE OF
2340: IBY_PAY_INSTRUCTIONS_ALL.attribute7%TYPE
2341: INDEX BY BINARY_INTEGER;
2342: TYPE t_attribute8 IS TABLE OF
2343: IBY_PAY_INSTRUCTIONS_ALL.attribute8%TYPE
2344: INDEX BY BINARY_INTEGER;
2345: TYPE t_attribute9 IS TABLE OF
2346: IBY_PAY_INSTRUCTIONS_ALL.attribute9%TYPE
2347: INDEX BY BINARY_INTEGER;

Line 2346: IBY_PAY_INSTRUCTIONS_ALL.attribute9%TYPE

2342: TYPE t_attribute8 IS TABLE OF
2343: IBY_PAY_INSTRUCTIONS_ALL.attribute8%TYPE
2344: INDEX BY BINARY_INTEGER;
2345: TYPE t_attribute9 IS TABLE OF
2346: IBY_PAY_INSTRUCTIONS_ALL.attribute9%TYPE
2347: INDEX BY BINARY_INTEGER;
2348: TYPE t_attribute10 IS TABLE OF
2349: IBY_PAY_INSTRUCTIONS_ALL.attribute10%TYPE
2350: INDEX BY BINARY_INTEGER;

Line 2349: IBY_PAY_INSTRUCTIONS_ALL.attribute10%TYPE

2345: TYPE t_attribute9 IS TABLE OF
2346: IBY_PAY_INSTRUCTIONS_ALL.attribute9%TYPE
2347: INDEX BY BINARY_INTEGER;
2348: TYPE t_attribute10 IS TABLE OF
2349: IBY_PAY_INSTRUCTIONS_ALL.attribute10%TYPE
2350: INDEX BY BINARY_INTEGER;
2351: TYPE t_attribute11 IS TABLE OF
2352: IBY_PAY_INSTRUCTIONS_ALL.attribute11%TYPE
2353: INDEX BY BINARY_INTEGER;

Line 2352: IBY_PAY_INSTRUCTIONS_ALL.attribute11%TYPE

2348: TYPE t_attribute10 IS TABLE OF
2349: IBY_PAY_INSTRUCTIONS_ALL.attribute10%TYPE
2350: INDEX BY BINARY_INTEGER;
2351: TYPE t_attribute11 IS TABLE OF
2352: IBY_PAY_INSTRUCTIONS_ALL.attribute11%TYPE
2353: INDEX BY BINARY_INTEGER;
2354: TYPE t_attribute12 IS TABLE OF
2355: IBY_PAY_INSTRUCTIONS_ALL.attribute12%TYPE
2356: INDEX BY BINARY_INTEGER;

Line 2355: IBY_PAY_INSTRUCTIONS_ALL.attribute12%TYPE

2351: TYPE t_attribute11 IS TABLE OF
2352: IBY_PAY_INSTRUCTIONS_ALL.attribute11%TYPE
2353: INDEX BY BINARY_INTEGER;
2354: TYPE t_attribute12 IS TABLE OF
2355: IBY_PAY_INSTRUCTIONS_ALL.attribute12%TYPE
2356: INDEX BY BINARY_INTEGER;
2357: TYPE t_attribute13 IS TABLE OF
2358: IBY_PAY_INSTRUCTIONS_ALL.attribute13%TYPE
2359: INDEX BY BINARY_INTEGER;

Line 2358: IBY_PAY_INSTRUCTIONS_ALL.attribute13%TYPE

2354: TYPE t_attribute12 IS TABLE OF
2355: IBY_PAY_INSTRUCTIONS_ALL.attribute12%TYPE
2356: INDEX BY BINARY_INTEGER;
2357: TYPE t_attribute13 IS TABLE OF
2358: IBY_PAY_INSTRUCTIONS_ALL.attribute13%TYPE
2359: INDEX BY BINARY_INTEGER;
2360: TYPE t_attribute14 IS TABLE OF
2361: IBY_PAY_INSTRUCTIONS_ALL.attribute14%TYPE
2362: INDEX BY BINARY_INTEGER;

Line 2361: IBY_PAY_INSTRUCTIONS_ALL.attribute14%TYPE

2357: TYPE t_attribute13 IS TABLE OF
2358: IBY_PAY_INSTRUCTIONS_ALL.attribute13%TYPE
2359: INDEX BY BINARY_INTEGER;
2360: TYPE t_attribute14 IS TABLE OF
2361: IBY_PAY_INSTRUCTIONS_ALL.attribute14%TYPE
2362: INDEX BY BINARY_INTEGER;
2363: TYPE t_attribute15 IS TABLE OF
2364: IBY_PAY_INSTRUCTIONS_ALL.attribute15%TYPE
2365: INDEX BY BINARY_INTEGER;

Line 2364: IBY_PAY_INSTRUCTIONS_ALL.attribute15%TYPE

2360: TYPE t_attribute14 IS TABLE OF
2361: IBY_PAY_INSTRUCTIONS_ALL.attribute14%TYPE
2362: INDEX BY BINARY_INTEGER;
2363: TYPE t_attribute15 IS TABLE OF
2364: IBY_PAY_INSTRUCTIONS_ALL.attribute15%TYPE
2365: INDEX BY BINARY_INTEGER;
2366:
2367: l_payment_instruction_id t_payment_instruction_id;
2368: l_payment_profile_id t_payment_profile_id;

Line 2441: || 'IBY_PAY_INSTRUCTIONS_ALL table.'

2437: IF (p_payInstrTab.COUNT = 0) THEN
2438: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2439: print_debuginfo(l_module_name, 'After grouping, no payment '
2440: || 'instructions were found to update '
2441: || 'IBY_PAY_INSTRUCTIONS_ALL table.'
2442: || ' Possible data corruption issue.');
2443: END IF;
2444: RETURN;
2445: END IF;

Line 2563: INSERT INTO IBY_PAY_INSTRUCTIONS_ALL

2559:
2560: /* CHANGE FOR BUG : 14348326 - START */
2561: FORALL i in p_payInstrTab.FIRST..p_payInstrTab.LAST SAVE EXCEPTIONS
2562: /* CHANGE FOR BUG : 14348326 - END */
2563: INSERT INTO IBY_PAY_INSTRUCTIONS_ALL
2564: (
2565: payment_instruction_id,
2566: payment_profile_id,
2567: process_type,

Line 2722: | table into IBY_PAY_INSTRUCTIONS_ALL table.

Line 2725: | IBY_PAY_INSTRUCTIONS_ALL after grouping (and before validation).

Line 2757: || ' were found to update IBY_PAY_INSTRUCTIONS_ALL table.');

2753: /* Normally, this shouldn't happen */
2754: IF (p_payInstrTab.COUNT = 0) THEN
2755: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2756: print_debuginfo(l_module_name, 'No payment instructions'
2757: || ' were found to update IBY_PAY_INSTRUCTIONS_ALL table.');
2758: END IF;
2759: RETURN;
2760: END IF;
2761:

Line 2765: IBY_PAY_INSTRUCTIONS_ALL

2761:
2762: FOR i in p_payInstrTab.FIRST..p_payInstrTab.LAST LOOP
2763:
2764: UPDATE
2765: IBY_PAY_INSTRUCTIONS_ALL
2766: SET
2767: payment_instruction_status =
2768: p_payInstrTab(i).payment_instruction_status,
2769: generate_sep_remit_advice_flag =

Line 2803: x_pmtInstrID IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL.

2799: | NOTES:
2800: |
2801: *---------------------------------------------------------------------*/
2802: PROCEDURE getNextPaymentInstructionID(
2803: x_pmtInstrID IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL.
2804: payment_instruction_id%TYPE
2805: )
2806: IS
2807:

Line 2811: IBY_PAY_INSTRUCTIONS_ALL_S.NEXTVAL

2807:
2808: BEGIN
2809:
2810: SELECT
2811: IBY_PAY_INSTRUCTIONS_ALL_S.NEXTVAL
2812: INTO
2813: x_pmtInstrID
2814: FROM
2815: DUAL

Line 3019: l_payment_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;

3015: where_clause VARCHAR(4000);
3016: order_clause VARCHAR(4000);
3017:
3018:
3019: l_payment_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
3020: l_grp_cntr NUMBER;
3021: l_logical_group_reference IBY_PAYMENTS_ALL.LOGICAL_GROUP_REFERENCE%TYPE;
3022: l_profileRec IBY_SYS_PMT_PROFILES_B%ROWTYPE;
3023:

Line 3593: * have already been written into the IBY_PAY_INSTRUCTIONS_ALL

3589:
3590: /*
3591: * All payment instructions for this run have been
3592: * created and stored in a PLSQL table. These instructions
3593: * have already been written into the IBY_PAY_INSTRUCTIONS_ALL
3594: * table just before validations. Now update these
3595: * payment instructions with any additional information.
3596: *
3597: * E.g., the payment instruction could have been failed because

Line 3687: CURSOR c_instr_val_sets(p_instr_id IBY_PAY_INSTRUCTIONS_ALL.

3683: *
3684: * For instructions, the validation level code has been changed
3685: * from 'INSTRUCTION' to 'DISBURSEMENT_INSTRUCTION'.
3686: */
3687: CURSOR c_instr_val_sets(p_instr_id IBY_PAY_INSTRUCTIONS_ALL.
3688: payment_instruction_id%TYPE)
3689: IS
3690: SELECT DISTINCT
3691: val_asgn.validation_assignment_id,

Line 3698: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,

3694: val.validation_code_entry_point
3695: FROM
3696: IBY_VALIDATION_SETS_VL val,
3697: IBY_VAL_ASSIGNMENTS val_asgn,
3698: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,
3699: IBY_PAYMENT_PROFILES prof,
3700: IBY_TRANSMIT_CONFIGS_VL txconf,
3701: IBY_TRANSMIT_PROTOCOLS_VL txproto,
3702: IBY_PAYMENTS_SEC_V pmt

Line 3809: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

3805: | NOTES:
3806: |
3807: *---------------------------------------------------------------------*/
3808: PROCEDURE reApplyPayInstrValidationSets(
3809: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
3810: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3811: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3812: )
3813: IS

Line 3827: CURSOR c_retry_instrvalsets(p_instr_id IBY_PAY_INSTRUCTIONS_ALL.

3823: /*
3824: * Pick up all validation sets applicable to a particular instruction
3825: * that have not overridden by the payment administrator.
3826: */
3827: CURSOR c_retry_instrvalsets(p_instr_id IBY_PAY_INSTRUCTIONS_ALL.
3828: payment_instruction_id%TYPE)
3829: IS
3830: SELECT DISTINCT
3831: val_asgn.validation_assignment_id,

Line 3838: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,

3834: val.validation_code_entry_point
3835: FROM
3836: IBY_VALIDATION_SETS_VL val,
3837: IBY_VAL_ASSIGNMENTS val_asgn,
3838: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,
3839: IBY_PAYMENT_PROFILES prof,
3840: IBY_TRANSMIT_CONFIGS_VL txconf,
3841: IBY_TRANSMIT_PROTOCOLS_VL txproto,
3842: IBY_TRANSACTION_ERRORS txerrors

Line 4043: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

4039: | NOTES:
4040: |
4041: *---------------------------------------------------------------------*/
4042: PROCEDURE executeValidationsForInstr(
4043: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
4044: p_valSetsTab IN instructionValSetsTab,
4045: p_isReval IN BOOLEAN,
4046: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
4047: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

Line 4514: || 'FROM IBY_PAY_INSTRUCTIONS_ALL '

4510: * XML output.
4511: */
4512:
4513: l_sql := 'SELECT payment_instruction_id '
4514: || 'FROM IBY_PAY_INSTRUCTIONS_ALL '
4515: || 'WHERE payment_instruction_id = :p_ins_id '
4516: || 'AND payment_instruction_status <> :p_ins_status';
4517:
4518: l_ctx := DBMS_XMLQuery.newContext(l_sql);

Line 5179: l_le_id IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE;

5175:
5176: l_ret_val BOOLEAN := FALSE;
5177: l_ledger_list GL_MC_INFO.ledger_tbl_type := GL_MC_INFO.ledger_tbl_type();
5178: l_ledger_id NUMBER(15);
5179: l_le_id IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE;
5180:
5181: l_module_name VARCHAR2(200) := G_PKG_NAME || '.getLedgerIdFromLEId';
5182:
5183: BEGIN

Line 5574: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE

5570: *---------------------------------------------------------------------*/
5571: FUNCTION getSortOptionsForProfile(
5572: p_sortOptionsTab IN sortOptionsTabType,
5573: p_profileMap IN IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType,
5574: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE
5575: )
5576: RETURN sortOptionsRecType
5577:
5578: IS

Line 6225: p_pmtInstrId IN IBY_PAY_INSTRUCTIONS_ALL.

6221: | NOTES:
6222: |
6223: *---------------------------------------------------------------------*/
6224: PROCEDURE setRemitFlagForPmtInstruction(
6225: p_pmtInstrId IN IBY_PAY_INSTRUCTIONS_ALL.
6226: payment_instruction_id%TYPE,
6227: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType
6228: )
6229: IS

Line 6472: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id

6468: | NOTES:
6469: |
6470: *---------------------------------------------------------------------*/
6471: PROCEDURE deriveDistinctAccessTypsForIns(
6472: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id
6473: %TYPE,
6474: p_pmt_function IN IBY_PAYMENTS_ALL.payment_function%TYPE,
6475: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
6476: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,

Line 6737: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE

6733: | NOTES:
6734: |
6735: *---------------------------------------------------------------------*/
6736: FUNCTION checkIfDocSeqCompleted(
6737: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE
6738: )
6739: RETURN BOOLEAN
6740: IS
6741:

Line 6844: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE

6840: | NOTES:
6841: |
6842: *---------------------------------------------------------------------*/
6843: FUNCTION checkIfPmtRefCompleted(
6844: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE
6845: )
6846: RETURN BOOLEAN
6847: IS
6848:

Line 6928: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

6924: | NOTES:
6925: |
6926: *---------------------------------------------------------------------*/
6927: PROCEDURE getSortedPmtsForInstr(
6928: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
6929: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE,
6930: p_sortOptionsTab IN sortOptionsTabType,
6931: p_profileMap IN IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType,
6932: x_sortedPmtTab IN OUT NOCOPY sortedPmtTabType

Line 6929: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE,

6925: |
6926: *---------------------------------------------------------------------*/
6927: PROCEDURE getSortedPmtsForInstr(
6928: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
6929: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE,
6930: p_sortOptionsTab IN sortOptionsTabType,
6931: p_profileMap IN IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType,
6932: x_sortedPmtTab IN OUT NOCOPY sortedPmtTabType
6933: )

Line 7024: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '

7020: || 'FROM '
7021: || 'IBY_PAYMENTS_ALL pmt, '
7022: || 'IBY_PAY_SERVICE_REQUESTS req, '
7023: || 'IBY_PAYMENT_METHODS_VL pmt_mthds, '
7024: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '
7025: || 'HZ_PARTIES payee, '
7026: --|| 'HZ_LOCATIONS payee_location, ' Bug 13739596
7027: || 'IBY_EXT_BANK_ACCOUNTS payee_bank ' -- Bug 5872977
7028: || 'WHERE '

Line 7063: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '

7059: || 'FROM '
7060: || 'IBY_PAYMENTS_ALL pmt, '
7061: || 'IBY_PAY_SERVICE_REQUESTS req, '
7062: || 'IBY_PAYMENT_METHODS_VL pmt_mthds, '
7063: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '
7064: || 'HZ_PARTIES payee '
7065: || 'WHERE '
7066: || ' pmt.payment_instruction_id = :instr_id '
7067: || 'AND pmt.payment_status = :pmt_status '

Line 7271: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)

7267: | NOTES:
7268: |
7269: *---------------------------------------------------------------------*/
7270: FUNCTION get_instruction_profile (
7271: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
7272: RETURN NUMBER
7273: IS
7274:
7275: l_pmt_instr_profile IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;

Line 7275: l_pmt_instr_profile IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;

7271: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
7272: RETURN NUMBER
7273: IS
7274:
7275: l_pmt_instr_profile IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;
7276: l_module_name VARCHAR2(200) := G_PKG_NAME || '.get_instruction_profile';
7277:
7278: BEGIN
7279:

Line 7285: IBY_PAY_INSTRUCTIONS_ALL

7281: payment_profile_id
7282: INTO
7283: l_pmt_instr_profile
7284: FROM
7285: IBY_PAY_INSTRUCTIONS_ALL
7286: WHERE
7287: payment_instruction_id = l_pmt_instr_id
7288: ;
7289:

Line 7335: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE,

7331: | NOTES:
7332: |
7333: *---------------------------------------------------------------------*/
7334: PROCEDURE retrieveSortOptionForProfile(
7335: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE,
7336: x_sortOptionsTab IN OUT NOCOPY sortOptionsTabType
7337: )
7338: IS
7339:

Line 7423: l_process_type IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE;

7419: )
7420: IS
7421:
7422: l_module_name VARCHAR2(200) := G_PKG_NAME || '.initializeInstrs';
7423: l_process_type IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE;
7424: l_multi_pi_flag BOOLEAN := FALSE;
7425: l_instr_seq_num VARCHAR2(200);
7426:
7427: BEGIN