1 PACKAGE MSC_PLAN_RELEASE AUTHID CURRENT_USER AS
2 -- $Header: MSCPLRLS.pls 120.0.12020000.2 2012/10/30 21:25:28 cnazarma noship $
3 PROCEDURE do_release_test(pid IN Number,psid in number,
4 p_user_id in number,
5 p_resp_id in number,
6 p_appl_id in number,
7 p_query_id IN OUT nocopy number,
8 p_return_msg IN OUT nocopy varchar,
9 p_return_status IN OUT nocopy number);
10
11 PROCEDURE validate_release(pid IN NUMBER,
12 p_return_status IN OUT NOCOPY number,
13 p_return_msg IN OUT NOCOPY varchar);
14
15
16
17
18
19 PROCEDURE do_release(pid IN Number,
20 psid in number,
21 p_user_id in number,
22 p_resp_id in number,
23 p_appl_id in number,
24 p_query_id IN OUT nocopy number,
25 p_return_msg IN OUT nocopy varchar,
26 p_return_status IN OUT nocopy number);
27 FUNCTION get_instance_release_status(p_sr_instance_id number)
28 return number;
29 FUNCTION get_implement_dock_date(p_plan_id in number,
30 p_inst_id in number,
31 p_org_id in number,
32 p_item_id in number,
33 p_receiving_calendar in varchar2,
34 p_implement_date in date) return date;
35
36 FUNCTION get_implement_ship_date(p_plan_id in number,
37 p_inst_id in number,
38 p_org_id in number,
39 p_order_type in number,
40 p_source_sr_instance_id in number,
41 p_source_org_id in number,
42 p_sourcre_vendor_site_id in number,
43 p_ship_method in varchar2,
44 p_intransit_calendar in varchar2,
45 p_ship_calendar in varchar2,
46 p_implement_dock_date in date,
47 p_source_table in varchar2) return date;
48
49
50 FUNCTION GET_WIP_JOB_PREFIX(p_instance_id in number) return varchar2;
51 Function get_Imp_Employee_id(
52 p_plan_id in number,
53 p_org_id in number,
54 p_inst_id in number,
55 p_item_id in number,
56 p_planner_code in varchar2) return number;
57
58 FUNCTION Check_Source_Supp_Org (
59 p_inst_id in number,
60 p_org_id in number) return number;
61
62
63 FUNCTION validate_order_for_release(
64 p_plan_id in number,
65 p_inst_id in number,
66 p_org_id in number,
67 p_org_code in varchar2,
68 p_item_id in number,
69 p_vmi in number,
70 p_source_Table in varchar2,
71 p_transaction_id in number,
72 p_order_type in number,
73 p_source_org_id in number,
74 P_bom_item_type in number,
75 p_release_time_fence_code in number,
76 p_in_source_plan in number,
77 p_build_in_wip_flag in number,
78 p_purchasing_enabled_flag in number,
79 p_planning_make_buy_code in number,
80 p_planner_code in varchar2,
81 p_implement_alternate_routing in varchar2,
82 p_user_id in number,
83 p_resp_id in number,
84 p_appl_id in number) return varchar2;
85
86 FUNCTION GET_ACTION (arg_source_table IN VARCHAR2,
87 arg_plan_id IN NUMBER ,
88 arg_sr_instance_id in number,
89 arg_org_id in number,
90 arg_item_id in number,
91 arg_bom_item_type IN NUMBER ,
92 arg_base_item_id IN NUMBER ,
93 arg_wip_supply_type IN NUMBER ,
94 arg_order_type IN NUMBER ,
95 arg_rescheduled_flag IN NUMBER,
96 arg_disposition_status_type IN NUMBER ,
97 arg_new_due_date IN DATE ,
98 arg_old_due_date IN DATE ,
99 arg_implemented_quantity IN NUMBER ,
100 arg_quantity_in_process IN NUMBER ,
101 arg_quantity_rate IN NUMBER ,
102 arg_release_time_fence_code IN NUMBER ,
103 arg_reschedule_days IN NUMBER ,
104 arg_firm_quantity IN NUMBER ,
105 arg_mrp_planning_code IN NUMBER,
106 arg_lots_exist IN NUMBER
107 ) RETURN varchar2;
108
109
110 FUNCTION get_Implement_Location_Id(p_inst_id in number,
111 p_org_id in number) return number;
112
113
114 FUNCTION GET_IMPLEMENT_WIP_CLASS_CODE(
115 p_plan_id in number,
116 p_instance_id in number,
117 p_org_id in number,
118 p_item_id in number,
119 p_transaction_id in number,
120 p_order_type in number,
121 p_project_id in number,
122 p_implement_project_id in number,
123 p_implement_as in number,
124 p_implement_alternate_routing in varchar2) return varchar2;
125
126 PROCEDURE PRINT_DEBUG(MSG IN VARCHAR2);
127 --procedure validate_icx_session(p_icx_cookie in varchar2,p_function varchar2) ;
128 procedure validate_icx_session(p_icx_cookie in varchar2,p_function in varchar2 DEFAULT NULL);
129 FUNCTION GET_RP_PLAN_PROFILE_VALUE(P_PLAN_ID IN NUMBER,
130 P_PROFILE_CODE IN VARCHAR2) RETURN VARCHAR2;
131
132 Function GET_REQUEST_STATUS (
133 request_id IN OUT nocopy number,
134 application IN varchar2 default NULL,
135 program IN varchar2 default NULL,
136 phase OUT nocopy varchar2 ,
137 status OUT nocopy varchar2 ,
138 dev_phase OUT nocopy varchar2,
139 dev_status OUT nocopy varchar2,
140 message OUT nocopy varchar2) return number;
141
142 Function test_permission(pname in varchar2) return number;
143 Function save_user_profile(name in varchar2, value in varchar2) return number;
144
145 PROCEDURE batch_replan_launch(p_plan_id varchar2, l_request_id out nocopy varchar2);
146
147 END MSC_PLAN_RELEASE;
[Home] [Help]