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 88: p_admin_assigned_ref IN IBY_PAY_INSTRUCTIONS_ALL.

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

Line 90: p_comments IN IBY_PAY_INSTRUCTIONS_ALL.

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

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

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

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

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

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

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

Line 202: l_pmtInstrRec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;

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

Line 1551: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%

1547: | NOTES:
1548: |
1549: *---------------------------------------------------------------------*/
1550: PROCEDURE recreatePaymentInstruction(
1551: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%
1552: ROWTYPE,
1553: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
1554: docErrorTabType,
1555: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.

Line 1565: l_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;

1561:
1562: l_doc_seq_flag BOOLEAN;
1563: l_pmt_ref_flag BOOLEAN;
1564:
1565: l_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
1566: l_profile_id IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;
1567:
1568: /* maps profile ids to system profile codes */
1569: l_profile_map IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType;

Line 1566: l_profile_id IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;

1562: l_doc_seq_flag BOOLEAN;
1563: l_pmt_ref_flag BOOLEAN;
1564:
1565: l_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
1566: l_profile_id IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;
1567:
1568: /* maps profile ids to system profile codes */
1569: l_profile_map IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType;
1570:

Line 1822: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

1818: | NOTES:
1819: |
1820: *---------------------------------------------------------------------*/
1821: PROCEDURE insertPmtIntoInstruction(
1822: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
1823: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
1824: p_newPmtInstrFlag IN BOOLEAN,
1825: x_currentPmtInstrId IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL.
1826: payment_instruction_id%TYPE,

Line 1825: x_currentPmtInstrId IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL.

1821: PROCEDURE insertPmtIntoInstruction(
1822: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
1823: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
1824: p_newPmtInstrFlag IN BOOLEAN,
1825: x_currentPmtInstrId IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL.
1826: payment_instruction_id%TYPE,
1827: x_pmtsInPmtInstrTab IN OUT NOCOPY pmtsInPmtInstrTabType,
1828: x_pmtsInPmtInstrRec IN OUT NOCOPY pmtsInPmtInstrRecType,
1829: x_pmtsInPmtInstrCount IN OUT NOCOPY NUMBER,

Line 2005: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE

2001: IS
2002: l_module_name VARCHAR2(200) := G_PKG_NAME || '.insertPaymentInstructions';
2003:
2004: TYPE t_payment_instruction_id IS TABLE OF
2005: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE
2006: INDEX BY BINARY_INTEGER;
2007: TYPE t_payment_profile_id IS TABLE OF
2008: IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE
2009: INDEX BY BINARY_INTEGER;

Line 2008: IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE

2004: TYPE t_payment_instruction_id IS TABLE OF
2005: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE
2006: INDEX BY BINARY_INTEGER;
2007: TYPE t_payment_profile_id IS TABLE OF
2008: IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE
2009: INDEX BY BINARY_INTEGER;
2010: TYPE t_process_type IS TABLE OF
2011: IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE
2012: INDEX BY BINARY_INTEGER;

Line 2011: IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE

2007: TYPE t_payment_profile_id IS TABLE OF
2008: IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE
2009: INDEX BY BINARY_INTEGER;
2010: TYPE t_process_type IS TABLE OF
2011: IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE
2012: INDEX BY BINARY_INTEGER;
2013: TYPE t_payment_instruction_status IS TABLE OF
2014: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE
2015: INDEX BY BINARY_INTEGER;

Line 2014: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE

2010: TYPE t_process_type IS TABLE OF
2011: IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE
2012: INDEX BY BINARY_INTEGER;
2013: TYPE t_payment_instruction_status IS TABLE OF
2014: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE
2015: INDEX BY BINARY_INTEGER;
2016: TYPE t_payments_complete_code IS TABLE OF
2017: IBY_PAY_INSTRUCTIONS_ALL.payments_complete_code%TYPE
2018: INDEX BY BINARY_INTEGER;

Line 2017: IBY_PAY_INSTRUCTIONS_ALL.payments_complete_code%TYPE

2013: TYPE t_payment_instruction_status IS TABLE OF
2014: IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE
2015: INDEX BY BINARY_INTEGER;
2016: TYPE t_payments_complete_code IS TABLE OF
2017: IBY_PAY_INSTRUCTIONS_ALL.payments_complete_code%TYPE
2018: INDEX BY BINARY_INTEGER;
2019: TYPE t_gen_sep_remit_advice_flag IS TABLE OF
2020: IBY_PAY_INSTRUCTIONS_ALL.generate_sep_remit_advice_flag%TYPE
2021: INDEX BY BINARY_INTEGER;

Line 2020: IBY_PAY_INSTRUCTIONS_ALL.generate_sep_remit_advice_flag%TYPE

2016: TYPE t_payments_complete_code IS TABLE OF
2017: IBY_PAY_INSTRUCTIONS_ALL.payments_complete_code%TYPE
2018: INDEX BY BINARY_INTEGER;
2019: TYPE t_gen_sep_remit_advice_flag IS TABLE OF
2020: IBY_PAY_INSTRUCTIONS_ALL.generate_sep_remit_advice_flag%TYPE
2021: INDEX BY BINARY_INTEGER;
2022: TYPE t_remit_advice_created_flag IS TABLE OF
2023: IBY_PAY_INSTRUCTIONS_ALL.remittance_advice_created_flag%TYPE
2024: INDEX BY BINARY_INTEGER;

Line 2023: IBY_PAY_INSTRUCTIONS_ALL.remittance_advice_created_flag%TYPE

2019: TYPE t_gen_sep_remit_advice_flag IS TABLE OF
2020: IBY_PAY_INSTRUCTIONS_ALL.generate_sep_remit_advice_flag%TYPE
2021: INDEX BY BINARY_INTEGER;
2022: TYPE t_remit_advice_created_flag IS TABLE OF
2023: IBY_PAY_INSTRUCTIONS_ALL.remittance_advice_created_flag%TYPE
2024: INDEX BY BINARY_INTEGER;
2025: TYPE t_regul_rpt_created_flag IS TABLE OF
2026: IBY_PAY_INSTRUCTIONS_ALL.regulatory_report_created_flag%TYPE
2027: INDEX BY BINARY_INTEGER;

Line 2026: IBY_PAY_INSTRUCTIONS_ALL.regulatory_report_created_flag%TYPE

2022: TYPE t_remit_advice_created_flag IS TABLE OF
2023: IBY_PAY_INSTRUCTIONS_ALL.remittance_advice_created_flag%TYPE
2024: INDEX BY BINARY_INTEGER;
2025: TYPE t_regul_rpt_created_flag IS TABLE OF
2026: IBY_PAY_INSTRUCTIONS_ALL.regulatory_report_created_flag%TYPE
2027: INDEX BY BINARY_INTEGER;
2028: TYPE t_bill_payable_flag IS TABLE OF
2029: IBY_PAY_INSTRUCTIONS_ALL.bill_payable_flag%TYPE
2030: INDEX BY BINARY_INTEGER;

Line 2029: IBY_PAY_INSTRUCTIONS_ALL.bill_payable_flag%TYPE

2025: TYPE t_regul_rpt_created_flag IS TABLE OF
2026: IBY_PAY_INSTRUCTIONS_ALL.regulatory_report_created_flag%TYPE
2027: INDEX BY BINARY_INTEGER;
2028: TYPE t_bill_payable_flag IS TABLE OF
2029: IBY_PAY_INSTRUCTIONS_ALL.bill_payable_flag%TYPE
2030: INDEX BY BINARY_INTEGER;
2031: TYPE t_legal_entity_id IS TABLE OF
2032: IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE
2033: INDEX BY BINARY_INTEGER;

Line 2032: IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE

2028: TYPE t_bill_payable_flag IS TABLE OF
2029: IBY_PAY_INSTRUCTIONS_ALL.bill_payable_flag%TYPE
2030: INDEX BY BINARY_INTEGER;
2031: TYPE t_legal_entity_id IS TABLE OF
2032: IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE
2033: INDEX BY BINARY_INTEGER;
2034: TYPE t_payment_count IS TABLE OF
2035: IBY_PAY_INSTRUCTIONS_ALL.payment_count%TYPE
2036: INDEX BY BINARY_INTEGER;

Line 2035: IBY_PAY_INSTRUCTIONS_ALL.payment_count%TYPE

2031: TYPE t_legal_entity_id IS TABLE OF
2032: IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE
2033: INDEX BY BINARY_INTEGER;
2034: TYPE t_payment_count IS TABLE OF
2035: IBY_PAY_INSTRUCTIONS_ALL.payment_count%TYPE
2036: INDEX BY BINARY_INTEGER;
2037: TYPE t_pos_pay_file_created_flag IS TABLE OF
2038: IBY_PAY_INSTRUCTIONS_ALL.positive_pay_file_created_flag%TYPE
2039: INDEX BY BINARY_INTEGER;

Line 2038: IBY_PAY_INSTRUCTIONS_ALL.positive_pay_file_created_flag%TYPE

2034: TYPE t_payment_count IS TABLE OF
2035: IBY_PAY_INSTRUCTIONS_ALL.payment_count%TYPE
2036: INDEX BY BINARY_INTEGER;
2037: TYPE t_pos_pay_file_created_flag IS TABLE OF
2038: IBY_PAY_INSTRUCTIONS_ALL.positive_pay_file_created_flag%TYPE
2039: INDEX BY BINARY_INTEGER;
2040: TYPE t_print_instruction_immed_flag IS TABLE OF
2041: IBY_PAY_INSTRUCTIONS_ALL.print_instruction_immed_flag%TYPE
2042: INDEX BY BINARY_INTEGER;

Line 2041: IBY_PAY_INSTRUCTIONS_ALL.print_instruction_immed_flag%TYPE

2037: TYPE t_pos_pay_file_created_flag IS TABLE OF
2038: IBY_PAY_INSTRUCTIONS_ALL.positive_pay_file_created_flag%TYPE
2039: INDEX BY BINARY_INTEGER;
2040: TYPE t_print_instruction_immed_flag IS TABLE OF
2041: IBY_PAY_INSTRUCTIONS_ALL.print_instruction_immed_flag%TYPE
2042: INDEX BY BINARY_INTEGER;
2043: TYPE t_transmit_instr_immed_flag IS TABLE OF
2044: IBY_PAY_INSTRUCTIONS_ALL.transmit_instr_immed_flag%TYPE
2045: INDEX BY BINARY_INTEGER;

Line 2044: IBY_PAY_INSTRUCTIONS_ALL.transmit_instr_immed_flag%TYPE

2040: TYPE t_print_instruction_immed_flag IS TABLE OF
2041: IBY_PAY_INSTRUCTIONS_ALL.print_instruction_immed_flag%TYPE
2042: INDEX BY BINARY_INTEGER;
2043: TYPE t_transmit_instr_immed_flag IS TABLE OF
2044: IBY_PAY_INSTRUCTIONS_ALL.transmit_instr_immed_flag%TYPE
2045: INDEX BY BINARY_INTEGER;
2046: TYPE t_created_by IS TABLE OF
2047: IBY_PAY_INSTRUCTIONS_ALL.created_by%TYPE
2048: INDEX BY BINARY_INTEGER;

Line 2047: IBY_PAY_INSTRUCTIONS_ALL.created_by%TYPE

2043: TYPE t_transmit_instr_immed_flag IS TABLE OF
2044: IBY_PAY_INSTRUCTIONS_ALL.transmit_instr_immed_flag%TYPE
2045: INDEX BY BINARY_INTEGER;
2046: TYPE t_created_by IS TABLE OF
2047: IBY_PAY_INSTRUCTIONS_ALL.created_by%TYPE
2048: INDEX BY BINARY_INTEGER;
2049: TYPE t_creation_date IS TABLE OF
2050: IBY_PAY_INSTRUCTIONS_ALL.creation_date%TYPE
2051: INDEX BY BINARY_INTEGER;

Line 2050: IBY_PAY_INSTRUCTIONS_ALL.creation_date%TYPE

2046: TYPE t_created_by IS TABLE OF
2047: IBY_PAY_INSTRUCTIONS_ALL.created_by%TYPE
2048: INDEX BY BINARY_INTEGER;
2049: TYPE t_creation_date IS TABLE OF
2050: IBY_PAY_INSTRUCTIONS_ALL.creation_date%TYPE
2051: INDEX BY BINARY_INTEGER;
2052: TYPE t_last_updated_by IS TABLE OF
2053: IBY_PAY_INSTRUCTIONS_ALL.last_updated_by%TYPE
2054: INDEX BY BINARY_INTEGER;

Line 2053: IBY_PAY_INSTRUCTIONS_ALL.last_updated_by%TYPE

2049: TYPE t_creation_date IS TABLE OF
2050: IBY_PAY_INSTRUCTIONS_ALL.creation_date%TYPE
2051: INDEX BY BINARY_INTEGER;
2052: TYPE t_last_updated_by IS TABLE OF
2053: IBY_PAY_INSTRUCTIONS_ALL.last_updated_by%TYPE
2054: INDEX BY BINARY_INTEGER;
2055: TYPE t_last_update_date IS TABLE OF
2056: IBY_PAY_INSTRUCTIONS_ALL.last_update_date%TYPE
2057: INDEX BY BINARY_INTEGER;

Line 2056: IBY_PAY_INSTRUCTIONS_ALL.last_update_date%TYPE

2052: TYPE t_last_updated_by IS TABLE OF
2053: IBY_PAY_INSTRUCTIONS_ALL.last_updated_by%TYPE
2054: INDEX BY BINARY_INTEGER;
2055: TYPE t_last_update_date IS TABLE OF
2056: IBY_PAY_INSTRUCTIONS_ALL.last_update_date%TYPE
2057: INDEX BY BINARY_INTEGER;
2058: TYPE t_last_update_login IS TABLE OF
2059: IBY_PAY_INSTRUCTIONS_ALL.last_update_login%TYPE
2060: INDEX BY BINARY_INTEGER;

Line 2059: IBY_PAY_INSTRUCTIONS_ALL.last_update_login%TYPE

2055: TYPE t_last_update_date IS TABLE OF
2056: IBY_PAY_INSTRUCTIONS_ALL.last_update_date%TYPE
2057: INDEX BY BINARY_INTEGER;
2058: TYPE t_last_update_login IS TABLE OF
2059: IBY_PAY_INSTRUCTIONS_ALL.last_update_login%TYPE
2060: INDEX BY BINARY_INTEGER;
2061: TYPE t_object_version_number IS TABLE OF
2062: IBY_PAY_INSTRUCTIONS_ALL.object_version_number%TYPE
2063: INDEX BY BINARY_INTEGER;

Line 2062: IBY_PAY_INSTRUCTIONS_ALL.object_version_number%TYPE

2058: TYPE t_last_update_login IS TABLE OF
2059: IBY_PAY_INSTRUCTIONS_ALL.last_update_login%TYPE
2060: INDEX BY BINARY_INTEGER;
2061: TYPE t_object_version_number IS TABLE OF
2062: IBY_PAY_INSTRUCTIONS_ALL.object_version_number%TYPE
2063: INDEX BY BINARY_INTEGER;
2064: TYPE t_internal_bank_account_id IS TABLE OF
2065: IBY_PAY_INSTRUCTIONS_ALL.internal_bank_account_id%TYPE
2066: INDEX BY BINARY_INTEGER;

Line 2065: IBY_PAY_INSTRUCTIONS_ALL.internal_bank_account_id%TYPE

2061: TYPE t_object_version_number IS TABLE OF
2062: IBY_PAY_INSTRUCTIONS_ALL.object_version_number%TYPE
2063: INDEX BY BINARY_INTEGER;
2064: TYPE t_internal_bank_account_id IS TABLE OF
2065: IBY_PAY_INSTRUCTIONS_ALL.internal_bank_account_id%TYPE
2066: INDEX BY BINARY_INTEGER;
2067: TYPE t_pay_admin_assigned_ref_code IS TABLE OF
2068: IBY_PAY_INSTRUCTIONS_ALL.pay_admin_assigned_ref_code%TYPE
2069: INDEX BY BINARY_INTEGER;

Line 2068: IBY_PAY_INSTRUCTIONS_ALL.pay_admin_assigned_ref_code%TYPE

2064: TYPE t_internal_bank_account_id IS TABLE OF
2065: IBY_PAY_INSTRUCTIONS_ALL.internal_bank_account_id%TYPE
2066: INDEX BY BINARY_INTEGER;
2067: TYPE t_pay_admin_assigned_ref_code IS TABLE OF
2068: IBY_PAY_INSTRUCTIONS_ALL.pay_admin_assigned_ref_code%TYPE
2069: INDEX BY BINARY_INTEGER;
2070: TYPE t_transmission_date IS TABLE OF
2071: IBY_PAY_INSTRUCTIONS_ALL.transmission_date%TYPE
2072: INDEX BY BINARY_INTEGER;

Line 2071: IBY_PAY_INSTRUCTIONS_ALL.transmission_date%TYPE

2067: TYPE t_pay_admin_assigned_ref_code IS TABLE OF
2068: IBY_PAY_INSTRUCTIONS_ALL.pay_admin_assigned_ref_code%TYPE
2069: INDEX BY BINARY_INTEGER;
2070: TYPE t_transmission_date IS TABLE OF
2071: IBY_PAY_INSTRUCTIONS_ALL.transmission_date%TYPE
2072: INDEX BY BINARY_INTEGER;
2073: TYPE t_acknowledgement_date IS TABLE OF
2074: IBY_PAY_INSTRUCTIONS_ALL.acknowledgement_date%TYPE
2075: INDEX BY BINARY_INTEGER;

Line 2074: IBY_PAY_INSTRUCTIONS_ALL.acknowledgement_date%TYPE

2070: TYPE t_transmission_date IS TABLE OF
2071: IBY_PAY_INSTRUCTIONS_ALL.transmission_date%TYPE
2072: INDEX BY BINARY_INTEGER;
2073: TYPE t_acknowledgement_date IS TABLE OF
2074: IBY_PAY_INSTRUCTIONS_ALL.acknowledgement_date%TYPE
2075: INDEX BY BINARY_INTEGER;
2076: TYPE t_comments IS TABLE OF
2077: IBY_PAY_INSTRUCTIONS_ALL.comments%TYPE
2078: INDEX BY BINARY_INTEGER;

Line 2077: IBY_PAY_INSTRUCTIONS_ALL.comments%TYPE

2073: TYPE t_acknowledgement_date IS TABLE OF
2074: IBY_PAY_INSTRUCTIONS_ALL.acknowledgement_date%TYPE
2075: INDEX BY BINARY_INTEGER;
2076: TYPE t_comments IS TABLE OF
2077: IBY_PAY_INSTRUCTIONS_ALL.comments%TYPE
2078: INDEX BY BINARY_INTEGER;
2079: TYPE t_bank_assigned_ref_code IS TABLE OF
2080: IBY_PAY_INSTRUCTIONS_ALL.bank_assigned_ref_code%TYPE
2081: INDEX BY BINARY_INTEGER;

Line 2080: IBY_PAY_INSTRUCTIONS_ALL.bank_assigned_ref_code%TYPE

2076: TYPE t_comments IS TABLE OF
2077: IBY_PAY_INSTRUCTIONS_ALL.comments%TYPE
2078: INDEX BY BINARY_INTEGER;
2079: TYPE t_bank_assigned_ref_code IS TABLE OF
2080: IBY_PAY_INSTRUCTIONS_ALL.bank_assigned_ref_code%TYPE
2081: INDEX BY BINARY_INTEGER;
2082: TYPE t_org_id IS TABLE OF
2083: IBY_PAY_INSTRUCTIONS_ALL.org_id%TYPE
2084: INDEX BY BINARY_INTEGER;

Line 2083: IBY_PAY_INSTRUCTIONS_ALL.org_id%TYPE

2079: TYPE t_bank_assigned_ref_code IS TABLE OF
2080: IBY_PAY_INSTRUCTIONS_ALL.bank_assigned_ref_code%TYPE
2081: INDEX BY BINARY_INTEGER;
2082: TYPE t_org_id IS TABLE OF
2083: IBY_PAY_INSTRUCTIONS_ALL.org_id%TYPE
2084: INDEX BY BINARY_INTEGER;
2085: TYPE t_org_type IS TABLE OF
2086: IBY_PAY_INSTRUCTIONS_ALL.org_type%TYPE
2087: INDEX BY BINARY_INTEGER;

Line 2086: IBY_PAY_INSTRUCTIONS_ALL.org_type%TYPE

2082: TYPE t_org_id IS TABLE OF
2083: IBY_PAY_INSTRUCTIONS_ALL.org_id%TYPE
2084: INDEX BY BINARY_INTEGER;
2085: TYPE t_org_type IS TABLE OF
2086: IBY_PAY_INSTRUCTIONS_ALL.org_type%TYPE
2087: INDEX BY BINARY_INTEGER;
2088: TYPE t_payment_date IS TABLE OF
2089: IBY_PAY_INSTRUCTIONS_ALL.payment_date%TYPE
2090: INDEX BY BINARY_INTEGER;

Line 2089: IBY_PAY_INSTRUCTIONS_ALL.payment_date%TYPE

2085: TYPE t_org_type IS TABLE OF
2086: IBY_PAY_INSTRUCTIONS_ALL.org_type%TYPE
2087: INDEX BY BINARY_INTEGER;
2088: TYPE t_payment_date IS TABLE OF
2089: IBY_PAY_INSTRUCTIONS_ALL.payment_date%TYPE
2090: INDEX BY BINARY_INTEGER;
2091: TYPE t_payment_currency_code IS TABLE OF
2092: IBY_PAY_INSTRUCTIONS_ALL.payment_currency_code%TYPE
2093: INDEX BY BINARY_INTEGER;

Line 2092: IBY_PAY_INSTRUCTIONS_ALL.payment_currency_code%TYPE

2088: TYPE t_payment_date IS TABLE OF
2089: IBY_PAY_INSTRUCTIONS_ALL.payment_date%TYPE
2090: INDEX BY BINARY_INTEGER;
2091: TYPE t_payment_currency_code IS TABLE OF
2092: IBY_PAY_INSTRUCTIONS_ALL.payment_currency_code%TYPE
2093: INDEX BY BINARY_INTEGER;
2094: TYPE t_payment_service_request_id IS TABLE OF
2095: IBY_PAY_INSTRUCTIONS_ALL.payment_service_request_id%TYPE
2096: INDEX BY BINARY_INTEGER;

Line 2095: IBY_PAY_INSTRUCTIONS_ALL.payment_service_request_id%TYPE

2091: TYPE t_payment_currency_code IS TABLE OF
2092: IBY_PAY_INSTRUCTIONS_ALL.payment_currency_code%TYPE
2093: INDEX BY BINARY_INTEGER;
2094: TYPE t_payment_service_request_id IS TABLE OF
2095: IBY_PAY_INSTRUCTIONS_ALL.payment_service_request_id%TYPE
2096: INDEX BY BINARY_INTEGER;
2097: TYPE t_payment_function IS TABLE OF
2098: IBY_PAY_INSTRUCTIONS_ALL.payment_function%TYPE
2099: INDEX BY BINARY_INTEGER;

Line 2098: IBY_PAY_INSTRUCTIONS_ALL.payment_function%TYPE

2094: TYPE t_payment_service_request_id IS TABLE OF
2095: IBY_PAY_INSTRUCTIONS_ALL.payment_service_request_id%TYPE
2096: INDEX BY BINARY_INTEGER;
2097: TYPE t_payment_function IS TABLE OF
2098: IBY_PAY_INSTRUCTIONS_ALL.payment_function%TYPE
2099: INDEX BY BINARY_INTEGER;
2100: TYPE t_payment_reason_code IS TABLE OF
2101: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_code%TYPE
2102: INDEX BY BINARY_INTEGER;

Line 2101: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_code%TYPE

2097: TYPE t_payment_function IS TABLE OF
2098: IBY_PAY_INSTRUCTIONS_ALL.payment_function%TYPE
2099: INDEX BY BINARY_INTEGER;
2100: TYPE t_payment_reason_code IS TABLE OF
2101: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_code%TYPE
2102: INDEX BY BINARY_INTEGER;
2103: TYPE t_rfc_identifier IS TABLE OF
2104: IBY_PAY_INSTRUCTIONS_ALL.rfc_identifier%TYPE
2105: INDEX BY BINARY_INTEGER;

Line 2104: IBY_PAY_INSTRUCTIONS_ALL.rfc_identifier%TYPE

2100: TYPE t_payment_reason_code IS TABLE OF
2101: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_code%TYPE
2102: INDEX BY BINARY_INTEGER;
2103: TYPE t_rfc_identifier IS TABLE OF
2104: IBY_PAY_INSTRUCTIONS_ALL.rfc_identifier%TYPE
2105: INDEX BY BINARY_INTEGER;
2106: TYPE t_pmt_method_code IS TABLE OF
2107: IBY_PAY_INSTRUCTIONS_ALL.payment_method_code%TYPE
2108: INDEX BY BINARY_INTEGER;

Line 2107: IBY_PAY_INSTRUCTIONS_ALL.payment_method_code%TYPE

2103: TYPE t_rfc_identifier IS TABLE OF
2104: IBY_PAY_INSTRUCTIONS_ALL.rfc_identifier%TYPE
2105: INDEX BY BINARY_INTEGER;
2106: TYPE t_pmt_method_code IS TABLE OF
2107: IBY_PAY_INSTRUCTIONS_ALL.payment_method_code%TYPE
2108: INDEX BY BINARY_INTEGER;
2109: TYPE t_payment_reason_comments IS TABLE OF
2110: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_comments%TYPE
2111: INDEX BY BINARY_INTEGER;

Line 2110: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_comments%TYPE

2106: TYPE t_pmt_method_code IS TABLE OF
2107: IBY_PAY_INSTRUCTIONS_ALL.payment_method_code%TYPE
2108: INDEX BY BINARY_INTEGER;
2109: TYPE t_payment_reason_comments IS TABLE OF
2110: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_comments%TYPE
2111: INDEX BY BINARY_INTEGER;
2112: TYPE t_payment_document_id IS TABLE OF
2113: IBY_PAY_INSTRUCTIONS_ALL.payment_document_id%TYPE
2114: INDEX BY BINARY_INTEGER;

Line 2113: IBY_PAY_INSTRUCTIONS_ALL.payment_document_id%TYPE

2109: TYPE t_payment_reason_comments IS TABLE OF
2110: IBY_PAY_INSTRUCTIONS_ALL.payment_reason_comments%TYPE
2111: INDEX BY BINARY_INTEGER;
2112: TYPE t_payment_document_id IS TABLE OF
2113: IBY_PAY_INSTRUCTIONS_ALL.payment_document_id%TYPE
2114: INDEX BY BINARY_INTEGER;
2115: TYPE t_printer_name IS TABLE OF
2116: IBY_PAY_INSTRUCTIONS_ALL.printer_name%TYPE
2117: INDEX BY BINARY_INTEGER;

Line 2116: IBY_PAY_INSTRUCTIONS_ALL.printer_name%TYPE

2112: TYPE t_payment_document_id IS TABLE OF
2113: IBY_PAY_INSTRUCTIONS_ALL.payment_document_id%TYPE
2114: INDEX BY BINARY_INTEGER;
2115: TYPE t_printer_name IS TABLE OF
2116: IBY_PAY_INSTRUCTIONS_ALL.printer_name%TYPE
2117: INDEX BY BINARY_INTEGER;
2118: TYPE t_attribute_category IS TABLE OF
2119: IBY_PAY_INSTRUCTIONS_ALL.attribute_category%TYPE
2120: INDEX BY BINARY_INTEGER;

Line 2119: IBY_PAY_INSTRUCTIONS_ALL.attribute_category%TYPE

2115: TYPE t_printer_name IS TABLE OF
2116: IBY_PAY_INSTRUCTIONS_ALL.printer_name%TYPE
2117: INDEX BY BINARY_INTEGER;
2118: TYPE t_attribute_category IS TABLE OF
2119: IBY_PAY_INSTRUCTIONS_ALL.attribute_category%TYPE
2120: INDEX BY BINARY_INTEGER;
2121: TYPE t_attribute1 IS TABLE OF
2122: IBY_PAY_INSTRUCTIONS_ALL.attribute1%TYPE
2123: INDEX BY BINARY_INTEGER;

Line 2122: IBY_PAY_INSTRUCTIONS_ALL.attribute1%TYPE

2118: TYPE t_attribute_category IS TABLE OF
2119: IBY_PAY_INSTRUCTIONS_ALL.attribute_category%TYPE
2120: INDEX BY BINARY_INTEGER;
2121: TYPE t_attribute1 IS TABLE OF
2122: IBY_PAY_INSTRUCTIONS_ALL.attribute1%TYPE
2123: INDEX BY BINARY_INTEGER;
2124: TYPE t_attribute2 IS TABLE OF
2125: IBY_PAY_INSTRUCTIONS_ALL.attribute2%TYPE
2126: INDEX BY BINARY_INTEGER;

Line 2125: IBY_PAY_INSTRUCTIONS_ALL.attribute2%TYPE

2121: TYPE t_attribute1 IS TABLE OF
2122: IBY_PAY_INSTRUCTIONS_ALL.attribute1%TYPE
2123: INDEX BY BINARY_INTEGER;
2124: TYPE t_attribute2 IS TABLE OF
2125: IBY_PAY_INSTRUCTIONS_ALL.attribute2%TYPE
2126: INDEX BY BINARY_INTEGER;
2127: TYPE t_attribute3 IS TABLE OF
2128: IBY_PAY_INSTRUCTIONS_ALL.attribute3%TYPE
2129: INDEX BY BINARY_INTEGER;

Line 2128: IBY_PAY_INSTRUCTIONS_ALL.attribute3%TYPE

2124: TYPE t_attribute2 IS TABLE OF
2125: IBY_PAY_INSTRUCTIONS_ALL.attribute2%TYPE
2126: INDEX BY BINARY_INTEGER;
2127: TYPE t_attribute3 IS TABLE OF
2128: IBY_PAY_INSTRUCTIONS_ALL.attribute3%TYPE
2129: INDEX BY BINARY_INTEGER;
2130: TYPE t_attribute4 IS TABLE OF
2131: IBY_PAY_INSTRUCTIONS_ALL.attribute4%TYPE
2132: INDEX BY BINARY_INTEGER;

Line 2131: IBY_PAY_INSTRUCTIONS_ALL.attribute4%TYPE

2127: TYPE t_attribute3 IS TABLE OF
2128: IBY_PAY_INSTRUCTIONS_ALL.attribute3%TYPE
2129: INDEX BY BINARY_INTEGER;
2130: TYPE t_attribute4 IS TABLE OF
2131: IBY_PAY_INSTRUCTIONS_ALL.attribute4%TYPE
2132: INDEX BY BINARY_INTEGER;
2133: TYPE t_attribute5 IS TABLE OF
2134: IBY_PAY_INSTRUCTIONS_ALL.attribute5%TYPE
2135: INDEX BY BINARY_INTEGER;

Line 2134: IBY_PAY_INSTRUCTIONS_ALL.attribute5%TYPE

2130: TYPE t_attribute4 IS TABLE OF
2131: IBY_PAY_INSTRUCTIONS_ALL.attribute4%TYPE
2132: INDEX BY BINARY_INTEGER;
2133: TYPE t_attribute5 IS TABLE OF
2134: IBY_PAY_INSTRUCTIONS_ALL.attribute5%TYPE
2135: INDEX BY BINARY_INTEGER;
2136: TYPE t_attribute6 IS TABLE OF
2137: IBY_PAY_INSTRUCTIONS_ALL.attribute6%TYPE
2138: INDEX BY BINARY_INTEGER;

Line 2137: IBY_PAY_INSTRUCTIONS_ALL.attribute6%TYPE

2133: TYPE t_attribute5 IS TABLE OF
2134: IBY_PAY_INSTRUCTIONS_ALL.attribute5%TYPE
2135: INDEX BY BINARY_INTEGER;
2136: TYPE t_attribute6 IS TABLE OF
2137: IBY_PAY_INSTRUCTIONS_ALL.attribute6%TYPE
2138: INDEX BY BINARY_INTEGER;
2139: TYPE t_attribute7 IS TABLE OF
2140: IBY_PAY_INSTRUCTIONS_ALL.attribute7%TYPE
2141: INDEX BY BINARY_INTEGER;

Line 2140: IBY_PAY_INSTRUCTIONS_ALL.attribute7%TYPE

2136: TYPE t_attribute6 IS TABLE OF
2137: IBY_PAY_INSTRUCTIONS_ALL.attribute6%TYPE
2138: INDEX BY BINARY_INTEGER;
2139: TYPE t_attribute7 IS TABLE OF
2140: IBY_PAY_INSTRUCTIONS_ALL.attribute7%TYPE
2141: INDEX BY BINARY_INTEGER;
2142: TYPE t_attribute8 IS TABLE OF
2143: IBY_PAY_INSTRUCTIONS_ALL.attribute8%TYPE
2144: INDEX BY BINARY_INTEGER;

Line 2143: IBY_PAY_INSTRUCTIONS_ALL.attribute8%TYPE

2139: TYPE t_attribute7 IS TABLE OF
2140: IBY_PAY_INSTRUCTIONS_ALL.attribute7%TYPE
2141: INDEX BY BINARY_INTEGER;
2142: TYPE t_attribute8 IS TABLE OF
2143: IBY_PAY_INSTRUCTIONS_ALL.attribute8%TYPE
2144: INDEX BY BINARY_INTEGER;
2145: TYPE t_attribute9 IS TABLE OF
2146: IBY_PAY_INSTRUCTIONS_ALL.attribute9%TYPE
2147: INDEX BY BINARY_INTEGER;

Line 2146: IBY_PAY_INSTRUCTIONS_ALL.attribute9%TYPE

2142: TYPE t_attribute8 IS TABLE OF
2143: IBY_PAY_INSTRUCTIONS_ALL.attribute8%TYPE
2144: INDEX BY BINARY_INTEGER;
2145: TYPE t_attribute9 IS TABLE OF
2146: IBY_PAY_INSTRUCTIONS_ALL.attribute9%TYPE
2147: INDEX BY BINARY_INTEGER;
2148: TYPE t_attribute10 IS TABLE OF
2149: IBY_PAY_INSTRUCTIONS_ALL.attribute10%TYPE
2150: INDEX BY BINARY_INTEGER;

Line 2149: IBY_PAY_INSTRUCTIONS_ALL.attribute10%TYPE

2145: TYPE t_attribute9 IS TABLE OF
2146: IBY_PAY_INSTRUCTIONS_ALL.attribute9%TYPE
2147: INDEX BY BINARY_INTEGER;
2148: TYPE t_attribute10 IS TABLE OF
2149: IBY_PAY_INSTRUCTIONS_ALL.attribute10%TYPE
2150: INDEX BY BINARY_INTEGER;
2151: TYPE t_attribute11 IS TABLE OF
2152: IBY_PAY_INSTRUCTIONS_ALL.attribute11%TYPE
2153: INDEX BY BINARY_INTEGER;

Line 2152: IBY_PAY_INSTRUCTIONS_ALL.attribute11%TYPE

2148: TYPE t_attribute10 IS TABLE OF
2149: IBY_PAY_INSTRUCTIONS_ALL.attribute10%TYPE
2150: INDEX BY BINARY_INTEGER;
2151: TYPE t_attribute11 IS TABLE OF
2152: IBY_PAY_INSTRUCTIONS_ALL.attribute11%TYPE
2153: INDEX BY BINARY_INTEGER;
2154: TYPE t_attribute12 IS TABLE OF
2155: IBY_PAY_INSTRUCTIONS_ALL.attribute12%TYPE
2156: INDEX BY BINARY_INTEGER;

Line 2155: IBY_PAY_INSTRUCTIONS_ALL.attribute12%TYPE

2151: TYPE t_attribute11 IS TABLE OF
2152: IBY_PAY_INSTRUCTIONS_ALL.attribute11%TYPE
2153: INDEX BY BINARY_INTEGER;
2154: TYPE t_attribute12 IS TABLE OF
2155: IBY_PAY_INSTRUCTIONS_ALL.attribute12%TYPE
2156: INDEX BY BINARY_INTEGER;
2157: TYPE t_attribute13 IS TABLE OF
2158: IBY_PAY_INSTRUCTIONS_ALL.attribute13%TYPE
2159: INDEX BY BINARY_INTEGER;

Line 2158: IBY_PAY_INSTRUCTIONS_ALL.attribute13%TYPE

2154: TYPE t_attribute12 IS TABLE OF
2155: IBY_PAY_INSTRUCTIONS_ALL.attribute12%TYPE
2156: INDEX BY BINARY_INTEGER;
2157: TYPE t_attribute13 IS TABLE OF
2158: IBY_PAY_INSTRUCTIONS_ALL.attribute13%TYPE
2159: INDEX BY BINARY_INTEGER;
2160: TYPE t_attribute14 IS TABLE OF
2161: IBY_PAY_INSTRUCTIONS_ALL.attribute14%TYPE
2162: INDEX BY BINARY_INTEGER;

Line 2161: IBY_PAY_INSTRUCTIONS_ALL.attribute14%TYPE

2157: TYPE t_attribute13 IS TABLE OF
2158: IBY_PAY_INSTRUCTIONS_ALL.attribute13%TYPE
2159: INDEX BY BINARY_INTEGER;
2160: TYPE t_attribute14 IS TABLE OF
2161: IBY_PAY_INSTRUCTIONS_ALL.attribute14%TYPE
2162: INDEX BY BINARY_INTEGER;
2163: TYPE t_attribute15 IS TABLE OF
2164: IBY_PAY_INSTRUCTIONS_ALL.attribute15%TYPE
2165: INDEX BY BINARY_INTEGER;

Line 2164: IBY_PAY_INSTRUCTIONS_ALL.attribute15%TYPE

2160: TYPE t_attribute14 IS TABLE OF
2161: IBY_PAY_INSTRUCTIONS_ALL.attribute14%TYPE
2162: INDEX BY BINARY_INTEGER;
2163: TYPE t_attribute15 IS TABLE OF
2164: IBY_PAY_INSTRUCTIONS_ALL.attribute15%TYPE
2165: INDEX BY BINARY_INTEGER;
2166:
2167: l_payment_instruction_id t_payment_instruction_id;
2168: l_payment_profile_id t_payment_profile_id;

Line 2230: || 'IBY_PAY_INSTRUCTIONS_ALL table.'

2226: /* Normally, this shouldn't happen */
2227: IF (p_payInstrTab.COUNT = 0) THEN
2228: print_debuginfo(l_module_name, 'After grouping, no payment '
2229: || 'instructions were found to update '
2230: || 'IBY_PAY_INSTRUCTIONS_ALL table.'
2231: || ' Possible data corruption issue.');
2232: RETURN;
2233: END IF;
2234:

Line 2350: INSERT INTO IBY_PAY_INSTRUCTIONS_ALL

2346: END LOOP;
2347:
2348:
2349: FORALL i in p_payInstrTab.FIRST..p_payInstrTab.LAST
2350: INSERT INTO IBY_PAY_INSTRUCTIONS_ALL
2351: (
2352: payment_instruction_id,
2353: payment_profile_id,
2354: process_type,

Line 2476: | table into IBY_PAY_INSTRUCTIONS_ALL table.

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

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

2504:
2505: /* Normally, this shouldn't happen */
2506: IF (p_payInstrTab.COUNT = 0) THEN
2507: print_debuginfo(l_module_name, 'No payment instructions'
2508: || ' were found to update IBY_PAY_INSTRUCTIONS_ALL table.');
2509: RETURN;
2510: END IF;
2511:
2512: FOR i in p_payInstrTab.FIRST..p_payInstrTab.LAST LOOP

Line 2515: IBY_PAY_INSTRUCTIONS_ALL

2511:
2512: FOR i in p_payInstrTab.FIRST..p_payInstrTab.LAST LOOP
2513:
2514: UPDATE
2515: IBY_PAY_INSTRUCTIONS_ALL
2516: SET
2517: payment_instruction_status =
2518: p_payInstrTab(i).payment_instruction_status,
2519: generate_sep_remit_advice_flag =

Line 2551: x_pmtInstrID IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL.

2547: | NOTES:
2548: |
2549: *---------------------------------------------------------------------*/
2550: PROCEDURE getNextPaymentInstructionID(
2551: x_pmtInstrID IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL.
2552: payment_instruction_id%TYPE
2553: )
2554: IS
2555:

Line 2559: IBY_PAY_INSTRUCTIONS_ALL_S.NEXTVAL

2555:
2556: BEGIN
2557:
2558: SELECT
2559: IBY_PAY_INSTRUCTIONS_ALL_S.NEXTVAL
2560: INTO
2561: x_pmtInstrID
2562: FROM
2563: DUAL

Line 2759: l_payment_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;

2755: where_clause VARCHAR(4000);
2756: order_clause VARCHAR(4000);
2757:
2758:
2759: l_payment_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
2760: l_grp_cntr NUMBER;
2761: l_logical_group_reference IBY_PAYMENTS_ALL.LOGICAL_GROUP_REFERENCE%TYPE;
2762: l_profileRec IBY_SYS_PMT_PROFILES_B%ROWTYPE;
2763:

Line 3156: * have already been written into the IBY_PAY_INSTRUCTIONS_ALL

3152:
3153: /*
3154: * All payment instructions for this run have been
3155: * created and stored in a PLSQL table. These instructions
3156: * have already been written into the IBY_PAY_INSTRUCTIONS_ALL
3157: * table just before validations. Now update these
3158: * payment instructions with any additional information.
3159: *
3160: * E.g., the payment instruction could have been failed because

Line 3244: CURSOR c_instr_val_sets(p_instr_id IBY_PAY_INSTRUCTIONS_ALL.

3240: *
3241: * For instructions, the validation level code has been changed
3242: * from 'INSTRUCTION' to 'DISBURSEMENT_INSTRUCTION'.
3243: */
3244: CURSOR c_instr_val_sets(p_instr_id IBY_PAY_INSTRUCTIONS_ALL.
3245: payment_instruction_id%TYPE)
3246: IS
3247: SELECT DISTINCT
3248: val_asgn.validation_assignment_id,

Line 3255: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,

3251: val.validation_code_entry_point
3252: FROM
3253: IBY_VALIDATION_SETS_VL val,
3254: IBY_VAL_ASSIGNMENTS val_asgn,
3255: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,
3256: IBY_PAYMENT_PROFILES prof,
3257: IBY_TRANSMIT_CONFIGS_VL txconf,
3258: IBY_TRANSMIT_PROTOCOLS_VL txproto,
3259: IBY_PAYMENTS_SEC_V pmt

Line 3357: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

3353: | NOTES:
3354: |
3355: *---------------------------------------------------------------------*/
3356: PROCEDURE reApplyPayInstrValidationSets(
3357: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
3358: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3359: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3360: )
3361: IS

Line 3373: CURSOR c_retry_instrvalsets(p_instr_id IBY_PAY_INSTRUCTIONS_ALL.

3369: /*
3370: * Pick up all validation sets applicable to a particular instruction
3371: * that have not overridden by the payment administrator.
3372: */
3373: CURSOR c_retry_instrvalsets(p_instr_id IBY_PAY_INSTRUCTIONS_ALL.
3374: payment_instruction_id%TYPE)
3375: IS
3376: SELECT DISTINCT
3377: val_asgn.validation_assignment_id,

Line 3384: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,

3380: val.validation_code_entry_point
3381: FROM
3382: IBY_VALIDATION_SETS_VL val,
3383: IBY_VAL_ASSIGNMENTS val_asgn,
3384: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,
3385: IBY_PAYMENT_PROFILES prof,
3386: IBY_TRANSMIT_CONFIGS_VL txconf,
3387: IBY_TRANSMIT_PROTOCOLS_VL txproto,
3388: IBY_TRANSACTION_ERRORS txerrors

Line 3575: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

3571: | NOTES:
3572: |
3573: *---------------------------------------------------------------------*/
3574: PROCEDURE executeValidationsForInstr(
3575: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
3576: p_valSetsTab IN instructionValSetsTab,
3577: p_isReval IN BOOLEAN,
3578: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3579: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

Line 3957: || 'FROM IBY_PAY_INSTRUCTIONS_ALL '

3953: * XML output.
3954: */
3955:
3956: l_sql := 'SELECT payment_instruction_id '
3957: || 'FROM IBY_PAY_INSTRUCTIONS_ALL '
3958: || 'WHERE payment_instruction_id = :p_ins_id '
3959: || 'AND payment_instruction_status <> :p_ins_status';
3960:
3961: l_ctx := DBMS_XMLQuery.newContext(l_sql);

Line 4594: l_le_id IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE;

4590:
4591: l_ret_val BOOLEAN := FALSE;
4592: l_ledger_list GL_MC_INFO.ledger_tbl_type := GL_MC_INFO.ledger_tbl_type();
4593: l_ledger_id NUMBER(15);
4594: l_le_id IBY_PAY_INSTRUCTIONS_ALL.legal_entity_id%TYPE;
4595:
4596: l_module_name VARCHAR2(200) := G_PKG_NAME || '.getLedgerIdFromLEId';
4597:
4598: BEGIN

Line 4957: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE

4953: *---------------------------------------------------------------------*/
4954: FUNCTION getSortOptionsForProfile(
4955: p_sortOptionsTab IN sortOptionsTabType,
4956: p_profileMap IN IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType,
4957: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE
4958: )
4959: RETURN sortOptionsRecType
4960:
4961: IS

Line 5601: p_pmtInstrId IN IBY_PAY_INSTRUCTIONS_ALL.

5597: | NOTES:
5598: |
5599: *---------------------------------------------------------------------*/
5600: PROCEDURE setRemitFlagForPmtInstruction(
5601: p_pmtInstrId IN IBY_PAY_INSTRUCTIONS_ALL.
5602: payment_instruction_id%TYPE,
5603: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType
5604: )
5605: IS

Line 5842: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id

5838: | NOTES:
5839: |
5840: *---------------------------------------------------------------------*/
5841: PROCEDURE deriveDistinctAccessTypsForIns(
5842: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id
5843: %TYPE,
5844: p_pmt_function IN IBY_PAYMENTS_ALL.payment_function%TYPE,
5845: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
5846: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,

Line 6099: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE

6095: | NOTES:
6096: |
6097: *---------------------------------------------------------------------*/
6098: FUNCTION checkIfDocSeqCompleted(
6099: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE
6100: )
6101: RETURN BOOLEAN
6102: IS
6103:

Line 6196: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE

6192: | NOTES:
6193: |
6194: *---------------------------------------------------------------------*/
6195: FUNCTION checkIfPmtRefCompleted(
6196: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE
6197: )
6198: RETURN BOOLEAN
6199: IS
6200:

Line 6272: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

6268: | NOTES:
6269: |
6270: *---------------------------------------------------------------------*/
6271: PROCEDURE getSortedPmtsForInstr(
6272: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
6273: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE,
6274: p_sortOptionsTab IN sortOptionsTabType,
6275: p_profileMap IN IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType,
6276: x_sortedPmtTab IN OUT NOCOPY sortedPmtTabType

Line 6273: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE,

6269: |
6270: *---------------------------------------------------------------------*/
6271: PROCEDURE getSortedPmtsForInstr(
6272: p_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
6273: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE,
6274: p_sortOptionsTab IN sortOptionsTabType,
6275: p_profileMap IN IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType,
6276: x_sortedPmtTab IN OUT NOCOPY sortedPmtTabType
6277: )

Line 6360: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '

6356: || 'FROM '
6357: || 'IBY_PAYMENTS_ALL pmt, '
6358: || 'IBY_PAY_SERVICE_REQUESTS req, '
6359: || 'IBY_PAYMENT_METHODS_VL pmt_mthds, '
6360: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '
6361: || 'HZ_PARTIES payee, '
6362: || 'HZ_LOCATIONS payee_location, '
6363: || 'IBY_EXT_BANK_ACCOUNTS payee_bank ' -- Bug 5872977
6364: || 'WHERE '

Line 6399: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '

6395: || 'FROM '
6396: || 'IBY_PAYMENTS_ALL pmt, '
6397: || 'IBY_PAY_SERVICE_REQUESTS req, '
6398: || 'IBY_PAYMENT_METHODS_VL pmt_mthds, '
6399: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '
6400: || 'HZ_PARTIES payee '
6401: || 'WHERE '
6402: || ' pmt.payment_instruction_id = :instr_id '
6403: || 'AND pmt.payment_status = :pmt_status '

Line 6595: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)

6591: | NOTES:
6592: |
6593: *---------------------------------------------------------------------*/
6594: FUNCTION get_instruction_profile (
6595: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
6596: RETURN NUMBER
6597: IS
6598:
6599: l_pmt_instr_profile IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;

Line 6599: l_pmt_instr_profile IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;

6595: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
6596: RETURN NUMBER
6597: IS
6598:
6599: l_pmt_instr_profile IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE;
6600: l_module_name VARCHAR2(200) := G_PKG_NAME || '.get_instruction_profile';
6601:
6602: BEGIN
6603:

Line 6609: IBY_PAY_INSTRUCTIONS_ALL

6605: payment_profile_id
6606: INTO
6607: l_pmt_instr_profile
6608: FROM
6609: IBY_PAY_INSTRUCTIONS_ALL
6610: WHERE
6611: payment_instruction_id = l_pmt_instr_id
6612: ;
6613:

Line 6657: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE,

6653: | NOTES:
6654: |
6655: *---------------------------------------------------------------------*/
6656: PROCEDURE retrieveSortOptionForProfile(
6657: p_profile_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_profile_id%TYPE,
6658: x_sortOptionsTab IN OUT NOCOPY sortOptionsTabType
6659: )
6660: IS
6661:

Line 6739: l_process_type IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE;

6735: )
6736: IS
6737:
6738: l_module_name VARCHAR2(200) := G_PKG_NAME || '.initializeInstrs';
6739: l_process_type IBY_PAY_INSTRUCTIONS_ALL.process_type%TYPE;
6740: l_multi_pi_flag BOOLEAN := FALSE;
6741: l_instr_seq_num VARCHAR2(200);
6742:
6743: BEGIN