DBA Data[Home] [Help]

APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_TRXN_CORE

Line 143: card_subtype_code IBY_TRXN_CORE.card_subtype_code%TYPE,

139: int_bank_country VARCHAR2(60),
140: settle_req_vrfy IBY_FNDCPT_SYS_EFT_PF_B.SETTLE_REQUIRE_VRFY_FLAG%TYPE,
141: auth_count PLS_INTEGER,
142: auth_dirdeb_instruction_code IBY_TRXN_SUMMARIES_ALL.dirdeb_instruction_code%TYPE,
143: card_subtype_code IBY_TRXN_CORE.card_subtype_code%TYPE,
144: card_data_level IBY_TRXN_CORE.card_data_level%TYPE
145: );
146:
147:

Line 144: card_data_level IBY_TRXN_CORE.card_data_level%TYPE

140: settle_req_vrfy IBY_FNDCPT_SYS_EFT_PF_B.SETTLE_REQUIRE_VRFY_FLAG%TYPE,
141: auth_count PLS_INTEGER,
142: auth_dirdeb_instruction_code IBY_TRXN_SUMMARIES_ALL.dirdeb_instruction_code%TYPE,
143: card_subtype_code IBY_TRXN_CORE.card_subtype_code%TYPE,
144: card_data_level IBY_TRXN_CORE.card_data_level%TYPE
145: );
146:
147:
148:

Line 2900: IBY_TRXN_CORE C

2896: FROM
2897: IBY_FNDCPT_TX_EXTENSIONS X,
2898: IBY_FNDCPT_TX_OPERATIONS O,
2899: IBY_TRXN_SUMMARIES_ALL A,
2900: IBY_TRXN_CORE C
2901: WHERE x.trxn_extension_id = ci_extension_id
2902: AND (x.trxn_extension_id = o.trxn_extension_id)
2903: AND (o.transactionid = a.transactionid)
2904: AND (a.trxnmid = c.trxnmid(+))

Line 4391: TYPE TrxnCoreTabType IS TABLE OF IBY_TRXN_CORE%ROWTYPE

4387:
4388: l_Trxn_Tab TrxnTabType;
4389: empty_Trxn_Tab TrxnTabType;
4390:
4391: TYPE TrxnCoreTabType IS TABLE OF IBY_TRXN_CORE%ROWTYPE
4392: INDEX BY BINARY_INTEGER;
4393:
4394: l_TrxnCore_Tab TrxnCoreTabType;
4395: empty_TrxnCore_Tab TrxnCoreTabType;

Line 4476: IBY_TRXN_CORE CORE

4472:
4473: CURSOR c_auth (c_tid IBY_TRXN_SUMMARIES_ALL.TRANSACTIONID%TYPE) IS
4474: SELECT CORE.authcode
4475: FROM IBY_TRXN_SUMMARIES_ALL TX,
4476: IBY_TRXN_CORE CORE
4477: WHERE TX.TRANSACTIONID = c_tid
4478: AND TX.TRXNMID=CORE.TRXNMID
4479: AND TX.TRXNTYPEID=2
4480: AND TX.STATUS=0;

Line 4800: IBY_TRXN_CORE auth_trxn_core

4796: CE_BANK_ACCOUNTS int_ba,
4797: --CE_BANK_BRANCHES_V branch
4798: HZ_PARTIES BranchParty,
4799: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
4800: IBY_TRXN_CORE auth_trxn_core
4801: WHERE orders.PAYMENT_TRXN_EXTENSION_ID = trxnext.TRXN_EXTENSION_ID(+)
4802: AND trxnop.transactionid = auth.transactionid(+)
4803: AND auth.payerid = auth_payer.ext_payer_id(+)
4804: AND auth.bepid = bep.bepid

Line 5481: -- insert into IBY_TRXN_CORE

5477: END IF;
5478: END IF;
5479:
5480: IF (l_TrxnCore_Tab.COUNT > 0) THEN
5481: -- insert into IBY_TRXN_CORE
5482: FORALL j IN l_Trxn_Tab.first..l_Trxn_Tab.last
5483: INSERT INTO IBY_TRXN_CORE VALUES l_TrxnCore_Tab(j);
5484: END IF;
5485:

Line 5483: INSERT INTO IBY_TRXN_CORE VALUES l_TrxnCore_Tab(j);

5479:
5480: IF (l_TrxnCore_Tab.COUNT > 0) THEN
5481: -- insert into IBY_TRXN_CORE
5482: FORALL j IN l_Trxn_Tab.first..l_Trxn_Tab.last
5483: INSERT INTO IBY_TRXN_CORE VALUES l_TrxnCore_Tab(j);
5484: END IF;
5485:
5486: IF (l_Tangible_Tab.COUNT > 0) THEN
5487: -- insert into IBY_TANGIBLE

