APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 265: IBY_FNDCPT_PAYER_ASSGN_INSTR_V

261: END IF;
262:
263: SELECT INSTRUMENT_ID into
264: l_instrument_id from
265: IBY_FNDCPT_PAYER_ASSGN_INSTR_V
266: where INSTR_ASSIGNMENT_ID = p_payment_trx_id;
267:
268: l_assignment_attribs.instrument.instrument_id := l_instrument_id;
269: l_assignment_attribs.Assignment_Id := p_payment_trx_id; -- bug 9857904

Line 821: l_instrument_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE := p_instrument_assignment_id;

817: l_org_id NUMBER;
818: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
819: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
820: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE := p_instrument_id;
821: l_instrument_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE := p_instrument_assignment_id;
822: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;
823: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
824: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
825: L_assign_id NUMBER;

Line 965: IBY_FNDCPT_PAYER_ASSGN_INSTR_V

961: END IF;
962:
963: SELECT INSTRUMENT_ID into
964: l_instrument_id from
965: IBY_FNDCPT_PAYER_ASSGN_INSTR_V
966: where INSTR_ASSIGNMENT_ID = p_payment_trx_id;
967: END IF;
968:
969:

Line 1906: l_instr_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;

1902: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
1903: l_cust_account_id NUMBER; --New
1904: l_err_message VARCHAR2(2000);
1905: l_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
1906: l_instr_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;
1907: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE;
1908: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
1909: l_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
1910: l_exists_assignment VARCHAR2(1) := 'N';

Line 1911: l_assign_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;

1907: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE;
1908: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
1909: l_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
1910: l_exists_assignment VARCHAR2(1) := 'N';
1911: l_assign_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;
1912:
1913: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1914:
1915: BEGIN

Line 1980: From IBY_FNDCPT_PAYER_ASSGN_INSTR_V

1976: --Commenting out this check for that.
1977: /*Begin
1978: Select 'Y'
1979: Into l_exists_assignment
1980: From IBY_FNDCPT_PAYER_ASSGN_INSTR_V
1981: Where party_id = l_party_id
1982: And instr_assignment_id = l_instr_assignment_id
1983: And rownum = 1;
1984: Exception When NO_DATA_FOUND THEN

Line 2537: from iby_fndcpt_payer_assgn_instr_v ifpai,

2533: oe_debug_pub.add('Inside the credit card query for site use id...'||p_trxn_extension_id);
2534: END IF;
2535: -- bug 8586227
2536: select ifpai.acct_site_use_id into l_site_use_id
2537: from iby_fndcpt_payer_assgn_instr_v ifpai,
2538: IBY_EXTN_INSTR_DETAILS_V itev where
2539: ifpai.instr_assignment_id = itev.instr_assignment_id and
2540: itev.trxn_extension_id = p_trxn_extension_id;
2541: ELSE