PACKAGE: APPS.MSC_DS_SCHEDULE

Source

1 PACKAGE msc_ds_schedule AUTHID CURRENT_USER AS
2 /* $Header: MSCDSSS.pls 120.0 2005/05/25 17:39:45 appldev noship $  */
3 
4   FIELD_SEPERATOR CONSTANT VARCHAR2(5) := '|';
5   RECORD_SEPERATOR CONSTANT VARCHAR2(5) := '&';
6   FORMAT_MASK CONSTANT VARCHAR2(20) :='MM/DD/YY';
7 
8   TYPE maxCharTbl IS TABLE of varchar2(32000);
9 
10   procedure getScheduleSummary(p_plan_id number, p_cat_set_id number, p_recom_days number,
11     p_late_supply_total out nocopy number, p_res_cons_total out nocopy number,
12     p_mat_cons_total out nocopy number, p_exc_setup_total out nocopy number,
13     p_resched_total out nocopy number, p_release_total out nocopy number);
14 
15   procedure getLateSupplyDetails(p_plan_id number, p_cat_set_id number,
16     p_round_val number, p_name_data in out nocopy msc_ds_schedule.maxCharTbl);
17 
18   procedure getLateSupplySummary(p_plan_id number, p_cat_set_id number,
19     p_round_val number, p_total_supply out nocopy number, p_late_supply out nocopy number,
20     p_avg_days_late out nocopy number, p_past_due_supply out nocopy number);
21 
22   procedure getResUtilSummary(p_plan_id number, p_resource_basis number,
23     p_round_val number, p_actual_util out nocopy number, p_setup_util out nocopy number);
24 
25   procedure getResUtilDetails(p_plan_id number, p_resource_basis number,
26     p_round_val number, p_name_data in out nocopy msc_ds_schedule.maxCharTbl);
27 
28 END msc_ds_schedule;