APPS.IBY_TRXN_DOCUMENTS_PKG dependencies on IBY_TRXN_DOCUMENTS

Line 1: PACKAGE IBY_TRXN_DOCUMENTS_PKG AUTHID CURRENT_USER AS

1: PACKAGE IBY_TRXN_DOCUMENTS_PKG AUTHID CURRENT_USER AS
2: /* $Header: ibytxdcs.pls 120.4 2005/10/30 05:51:11 appldev noship $ */
3:
4:
5: /* FetchDocument constant indicating doc is being accessed read-only. */

Line 48: doctype_in IN iby_trxn_documents.doctype%TYPE

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: /*
52: * USE: Add an empty document based on the master trxn id of a trxn

Line 64: doctype_in IN iby_trxn_documents.doctype%TYPE,

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:
68:

Line 65: docid_out OUT NOCOPY iby_trxn_documents.trxn_document_id%TYPE

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:
68:
69: /*

Line 83: doctype_in IN iby_trxn_documents.doctype%TYPE,

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:
87: /*

Line 84: docid_out OUT NOCOPY iby_trxn_documents.trxn_document_id%TYPE

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:
87: /*
88: * USE: Add an empty document based on (transaction id, trxntype, status).

Line 101: doctype_in IN iby_trxn_documents.doctype%TYPE

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: /*
105: * Retro-fit IBY_TRXN_DOCUMENTS for storing R12 FD extract -

Line 105: * Retro-fit IBY_TRXN_DOCUMENTS for storing R12 FD extract -

101: doctype_in IN iby_trxn_documents.doctype%TYPE
102: );
103:
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.

Line 117: docid_out OUT NOCOPY iby_trxn_documents.trxn_document_id%TYPE

113: (
114: p_payment_instruction_id IN NUMBER,
115: p_doctype IN NUMBER,
116: p_doc IN CLOB,
117: docid_out OUT NOCOPY iby_trxn_documents.trxn_document_id%TYPE
118: );
119:
120: /*
121: * USE: Delete a document based on the master trxn id of a trxn.

Line 130: doctype_in IN iby_trxn_documents.doctype%TYPE

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: /*
134: * USE: Delete a document based on based on (transaction id, trxntype, status)

Line 147: doctype_in IN iby_trxn_documents.doctype%TYPE

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: /*
151: * USE: Fetch a document based on (trxnmid, doctype).

Line 166: doctype_in IN iby_trxn_documents.doctype%TYPE,

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: );
170:

Line 168: document_out OUT NOCOPY iby_trxn_documents.document%TYPE

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: );
170:
171: /*
172: * USE: Over-loaded version of the above fetch method.

Line 191: doctype_in IN iby_trxn_documents.doctype%TYPE,

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: );
195:

Line 193: document_out OUT NOCOPY iby_trxn_documents.document%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: );
195:
196: /*
197: * USE: Fetch a document based on (payment_instruction_id, doctype)

Line 216: document_out OUT NOCOPY iby_trxn_documents.document%TYPE

212: (
213: p_payment_instruction_id IN NUMBER,
214: p_doctype IN NUMBER,
215: read_only_in IN INTEGER DEFAULT C_FETCH_READONLY,
216: document_out OUT NOCOPY iby_trxn_documents.document%TYPE
217: );
218:
219: END IBY_TRXN_DOCUMENTS_PKG;
220:

Line 219: END IBY_TRXN_DOCUMENTS_PKG;

215: read_only_in IN INTEGER DEFAULT C_FETCH_READONLY,
216: document_out OUT NOCOPY iby_trxn_documents.document%TYPE
217: );
218:
219: END IBY_TRXN_DOCUMENTS_PKG;
220: