DBA Data[Home] [Help]

PACKAGE: APPS.MRP_HORIZONTAL_PLAN_SC

Source


1 PACKAGE MRP_HORIZONTAL_PLAN_SC AUTHID CURRENT_USER AS
2 /* $Header: MRPPHOPS.pls 115.1 2002/11/27 22:50:33 svaidyan ship $ */
3 
4 /* 2663505 - Removed defaulting of arg_current_data, enterprize_view, arg_res_level according to PL/SQL stds. since we always pass these parameters */
5 
6 PROCEDURE populate_horizontal_plan (item_list_id IN NUMBER,
7 			  arg_plan_id IN NUMBER,
8 			  arg_organization_id IN NUMBER,
9 			  arg_compile_designator IN VARCHAR2,
10               arg_plan_organization_id IN NUMBER,
11 			  arg_bucket_type IN NUMBER,
12 			  arg_cutoff_date IN DATE,
13 			  arg_current_data IN NUMBER,
14 			  arg_ind_demand_type IN NUMBER DEFAULT NULL,
15               arg_source_list_name IN VARCHAR2 DEFAULT NULL,
16               enterprize_view IN BOOLEAN,
17 		      arg_res_level IN NUMBER,
18 			  arg_resval1 IN VARCHAR2 DEFAULT NULL,
19 			  arg_resval2 IN NUMBER DEFAULT NULL);
20 
21 FUNCTION      compute_daily_rate_t
22                     (var_calendar_code varchar2,
23                      var_exception_set_id number,
24                      var_daily_production_rate number,
25                      var_quantity_completed number,
26                      fucd date,
27                      var_date date) return number  ;
28 
29     PRAGMA RESTRICT_REFERENCES (compute_daily_rate_t, WNDS,WNPS);
30 
31 END MRP_HORIZONTAL_PLAN_SC;