Line 6088: l_authcode IBY_TRXN_CORE.authcode%TYPE;

6084: l_payer IBY_PAYMENT_ADAPTER_PUB.Payer_rec_type;
6085: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;
6086: l_pmt_instr IBY_PAYMENT_ADAPTER_PUB.PmtInstr_rec_type;
6087: l_org_id IBY_TRXN_SUMMARIES_ALL.org_id%TYPE;
6088: l_authcode IBY_TRXN_CORE.authcode%TYPE;
6089: l_tracenumber IBY_TRXN_CORE.tracenumber%TYPE;
6090: l_tax_amt IBY_TRXN_CORE.taxamount%TYPE;
6091: l_ship_from_zip IBY_TRXN_CORE.shipfromzip%TYPE;
6092: l_ship_to_zip IBY_TRXN_CORE.shiptozip%TYPE;

Line 6089: l_tracenumber IBY_TRXN_CORE.tracenumber%TYPE;

6085: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;
6086: l_pmt_instr IBY_PAYMENT_ADAPTER_PUB.PmtInstr_rec_type;
6087: l_org_id IBY_TRXN_SUMMARIES_ALL.org_id%TYPE;
6088: l_authcode IBY_TRXN_CORE.authcode%TYPE;
6089: l_tracenumber IBY_TRXN_CORE.tracenumber%TYPE;
6090: l_tax_amt IBY_TRXN_CORE.taxamount%TYPE;
6091: l_ship_from_zip IBY_TRXN_CORE.shipfromzip%TYPE;
6092: l_ship_to_zip IBY_TRXN_CORE.shiptozip%TYPE;
6093: l_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE;

Line 6090: l_tax_amt IBY_TRXN_CORE.taxamount%TYPE;

6086: l_pmt_instr IBY_PAYMENT_ADAPTER_PUB.PmtInstr_rec_type;
6087: l_org_id IBY_TRXN_SUMMARIES_ALL.org_id%TYPE;
6088: l_authcode IBY_TRXN_CORE.authcode%TYPE;
6089: l_tracenumber IBY_TRXN_CORE.tracenumber%TYPE;
6090: l_tax_amt IBY_TRXN_CORE.taxamount%TYPE;
6091: l_ship_from_zip IBY_TRXN_CORE.shipfromzip%TYPE;
6092: l_ship_to_zip IBY_TRXN_CORE.shiptozip%TYPE;
6093: l_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE;
6094: l_rcpt_method_id IBY_TRXN_SUMMARIES_ALL.ar_receipt_method_id%TYPE;

Line 6091: l_ship_from_zip IBY_TRXN_CORE.shipfromzip%TYPE;

6087: l_org_id IBY_TRXN_SUMMARIES_ALL.org_id%TYPE;
6088: l_authcode IBY_TRXN_CORE.authcode%TYPE;
6089: l_tracenumber IBY_TRXN_CORE.tracenumber%TYPE;
6090: l_tax_amt IBY_TRXN_CORE.taxamount%TYPE;
6091: l_ship_from_zip IBY_TRXN_CORE.shipfromzip%TYPE;
6092: l_ship_to_zip IBY_TRXN_CORE.shiptozip%TYPE;
6093: l_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE;
6094: l_rcpt_method_id IBY_TRXN_SUMMARIES_ALL.ar_receipt_method_id%TYPE;
6095: l_reqresp IBY_PAYMENT_ADAPTER_PUB.ReqResp_rec_type;

Line 6092: l_ship_to_zip IBY_TRXN_CORE.shiptozip%TYPE;

6088: l_authcode IBY_TRXN_CORE.authcode%TYPE;
6089: l_tracenumber IBY_TRXN_CORE.tracenumber%TYPE;
6090: l_tax_amt IBY_TRXN_CORE.taxamount%TYPE;
6091: l_ship_from_zip IBY_TRXN_CORE.shipfromzip%TYPE;
6092: l_ship_to_zip IBY_TRXN_CORE.shiptozip%TYPE;
6093: l_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE;
6094: l_rcpt_method_id IBY_TRXN_SUMMARIES_ALL.ar_receipt_method_id%TYPE;
6095: l_reqresp IBY_PAYMENT_ADAPTER_PUB.ReqResp_rec_type;
6096:

Line 6149: iby_trxn_core core,

6145: FROM iby_fndcpt_tx_extensions xt,
6146: iby_fndcpt_tx_operations op,
6147: iby_trxn_summaries_all auth,
6148: iby_tangible tg,
6149: iby_trxn_core core,
6150: iby_bepinfo bep,
6151: iby_creditcard_issuers_b brand
6152: WHERE (xt.trxn_extension_id = ci_extension_id)
6153: AND (xt.trxn_extension_id = op.trxn_extension_id)