APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 207: IBY_FNDCPT_PAYER_ASSGN_INSTR_V

203: END IF;
204:
205: SELECT INSTRUMENT_ID into
206: l_instrument_id from
207: IBY_FNDCPT_PAYER_ASSGN_INSTR_V
208: where INSTR_ASSIGNMENT_ID = p_payment_trx_id;
209:
210: l_assignment_attribs.instrument.instrument_id := l_instrument_id;
211: END IF;

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

680: l_org_id NUMBER;
681: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
682: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
683: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE := p_instrument_id;
684: l_instrument_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE := p_instrument_assignment_id;
685: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;
686: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
687: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
688: L_assign_id NUMBER;

Line 824: IBY_FNDCPT_PAYER_ASSGN_INSTR_V

820: END IF;
821:
822: SELECT INSTRUMENT_ID into
823: l_instrument_id from
824: IBY_FNDCPT_PAYER_ASSGN_INSTR_V
825: where INSTR_ASSIGNMENT_ID = p_payment_trx_id;
826: END IF;
827:
828:

Line 1603: l_instr_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;

1599: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
1600: l_cust_account_id NUMBER; --New
1601: l_err_message VARCHAR2(2000);
1602: l_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
1603: l_instr_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;
1604: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE;
1605: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
1606: l_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
1607: l_exists_assignment VARCHAR2(1) := 'N';

Line 1608: l_assign_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;

1604: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE;
1605: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
1606: l_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
1607: l_exists_assignment VARCHAR2(1) := 'N';
1608: l_assign_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;
1609:
1610: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1611:
1612: BEGIN

Line 1676: From IBY_FNDCPT_PAYER_ASSGN_INSTR_V

1672: --Commenting out this check for that.
1673: /*Begin
1674: Select 'Y'
1675: Into l_exists_assignment
1676: From IBY_FNDCPT_PAYER_ASSGN_INSTR_V
1677: Where party_id = l_party_id
1678: And instr_assignment_id = l_instr_assignment_id
1679: And rownum = 1;
1680: Exception When NO_DATA_FOUND THEN

Line 2141: from iby_fndcpt_payer_assgn_instr_v ifpai,

2137: IF l_debug_level > 0 THEN
2138: oe_debug_pub.add('Inside the credit card query for site use id...'||p_trxn_extension_id);
2139: END IF;
2140: select ifpai.acct_site_use_id into l_site_use_id
2141: from iby_fndcpt_payer_assgn_instr_v ifpai,
2142: iby_trxn_extensions_v itev where
2143: ifpai.instr_assignment_id = itev.instr_assignment_id and
2144: itev.trxn_extension_id = p_trxn_extension_id;
2145: ELSE