APPS.HRI_BPL_OE_ORDER dependencies on OE_ORDER_HEADERS_ALL

Line 5: g_order_number oe_order_headers_all.order_number%type;

1: PACKAGE BODY HRI_BPL_OE_ORDER AS
2: /* $Header: hriboeod.pkb 120.0 2005/05/29 07:03:43 appldev noship $ */
3: --globals to cache
4: g_line_number oe_order_lines_all.line_number%type;
5: g_order_number oe_order_headers_all.order_number%type;
6: g_line_id oe_order_lines_all.line_id%type;
7: g_header_id oe_order_headers_all.header_id%type;
8:
9: PROCEDURE UPDATE_GLOBALS(p_line_id IN NUMBER)

Line 7: g_header_id oe_order_headers_all.header_id%type;

3: --globals to cache
4: g_line_number oe_order_lines_all.line_number%type;
5: g_order_number oe_order_headers_all.order_number%type;
6: g_line_id oe_order_lines_all.line_id%type;
7: g_header_id oe_order_headers_all.header_id%type;
8:
9: PROCEDURE UPDATE_GLOBALS(p_line_id IN NUMBER)
10: IS
11: CURSOR csr_line_order

Line 18: oe_order_headers_all ooh,

14: ool.header_id l_header_id,
15: ool.line_number l_line_number,
16: ooh.order_number l_order_number
17: from
18: oe_order_headers_all ooh,
19: oe_order_lines_all ool
20: where
21: p_line_id = ool.line_id
22: AND ool.header_id = ooh.header_id;