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

Line 12: p_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,

8: -- of DocumentReceivable and DocumentReceivableCount
9: --
10: FUNCTION get_document_receivable
11: (
12: p_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
13: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
14: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
15: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE
16: )

Line 13: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,

9: --
10: FUNCTION get_document_receivable
11: (
12: p_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
13: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
14: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
15: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE
16: )
17: RETURN XMLType

Line 15: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE

11: (
12: p_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
13: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
14: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
15: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE
16: )
17: RETURN XMLType
18: IS
19:

Line 39: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,

35: -- Bug # 8301765
36: -- Added input parameter p_source_view : Name of the invoking view name.
37: FUNCTION get_document_receivable
38: (
39: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,
40: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
41: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
42: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE,
43: p_source_view IN VARCHAR2

Line 40: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,

36: -- Added input parameter p_source_view : Name of the invoking view name.
37: FUNCTION get_document_receivable
38: (
39: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,
40: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
41: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
42: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE,
43: p_source_view IN VARCHAR2
44: )

Line 42: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE,

38: (
39: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,
40: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
41: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
42: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE,
43: p_source_view IN VARCHAR2
44: )
45: RETURN XMLType
46: IS

Line 57: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE,

53: with global temporary tables iby_ar_doc_header_gt and iby_ar_doc_lines_gt.
54: Data will be inserted into GTs before extract view call
55: */
56: CURSOR l_doc_rec_csr
57: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE,
58: c_card_data_level iby_trxn_core.card_data_level%TYPE) IS
59: /*
60: SELECT
61: XMLConcat(XMLAgg(document_headers),

Line 237: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,

233: -- Added input parameter p_process_profile : process profile code of the transaction.
234:
235: FUNCTION get_document_receivable
236: (
237: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,
238: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
239: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
240: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE,
241: p_process_profile IN iby_trxn_summaries_all.process_profile_code%TYPE,

Line 238: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,

234:
235: FUNCTION get_document_receivable
236: (
237: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,
238: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
239: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
240: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE,
241: p_process_profile IN iby_trxn_summaries_all.process_profile_code%TYPE,
242: p_source_view IN VARCHAR2

Line 240: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE,

236: (
237: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,
238: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
239: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
240: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE,
241: p_process_profile IN iby_trxn_summaries_all.process_profile_code%TYPE,
242: p_source_view IN VARCHAR2
243: )
244: RETURN XMLType

Line 241: p_process_profile IN iby_trxn_summaries_all.process_profile_code%TYPE,

237: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,
238: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
239: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
240: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE,
241: p_process_profile IN iby_trxn_summaries_all.process_profile_code%TYPE,
242: p_source_view IN VARCHAR2
243: )
244: RETURN XMLType
245: IS

Line 257: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE,

253: with global temporary tables iby_ar_doc_header_gt and iby_ar_doc_lines_gt.
254: Data will be inserted into GTs before extract view call
255: */
256: CURSOR l_doc_rec_csr
257: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE,
258: c_card_data_level iby_trxn_core.card_data_level%TYPE) IS
259: /*
260: SELECT
261: XMLConcat(XMLAgg(document_headers),

Line 756: FROM iby_trxn_summaries_all summ

752:
753: CURSOR c_auth_status(c_extension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
754: IS
755: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
756: FROM iby_trxn_summaries_all summ
757: , iby_fndcpt_tx_operations op
758: WHERE summ.transactionid = op.transactionid
759: AND reqtype = 'ORAPMTREQ'
760: AND status IN(0, 100)

Line 766: FROM iby_trxn_summaries_all summ1,

762: AND ((trxntypeid IN(2, 3))
763: OR
764: (trxntypeid = 20
765: AND summ.trxnmid = (SELECT MAX(trxnmid)
766: FROM iby_trxn_summaries_all summ1,
767: iby_fndcpt_tx_operations op1
768: WHERE summ1.transactionid = op1.transactionid
769: AND summ1.reqtype = 'ORAPMTREQ'
770: AND summ1.status IN(0, 100)