APPS.OE_INF_POPULATE_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 46: -- Select the header_id from the oe_order_headers_all table

42: IF l_debug_level > 0 THEN
43: oe_debug_pub.add( 'OEXPIFPB: ENTERING POPULATE_INTERFACE API' ) ;
44: END IF;
45:
46: -- Select the header_id from the oe_order_headers_all table
47: -- for what ???
48: BEGIN
49:
50: SELECT header_id, sold_to_org_id

Line 52: FROM oe_order_headers_all

48: BEGIN
49:
50: SELECT header_id, sold_to_org_id
51: INTO old_header_id_v, l_sold_to_org_id
52: FROM oe_order_headers_all
53: WHERE order_number = order_number_v;
54:
55: IF l_debug_level > 0 THEN
56: oe_debug_pub.add( 'OEXPIFPB: HEADER ID => ' || TO_CHAR ( OLD_HEADER_ID_V ) ) ;

Line 512: from oe_order_headers_all

508: ,end_customer_site_use_id /* end_customer_site_use_id number */
509: ,ib_owner /* ib_owner varchar2(60) */
510: ,ib_current_location /* ib_current_location varchar2(60) */
511: ,ib_installed_at_location /* ib_installed_at_location varchar2(60) */
512: from oe_order_headers_all
513: where order_number = order_number_v;
514:
515: IF SQL%ROWCOUNT > 0 THEN
516: IF l_debug_level > 0 THEN