[Home] [Help]
PACKAGE: APPS.MRP_BAL_UTILS
Source
1 PACKAGE MRP_BAL_UTILS 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;