PACKAGE: APPS.WIP_WS_LABOR_METRIC_PUB

Source

1 PACKAGE WIP_WS_LABOR_METRIC_PUB AS
2 /* $Header: wipwslms.pls 120.3 2007/11/20 05:23:53 hvutukur noship $ */
3 
4 function get_calendar_code(p_organization_id in number)
5 return varchar2;
6 
7 function is_time_uom(p_uom_code in varchar2)
8 return number;
9 
10 function get_period_end(p_calendar_code in varchar2,
11                         p_date in date)
12 return date;
13 
14 function get_period_start(p_org_id in number,
15                           p_date in date)
16 return date;
17 
18 function get_date_for_seq(p_org_id in number,
19                           p_seq_num in number,
20                           p_shift_num in number)
21 return date;
22 
23 function get_date(p_org_id in number,
24                   p_seq_num in number,
25                   p_shift_num in number)
26 return date;
27 
28 function get_index_for_date(p_date in date,
29                             p_organization_id in number,
30                             p_dept_id in number,
31                             p_resource_id in number)
32 return varchar2;
33 
34 procedure handle_error(p_error_msg in varchar2,
35                        p_stmt_num in number,
36                        p_proc_name in varchar2);
37 
38 
39 procedure calculate_metrics(retcode out nocopy number,
40                             errbuf  out nocopy varchar2,
41                             p_organization_id in number);
42 
43 function get_client_date(p_date in Date)
44 return date;
45 
46 END WIP_WS_LABOR_METRIC_PUB;