1 Package pqh_corps_utility AUTHID CURRENT_USER as
2 /* $Header: pqcpdutl.pkh 120.0 2005/05/29 01:45:02 appldev noship $ */
3
4 Procedure review_submit_valid_corps(p_copy_entity_txn_id IN NUMBER,
5 p_effective_date IN DATE,
6 p_business_group_id IN NUMBER,
7 p_status OUT NOCOPY VARCHAR2);
8
9 Function get_step_name(p_step_id IN Number,
10 p_effective_date IN Date) RETURN varchar2;
11
12 Function get_increased_index(p_gross_index IN NUMBER,
13 p_effective_date IN date) Return Number;
14
15 Function get_salary_rate(p_gross_index IN NUMBER,
16 p_effective_date IN DATE,
17 p_copy_entity_txn_id IN NUMBER DEFAULT NULL,
18 p_currency_code IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;
19
20 Function get_increased_index(p_gross_index IN NUMBER,
21 p_copy_entity_txn_id IN NUMBER) RETURN NUMBER;
22
23 Function get_global_basic_sal_rate(p_effective_date in DATE) RETURN NUMBER;
24
25 Function get_cet_business_area(p_copy_entity_txn_id IN Number) return Varchar2;
26
27 Function get_step_name_for_hgrid(p_step_id IN Number, p_effective_date IN DATE) RETURN VARCHAR2;
28
29 Function get_bg_type_of_ps(p_business_group_id IN NUMBER) RETURN VARCHAR2;
30
31 Function get_cpd_status(p_node_number IN varchar2,
32 p_copy_entity_txn_id IN NUMBER) RETURN VARCHAR2;
33
34 Function chk_steps_exist_for_index(p_gross_index IN NUMBER) RETURN VARCHAR2;
35
36 FUNCTION bus_area_pgm_entity_exist(p_bus_area_cd IN Varchar2,
37 P_pgm_id IN NUMBER)
38 RETURN varchar2;
39
40 FUNCTION chk_primary_prof_field(p_corps_definition_id IN NUMBER
41 ,p_field_of_prof_activity_id IN NUMBER)
42 RETURN VARCHAR2;
43 FUNCTION chk_corps_info_exists(p_corps_definition_id IN NUMBER
44 ,p_information_type IN VARCHAR2)
45 RETURN VARCHAR2;
46
47 FUNCTION get_corps_name(p_corps_definition_id IN VARCHAR2) Return Varchar2;
48
49 FUNCTION los_in_months(p_los_years IN Number,
50 p_los_months IN Number,
51 p_los_days IN Number) Return Number;
52
53 FUNCTION get_from_step_name( p_step_cer_id IN Number,
54 p_copy_entity_txn_id IN Number) Return Varchar2;
55
56 Procedure update_or_delete_crpath ( p_crpath_cer_id IN Number,
57 p_effective_date IN Date,
58 p_dml_operation IN Varchar2);
59
60 Function decode_stage_entity(p_copy_entity_txn_id IN NUMBER,
61 p_table_alias IN VARCHAR2,
62 p_copy_entity_result_id IN NUMBER) RETURN VARCHAR2;
63
64 FUNCTION is_career_def_exist(p_Copy_Entity_txn_Id IN NUMBER,
65 p_mirror_src_entity_rslt_id IN Number,
66 p_from_step_id IN NUMBER,
67 p_to_corps_id IN Number,
68 p_to_grade_id In Number,
69 p_to_step_id In Number ,
70 p_copy_entity_result_id In Number) RETURN VARCHAR2;
71
72 FUNCTION get_pgm_id (p_corps_definition_id IN NUMBER) RETURN NUMBER;
73
74
75 function get_date_of_placement(p_career_level in varchar2, p_assignment_id in number,
76 p_career_level_id in number)
77 return date;
78
79 FUNCTION get_gross_index (p_step_id IN NUMBER, p_effective_date IN DATE)
80 RETURN NUMBER;
81 Function get_postStyle_of_grdldr(p_txn_id in varchar2) return varchar2;
82
83 End pqh_corps_utility;