PACKAGE: APPS.OE_SCH_ORGANIZER_UTIL

Source

1 PACKAGE OE_SCH_ORGANIZER_UTIL AS
2 /* $Header: OEXUSCOS.pls 120.2.12010000.2 2008/11/11 08:20:48 rmoharan 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 );
33 
34 TYPE sch_line_tbl_type IS TABLE OF sch_line_rec_type
35   INDEX BY BINARY_INTEGER;
36 
37 --3751812 : Size of line_list increased from 2000 to 32000
38 TYPE line_list_rec_typ IS RECORD(
39      line_list VARCHAR2(32000),
40      count     NUMBER);
41 
42 TYPE line_list_tab_typ IS TABLE OF line_list_rec_typ INDEX BY BINARY_INTEGER;
43 
44 TYPE header_line_rec IS RECORD(
45      line_id NUMBER,
46      header_id NUMBER,
47      exclude VARCHAR2(1));
48 TYPE header_line_tab IS TABLE OF header_line_rec INDEX BY BINARY_INTEGER;
49 
50 
51 PROCEDURE Sch_Window_Key_Commit
52 (p_x_sch_line_tbl IN OUT NOCOPY sch_line_tbl_type,
53  x_return_status OUT NOCOPY VARCHAR2,
54  x_msg_count OUT NOCOPY NUMBER,
55  x_msg_data OUT NOCOPY VARCHAR2,
56  x_failed_count OUT NOCOPY NUMBER);
57 
58 PROCEDURE Order_Boundary_Sorting(p_line_list IN VARCHAR2, p_count IN NUMBER,
59                                  x_line_list_tbl OUT NOCOPY line_list_tab_typ);
60 --Pack J
61 FUNCTION Submit_Reservation_Request
62 (p_selected_line_tbl    IN OE_GLOBALS.selected_record_tbl, --R12.MOAC
63  p_reservation_mode     IN VARCHAR2 DEFAULT NULL,
64  p_percent              IN NUMBER DEFAULT NULL,
65  p_reserve_run_type     IN VARCHAR2,
66  p_reservation_set_Name IN VARCHAR2 DEFAULT NULL,
67  p_override_set         IN VARCHAR2 DEFAULT 'N',
68  p_order_by             IN VARCHAR2 DEFAULT NULL,
69  p_partial_preference   IN VARCHAR2 DEFAULT 'N')
70 RETURN NUMBER;
71 
72 PROCEDURE Update_Reservation_Qty
73 (p_reservation_set  IN  VARCHAR2,
74  p_sch_line_tbl  IN  OE_SCH_ORGANIZER_UTIL.sch_line_tbl_type);
75 
76 FUNCTION Reservation_Set_Processed
77 (p_reservation_set_name  IN VARCHAR2)
78 RETURN BOOLEAN;
79 
80   -- R12.MOAC
81 PROCEDURE Insert_into_tmp_tab(p_line_id IN NUMBER);
82 PROCEDURE Insert_into_tmp_tab(p_line_tbl IN OE_GLOBALS.Selected_Record_Tbl);
83 PROCEDURE delete_tmp_tab;
84 
85 PROCEDURE Process_Schedule_Action
86 (p_selected_line_tbl     IN   OE_GLOBALS.Selected_Record_Tbl,
87 p_sch_action             IN   VARCHAR2,
88 x_atp_tbl                OUT NOCOPY oe_atp.atp_tbl_type,
89 x_return_status          OUT NOCOPY VARCHAR2,
90 x_msg_count              OUT NOCOPY NUMBER,
91 x_msg                    OUT NOCOPY VARCHAR2);
92 
93 END OE_SCH_ORGANIZER_UTIL;