PACKAGE BODY: APPS.MRP_BAL_UTILS

Source

1 PACKAGE BODY MRP_BAL_UTILS AS
2 /* $Header: MRPUBALB.pls 115.19 2003/03/24 23:41:28 cnazarma ship $  */
3 
4 
5 /*
6 PROCEDURE extend( p_nodes IN OUT NoCopy mrp_oe_rec , extend_amount NUMBER );
7 PROCEDURE trim( p_nodes IN OUT NoCopy mrp_oe_rec , trim_amount NUMBER );
8 */
9 
10 PROCEDURE populate_temp_table (p_session_id NUMBER,
11 			       p_order_by   VARCHAR2,
12 			       p_where      VARCHAR2,
13 			       p_overwrite  NUMBER,
14 			       p_org_id     NUMBER) IS
15 BEGIN
16 	MSC_BAL_UTILS.populate_temp_table(
17 		p_session_id,
18                 p_order_by,
19                 p_where,
20                 p_overwrite,
21                 p_org_id);
22 END populate_temp_table;
23 
24 PROCEDURE undemand_orders (p_session_id NUMBER) IS
25 x_msg_count     NUMBER;
26 x_msg_data      VARCHAR2(100);
27 x_return_status VARCHAR2(1);
28 
29 BEGIN
30 	MSC_BAL_UTILS.undemand_orders (p_session_id,
31                            x_msg_count,
32                            x_msg_data ,
33                            x_return_status);
34 
35 END undemand_orders;
36 
37 PROCEDURE schedule_orders (p_session_id NUMBER,
38 			   x_msg_count       OUT    NoCopy NUMBER,
39 			   x_msg_data        OUT    NoCopy varchar2,
40 			   x_return_status   OUT    NoCopy varchar2
41 			   ) IS
42 BEGIN
43 	MSC_BAL_UTILS. schedule_orders(
44 		p_session_id,
45                 x_msg_count,
46                 x_msg_data,
47                 x_return_status);
48 END schedule_orders;
49 
50 
51 PROCEDURE execute_command (p_command VARCHAR2,
52 			   p_user_command NUMBER,
53 			   x_msg_data        OUT    NoCopy varchar2,
54 			   x_return_status   OUT    NoCopy varchar2 )
55   IS
56 BEGIN
57 	MSC_BAL_UTILS.execute_command(
58 		p_command,
59                 p_user_command,
60                 x_msg_data,
61                 x_return_status);
62 END execute_command;
63 
64 
65 PROCEDURE extend( p_nodes IN OUT NoCopy seq_alter , extend_amount NUMBER ) IS
66 BEGIN
67 	MSC_BAL_UTILS.extend(p_nodes, extend_amount);
68 END extend;
69 
70 /*
71 PROCEDURE extend( p_nodes IN OUT NoCopy mrp_oe_rec, extend_amount NUMBER ) IS
72 BEGIN
73 	MSC_BAL_UTILS.extend(p_nodes, extend_amount);
74 END extend;
75 
76 PROCEDURE trim( p_nodes IN OUT NoCopy mrp_oe_rec, trim_amount NUMBER ) IS
77 BEGIN
78 	MSC_BAL_UTILS.trim(p_nodes, trim_amount);
79 END trim;
80 */
81 
82 PROCEDURE call_oe_api (p_session_id NUMBER,
83 		       x_msg_count       OUT    NoCopy NUMBER,
84 		       x_msg_data        OUT    NoCopy varchar2,
85 		       x_return_status   OUT    NoCopy varchar2
86 		       )
87   IS
88 BEGIN
89 	MSC_BAL_UTILS.call_oe_api(
90 		p_session_id,
91                 x_msg_count,
92                 x_msg_data,
93                 x_return_status);
94 END call_oe_api;
95 
96 
97 PROCEDURE call_oe_api (p_atp_rec                MRP_ATP_PUB.atp_rec_typ,
98 		       x_msg_count       OUT    NoCopy NUMBER,
99 		       x_msg_data        OUT    NoCopy VARCHAR2,
100 		       x_return_status   OUT    NoCopy VARCHAR2)
101   IS
102 BEGIN
103 	MSC_BAL_UTILS.call_oe_api(
104 		p_atp_rec,
105                 x_msg_count,
106                 x_msg_data,
107                 x_return_status);
108 END call_oe_api;
109 
110 PROCEDURE update_seq(p_session_id               NUMBER,
111 		     p_seq_alter       IN OUT   NoCopy seq_alter,
112 		     x_msg_count       OUT      NoCopy NUMBER,
113 		     x_msg_data        OUT      NoCopy VARCHAR2,
114 		     x_return_status   OUT      NoCopy VARCHAR2)
115   IS
116 BEGIN
117 	MSC_BAL_UTILS.update_seq(
118 		p_session_id,
119                 p_seq_alter,
120                 x_msg_count,
121                 x_msg_data,
122                 x_return_status);
123 END update_seq;
124 
125 END MRP_BAL_UTILS;