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 36: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,

32: -- of DocumentReceivable and DocumentReceivableCount
33: --
34: FUNCTION get_document_receivable
35: (
36: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,
37: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
38: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
39: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE
40: )

Line 37: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,

33: --
34: FUNCTION get_document_receivable
35: (
36: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,
37: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
38: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
39: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE
40: )
41: RETURN XMLType

Line 39: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE

35: (
36: p_extension_id IN iby_trxn_summaries_all.initiator_extension_id%TYPE,
37: p_trxntypeid IN iby_trxn_summaries_all.trxntypeid%TYPE,
38: p_card_data_level IN iby_trxn_core.card_data_level%TYPE,
39: p_instrument_type IN iby_trxn_summaries_all.instrtype%TYPE
40: )
41: RETURN XMLType
42: IS
43: l_doc_rec XMLType;

Line 46: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE) IS

42: IS
43: l_doc_rec XMLType;
44:
45: CURSOR l_doc_rec_csr
46: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE) IS
47: SELECT
48: XMLConcat(XMLAgg(document_headers),
49: XMLElement("DocumentReceivableCount",count(trxn_extension_id)))
50: FROM iby_xml_fndcpt_doc_headers_v

Line 338: FROM iby_trxn_summaries_all summ

334: IS
335: BEGIN
336: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
337: into x_auth_flag
338: FROM iby_trxn_summaries_all summ
339: , iby_fndcpt_tx_operations op
340: WHERE summ.transactionid = op.transactionid
341: AND reqtype = 'ORAPMTREQ'
342: AND status IN(0, 100)

Line 346: FROM iby_trxn_summaries_all summ1

342: AND status IN(0, 100)
343: AND trxntypeid IN(2, 3, 20)
344: AND op.trxn_extension_id = p_trxn_extension_id
345: AND summ.trxnmid = (SELECT MAX(trxnmid)
346: FROM iby_trxn_summaries_all summ1
347: , iby_fndcpt_tx_operations op1
348: WHERE summ1.transactionid = op1.transactionid
349: AND summ1.reqtype = 'ORAPMTREQ'
350: AND summ1.status IN(0, 100)