DBA Data[Home] [Help]

APPS.ORDER_SCH_WB dependencies on MSC_SCH_WB

Line 15: MSC_SCH_WB.GET_ATP_RESULT (

11: x_return_status OUT NoCopy VARCHAR2
12: )
13: IS
14: BEGIN
15: MSC_SCH_WB.GET_ATP_RESULT (
16: x_session_id,
17: commit_flag,
18: call_oe,
19: x_msg_count,

Line 38: MSC_SCH_WB.delete_lines(p_session_id, p_where_clause);

34: PROCEDURE delete_lines
35: ( p_session_id NUMBER,
36: p_where_clause varchar2) IS
37: BEGIN
38: MSC_SCH_WB.delete_lines(p_session_id, p_where_clause);
39:
40: END delete_lines;
41:
42: PROCEDURE get_supply_sources_local(

Line 53: MSC_SCH_WB.get_supply_sources_local(

49: x_ret_status OUT NoCopy VARCHAR2,
50: x_error_mesg OUT NoCopy VARCHAR2)
51: IS
52: BEGIN
53: MSC_SCH_WB.get_supply_sources_local(
54: x_dblink,
55: x_session_id,
56: x_sr_instance_id,
57: x_assignment_set_id,

Line 74: MSC_SCH_WB.get_atp_rule_name (

70: atp_rule_name OUT NoCopy VARCHAR2,
71: inst VARCHAR2)
72: IS
73: BEGIN
74: MSC_SCH_WB.get_atp_rule_name (
75: dblink,
76: item_id,
77: org_id,
78: sr_instance_id,

Line 97: MSC_SCH_WB.get_assignment_set (

93: x_ret_code OUT NoCopy VARCHAR2,
94: x_err_mesg OUT NoCopy VARCHAR2)
95: IS
96: BEGIN
97: MSC_SCH_WB.get_assignment_set (
98: x_dblink,
99: x_assignment_set_id,
100: x_assignment_set_name,
101: x_plan_id,

Line 115: MSC_SCH_WB.atp_debug(buf);

111: END get_assignment_set;
112:
113: PROCEDURE atp_debug(buf IN VARCHAR2) IS
114: BEGIN
115: MSC_SCH_WB.atp_debug(buf);
116: END atp_debug;
117:
118: PROCEDURE MRP_TIMING(buf IN VARCHAR2)
119: IS

Line 121: MSC_SCH_WB.mrp_timing(buf);

117:
118: PROCEDURE MRP_TIMING(buf IN VARCHAR2)
119: IS
120: BEGIN
121: MSC_SCH_WB.mrp_timing(buf);
122: EXCEPTION
123: WHEN OTHERS THEN
124: --dbms_output.put_line('Exception in mrp_timing '||Sqlerrm);
125: return;

Line 150: MSC_SCH_WB.get_period_atp_strings(

146: p_week_str OUT NoCopy VARCHAR2,
147: p_period_str OUT NoCopy VARCHAR2
148: ) is
149: BEGIN
150: MSC_SCH_WB.get_period_atp_strings(
151: p_is_allocated,
152: p_session_id,
153: p_old_session_id,
154: p_dmd_flag,

Line 172: msc_sch_wb.atp_debug('get_period_atp_strings: ' || ' excp in get_period_strings '||substr(Sqlerrm, 1, 100));

168: p_period_str);
169: EXCEPTION
170: WHEN OTHERS THEN
171: IF order_sch_wb.mr_debug in ('Y', 'C') THEN
172: msc_sch_wb.atp_debug('get_period_atp_strings: ' || ' excp in get_period_strings '||substr(Sqlerrm, 1, 100));
173: END IF;
174: END get_period_atp_strings;
175:
176: PROCEDURE calc_exceptions(

Line 185: MSC_SCH_WB.calc_exceptions(

181: )
182: IS
183: PRAGMA AUTONOMOUS_TRANSACTION;
184: BEGIN
185: MSC_SCH_WB.calc_exceptions(
186: p_session_id,
187: x_return_status,
188: x_msg_data,
189: x_msg_count);

Line 204: RETURN MSC_SCH_WB.get_supply_demand_source_name (

200: supply_demand_source_type IN NUMBER,
201: supply_demand_source_id IN NUMBER
202: ) RETURN VARCHAR2 IS
203: BEGIN
204: RETURN MSC_SCH_WB.get_supply_demand_source_name (
205: organization_id,
206: supply_demand_source_type,
207: supply_demand_source_id);
208:

Line 225: MSC_SCH_WB.pipe_utility(

221: ret NUMBER;
222: empty_pipe EXCEPTION;
223: PRAGMA EXCEPTION_INIT (EMPTY_PIPE, -6556);
224: BEGIN
225: MSC_SCH_WB.pipe_utility(
226: p_session_id,
227: p_command,
228: p_message,
229: p_message_count,

Line 247: MSC_SCH_WB.set_session_id(p_session_id);

243:
244: PROCEDURE set_session_id(p_session_id IN NUMBER)
245: IS
246: BEGIN
247: MSC_SCH_WB.set_session_id(p_session_id);
248: END set_session_id;
249:
250: PROCEDURE extend_other_cols(x_other_cols IN OUT NoCopy other_cols_typ, amount NUMBER)
251: IS

Line 253: MSC_SCH_WB.extend_other_cols(x_other_cols, amount);

249:
250: PROCEDURE extend_other_cols(x_other_cols IN OUT NoCopy other_cols_typ, amount NUMBER)
251: IS
252: BEGIN
253: MSC_SCH_WB.extend_other_cols(x_other_cols, amount);
254: END extend_other_cols;
255:
256: PROCEDURE commit_db IS
257: BEGIN

Line 264: MSC_SCH_WB.get_master_org(p_master_org_id);

260:
261: PROCEDURE get_master_org(p_master_org_id OUT NoCopy NUMBER)
262: IS
263: BEGIN
264: MSC_SCH_WB.get_master_org(p_master_org_id);
265: END get_master_org;
266:
267: PROCEDURE get_profile(profile_name VARCHAR2, profile_value OUT NoCopy NUMBER)
268: IS

Line 270: MSC_SCH_WB.get_profile(profile_name, profile_value);

266:
267: PROCEDURE get_profile(profile_name VARCHAR2, profile_value OUT NoCopy NUMBER)
268: IS
269: BEGIN
270: MSC_SCH_WB.get_profile(profile_name, profile_value);
271: END get_profile;
272:
273: END ORDER_SCH_WB;