DBA Data[Home] [Help]

PACKAGE: APPS.GHR_UPD_HR_VALIDATION

Source


1 PACKAGE ghr_upd_hr_validation AUTHID CURRENT_USER AS
2 /* $Header: ghuhrval.pkh 120.1.12000000.1 2007/01/18 14:19:57 appldev noship $ */
3 
4   g_package       constant varchar2(33) := 'ghr_upd_hr_validation.';
5   --
6 
7   form_item_name    VARCHAR2(61); -- This will be the block_name.item_name
8   --
9   FUNCTION get_form_item_name
10     RETURN VARCHAR2;
11   --
12   PROCEDURE set_form_item_name(p_value IN VARCHAR2);
13   --
14   PROCEDURE main_validation(p_pa_requests_type            IN ghr_pa_requests%ROWTYPE
15                          ,p_asg_non_sf52_type           IN ghr_api.asg_non_sf52_type
16                          ,p_asg_nte_dates_type          IN ghr_api.asg_nte_dates_type
17                          ,p_per_group1_type             IN ghr_api.per_group1_type
18                          ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
19                          ,p_per_retained_grade_type     IN ghr_api.per_retained_grade_type
20                          ,p_per_sep_retire_type         IN ghr_api.per_sep_retire_type
21                          ,p_per_probations_type         IN ghr_api.per_probations_type
22                          ,p_pos_grp1_type               IN ghr_api.pos_grp1_type
23                          ,p_pos_grp2_type               IN ghr_api.pos_grp2_type
24                          ,p_within_grade_increase_type  IN ghr_api.within_grade_increase_type
25                          ,p_government_awards_type      IN ghr_api.government_awards_type
26                          ,p_government_payroll_type     IN ghr_api.government_payroll_type
27                          ,p_performance_appraisal_type  IN ghr_api.performance_appraisal_type
28                          ,p_recruitment_bonus_type      IN ghr_api.recruitment_bonus_type
29                          ,p_relocation_bonus_type       IN ghr_api.relocation_bonus_type
30                          ,p_student_loan_repay_type     IN ghr_api.student_loan_repay_type
31                          --Pradeep
32                          ,p_mddds_special_pay           IN ghr_api.mddds_special_pay_type
33 						 ,p_premium_pay_ind           IN ghr_api.premium_pay_ind_type
34                          ,p_per_conversions_type        IN ghr_api.per_conversions_type
35                          ,p_conduct_performance_type    IN ghr_api.conduct_performance_type
36 						 -- Sundar Bug 4582970 Added for Benefits EIT validation
37 						  ,p_thrift_savings_plan         IN ghr_api.thrift_saving_plan
38 						  ,p_per_benefit_info            IN ghr_api.per_benefit_info_type
39 						  ,p_per_scd_info_type           IN ghr_api.per_scd_info_type
40 
41                            );
42 --
43 FUNCTION get_exemp_award_date(p_pa_request_id IN NUMBER)
44     RETURN DATE;
45 pragma restrict_references (get_exemp_award_date, WNDS, WNPS);
46 
47 --
48 PROCEDURE get_rpa_info(p_pa_request_id IN NUMBER,
49                        p_asg_end_date  OUT NOCOPY  DATE,
50                        p_rpa_eff_date  OUT NOCOPY  DATE,
51                        p_position_id   OUT NOCOPY  NUMBER);
52 
53 --
54 -- --------------------------------------------------------------------------
55 -- ---------------------------< Function: to_posn_not_active>--------------
56 -- --------------------------------------------------------------------------
57   Procedure to_posn_not_active(p_position_id         in number
58                               ,p_effective_date      in date
59                               ,p_hiring_status       OUT NOCOPY varchar
60                               ,p_hiring_status_start_date OUT NOCOPY date);
61 
62 --
63 
64 
65 END ghr_upd_hr_validation;