PACKAGE: APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB

Source

1 PACKAGE MSC_SELECT_ALL_FOR_RELEASE_PUB AUTHID CURRENT_USER AS
2     /* $Header: MSCSARPS.pls 120.5 2011/07/19 23:51:39 cnazarma ship $ */
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                                           p_current_plan_type IN NUMBER DEFAULT NULL,
14                                           x_plan_id IN NUMBER DEFAULT NULL);
15 
16 
17 	FUNCTION get_alternate_bom(p_plan_id IN number,
18                                    p_sr_instance_id in number ,
19                                    p_proc_seq_id in number ) return varchar2;
20 
21 	FUNCTION get_alternate_rtg(p_plan_id IN number,
22                                    p_sr_instance_id in number ,
23                                    p_proc_seq_id in number ) return varchar2;
24 
25         FUNCTION get_wip_job_prefix(p_sr_instance_id IN number) return varchar2;
26 
27         FUNCTION child_supplies_onhand(p_plan_id number,
28                                    p_transaction_id number) return number;
29 
30         FUNCTION get_implement_as(p_order_type number,
31                           p_org_id number,
32                           p_source_org_id number,
33                           p_supplier_id number,
34                           p_planning_make_buy_code number,
35                           p_build_in_wip_flag number,
36                           p_purchasing_enabled_flag number,
37                           p_sr_instance_id number,
38                           p_plan_type number,
39                           p_source_table varchar,
40                           p_dest_org_id number,
41                           p_dest_inst_id number) return number ;
42 
43 PRAGMA RESTRICT_REFERENCES (get_alternate_rtg, WNDS, WNPS);
44 PRAGMA RESTRICT_REFERENCES (get_alternate_bom, WNDS, WNPS);
45 
46 END MSC_SELECT_ALL_FOR_RELEASE_PUB;