APPS.MSC_DS_SCHEDULE dependencies on MSC_DS_SCHEDULE

Line 1: PACKAGE BODY msc_ds_schedule AS

1: PACKAGE BODY msc_ds_schedule AS
2: /* $Header: MSCDSSB.pls 120.0 2005/05/25 18:26:26 appldev noship $ */
3:
4: procedure getScheduleSummary(p_plan_id number, p_cat_set_id number, p_recom_days number,
5: p_late_supply_total out nocopy number, p_res_cons_total out nocopy number,

Line 89: p_round_val number, p_name_data in out nocopy msc_ds_schedule.maxCharTbl) is

85:
86: end getLateSupplySummary;
87:
88: procedure getLateSupplyDetails(p_plan_id number, p_cat_set_id number,
89: p_round_val number, p_name_data in out nocopy msc_ds_schedule.maxCharTbl) is
90:
91: cursor c_late_supplies is
92: select to_date(key_date,'J') detail_date,
93: round(nvl(total_supply_count,0), p_round_val) total_supply_count,

Line 149: p_round_val number, p_name_data in out nocopy msc_ds_schedule.maxCharTbl) is

145:
146: end getLateSupplyDetails;
147:
148: procedure getResUtilDetails(p_plan_id number, p_resource_basis number,
149: p_round_val number, p_name_data in out nocopy msc_ds_schedule.maxCharTbl) is
150:
151: cursor c_util_details is
152: select mbrs.resource_date detail_date,
153: round(avg(nvl(mbrs.utilization,0)),p_round_val) run_util,

Line 233: end msc_ds_schedule;

229: fetch c_util_summary into p_actual_util, p_setup_util;
230: close c_util_summary;
231: end getResUtilSummary;
232:
233: end msc_ds_schedule;