1 PACKAGE HRI_OPL_ASGN_EVENTS AUTHID CURRENT_USER AS
2 /* $Header: hrioaevt.pkh 120.1.12000000.2 2007/04/12 12:09:27 smohapat noship $ */
3 --
4 -- Exceptions raised when there is a problem with a fast formula
5 --
6 ff_not_compiled EXCEPTION;
7 --
8 -- Public type declarations
9 --
10 -- Assignment change record
11 --
12 TYPE g_asg_change_rec_type IS RECORD
13 (change_date DATE
14 ,change_end_date DATE
15 ,hire_date DATE
16 ,termination_date DATE
17 ,assignment_id NUMBER
18 ,person_id NUMBER
19 ,business_group_id NUMBER
20 ,organization_id NUMBER
21 ,location_id NUMBER
22 ,job_id NUMBER
23 ,grade_id NUMBER
24 ,position_id NUMBER
25 ,supervisor_id NUMBER
26 ,payroll_id NUMBER
27 ,pay_basis_id NUMBER
28 ,prsntyp_sk_fk NUMBER
29 ,summarization_rqd_ind NUMBER
30 ,pow_start_date_adj DATE
31 ,primary_flag VARCHAR2(30)
32 ,type VARCHAR2(30)
33 ,leaving_reason_code VARCHAR2(30)
34 ,change_reason_code VARCHAR2(30)
35 ,status_code VARCHAR2(30)
36 ,wkth_wktyp_code VARCHAR2(30));
37 --
38 -- Salary change record
39 --
40 TYPE g_sal_change_rec_type IS RECORD
41 (effective_start_date DATE
42 ,effective_end_date DATE
43 ,anl_slry NUMBER
44 ,pay_proposal_id NUMBER
45 ,anl_slry_currency VARCHAR2(30));
46 --
47 -- Performance band change record
48 --
49 TYPE g_perf_change_rec_type IS RECORD
50 (effective_start_date DATE
51 ,effective_end_date DATE
52 ,nrmlsd_rating NUMBER
53 ,band NUMBER
54 ,review_id NUMBER
55 ,review_type_cd VARCHAR2(30)
56 ,rating_cd VARCHAR2(30));
57 --
58 -- Simple table types.
59 --
60 TYPE g_date_tab_type IS TABLE OF DATE
61 INDEX BY BINARY_INTEGER;
62 TYPE g_number_tab_type IS TABLE OF NUMBER
63 INDEX BY BINARY_INTEGER;
64 TYPE g_varchar2_tab_type IS TABLE OF VARCHAR2(30)
65 INDEX BY BINARY_INTEGER;
66 TYPE g_varchar2_240_tab_type IS TABLE OF VARCHAR2(240)
67 INDEX BY BINARY_INTEGER;
68 --
69 -- Assignment change table
70 --
71 TYPE g_asg_change_tab_type IS TABLE OF g_asg_change_rec_type
72 INDEX BY BINARY_INTEGER;
73 --
74 -- Salary change table
75 --
76 TYPE g_sal_change_tab_type IS TABLE OF g_sal_change_rec_type
77 INDEX BY BINARY_INTEGER;
78 --
79 -- Performance band change table
80 --
81 TYPE g_perf_change_tab_type IS TABLE OF g_perf_change_rec_type
82 INDEX BY BINARY_INTEGER;
83 --
84 --
85 PROCEDURE shared_hrms_dflt_prcss
86 (errbuf OUT NOCOPY VARCHAR2
87 ,retcode OUT NOCOPY NUMBER
88 ,p_collect_from_date IN VARCHAR2 DEFAULT NULL
89 ,p_collect_to_date IN VARCHAR2 DEFAULT NULL
90 ,p_full_refresh IN VARCHAR2 DEFAULT NULL
91 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
92 ,p_attribute2 IN VARCHAR2 DEFAULT NULL);
93 --
94 PROCEDURE pre_process
95 (p_mthd_action_id IN NUMBER
96 ,p_sqlstr OUT NOCOPY VARCHAR2);
97 --
98 PROCEDURE process_range
99 (errbuf OUT NOCOPY VARCHAR2
100 ,retcode OUT NOCOPY NUMBER
101 ,p_mthd_action_id IN NUMBER
102 ,p_mthd_range_id IN NUMBER
103 ,p_start_object_id IN NUMBER
104 ,p_end_object_id IN NUMBER);
105 --
106 PROCEDURE post_process
107 (p_mthd_action_id IN NUMBER);
108 --
109 PROCEDURE run_for_asg(p_assignment_id IN NUMBER);
110 --
111 END HRI_OPL_ASGN_EVENTS;