APPS.IBY_QUERYCC_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 52: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,

48: *
49: */
50: PROCEDURE getTrxnInfo
51: (
52: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
53: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
54: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE DEFAULT NULL,
55: status_in IN iby_trxn_summaries_all.status%TYPE,
56: status_aux_in IN iby_trxn_summaries_all.status%TYPE DEFAULT NULL,

Line 53: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

49: */
50: PROCEDURE getTrxnInfo
51: (
52: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
53: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
54: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE DEFAULT NULL,
55: status_in IN iby_trxn_summaries_all.status%TYPE,
56: status_aux_in IN iby_trxn_summaries_all.status%TYPE DEFAULT NULL,
57: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,

Line 54: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE DEFAULT NULL,

50: PROCEDURE getTrxnInfo
51: (
52: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
53: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
54: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE DEFAULT NULL,
55: status_in IN iby_trxn_summaries_all.status%TYPE,
56: status_aux_in IN iby_trxn_summaries_all.status%TYPE DEFAULT NULL,
57: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
58: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,

Line 55: status_in IN iby_trxn_summaries_all.status%TYPE,

51: (
52: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
53: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
54: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE DEFAULT NULL,
55: status_in IN iby_trxn_summaries_all.status%TYPE,
56: status_aux_in IN iby_trxn_summaries_all.status%TYPE DEFAULT NULL,
57: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
58: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,
59: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE

Line 56: status_aux_in IN iby_trxn_summaries_all.status%TYPE DEFAULT NULL,

52: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
53: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
54: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE DEFAULT NULL,
55: status_in IN iby_trxn_summaries_all.status%TYPE,
56: status_aux_in IN iby_trxn_summaries_all.status%TYPE DEFAULT NULL,
57: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
58: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,
59: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE
60: );

Line 57: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,

53: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
54: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE DEFAULT NULL,
55: status_in IN iby_trxn_summaries_all.status%TYPE,
56: status_aux_in IN iby_trxn_summaries_all.status%TYPE DEFAULT NULL,
57: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
58: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,
59: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE
60: );
61:

Line 58: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,

54: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE DEFAULT NULL,
55: status_in IN iby_trxn_summaries_all.status%TYPE,
56: status_aux_in IN iby_trxn_summaries_all.status%TYPE DEFAULT NULL,
57: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
58: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,
59: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE
60: );
61:
62:

Line 59: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE

55: status_in IN iby_trxn_summaries_all.status%TYPE,
56: status_aux_in IN iby_trxn_summaries_all.status%TYPE DEFAULT NULL,
57: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
58: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,
59: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE
60: );
61:
62:
63: END iby_querycc_pkg;