[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;