PACKAGE: APPS.MSC_HUB_CALENDAR

Source

1 package msc_hub_calendar AUTHID CURRENT_USER as
2 /*  $Header: MSCHBCAS.pls 120.7 2011/12/02 17:08:47 lreinhar ship $ */
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 number,
33         p_inventory_item_id number,
34         p_sr_instance_id number,
35         p_def_organization_id number default null)
36     return number;
37 
38 end msc_hub_calendar;