DBA Data[Home] [Help]

APPS.OE_PAYMENT_TRXN_UTIL dependencies on OE_ORDER_LINES_ALL

Line 108: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;

104: L_pmt_channel_code IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;
105: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
106: --l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE;
107: l_trxn_extension_id NUMBER;
108: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
109: l_err_message VARCHAR2(4000);
110: l_instrument_security_code VARCHAR2(30);
111: l_cust_account_id NUMBER;
112: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 155: from oe_order_lines_all where header_id = p_header_id

151:
152: -- BEGIN
153: IF p_line_id is not null then
154: Select INVOICE_TO_ORG_ID,ORG_ID into l_invoice_to_org_id,l_org_id
155: from oe_order_lines_all where header_id = p_header_id
156: and line_id = p_line_id;
157: ELSE
158: /*
159: select invoice_to_org_id,org_id into l_invoice_to_org_id,l_org_id

Line 826: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;

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;
826: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
827: L_pmt_channel_code IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;
828: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
829: l_payment_number NUMBER;
830: l_cust_account_id NUMBER; --New

Line 892: from oe_order_lines_all where header_id = p_header_id and line_id = p_line_id;

888: --Get party id for the bill to site Verify
889:
890: IF p_line_id is not null then
891: Select INVOICE_TO_ORG_ID,ORG_ID into l_invoice_to_org_id,l_org_id
892: from oe_order_lines_all where header_id = p_header_id and line_id = p_line_id;
893: else
894: /*
895: select invoice_to_org_id,org_id into l_invoice_to_org_id,l_org_id
896: from oe_order_headers_all where header_id = p_header_id;

Line 1902: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;

1898: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1899: l_org_id NUMBER;
1900: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
1901: p_entities IBY_FNDCPT_COMMON_PUB.Id_tbl_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;

Line 1919: from oe_order_lines_all where header_id = p_header_id and line_id = p_line_id;

1915: BEGIN
1916: --Get party id for the bill to site;??
1917: IF p_line_id is not null then
1918: Select INVOICE_TO_ORG_ID,ORG_ID into l_invoice_to_org_id,l_org_id
1919: from oe_order_lines_all where header_id = p_header_id and line_id = p_line_id;
1920: else
1921: /*
1922: select invoice_to_org_id,ORG_ID into l_invoice_to_org_id,l_org_id
1923: from oe_order_headers_all where header_id = p_header_id;

Line 2493: from oe_order_lines_all where line_id = p_line_id and header_id = p_header_id;

2489: END IF;
2490:
2491: IF p_line_id is not null then
2492: Select ORG_ID into l_org_id
2493: from oe_order_lines_all where line_id = p_line_id and header_id = p_header_id;
2494: else
2495: oe_order_cache.load_order_header(p_header_id);
2496: l_org_id := OE_Order_Cache.g_header_rec.org_id;
2497: end if;

Line 2668: UPDATE oe_order_lines_ALL

2664: WHERE trxn_extension_id = p_trxn_extension_id
2665: AND header_id = p_header_id
2666: AND nvl(line_id,-1) = nvl(p_line_id,-1)
2667: ;*/ --Commented for CC Reversal ER bug# 16595030
2668: UPDATE oe_order_lines_ALL
2669: SET payment_type_code=null
2670: WHERE 1=1
2671: AND header_id = p_header_id
2672: AND nvl(line_id,-1) = nvl(p_line_id,-1)

Line 2948: FROM oe_order_lines_all

2944: END IF;
2945: BEGIN
2946: SELECT invoice_to_org_id, org_id
2947: INTO l_invoice_to_org_id,l_org_id
2948: FROM oe_order_lines_all
2949: WHERE line_id = p_line_id;
2950: EXCEPTION WHEN NO_DATA_FOUND THEN
2951: IF l_debug_level > 0 THEN
2952: oe_debug_pub.add('Invoice to Org id is null.....',5);