1 package HR_SPEC_PKG AUTHID CURRENT_USER as
2 /* $Header: hrspec.pkh 115.1 99/07/17 05:37:08 porting ship $ */
3 ------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1994 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name
11 HR Libraries server-side agent
12 Purpose
13 Agent handles all server-side traffic to and from forms libraries. This
14 is particularly necessary because we wish to avoid the situation where
15 a form and its libraries both refer to the same server-side package.
16 Forms/libraries appears to be unable to cope with this situation in
17 circumstances which we cannot yet define.
18 History
19 21 Apr 95 N Simpson Created
20 17 May 95 N Simpson Added delete_ownerships,
21 insert_ownerships and
22 startup_insert_allowed to
23 remove all sql from client side and
24 thus allow library to be made global
25 06 Sep 95 S Desai Added test_path_to_perbecvd
26 test_path_to_perbeben
27 08 Sep 95 D Kerr Changed datatype of parameter
28 chk_asg_on_payroll from %TYPE to
29 number. Workaround for forms bug.
30 11 Mar 96 D Kerr Added checkformat and changeformat.
31 19 Aug 97 Sxshah Banner now on eack line.
32 21 Aug 97 V Treiger Added procedures per_date_range and
33 asg_date_range
34 21 May 98 D Kerr Added overload version of
35 chk_asg_on_payroll
36 */
37 procedure test_path_to_perwsspp (p_ass_id NUMBER);
38 --
39 procedure chk_asg_on_payroll
40 (p_assignment_id in NUMBER);
41
42 -- This routine is required for bug 620733.
43 procedure chk_asg_on_payroll
44 (p_assignment_id in NUMBER,
45 p_effective_date in DATE);
46 --
47 procedure test_path_to_perbecvd ( p_element_entry_id NUMBER );
48 --
49 procedure test_path_to_perbeben ( p_element_entry_id NUMBER );
50 --
51 procedure delete_ownerships (p_key_name varchar2, p_key_value number);
52 procedure insert_ownerships (p_session_id number, p_key_name varchar2, p_key_value number);
53 function startup_insert_allowed (p_session_id number) return boolean;
54 --
55 -- From hr_chkfmt
56 --
57 procedure checkformat
58 ( value in out varchar2,
59 format in varchar2,
60 output in out varchar2,
61 minimum in varchar2,
62 maximum in varchar2,
63 nullok in varchar2,
64 rgeflg in out varchar2,
65 curcode in varchar2
66 ) ;
67 --
68 procedure changeformat
69 ( input in varchar2,
70 output out varchar2,
71 format in varchar2,
72 curcode in varchar2
73 ) ;
74 --
75 procedure per_date_range
76 ( p_person_id in number,
77 p_date_from in out date,
78 p_date_to in out date
79 ) ;
80 --
81 procedure asg_date_range
82 ( p_assignment_id in number,
83 p_date_from in out date,
84 p_date_to in out date
85 ) ;
86 --
87 end hr_spec_pkg;
[Home] [Help]