1 PACKAGE PQH_FR_UTILITY AUTHID CURRENT_USER AS
2 /* $Header: pqfrutil.pkh 120.3.12000000.1 2007/01/16 22:44:08 appldev noship $ */
3
4
5
6 FUNCTION Get_Award_Type(p_person_id Number,
7 p_award_category Varchar2,
8 p_award_type Varchar2) RETURN VARCHAR2;
9 FUNCTION Get_Award_Grade_Level(p_person_id Number,
10 p_award_category Varchar2,
11 p_award_type Varchar2) RETURN VARCHAR2;
12
13 FUNCTION Get_Entitlement_Item(p_business_group_id NUMBER,
14 p_item_type Varchar2) RETURN NUMBER;
15 FUNCTION Check_PS_Installed (p_business_group_id NUMBER) RETURN VARCHAR2;
16 PROCEDURE Get_DateTrack_Mode (p_effective_date IN DATE,
17 p_base_table_name IN VARCHAR2,
18 p_base_key_column IN VARCHAR2,
19 p_base_key_value IN NUMBER,
20 p_datetrack_mode OUT NOCOPY VARCHAR2);
21
22 FUNCTION Get_Accommodation_status (p_accommodation_id IN NUMBER,
23 p_effective_date IN DATE) RETURN VARCHAR2;
24
25 FUNCTION get_lookup_shared_type( p_lookup_type VARCHAR2, p_lookup_code VARCHAR2,
26 p_business_group_id NUMBER, p_return_value VARCHAR2) RETURN VARCHAR2;
27
28 procedure hr_actions_validate_person (p_person_id in number, p_return_status out NOCOPY varchar2,
29 p_effective_date in varchar2,p_function_name in Varchar2);
30
31 procedure admin_effective_warning( p_person_id in number,p_effective_date in varchar2,p_return_status out NOCOPY varchar );
32
33 Function Get_DateTrack_Mode ( p_effective_date IN DATE,
34 p_base_table_name IN VARCHAR2,
35 p_base_key_column IN VARCHAR2,
36 p_base_key_value IN NUMBER) Return varchar2;
37
38 Function Get_available_hours(p_person_id IN NUMBER, p_effective_date in Date) return number;
39
40 Function Get_Salary_Share(p_shard_type_cd IN Varchar2) return VARCHAR2;
41
42 Function Get_contract_reference(p_contract_id in Number, p_effective_date in Date) return varchar2;
43
44
45 Function is_worker_employee(p_person_id in number, p_effective_date in date) return boolean;
46
47 Function is_worker_CWK(p_person_id in number, p_effective_date in date) return boolean;
48
49 PROCEDURE Default_Employment_Terms(p_person_id IN NUMBER,p_emp_type IN VARCHAR2);
50
51 Function is_action_valid(p_function_name IN varchar2, p_person_id in Number,p_effective_date in Date) return varchar2;
52
53 Function get_position_name (p_admin_career_id in Varchar2,p_effective_date in Date) return varchar2;
54
55 Function get_position_id (p_admin_career_id in Varchar2,p_effective_date in Date) return number;
56
57 FUNCTION GET_STEP_RATE (p_step_id IN NUMBER, p_effective_date IN DATE, p_gl_currency IN VARCHAR2) RETURN NUMBER;
58
59 FUNCTION GET_SALARY_RATE(p_assignment_id NUMBER, p_effective_date DATE) RETURN NUMBER;
60
61 FUNCTION GET_DT_DIFF_FOR_DISPLAY(p_start_date IN DATE, p_end_date IN DATE) Return VARCHAR2;
62
63 Function GET_BG_TYPE_OF_PS RETURN VARCHAR2;
64
65 function view_start_date(p_assignment_id in number,
66 p_start_date in date,
67 p_action in varchar2) return date;
68 --
69 --Function to get Proposed End Date for Contract.
70 FUNCTION get_proposed_end_date(p_contract_id IN NUMBER,
71 p_effective_date IN DATE)
72 RETURN DATE;
73 --
74 --Function to check if Working Hours changed or Affectations exist outside new Corp.
75 FUNCTION diff_corps_attributes(p_old_ben_pgm_id IN VARCHAR2,
76 p_new_ben_pgm_id IN VARCHAR2,
77 p_primary_assign_id IN NUMBER,
78 p_effective_date IN DATE)
79 RETURN VARCHAR2;
80 --
81 --Function to check if Working Hours changed for new Establishment.
82 FUNCTION check_work_hrs(p_old_estab_id IN VARCHAR2,
83 p_new_estab_id IN VARCHAR2,
84 p_effective_date IN DATE)
85 RETURN VARCHAR2;
86 --
87 function view_end_date(p_assignment_id in number,
88 p_person_id in number,
89 p_start_date in date,
90 p_action in varchar2) return date;
91
92 FUNCTION diff_corps_positions(p_pos_id IN VARCHAR2,
93 p_primary_assign_id IN NUMBER,
94 p_effective_date IN DATE)
95 RETURN VARCHAR2 ;
96 --
97 --Function to get Org Category Information1 for BG Shared Type.
98 FUNCTION get_ps_org_cat_info(p_person_id NUMBER,
99 p_effective_date DATE) RETURN VARCHAR2;
100
101 --
102 --This function is same as get_lookup_shared_types but because of Web ADI
103 --Integrator Col limitations created this function so as to reduce size of
104 --fn call in query to fit Val_Object_Name Column size for Type_Of_PS LOV.
105 FUNCTION get_ps(p_lookup_code VARCHAR2
106 ,p_return_value VARCHAR2) RETURN VARCHAR2;
107 --
108 FUNCTION get_currency_desc(p_currency_code IN VARCHAR2) RETURN VARCHAR2;
109 --
110 FUNCTION get_owner_desc(p_org_id IN NUMBER
111 ,p_effective_date IN DATE) RETURN VARCHAR2;
112 --
113 FUNCTION get_payment_name(p_business_group_id IN NUMBER
114 ,p_payment_code IN NUMBER) RETURN VARCHAR2;
115 --
116 -- New procedure for mass update of employee assignment form
117 PROCEDURE DELETE_DUPLICATE_ASG_RECORDS (P_COPY_ENTITY_RESULT_ID in NUMBER
118 ,P_COPY_ENTITY_TXN_ID IN NUMBER
119 ,P_RESULT_TYPE_CD in VARCHAR2
120 ,P_INFORMATION2 IN VARCHAR2
121 ,P_INFORMATION67 IN VARCHAR2);
122
123 END PQH_FR_UTILITY;