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