1 package msc_hub_calendar as
2 /* $Header: MSCHBCAS.pls 120.6 2008/03/19 07:04:07 prdas noship $ */
3
4
5 function first_work_date(p_calendar_code in varchar2,
6 p_sr_instance_id in number,
7 p_bkt_type in number,
8 p_bkt_start_date date) return date;
9
10 function last_work_date(p_calendar_code in varchar2,
11 p_sr_instance_id in number,
12 p_bkt_type in number,
13 p_bkt_start_date date) return date ;
14
15 function last_work_date(p_plan_id in number,
16 p_sr_instance_id in number,
17 p_bkt_type in number,
18 p_bkt_start_date in date,
19 p_bkt_end_date in date) return date;
20
21 function last_work_date(p_plan_id in number,
22 p_date in date ) return date;
23
24 function ss_date(p_plan_id in number,p_bkt_start_date in date,p_bkt_end_date in date) return date;
25
26 function working_day_bkt_start_date(p_plan_id in number,
27 p_sr_instance_id in number,
28 p_bkt_type in number,
29 p_bkt_start_date in date,
30 p_bkt_end_date in date) return date;
31
32 function get_item_org(p_plan_id in number,p_item_id in number,
33 p_sr_inst_id in number) return number;
34
35 end msc_hub_calendar;