[Home] [Help]
PACKAGE: APPS.ORDER_SCH_WB
Source
1 PACKAGE order_sch_wb AUTHID CURRENT_USER AS
2 /* $Header: MRPOSCWS.pls 115.36 2003/08/29 00:29:47 mahamed ship $ */
3
4 mr_debug VARCHAR2(1) := NVL(fnd_profile.value('MSC_ATP_DEBUG'),'N');
5 file_or_terminal NUMBER := 1; -- 2 = dbms_output
6 debug_session_id NUMBER := 0;
7 sys_yes CONSTANT NUMBER := 1;
8 sys_no CONSTANT NUMBER := 2;
9 delim CONSTANT VARCHAR2(1) := fnd_global.local_chr(13);
10 file_dir varchar2(512); -- bug 2124950
11
12 apps CONSTANT VARCHAR2(10) := 'APPS';
13 server CONSTANT VARCHAR2(10) := 'SERVER';
14 mrd_canonical_date CONSTANT VARCHAR2(10) := 'MM/DD/YYYY';
15 mrn_canonical_num CONSTANT VARCHAR2(50) := 'FM999999999999999999999.99999999999999999999';
16
17 BACKLOG_MODE CONSTANT NUMBER := 1;
18 OE_MODE CONSTANT NUMBER := 2;
19 INV_MODE CONSTANT NUMBER := 3;
20
21 TYPE char7_arr IS TABLE of varchar2(7);
22 TYPE char18_arr IS TABLE of varchar2(18);
23 TYPE char80_arr IS TABLE of varchar2(80);
24 TYPE number_arr IS TABLE OF number;
25 TYPE date_arr IS TABLE OF date;
26
27 -- This will be set by the form before the SD_DETAIL
28 -- is queried, and will be updated if it changes
29 parameter_chart_of_accounts_id NUMBER;
30 form_field_c_column1 VARCHAR2(30);
31
32 TYPE other_cols_typ IS RECORD (
33 row_index number_arr:= number_arr(),
34 org_code char7_arr:= char7_arr(),
35 ship_method_text char80_arr:= char80_arr(),
36 vendor_name char80_arr:= char80_arr(),
37 sr_supplier_id number_arr:= number_arr(),
38 vendor_site_name char80_arr:= char80_arr(),
39 sr_supplier_site_id number_arr:= number_arr());
40
41 TYPE mast_typ IS RECORD (
42 rowid_char char18_arr:= char18_arr(),
43 sr_instance_id number_arr:= number_arr(),
44 inventory_item_id number_arr:= number_arr(),
45 organization_id number_arr:= number_arr(),
46 customer_id number_arr:= number_arr(),
47 customer_site_id number_arr:= number_arr()
48 );
49
50 TYPE ATP_Period_String_typ is Record (
51 Total_Supply_Quantity
52 number_arr:= number_arr(),
53 Total_Demand_Quantity
54 number_arr:= number_arr(),
55 Period_Start_Date
56 date_arr:= date_arr(),
57 Period_End_Date
58 date_arr:= date_arr(),
59 Period_Quantity
60 number_arr:= number_arr(),
61 Cumulative_Quantity
62 number_arr:= number_arr(),
63 Bucketed_Quantity
64 number_arr:= number_arr()
65 );
66
67 PROCEDURE get_Supply_Sources_local(
68 x_dblink IN VARCHAR2,
69 x_session_id IN NUMBER,
70 x_sr_instance_id IN NUMBER,
71 x_assignment_set_id IN NUMBER,
72 x_plan_id IN NUMBER,
73 x_calling_inst IN VARCHAR2,
74 x_ret_status OUT NoCopy VARCHAR2,
75 x_error_mesg OUT NoCopy VARCHAR2
76 );
77
78 PROCEDURE GET_ATP_RESULT (
79 x_session_id IN NUMBER,
80 commit_flag IN NUMBER,
81 call_oe IN NUMBER,
82 x_msg_count OUT NoCopy number,
83 x_msg_data OUT NoCopy varchar2,
84 x_return_status OUT NoCopy varchar2
85 );
86
87
88 PROCEDURE get_atp_rule_name (
89 dblink VARCHAR2,
90 item_id NUMBER,
91 org_id NUMBER,
92 sr_instance_id NUMBER,
93 atp_rule_name OUT NoCopy VARCHAR2,
94 inst VARCHAR2);
95
96 PROCEDURE get_assignment_set (
97 x_dblink VARCHAR2,
98 x_assignment_set_id OUT NoCopy NUMBER,
99 x_assignment_set_name OUT NoCopy VARCHAR2,
100 x_plan_id OUT NoCopy NUMBER,
101 x_plan_name OUT NoCopy VARCHAR2,
102 x_sr_instance_id NUMBER,
103 x_inst VARCHAR2,
104 x_ret_code OUT NoCopy VARCHAR2,
105 x_err_mesg OUT NoCopy VARCHAR2);
106
107 PROCEDURE MRP_TIMING(buf IN VARCHAR2);
108 PROCEDURE atp_debug(buf IN VARCHAR2);
109
110 PROCEDURE get_period_atp_strings(
111 p_is_allocated BOOLEAN,
112 p_session_id NUMBER,
113 p_old_session_id number,
114 p_dmd_flag number,
115 p_end_pegging_id number,
116 p_pegging_id NUMBER,
117 p_organization_id NUMBER,
118 p_sr_instance_id NUMBER,
119 p_inst VARCHAR2,
120 p_supply_str OUT NoCopy VARCHAR2,
121 p_demand_str OUT NoCopy VARCHAR2,
122 p_bkd_demand_str OUT NoCopy VARCHAR2,
123 p_net_atp_str OUT NoCopy VARCHAR2,
124 p_cum_atp_str OUT NoCopy VARCHAR2,
125 p_row_hdr_str OUT NoCopy VARCHAR2,
126 p_date_str OUT NoCopy VARCHAR2,
127 p_week_str OUT NoCopy VARCHAR2,
128 p_period_str OUT NoCopy VARCHAR2
129 );
130
131 TYPE excp_rec_typ IS RECORD (
132 exception1 number_arr:=number_arr(),
133 exception2 number_arr:=number_arr(),
134 exception3 number_arr:=number_arr(),
135 exception4 number_arr:=number_arr(),
136 exception5 number_arr:=number_arr(),
137 exception6 number_arr:=number_arr(),
138 exception7 number_arr:=number_arr(),
139 exception8 number_arr:=number_arr(),
140 exception9 number_arr:=number_arr(),
141 exception10 number_arr:=number_arr(),
142 exception11 number_arr:=number_arr(),
143 exception12 number_arr:=number_arr(),
144 exception13 number_arr:=number_arr(),
145 exception14 number_arr:=number_arr(),
146 exception15 number_arr:=number_arr()
147 );
148
149 PROCEDURE calc_exceptions(
150 p_session_id IN NUMBER,
151 x_return_status OUT NoCopy VARCHAR2,
152 x_msg_data OUT NoCopy VARCHAR2,
153 x_msg_count OUT NoCopy NUMBER
154 );
155
156 PROCEDURE pipe_utility(
157 p_session_id IN NUMBER,
158 p_command IN VARCHAR2,
159 p_message IN OUT NoCopy VARCHAR2,
160 p_message_count OUT NoCopy NUMBER,
161 x_return_status OUT NoCopy VARCHAR2,
162 x_msg_data OUT NoCopy VARCHAR2,
163 x_msg_count OUT NoCopy NUMBER
164 );
165
166 PROCEDURE set_session_id(p_session_id IN NUMBER);
167
168 PROCEDURE get_master_org(p_master_org_id OUT NoCopy NUMBER);
169
170 PROCEDURE delete_lines
171 ( p_session_id NUMBER, p_where_clause varchar2);
172
173 FUNCTION get_supply_demand_source_name
174 (
175 organization_id IN NUMBER,
176 supply_demand_source_type IN NUMBER,
177 supply_demand_source_id IN NUMBER
178 ) RETURN VARCHAR2;
179
180 PRAGMA RESTRICT_REFERENCES (get_supply_demand_source_name, WNDS);
181
182 PROCEDURE extend_other_cols(x_other_cols IN OUT NoCopy other_cols_typ,
183 amount NUMBER);
184
185 PROCEDURE commit_db;
186 PROCEDURE get_profile(profile_name VARCHAR2, profile_value OUT NoCopy NUMBER);
187
188 END order_sch_wb;