[Home] [Help]
PACKAGE: APPS.MSC_SCH_WB
Source
1 PACKAGE msc_sch_wb AS
2 /* $Header: MSCOSCWS.pls 120.2.12010000.1 2008/11/18 00:34:59 cmsops ship $ */
3
4 -- krajan : 2400676:
5 -- Variable used for propagating error code to UI from View Alloc WB
6 G_ATP_ERROR_CODE NUMBER := 0;
7
8 PROCEDURE get_Supply_Sources_local(
9 x_dblink IN VARCHAR2,
10 x_session_id IN NUMBER,
11 x_sr_instance_id IN NUMBER,
12 x_assignment_set_id IN NUMBER,
13 x_plan_id IN NUMBER,
14 x_calling_inst IN VARCHAR2,
15 x_ret_status OUT NoCopy VARCHAR2,
16 x_error_mesg OUT NoCopy VARCHAR2
17 );
18
19 PROCEDURE GET_ATP_RESULT (
20 x_session_id IN NUMBER,
21 commit_flag IN NUMBER,
22 call_oe IN NUMBER,
23 x_msg_count OUT NoCopy number,
24 x_msg_data OUT NoCopy varchar2,
25 x_return_status OUT NoCopy varchar2,
26 p_diagnostic_atp IN NUMBER DEFAULT 2
27 );
28
29 PROCEDURE cleanup_data (p_session_id in number);
30
31 FUNCTION get_alloc_rule_variables return NUMBER;
32
33 FUNCTION get_label(p_demand_class varchar2) return varchar2;
34
35 PROCEDURE get_atp_rule_name (
36 dblink VARCHAR2,
37 item_id NUMBER,
38 org_id NUMBER,
39 sr_instance_id NUMBER,
40 atp_rule_name OUT NoCopy VARCHAR2,
41 inst VARCHAR2);
42
43 PROCEDURE get_msc_assign_set(x_dblink VARCHAR2,
44 x_assignment_set_id IN OUT NoCopy NUMBER,
45 x_sr_instance_id NUMBER,
46 x_ret_code OUT NoCopy VARCHAR2,
47 x_err_mesg OUT NoCopy VARCHAR2);
48
49 PROCEDURE get_assignment_set (
50 x_dblink VARCHAR2,
51 x_assignment_set_id OUT NoCopy NUMBER,
52 x_assignment_set_name OUT NoCopy VARCHAR2,
53 x_plan_id OUT NoCopy NUMBER,
54 x_plan_name OUT NoCopy VARCHAR2,
55 x_sr_instance_id NUMBER,
56 x_inst VARCHAR2,
57 x_ret_code OUT NoCopy VARCHAR2,
58 x_err_mesg OUT NoCopy VARCHAR2);
59
60 PROCEDURE MRP_TIMING(buf IN VARCHAR2);
61 PROCEDURE atp_debug(buf IN VARCHAR2);
62
63 PROCEDURE get_period_atp_strings(
64 p_is_allocated BOOLEAN,
65 p_session_id NUMBER,
66 p_old_session_id number,
67 p_dmd_flag number,
68 p_end_pegging_id number,
69 p_pegging_id NUMBER,
70 p_organization_id NUMBER,
71 p_sr_instance_id NUMBER,
72 p_inst VARCHAR2,
73 p_supply_str OUT NoCopy VARCHAR2,
74 p_demand_str OUT NoCopy VARCHAR2,
75 p_bkd_demand_str OUT NoCopy VARCHAR2,
76 p_net_atp_str OUT NoCopy VARCHAR2,
77 p_cum_atp_str OUT NoCopy VARCHAR2,
78 p_row_hdr_str OUT NoCopy VARCHAR2,
79 p_date_str OUT NoCopy VARCHAR2,
80 p_week_str OUT NoCopy VARCHAR2,
81 p_period_str OUT NoCopy VARCHAR2
82 );
83
84
85 PROCEDURE calc_exceptions(
86 p_session_id IN NUMBER,
87 x_return_status OUT NoCopy VARCHAR2,
88 x_msg_data OUT NoCopy VARCHAR2,
89 x_msg_count OUT NoCopy NUMBER
90 );
91
92 PROCEDURE pipe_utility(
93 p_session_id IN NUMBER,
94 p_command IN VARCHAR2,
95 p_message IN OUT NoCopy VARCHAR2,
96 p_message_count OUT NoCopy NUMBER,
97 x_return_status OUT NoCopy VARCHAR2,
98 x_msg_data OUT NoCopy VARCHAR2,
99 x_msg_count OUT NoCopy NUMBER
100 );
101
102 PROCEDURE set_session_id(p_session_id IN NUMBER);
103 PROCEDURE get_master_org(p_master_org_id OUT NoCopy NUMBER);
104
105 PROCEDURE delete_lines
106 ( p_session_id NUMBER, p_where_clause varchar2);
107
108 FUNCTION get_supply_demand_source_name
109 (
110 organization_id IN NUMBER,
111 supply_demand_source_type IN NUMBER,
112 supply_demand_source_id IN NUMBER
113 ) RETURN VARCHAR2;
114
115 PRAGMA RESTRICT_REFERENCES (get_supply_demand_source_name, WNDS);
116
117 PROCEDURE extend_other_cols(x_other_cols IN OUT NoCopy order_sch_wb.other_cols_typ,
118 amount NUMBER);
119
120 PROCEDURE commit_db;
121 PROCEDURE get_profile(profile_name VARCHAR2, profile_value OUT NoCopy NUMBER);
122
123 PROCEDURE get_session_id(p_db_link in varchar2 default NULL,p_session_id out NoCopy varchar2 ) ;
124
125 -- 2400676: krajan
126 -- Returns the global aTp error code to UI for view_allocation fix.
127 PROCEDURE get_g_atp_error_code(x_atp_err_code OUT NoCopy NUMBER);
128 PROCEDURE update_constraint_path(p_session_id IN NUMBER,
129 p_return_error IN OUT NoCopy VARCHAR2);
130
131
132 PROCEDURE get_ato_comp_details(p_session_id IN NUMBER,
133 p_child_ato_id IN NUMBER,
134 p_organization_id IN NUMBER,
135 x_days_late IN OUT NoCopy NUMBER,
136 x_error_code IN OUT NoCopy VARCHAR2);
137
138 END msc_sch_wb;