PACKAGE: APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB

Source

1 PACKAGE MSC_SELECT_ALL_FOR_RELEASE_PUB AS
2     /* $Header: MSCSARPS.pls 120.2 2006/03/13 11:55:50 eychen noship $ */
3 
4 	PROCEDURE Update_Implement_Attrib(p_where_clause IN VARCHAR2,
5 					  p_employee_id IN NUMBER,
6 					  p_demand_class IN VARCHAR2,
7 					  p_def_job_class IN VARCHAR2,
8 					  p_def_firm_jobs IN VARCHAR2,
9                                           p_include_so IN VARCHAR2,
10 					  p_total_rows OUT NOCOPY NUMBER,
11 					  p_succ_rows OUT NOCOPY NUMBER,
12 					  p_error_rows OUT NOCOPY NUMBER);
13 
14 
15 	FUNCTION get_alternate_bom(p_plan_id IN number,
16                                    p_sr_instance_id in number ,
17                                    p_proc_seq_id in number ) return varchar2;
18 
19 	FUNCTION get_alternate_rtg(p_plan_id IN number,
20                                    p_sr_instance_id in number ,
21                                    p_proc_seq_id in number ) return varchar2;
22 
23         FUNCTION get_wip_job_prefix(p_sr_instance_id IN number) return varchar2;
24 
25         FUNCTION child_supplies_onhand(p_plan_id number,
26                                    p_transaction_id number) return number;
27 
28         FUNCTION get_implement_as(p_order_type number,
29                           p_org_id number,
30                           p_source_org_id number,
31                           p_supplier_id number,
32                           p_planning_make_buy_code number,
33                           p_build_in_wip_flag number,
34                           p_purchasing_enabled_flag number) return number ;
35 
36 PRAGMA RESTRICT_REFERENCES (get_alternate_rtg, WNDS, WNPS);
37 PRAGMA RESTRICT_REFERENCES (get_alternate_bom, WNDS, WNPS);
38 
39 END MSC_SELECT_ALL_FOR_RELEASE_PUB;