PACKAGE: APPS.OE_SCH_ORGANIZER_UTIL

Source

1 PACKAGE OE_SCH_ORGANIZER_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEXUSCOS.pls 120.4.12020000.1 2012/06/26 09:47:16 appldev ship $ */
3 
4 TYPE sch_line_rec_type is RECORD (
5 org_id                   NUMBER, -- R12.MOAC--
6 header_id                NUMBER,
7 line_id                  NUMBER,
8 schedule_ship_date       DATE,
9 schedule_arrival_date    DATE,
10 demand_class_code        VARCHAR2(30),
11 shipment_priority_code   VARCHAR2(30),
12 planning_priority        NUMBER,
13 ship_from_org_id         NUMBER,
14 reserved_quantity        NUMBER,
15 subinventory             VARCHAR2(10),
16 ship_set                 VARCHAR2(40),
17 arrival_set              VARCHAR2(40),
18 project_id               NUMBER,
19 task_id                  NUMBER,
20 end_item_unit_number     VARCHAR2(30),
21 source_type_code         VARCHAR2(30),
22 shipping_method_code     VARCHAR2(30),
23 override_atp_date_code   VARCHAR2(30),
24 late_demand_penalty_factor NUMBER,
25 latest_acceptable_date   DATE,
26 exclude                  VARCHAR2(1),
27 ship_set_changed         VARCHAR2(1),
28 arrival_set_changed      VARCHAR2(1),
29 Corrected_Qty            NUMBER,
30 Corrected_Qty2           NUMBER, -- INVCONV
31 reserved_quantity2       NUMBER, -- INVCONV
32 firm_demand_flag         VARCHAR2(1) -- for bug 8370582
33 );
34 
35 TYPE sch_line_tbl_type IS TABLE OF sch_line_rec_type
36   INDEX BY BINARY_INTEGER;
37 
38 --3751812 : Size of line_list increased from 2000 to 32000
39 TYPE line_list_rec_typ IS RECORD(
40      line_list VARCHAR2(32000),
41      count     NUMBER);
42 
43 TYPE line_list_tab_typ IS TABLE OF line_list_rec_typ INDEX BY BINARY_INTEGER;
44 
45 TYPE header_line_rec IS RECORD(
46      line_id NUMBER,
47      header_id NUMBER,
48      exclude VARCHAR2(1));
49 TYPE header_line_tab IS TABLE OF header_line_rec INDEX BY BINARY_INTEGER;
50 
51 
52 PROCEDURE Sch_Window_Key_Commit
53 (p_x_sch_line_tbl IN OUT NOCOPY sch_line_tbl_type,
54  x_return_status OUT NOCOPY VARCHAR2,
55  x_msg_count OUT NOCOPY NUMBER,
56  x_msg_data OUT NOCOPY VARCHAR2,
57  x_failed_count OUT NOCOPY NUMBER);
58 
59 PROCEDURE Order_Boundary_Sorting(p_line_list IN VARCHAR2, p_count IN NUMBER,
60                                  x_line_list_tbl OUT NOCOPY line_list_tab_typ);
61 --Pack J
62 FUNCTION Submit_Reservation_Request
63 (p_selected_line_tbl    IN OE_GLOBALS.selected_record_tbl, --R12.MOAC
64  p_reservation_mode     IN VARCHAR2 DEFAULT NULL,
65  p_percent              IN NUMBER DEFAULT NULL,
66  p_reserve_run_type     IN VARCHAR2,
67  p_reservation_set_Name IN VARCHAR2 DEFAULT NULL,
68  p_override_set         IN VARCHAR2 DEFAULT 'N',
69  p_order_by             IN VARCHAR2 DEFAULT NULL,
70  p_partial_preference   IN VARCHAR2 DEFAULT 'N')
71 RETURN NUMBER;
72 
73 PROCEDURE Update_Reservation_Qty
74 (p_reservation_set  IN  VARCHAR2,
75  p_sch_line_tbl  IN  OE_SCH_ORGANIZER_UTIL.sch_line_tbl_type);
76 
77 FUNCTION Reservation_Set_Processed
78 (p_reservation_set_name  IN VARCHAR2)
79 RETURN BOOLEAN;
80 
81   -- R12.MOAC
82 PROCEDURE Insert_into_tmp_tab(p_line_id IN NUMBER);
83 PROCEDURE Insert_into_tmp_tab(p_line_tbl IN OE_GLOBALS.Selected_Record_Tbl);
84 PROCEDURE delete_tmp_tab;
85 
86 PROCEDURE Process_Schedule_Action
87 (p_selected_line_tbl     IN   OE_GLOBALS.Selected_Record_Tbl,
88 p_sch_action             IN   VARCHAR2,
89 x_atp_tbl                OUT NOCOPY oe_atp.atp_tbl_type,
90 x_return_status          OUT NOCOPY VARCHAR2,
91 x_msg_count              OUT NOCOPY NUMBER,
92 x_msg                    OUT NOCOPY VARCHAR2);
93 
94 END OE_SCH_ORGANIZER_UTIL;