1 PACKAGE hri_opl_wrkfc_evt_type AUTHID CURRENT_USER AS
2 /* $Header: hriowevtdim.pkh 120.1.12000000.2 2007/04/12 13:23:13 smohapat noship $ */
3
4 TYPE evtypcmb_rec_type IS RECORD
5 (evtypcmb_code VARCHAR2(240)
6 ,assgnmnt_chng_flag_code VARCHAR2(30)
7 ,salary_chng_flag_code VARCHAR2(30)
8 ,prfrtng_chng_flag_code VARCHAR2(30)
9 ,perfband_chng_flag_code VARCHAR2(30)
10 ,powband_chng_flag_code VARCHAR2(30)
11 ,hdc_gain_flag_code VARCHAR2(30)
12 ,hdc_loss_flag_code VARCHAR2(30)
13 ,hdc_chng_flag_code VARCHAR2(30)
14 ,fte_gain_flag_code VARCHAR2(30)
15 ,fte_loss_flag_code VARCHAR2(30)
16 ,fte_chng_flag_code VARCHAR2(30)
17 ,grd_chng_flag_code VARCHAR2(30)
18 ,job_chng_flag_code VARCHAR2(30)
19 ,pos_chng_flag_code VARCHAR2(30)
20 ,loc_chng_flag_code VARCHAR2(30)
21 ,org_chng_flag_code VARCHAR2(30)
22 ,mgrh_chng_flag_code VARCHAR2(30)
23 ,hire_flag_code VARCHAR2(30)
24 ,asg_start_flag_code VARCHAR2(30)
25 ,hire_or_start_flag_code VARCHAR2(30)
26 ,term_or_end_flag_code VARCHAR2(30)
27 ,term_vol_flag_code VARCHAR2(30)
28 ,term_invol_flag_code VARCHAR2(30)
29 ,term_flag_code VARCHAR2(30)
30 ,asg_end_flag_code VARCHAR2(30)
31 ,start_sspnsn_flag_code VARCHAR2(30)
32 ,end_sspnsn_flag_code VARCHAR2(30)
33 ,prmtn_flag_code VARCHAR2(30));
34
35 PROCEDURE truncate_evtypcmb_table;
36
37 FUNCTION get_evtypcmb_fk
38 (p_assignment_change_ind IN NUMBER
39 ,p_salary_change_ind IN NUMBER
40 ,p_perf_rating_change_ind IN NUMBER
41 ,p_perf_band_change_ind IN NUMBER
42 ,p_pow_band_change_ind IN NUMBER
43 ,p_headcount_gain_ind IN NUMBER
44 ,p_headcount_loss_ind IN NUMBER
45 ,p_fte_gain_ind IN NUMBER
46 ,p_fte_loss_ind IN NUMBER
47 ,p_grade_change_ind IN NUMBER
48 ,p_job_change_ind IN NUMBER
49 ,p_position_change_ind IN NUMBER
50 ,p_location_change_ind IN NUMBER
51 ,p_organization_change_ind IN NUMBER
52 ,p_supervisor_change_ind IN NUMBER
53 ,p_worker_hire_ind IN NUMBER
54 ,p_post_hire_asgn_start_ind IN NUMBER
55 ,p_pre_sprtn_asgn_end_ind IN NUMBER
56 ,p_term_voluntary_ind IN NUMBER
57 ,p_term_involuntary_ind IN NUMBER
58 ,p_worker_term_ind IN NUMBER
59 ,p_start_sspnsn_ind IN NUMBER
60 ,p_end_sspnsn_ind IN NUMBER
61 ,p_promotion_ind IN NUMBER)
62 RETURN NUMBER;
63
64 END hri_opl_wrkfc_evt_type;