1 PACKAGE WIP_TIME_ENTRY_PUB AS
2 /* $Header: wipwsils.pls 120.2 2008/01/22 04:35:16 sisankar noship $ */
3
4 type t_wip_time_intf is table of wip_time_entry_interface%rowtype index by binary_integer;
5
6 procedure process_interface_records(retcode out nocopy number,
7 errbuf out nocopy varchar2,
8 p_organization_id in number);
9
10 procedure get_time_preferences(p_organization_id IN NUMBER default null,
11 x_shift_enabled OUT NOCOPY boolean,
12 x_clock_enabled OUT NOCOPY boolean);
13
14 procedure process(p_wip_time_intf_tbl in t_wip_time_intf,
15 x_ret_status out nocopy number);
16
17 procedure write_to_log(p_interface_id in number,
18 p_error_msg in varchar2,
19 p_stmt_num in number);
20
21 function is_emp_invalid(p_org_id in number,
22 p_dep_id in number,
23 p_res_id in number,
24 p_emp_id in number)
25 return boolean;
26
27 function default_job_id(p_org_id in number,
28 p_job_name in varchar2)
29 return number;
30
31 function is_job_invalid(p_org_id in number,
32 p_we_id in number)
33 return boolean;
34
35 function get_op_dept_id(p_org_id in number,
36 p_we_id in number,
37 p_op_seq in number)
38 return number;
39
40 function default_res_id(p_org_id in number,
41 p_res_name in varchar)
42 return number;
43
44 function is_res_invalid(p_org_id in number,
45 p_dep_id in number,
46 p_res_id in number)
47 return boolean;
48
49 function is_emp_shift_in(p_wip_entity_id in number,
50 p_employee_id in number)
51 return boolean;
52
53 END WIP_TIME_ENTRY_PUB;