PACKAGE: APPS.MRP_BAL_UTILS

Source

1 PACKAGE MRP_BAL_UTILS AUTHID CURRENT_USER AS
2 /* $Header: MRPUBALS.pls 120.0 2005/05/25 03:37:59 appldev noship $  */
3 
4 TYPE number_arr IS TABLE OF number;
5 TYPE char18_arr IS TABLE of varchar2(18);
6 TYPE char80_arr IS TABLE of varchar2(80);
7 
8 TYPE mrp_oe_rec IS RECORD (line_id             number_arr:=number_arr(),
9 			   ship_set_id         number_arr:=number_arr(),
10 			   arrival_set_id      number_arr:=number_arr(),
11 			   seq_num             number_arr:=number_arr(),
12                            ato_line_id         number_arr:=number_arr(),
13                            top_model_line_id   number_arr:=number_arr(),
14                            item_type_code      char80_arr:=char80_arr(),
15                            order_number        number_arr:=number_arr());
16 
17 TYPE seq_alter IS RECORD(order_line_id       number_arr:=number_arr(),
18 			 ship_set_id         number_arr:=number_arr(),
19 			 arrival_set_id      number_arr:=number_arr(),
20 			 seq_diff            number_arr:=number_arr(),
21                          seq_num             number_arr:=number_arr(),
22                          orig_seq_num        number_arr:=number_arr());
23 
24 
25 PROCEDURE populate_temp_table (p_session_id   NUMBER,
26 			       p_order_by     VARCHAR2,
27 			       p_where        VARCHAR2,
28 			       p_overwrite    NUMBER,
29 			       p_org_id       NUMBER);
30 
31 PROCEDURE undemand_orders (p_session_id       NUMBER);
32 
33 PROCEDURE schedule_orders (p_session_id             NUMBER,
34 			   x_msg_count       OUT    NoCopy NUMBER,
35 			   x_msg_data        OUT    NoCopy VARCHAR2,
36 			   x_return_status   OUT    NoCopy VARCHAR2);
37 
38 PROCEDURE call_oe_api (p_session_id             NUMBER,
39 		       x_msg_count       OUT    NoCopy NUMBER,
40 		       x_msg_data        OUT    NoCopy VARCHAR2,
41 		       x_return_status   OUT    NoCopy VARCHAR2);
42 
43 PROCEDURE call_oe_api (p_atp_rec                MRP_ATP_PUB.atp_rec_typ,
44 		       x_msg_count       OUT    NoCopy NUMBER,
45 		       x_msg_data        OUT    NoCopy VARCHAR2,
46 		       x_return_status   OUT    NoCopy VARCHAR2);
47 
48 PROCEDURE execute_command (p_command                VARCHAR2,
49 			   p_user_command           NUMBER,
50 			   x_msg_data        OUT    NoCopy VARCHAR2,
51 			   x_return_status   OUT    NoCopy VARCHAR2);
52 
53 PROCEDURE update_seq(p_session_id               NUMBER,
54 		     p_seq_alter       IN OUT   NoCopy seq_alter,
55 		     x_msg_count       OUT      NoCopy NUMBER,
56 		     x_msg_data        OUT      NoCopy VARCHAR2,
57 		     x_return_status   OUT      NoCopy VARCHAR2);
58 
59 PROCEDURE extend( p_nodes IN OUT NoCopy seq_alter , extend_amount NUMBER );
60 
61 
62 END MRP_BAL_UTILS;