eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_PAYMENT_TRXN_UTIL dependencies on OE_ORDER_LINES_ALL

Line 50: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;

46: L_pmt_channel_code IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;
47: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
48: --l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE;
49: l_trxn_extension_id NUMBER;
50: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
51: l_err_message VARCHAR2(4000);
52: l_instrument_security_code VARCHAR2(30);
53: l_cust_account_id NUMBER;
54: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 97: from oe_order_lines_all where header_id = p_header_id

93:
94: -- BEGIN
95: IF p_line_id is not null then
96: Select INVOICE_TO_ORG_ID,ORG_ID into l_invoice_to_org_id,l_org_id
97: from oe_order_lines_all where header_id = p_header_id
98: and line_id = p_line_id;
99: ELSE
100: /*
101: select invoice_to_org_id,org_id into l_invoice_to_org_id,l_org_id

Line 689: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;

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;
689: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
690: L_pmt_channel_code IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;
691: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
692: l_payment_number NUMBER;
693: l_cust_account_id NUMBER; --New

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

747: --Get party id for the bill to site Verify
748:
749: IF p_line_id is not null then
750: Select INVOICE_TO_ORG_ID,ORG_ID into l_invoice_to_org_id,l_org_id
751: from oe_order_lines_all where header_id = p_header_id and line_id = p_line_id;
752: else
753: /*
754: select invoice_to_org_id,org_id into l_invoice_to_org_id,l_org_id
755: from oe_order_headers_all where header_id = p_header_id;

Line 1599: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;

1595: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1596: l_org_id NUMBER;
1597: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
1598: p_entities IBY_FNDCPT_COMMON_PUB.Id_tbl_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;

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

1612: BEGIN
1613: --Get party id for the bill to site;??
1614: IF p_line_id is not null then
1615: Select INVOICE_TO_ORG_ID,ORG_ID into l_invoice_to_org_id,l_org_id
1616: from oe_order_lines_all where header_id = p_header_id and line_id = p_line_id;
1617: else
1618: /*
1619: select invoice_to_org_id,ORG_ID into l_invoice_to_org_id,l_org_id
1620: from oe_order_headers_all where header_id = p_header_id;

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

2104: END IF;
2105:
2106: IF p_line_id is not null then
2107: Select ORG_ID into l_org_id
2108: from oe_order_lines_all where line_id = p_line_id and header_id = p_header_id;
2109: else
2110: oe_order_cache.load_order_header(p_header_id);
2111: l_org_id := OE_Order_Cache.g_header_rec.org_id;
2112: end if;