PACKAGE: APPS.MSC_BAL_UTILS

Source

1 PACKAGE MSC_BAL_UTILS AUTHID CURRENT_USER AS
2 /* $Header: MSCUBALS.pls 120.3 2007/12/14 07:36:03 sbnaik ship $  */
3 
4 /*
5 TYPE number_arr IS TABLE OF number;
6 TYPE char18_arr IS TABLE of varchar2(18);
7 
8 TYPE mrp_oe_rec IS RECORD (line_id             number_arr,
9 			   ship_set_id         number_arr,
10 			   arrival_set_id      number_arr,
11 			   seq_num             number_arr);
12 
13 TYPE seq_alter IS RECORD(order_line_id       number_arr,
14 			 ship_set_id         number_arr,
15 			 arrival_set_id      number_arr,
16 			 seq_diff            number_arr);
17 */
18 
19 
20 --bwb
21 TYPE number_arr IS TABLE OF number;
22 
23 g_om_status varchar2(20);
24 g_om_req_id NUMBER;
25 
26 TYPE ATP_QTY_ORDERED_TYP is RECORD (
27 quantity_ordered  number_arr := number_arr(),
28 order_line_id     number_arr := number_arr(),
29 session_id        number_arr := number_arr()
30   );
31 
32 PROCEDURE populate_temp_table (p_session_id   NUMBER,
33 			       p_order_by     VARCHAR2,
34 			       p_where        VARCHAR2,
35 			       p_overwrite    NUMBER,
36 			       p_org_id       NUMBER,
37                                p_exclude_picked NUMBER DEFAULT 0);
38 
39 PROCEDURE cmt_schedule(   p_user_id         IN            NUMBER,
40                           p_resp_id         IN            NUMBER,
41                           p_appl_id         IN            NUMBER,
42                           p_session_id      IN            NUMBER,
43                           x_msg_count       OUT    NoCopy NUMBER,
44                           x_msg_data        OUT    NoCopy varchar2,
45                           x_return_status   OUT    NoCopy varchar2,
46                           p_tcf BOOLEAN default TRUE);
47 
48 
49 PROCEDURE undemand_orders (p_session_id                    NUMBER,
50                            x_msg_count      IN  OUT    NoCopy NUMBER ,
51                            x_msg_data       IN  OUT    NoCopy VARCHAR2 ,
52                            x_return_status  IN  OUT    NoCopy VARCHAR2);
53 
54 PROCEDURE  update_schedule_qties(p_atp_qty_ordered_temp IN MSC_BAL_UTILS.ATP_QTY_ORDERED_TYP,
55                         p_return_status out nocopy VARCHAR2,
56                         p_error_message out nocopy VARCHAR2 );
57 
58 PROCEDURE reschedule(p_session_id NUMBER,
59                            x_msg_count       OUT    NoCopy NUMBER,
60                            x_msg_data        OUT    NoCopy varchar2,
61                            x_return_status   OUT    NoCopy varchar2,
62                            p_tcf BOOLEAN default TRUE) ;
63 
64 PROCEDURE schedule_orders (p_session_id             NUMBER,
65 			   x_msg_count       OUT    NoCopy NUMBER,
66 			   x_msg_data        OUT    NoCopy VARCHAR2,
67 			   x_return_status   OUT    NoCopy VARCHAR2,
68                            p_tcf BOOLEAN default TRUE);
69 
70 PROCEDURE call_oe_api (p_session_id             NUMBER,
71 		       x_msg_count       OUT    NoCopy NUMBER,
72 		       x_msg_data        OUT    NoCopy VARCHAR2,
73 		       x_return_status   OUT    NoCopy VARCHAR2);
74 
75 PROCEDURE call_oe_api (p_atp_rec                MRP_ATP_PUB.atp_rec_typ,
76 		       x_msg_count       OUT    NoCopy NUMBER,
77 		       x_msg_data        OUT    NoCopy VARCHAR2,
78 		       x_return_status   OUT    NoCopy VARCHAR2);
79 
80 PROCEDURE execute_command (p_command                VARCHAR2,
81 			   p_user_command           NUMBER,
82 			   x_msg_data        OUT    NoCopy VARCHAR2,
83 			   x_return_status   OUT    NoCopy VARCHAR2);
84 
85 PROCEDURE update_seq(p_session_id               NUMBER,
86 		     p_seq_alter       IN OUT   NoCopy MRP_BAL_UTILS.seq_alter,
87 		     x_msg_count       OUT      NoCopy NUMBER,
88 		     x_msg_data        OUT      NoCopy VARCHAR2,
89 		     x_return_status   OUT      NoCopy VARCHAR2);
90 
91 PROCEDURE extend( p_nodes IN OUT NoCopy MRP_BAL_UTILS.seq_alter , extend_amount NUMBER );
92 
93 
94 
95 END MSC_BAL_UTILS;