1 PACKAGE OE_SCH_CONC_REQUESTS AUTHID CURRENT_USER AS
2 /* $Header: OEXCSCHS.pls 120.8 2012/01/04 08:42:37 kshashan ship $ */
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 g_checked_for_holds VARCHAR2(1) := 'N'; -- ER 13114460
9
10 TYPE id_arr IS TABLE OF number INDEX BY BINARY_INTEGER;
11 OE_model_id_Tbl id_arr;
12 OE_set_id_Tbl id_arr;
13 oe_included_id_tbl id_arr;
14 --5166476
15 TYPE status_arr IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
16 OE_line_status_Tbl status_arr;
17
18 PROCEDURE Request (ERRBUF OUT NOCOPY VARCHAR2,
19 RETCODE OUT NOCOPY VARCHAR2,
20 /* Moac */
21 p_org_id IN NUMBER,
22 p_order_number_low IN NUMBER,
23 p_order_number_high IN NUMBER,
24 p_request_date_low IN VARCHAR2,
25 p_request_date_high IN VARCHAR2,
26 p_customer_po_number IN VARCHAR2,
27 p_ship_to_location IN VARCHAR2,
28 p_order_type IN VARCHAR2,
29 p_customer IN VARCHAR2,
30 p_ordered_date_low IN VARCHAR2,
31 p_ordered_date_high IN VARCHAR2,
32 p_warehouse IN VARCHAR2,
33 p_item IN VARCHAR2,
34 p_demand_class IN VARCHAR2,
35 p_planning_priority IN VARCHAR2,
36 p_shipment_priority IN VARCHAR2,
37 p_line_type IN VARCHAR2,
38 p_line_request_date_low IN VARCHAR2,
39 p_line_request_date_high IN VARCHAR2,
40 p_line_ship_to_location IN VARCHAR2,
41 p_sch_ship_date_low IN VARCHAR2,
42 p_sch_ship_date_high IN VARCHAR2,
43 p_sch_arrival_date_low IN VARCHAR2,
44 p_sch_arrival_date_high IN VARCHAR2,
45 p_booked IN VARCHAR2,
46 p_sch_mode IN VARCHAR2,
47 p_dummy1 IN VARCHAR2,
48 p_dummy2 IN VARCHAR2,
49 p_apply_warehouse IN VARCHAR2,
50 p_apply_sch_date IN VARCHAR2,
51 p_order_by_first IN VARCHAR2,
52 p_order_by_sec IN VARCHAR2,
53 p_picked IN VARCHAR2 DEFAULT NULL, --Bug 8813015
54 p_dummy3 IN VARCHAR2 DEFAULT NULL, -- 12639770
55 p_commit_threshold IN NUMBER DEFAULT NULL -- 12639770
56 );
57
58 FUNCTION included_processed(p_inc_item_id IN NUMBER)
59 RETURN BOOLEAN;
60
61 END OE_SCH_CONC_REQUESTS;