1 PACKAGE MSC_ATP_UTILS AUTHID CURRENT_USER AS
2 /* $Header: MSCUATPS.pls 120.2 2007/12/12 10:43:08 sbnaik ship $ */
3
4
5 SYS_YES CONSTANT NUMBER := 1;
6 SYS_NO CONSTANT NUMBER := 2;
7 REQUEST_MODE CONSTANT NUMBER := 1;
8 RESULTS_MODE CONSTANT NUMBER := 2;
9
10
11 PROCEDURE put_into_temp_table(
12 x_dblink IN VARCHAR2,
13 x_session_id IN NUMBER,
14 x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
15 x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16 x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
17 x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
18 x_mode IN NUMBER,
19 x_return_status OUT NoCopy VARCHAR2,
20 x_msg_data OUT NoCopy VARCHAR2,
21 x_msg_count OUT NoCopy NUMBER
22 );
23
24 PROCEDURE get_from_temp_table(
25 x_dblink IN VARCHAR2,
26 x_session_id IN NUMBER,
27 x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
28 x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
29 x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
30 x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
31 x_mode IN NUMBER,
32 x_return_status OUT NoCopy VARCHAR2,
33 x_msg_data OUT NoCopy VARCHAR2,
34 x_msg_count OUT NoCopy NUMBER,
35 p_details_flag IN NUMBER
36 );
37
38 FUNCTION Call_ATP_11(
39 p_group_id NUMBER,
40 p_session_id NUMBER,
41 p_insert_flag NUMBER,
42 p_partial_flag NUMBER,
43 p_err_message IN OUT NoCopy VARCHAR2)
44 RETURN NUMBER;
45
46
47 PROCEDURE extend_mast(
48 mast_rec IN OUT NoCopy MRP_ATP_UTILS.mrp_atp_schedule_temp_typ,
49 x_ret_code OUT NoCopy varchar2,
50 x_ret_status OUT NoCopy varchar2);
51
52 PROCEDURE trim_mast(
53 mast_rec IN OUT NoCopy MRP_ATP_UTILS.mrp_atp_schedule_temp_typ,
54 x_ret_code OUT NoCopy varchar2,
55 x_ret_status OUT NoCopy varchar2);
56
57 /* 2974324 Procedure just for testing. Removed
58 PROCEDURE test(x_session_id NUMBER);
59 */
60
61 -- Added on 10/16 by ngoel for inserting BOM data into MSC_BOM_TEMP
62 -- table when ATP is called with CTO models from OM or Configurator.
63
64 PROCEDURE put_into_bom_temp_table(
65 p_session_id IN NUMBER,
66 p_dblink IN VARCHAR2,
67 p_atp_bom_rec IN MRP_ATP_PUB.ATP_BOM_Rec_Typ,
68 x_return_status OUT NoCopy VARCHAR2,
69 x_msg_data OUT NoCopy VARCHAR2,
70 x_msg_count OUT NoCopy NUMBER);
71
72 PROCEDURE Put_SD_Data (
73 p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
74 p_dblink IN VARCHAR2,
75 p_session_id IN NUMBER );
76
77 PROCEDURE Put_Period_Data (
78 p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
79 p_dblink IN VARCHAR2,
80 p_session_id IN NUMBER );
81
82 PROCEDURE Put_Pegging_data (p_session_id IN NUMBER,
83 p_dblink IN VARCHAR2);
84
85 Procedure Put_Scheduling_data(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
86 p_mode IN NUMBER,
87 p_dblink IN VARCHAR2,
88 p_session_id IN NUMBER );
89
90 Procedure Process_Supply_Demand_details( p_dblink IN varchar2,
91 p_session_id IN number,
92 x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ);
93
94 PROCEDURE Transfer_mrp_atp_details_temp(
95 p_dblink IN VARCHAR2,
96 p_session_id IN NUMBER
97 );
98
99 PROCEDURE Retrieve_Period_and_SD_Data(
100 p_session_id IN NUMBER,
101 x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
102 x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ
103 );
104
105 PROCEDURE Copy_MRP_SD_Recs(
106 p_old_pegging_id NUMBER,
107 p_pegging_id NUMBER
108 );
109
110 procedure Put_Sch_Data_Request_Mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
111 p_session_id IN NUMBER);
112
113
114 Procedure Put_Sch_data_result_mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
115 p_dblink IN VARCHAR2,
116 p_session_id IN NUMBER);
117
118 Procedure Transfer_Scheduling_data(p_session_id IN Number,
119 p_dblink IN VARCHAR2,
120 p_mode IN NUMBER);
121
122 procedure Update_Line_Item_Properties(p_session_id IN NUMBER,
123 Action IN NUMBER DEFAULT NULL); --3720018
124
125 /* Bug 5598066: Function to Truncate demand to 6 decimal places.
126 Also if the 7th point if 9, it will be a 1 increase in the 6th point. */
127
128 FUNCTION Truncate_Demand (p_demand_qty IN NUMBER)
129 Return NUMBER;
130
131 END MSC_ATP_UTILS;
132