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_TRXN_DOCUMENTS_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 10: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,

6:
7: /* Gets the trxnmid based on (transaction id,trxntype id,status) */
8: PROCEDURE getTrxnMID
9: (
10: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
11: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
12: status_in IN iby_trxn_summaries_all.status%TYPE,
13: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
14: )

Line 11: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

7: /* Gets the trxnmid based on (transaction id,trxntype id,status) */
8: PROCEDURE getTrxnMID
9: (
10: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
11: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
12: status_in IN iby_trxn_summaries_all.status%TYPE,
13: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
14: )
15: IS

Line 12: status_in IN iby_trxn_summaries_all.status%TYPE,

8: PROCEDURE getTrxnMID
9: (
10: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
11: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
12: status_in IN iby_trxn_summaries_all.status%TYPE,
13: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
14: )
15: IS
16: CURSOR c_trxnmid

Line 13: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE

9: (
10: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
11: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
12: status_in IN iby_trxn_summaries_all.status%TYPE,
13: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
14: )
15: IS
16: CURSOR c_trxnmid
17: (

Line 18: ci_transactionid iby_trxn_summaries_all.transactionid%TYPE,

14: )
15: IS
16: CURSOR c_trxnmid
17: (
18: ci_transactionid iby_trxn_summaries_all.transactionid%TYPE,
19: ci_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE,
20: ci_status iby_trxn_summaries_all.status%TYPE
21: )
22: IS

Line 19: ci_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE,

15: IS
16: CURSOR c_trxnmid
17: (
18: ci_transactionid iby_trxn_summaries_all.transactionid%TYPE,
19: ci_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE,
20: ci_status iby_trxn_summaries_all.status%TYPE
21: )
22: IS
23: SELECT trxnmid INTO trxnmid_out

Line 20: ci_status iby_trxn_summaries_all.status%TYPE

16: CURSOR c_trxnmid
17: (
18: ci_transactionid iby_trxn_summaries_all.transactionid%TYPE,
19: ci_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE,
20: ci_status iby_trxn_summaries_all.status%TYPE
21: )
22: IS
23: SELECT trxnmid INTO trxnmid_out
24: FROM iby_trxn_summaries_all

Line 24: FROM iby_trxn_summaries_all

20: ci_status iby_trxn_summaries_all.status%TYPE
21: )
22: IS
23: SELECT trxnmid INTO trxnmid_out
24: FROM iby_trxn_summaries_all
25: WHERE (transactionid=ci_transactionid)
26: AND (status=ci_status)
27: AND ((trxntypeid=NVL(ci_trxntypeid,trxntypeid)) OR (trxntypeid is NULL))
28: ORDER BY creation_date DESC;

Line 53: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,

49: /*------*/
50: /* Gets the trxnmid based on (transaction id,trxntype id) */
51: PROCEDURE getTrxnMIDFinancing
52: (
53: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
54: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
55: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
56: )
57: IS

Line 54: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

50: /* Gets the trxnmid based on (transaction id,trxntype id) */
51: PROCEDURE getTrxnMIDFinancing
52: (
53: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
54: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
55: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
56: )
57: IS
58: BEGIN

Line 55: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE

51: PROCEDURE getTrxnMIDFinancing
52: (
53: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
54: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
55: trxnmid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
56: )
57: IS
58: BEGIN
59:

Line 61: FROM iby_trxn_summaries_all

57: IS
58: BEGIN
59:
60: SELECT trxnmid INTO trxnmid_out
61: FROM iby_trxn_summaries_all
62: WHERE (transactionid=transactionid_in) AND (trxntypeid=trxntypeid_in);
63:
64: EXCEPTION
65:

Line 79: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

75:
76: /* Add an empty document based on the master trxn id of a trxn. */
77: PROCEDURE CreateDocument
78: (
79: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
80: doctype_in IN iby_trxn_documents.doctype%TYPE
81: )
82: IS
83:

Line 97: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

93: * transaction and return the generated document id.
94: */
95: PROCEDURE CreateDocument
96: (
97: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
98: doctype_in IN iby_trxn_documents.doctype%TYPE,
99: docid_out OUT NOCOPY iby_trxn_documents.trxn_document_id%TYPE
100: )
101: IS

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

121: /*
122: * Retro-fit IBY_TRXN_DOCUMENTS for storing R12 FD extract -
123: * doctype is 100.
124: * TRXNMID is made nullable
125: * the doc will be associated with either IBY_TRXN_SUMMARIES_ALL
126: * or IBY_PAY_INSTRUCTIONS_ALL depending on the doctype.
127: * FZ 3/14/05
128: */
129: PROCEDURE CreateDocument

Line 173: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

169: * Used in online financing.
170: */
171: PROCEDURE CreateOrUpdateDocument
172: (
173: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
174: doctype_in IN iby_trxn_documents.doctype%TYPE,
175: docid_out OUT NOCOPY iby_trxn_documents.trxn_document_id%TYPE
176: )
177:

