1 PACKAGE OE_SCH_CONC_REQUESTS AS
2 /* $Header: OEXCSCHS.pls 120.5 2006/07/13 11:30:25 rmoharan noship $ */
3
4 g_process_records NUMBER;
5 g_failed_records NUMBER;
6 g_conc_program VARCHAR2(1) := 'N';
7 g_recorded VARCHAR2(1) := 'N'; --5166476
8
9 TYPE id_arr IS TABLE OF number INDEX BY BINARY_INTEGER;
10 OE_model_id_Tbl id_arr;
11 OE_set_id_Tbl id_arr;
12 oe_included_id_tbl id_arr;
13 --5166476
14 TYPE status_arr IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
15 OE_line_status_Tbl status_arr;
16
17 PROCEDURE Request (ERRBUF OUT NOCOPY VARCHAR2,
18 RETCODE OUT NOCOPY VARCHAR2,
19 /* Moac */
20 p_org_id IN NUMBER,
21 p_order_number_low IN NUMBER,
22 p_order_number_high IN NUMBER,
23 p_request_date_low IN VARCHAR2,
24 p_request_date_high IN VARCHAR2,
25 p_customer_po_number IN VARCHAR2,
26 p_ship_to_location IN VARCHAR2,
27 p_order_type IN VARCHAR2,
28 p_customer IN VARCHAR2,
29 p_ordered_date_low IN VARCHAR2,
30 p_ordered_date_high IN VARCHAR2,
31 p_warehouse IN VARCHAR2,
32 p_item IN VARCHAR2,
33 p_demand_class IN VARCHAR2,
34 p_planning_priority IN VARCHAR2,
35 p_shipment_priority IN VARCHAR2,
36 p_line_type IN VARCHAR2,
37 p_line_request_date_low IN VARCHAR2,
38 p_line_request_date_high IN VARCHAR2,
39 p_line_ship_to_location IN VARCHAR2,
40 p_sch_ship_date_low IN VARCHAR2,
41 p_sch_ship_date_high IN VARCHAR2,
42 p_sch_arrival_date_low IN VARCHAR2,
43 p_sch_arrival_date_high IN VARCHAR2,
44 p_booked IN VARCHAR2,
45 p_sch_mode IN VARCHAR2,
46 p_dummy1 IN VARCHAR2,
47 p_dummy2 IN VARCHAR2,
48 p_apply_warehouse IN VARCHAR2,
49 p_apply_sch_date IN VARCHAR2,
50 p_order_by_first IN VARCHAR2,
51 p_order_by_sec IN VARCHAR2);
52
53 FUNCTION included_processed(p_inc_item_id IN NUMBER)
54 RETURN BOOLEAN;
55
56 END OE_SCH_CONC_REQUESTS;