APPS.IBY_CHECKNUMBER_PUB dependencies on IBY_DOCS_PAYABLE_ALL

Line 7: -- inserted into IBY_DOCS_PAYABLE_ALL table and linked to

3:
4: --
5: -- For check payments, we have to keep track of setup and
6: -- overflow documents. These are dummy documents that are
7: -- inserted into IBY_DOCS_PAYABLE_ALL table and linked to
8: -- a particular payment.
9: --
10: -- This data structure holds all payments that have processing
11: -- type set to 'PAPER' - i.e., payment payments.

Line 87: -- insert dummy documents payable into IBY_DOCS_PAYABLE_ALL

83: INDEX BY BINARY_INTEGER;
84:
85: --
86: -- PLSQL table of documents payable. This table is used to
87: -- insert dummy documents payable into IBY_DOCS_PAYABLE_ALL
88: -- (for handling setup and overflow documents).
89: --
90: TYPE docsTabType IS TABLE OF iby_docs_payable_all%ROWTYPE
91: INDEX BY BINARY_INTEGER;

Line 90: TYPE docsTabType IS TABLE OF iby_docs_payable_all%ROWTYPE

86: -- PLSQL table of documents payable. This table is used to
87: -- insert dummy documents payable into IBY_DOCS_PAYABLE_ALL
88: -- (for handling setup and overflow documents).
89: --
90: TYPE docsTabType IS TABLE OF iby_docs_payable_all%ROWTYPE
91: INDEX BY BINARY_INTEGER;
92:
93: --
94: -- Record that holds the formatting_payment_id for a particular

Line 102: doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

98: -- will be different from the payment_id, otherwise, both these
99: -- will be the same for a particular document.
100: --
101: TYPE overflowDocsRecType IS RECORD (
102: doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
103: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
104: pmt_currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
105: pmt_function IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
106: format_payment_id IBY_DOCS_PAYABLE_ALL.formatting_payment_id%TYPE,

Line 103: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,

99: -- will be the same for a particular document.
100: --
101: TYPE overflowDocsRecType IS RECORD (
102: doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
103: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
104: pmt_currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
105: pmt_function IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
106: format_payment_id IBY_DOCS_PAYABLE_ALL.formatting_payment_id%TYPE,
107: org_id IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

Line 104: pmt_currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

100: --
101: TYPE overflowDocsRecType IS RECORD (
102: doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
103: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
104: pmt_currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
105: pmt_function IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
106: format_payment_id IBY_DOCS_PAYABLE_ALL.formatting_payment_id%TYPE,
107: org_id IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
108: org_type IBY_DOCS_PAYABLE_ALL.org_type%TYPE

Line 105: pmt_function IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,

101: TYPE overflowDocsRecType IS RECORD (
102: doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
103: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
104: pmt_currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
105: pmt_function IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
106: format_payment_id IBY_DOCS_PAYABLE_ALL.formatting_payment_id%TYPE,
107: org_id IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
108: org_type IBY_DOCS_PAYABLE_ALL.org_type%TYPE
109: );

Line 106: format_payment_id IBY_DOCS_PAYABLE_ALL.formatting_payment_id%TYPE,

102: doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
103: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
104: pmt_currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
105: pmt_function IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
106: format_payment_id IBY_DOCS_PAYABLE_ALL.formatting_payment_id%TYPE,
107: org_id IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
108: org_type IBY_DOCS_PAYABLE_ALL.org_type%TYPE
109: );
110:

Line 107: org_id IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

103: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
104: pmt_currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
105: pmt_function IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
106: format_payment_id IBY_DOCS_PAYABLE_ALL.formatting_payment_id%TYPE,
107: org_id IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
108: org_type IBY_DOCS_PAYABLE_ALL.org_type%TYPE
109: );
110:
111: --

Line 108: org_type IBY_DOCS_PAYABLE_ALL.org_type%TYPE

104: pmt_currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
105: pmt_function IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
106: format_payment_id IBY_DOCS_PAYABLE_ALL.formatting_payment_id%TYPE,
107: org_id IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
108: org_type IBY_DOCS_PAYABLE_ALL.org_type%TYPE
109: );
110:
111: --
112: -- Table of overflow doc recs.