DBA Data[Home] [Help]

PACKAGE: APPS.MSC_HUB_CALENDAR

Source


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;