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: );
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:
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: /*--------------*/
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
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: /*--------------*/
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:
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: /*
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: /*
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:
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:
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: );
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:
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: /*
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
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: /*
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: );
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:
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: /*
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: );
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,
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
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: );