DBA Data[Home] [Help]

APPS.IBY_TRXN_DOCUMENTS_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 23: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,

19: * 4. the trxnmid (master id) of the given trxn
20: */
21: PROCEDURE getTrxnMID
22: (
23: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
24: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
25: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
26: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
27: );

Line 24: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

20: */
21: PROCEDURE getTrxnMID
22: (
23: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
24: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
25: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
26: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
27: );
28:

Line 25: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,

21: PROCEDURE getTrxnMID
22: (
23: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
24: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
25: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
26: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
27: );
28:
29: /*--------------*/

Line 26: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE

22: (
23: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
24: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
25: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
26: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
27: );
28:
29: /*--------------*/
30: PROCEDURE getTrxnMIDFinancing

Line 32: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,

28:
29: /*--------------*/
30: PROCEDURE getTrxnMIDFinancing
31: (
32: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
33: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
34: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
35: );
36: /*--------------*/

Line 33: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

29: /*--------------*/
30: PROCEDURE getTrxnMIDFinancing
31: (
32: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
33: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
34: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
35: );
36: /*--------------*/
37:

Line 34: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE

30: PROCEDURE getTrxnMIDFinancing
31: (
32: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
33: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
34: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
35: );
36: /*--------------*/
37:
38: /*

Line 47: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

43: * 2. application-defined document type of the doc to create
44: */
45: PROCEDURE CreateDocument
46: (
47: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
48: doctype_in IN iby_trxn_documents.doctype%TYPE
49: );
50:
51: /*

Line 63: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

59: * 3. the document id (primary key to the table).
60: */
61: PROCEDURE CreateDocument
62: (
63: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
64: doctype_in IN iby_trxn_documents.doctype%TYPE,
65: docid_out OUT NOCOPY iby_trxn_documents.trxn_document_id%TYPE
66: );
67:

Line 82: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

78: * 3. the document id (primary key to the table).
79: */
80: PROCEDURE CreateOrUpdateDocument
81: (
82: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
83: doctype_in IN iby_trxn_documents.doctype%TYPE,
84: docid_out OUT NOCOPY iby_trxn_documents.trxn_document_id%TYPE
85: );
86:

Line 98: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,

94: * 4. application-defined document type of the doc to create
95: */
96: PROCEDURE CreateDocument
97: (
98: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
99: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
100: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
101: doctype_in IN iby_trxn_documents.doctype%TYPE
102: );

Line 99: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

95: */
96: PROCEDURE CreateDocument
97: (
98: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
99: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
100: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
101: doctype_in IN iby_trxn_documents.doctype%TYPE
102: );
103:

Line 100: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,

96: PROCEDURE CreateDocument
97: (
98: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
99: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
100: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
101: doctype_in IN iby_trxn_documents.doctype%TYPE
102: );
103:
104: /*

Line 108: * the doc will be associated with either IBY_TRXN_SUMMARIES_ALL

104: /*
105: * Retro-fit IBY_TRXN_DOCUMENTS for storing R12 FD extract -
106: * doctype is 100.
107: * TRXNMID is made nullable
108: * the doc will be associated with either IBY_TRXN_SUMMARIES_ALL
109: * or IBY_PAY_INSTRUCTIONS_ALL depending on the doctype.
110: * FZ 3/14/05
111: */
112: PROCEDURE CreateDocument

Line 129: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

125: * 2. application-defined document type of the doc to delete
126: */
127: PROCEDURE DeleteDocument
128: (
129: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
130: doctype_in IN iby_trxn_documents.doctype%TYPE
131: );
132:
133: /*

Line 144: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,

140: * 4. application-defined document type of the doc to delete
141: */
142: PROCEDURE DeleteDocument
143: (
144: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
145: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
146: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
147: doctype_in IN iby_trxn_documents.doctype%TYPE
148: );

Line 145: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

141: */
142: PROCEDURE DeleteDocument
143: (
144: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
145: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
146: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
147: doctype_in IN iby_trxn_documents.doctype%TYPE
148: );
149:

Line 146: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,

142: PROCEDURE DeleteDocument
143: (
144: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
145: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
146: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
147: doctype_in IN iby_trxn_documents.doctype%TYPE
148: );
149:
150: /*

Line 165: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

161: * 4. the document, which can be written to/appended.
162: */
163: PROCEDURE FetchDocument
164: (
165: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
166: doctype_in IN iby_trxn_documents.doctype%TYPE,
167: read_only_in IN INTEGER DEFAULT C_FETCH_READONLY,
168: document_out OUT NOCOPY iby_trxn_documents.document%TYPE
169: );

Line 188: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,

184: * 6. the document, which can be written to/appended.
185: */
186: PROCEDURE FetchDocument
187: (
188: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
189: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
190: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
191: doctype_in IN iby_trxn_documents.doctype%TYPE,
192: read_only_in IN INTEGER DEFAULT C_FETCH_READONLY,

Line 189: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

185: */
186: PROCEDURE FetchDocument
187: (
188: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
189: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
190: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
191: doctype_in IN iby_trxn_documents.doctype%TYPE,
192: read_only_in IN INTEGER DEFAULT C_FETCH_READONLY,
193: document_out OUT NOCOPY iby_trxn_documents.document%TYPE

Line 190: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,

186: PROCEDURE FetchDocument
187: (
188: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
189: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
190: status_in IN iby_trxn_summaries_all.status%TYPE DEFAULT 0,
191: doctype_in IN iby_trxn_documents.doctype%TYPE,
192: read_only_in IN INTEGER DEFAULT C_FETCH_READONLY,
193: document_out OUT NOCOPY iby_trxn_documents.document%TYPE
194: );