Line 182: cursor c_doc(ci_trxnmid in iby_trxn_summaries_all.trxnmid%type,

178: IS
179:
180: l_docid iby_trxn_documents.trxn_document_id%TYPE;
181:
182: cursor c_doc(ci_trxnmid in iby_trxn_summaries_all.trxnmid%type,
183: ci_doctype in iby_trxn_documents.doctype%type)
184: is
185: SELECT trxn_document_id
186: FROM iby_trxn_documents

Line 228: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,

224:
225: /* Add an empty document based on (transaction id, trxntype, status) */
226: PROCEDURE CreateDocument
227: (
228: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
229: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
230: status_in IN iby_trxn_summaries_all.status%TYPE,
231: doctype_in IN iby_trxn_documents.doctype%TYPE
232: )

Line 229: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

225: /* Add an empty document based on (transaction id, trxntype, status) */
226: PROCEDURE CreateDocument
227: (
228: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
229: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
230: status_in IN iby_trxn_summaries_all.status%TYPE,
231: doctype_in IN iby_trxn_documents.doctype%TYPE
232: )
233: IS

Line 230: status_in IN iby_trxn_summaries_all.status%TYPE,

226: PROCEDURE CreateDocument
227: (
228: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
229: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
230: status_in IN iby_trxn_summaries_all.status%TYPE,
231: doctype_in IN iby_trxn_documents.doctype%TYPE
232: )
233: IS
234: l_mtrxnid iby_trxn_summaries_all.trxnmid%TYPE;

Line 234: l_mtrxnid iby_trxn_summaries_all.trxnmid%TYPE;

230: status_in IN iby_trxn_summaries_all.status%TYPE,
231: doctype_in IN iby_trxn_documents.doctype%TYPE
232: )
233: IS
234: l_mtrxnid iby_trxn_summaries_all.trxnmid%TYPE;
235: BEGIN
236: getTrxnMID(transactionid_in, trxntypeid_in, status_in,l_mtrxnid);
237: CreateDocument(l_mtrxnid,doctype_in);
238: END CreateDocument;

Line 244: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

240:
241: /* Delete a document based on the master trxn id of a trxn. */
242: PROCEDURE DeleteDocument
243: (
244: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
245: doctype_in IN iby_trxn_documents.doctype%TYPE
246: )
247: IS
248: BEGIN

Line 257: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,

253:
254: /* Add a document based on (transaction id, trxntype, status) */
255: PROCEDURE DeleteDocument
256: (
257: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
258: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
259: status_in IN iby_trxn_summaries_all.status%TYPE,
260: doctype_in IN iby_trxn_documents.doctype%TYPE
261: )

Line 258: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

254: /* Add a document based on (transaction id, trxntype, status) */
255: PROCEDURE DeleteDocument
256: (
257: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
258: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
259: status_in IN iby_trxn_summaries_all.status%TYPE,
260: doctype_in IN iby_trxn_documents.doctype%TYPE
261: )
262: IS

Line 259: status_in IN iby_trxn_summaries_all.status%TYPE,

255: PROCEDURE DeleteDocument
256: (
257: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
258: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
259: status_in IN iby_trxn_summaries_all.status%TYPE,
260: doctype_in IN iby_trxn_documents.doctype%TYPE
261: )
262: IS
263: l_mtrxnid iby_trxn_summaries_all.trxnmid%TYPE;

Line 263: l_mtrxnid iby_trxn_summaries_all.trxnmid%TYPE;

259: status_in IN iby_trxn_summaries_all.status%TYPE,
260: doctype_in IN iby_trxn_documents.doctype%TYPE
261: )
262: IS
263: l_mtrxnid iby_trxn_summaries_all.trxnmid%TYPE;
264: BEGIN
265: getTrxnMID(transactionid_in,trxntypeid_in,status_in,l_mtrxnid);
266: DeleteDocument(l_mtrxnid,doctype_in);
267: END DeleteDocument;

Line 273: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,

269:
270: /* Fetches a document based on (transaction id,trxn type id,status,doctype) */
271: PROCEDURE FetchDocument
272: (
273: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
274: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
275: status_in IN iby_trxn_summaries_all.status%TYPE,
276: doctype_in IN iby_trxn_documents.doctype%TYPE,
277: read_only_in IN INTEGER,

Line 274: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

270: /* Fetches a document based on (transaction id,trxn type id,status,doctype) */
271: PROCEDURE FetchDocument
272: (
273: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
274: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
275: status_in IN iby_trxn_summaries_all.status%TYPE,
276: doctype_in IN iby_trxn_documents.doctype%TYPE,
277: read_only_in IN INTEGER,
278: document_out OUT NOCOPY iby_trxn_documents.document%TYPE

Line 275: status_in IN iby_trxn_summaries_all.status%TYPE,

271: PROCEDURE FetchDocument
272: (
273: transactionid_in IN iby_trxn_summaries_all.transactionid%TYPE,
274: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
275: status_in IN iby_trxn_summaries_all.status%TYPE,
276: doctype_in IN iby_trxn_documents.doctype%TYPE,
277: read_only_in IN INTEGER,
278: document_out OUT NOCOPY iby_trxn_documents.document%TYPE
279: )

Line 281: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;

277: read_only_in IN INTEGER,
278: document_out OUT NOCOPY iby_trxn_documents.document%TYPE
279: )
280: IS
281: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;
282: BEGIN
283: getTrxnMID(transactionid_in,trxntypeid_in,status_in,l_trxnmid);
284: FetchDocument(l_trxnmid,doctype_in,read_only_in,document_out);
285: END FetchDocument;

Line 291: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

287:
288: /* Fetch a document based on (trxnmid,doctype) */
289: PROCEDURE FetchDocument
290: (
291: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
292: doctype_in IN iby_trxn_documents.doctype%TYPE,
293: read_only_in IN INTEGER,
294: document_out OUT NOCOPY iby_trxn_documents.document%TYPE
295: )