1 package pqh_gsp_ben_validations AUTHID CURRENT_USER as
2 /* $Header: pqgspben.pkh 120.0.12010000.1 2008/07/28 12:57:26 appldev ship $ */
3
4 procedure pgm_validations(p_pgm_id in Number,
5 p_dml_operation in Varchar2,
6 p_effective_date in Date,
7 p_business_group_id in Number Default hr_general.GET_BUSINESS_GROUP_ID,
8 p_short_name in Varchar2 Default NULL,
9 p_short_code in Varchar2 Default NULL,
10 p_Dflt_Pgm_Flag in Varchar2 Default 'N',
11 p_Pgm_Typ_Cd in Varchar2 Default NULL,
12 p_pgm_Stat_cd in Varchar2 Default 'I',
13 p_Use_Prog_Points_Flag in Varchar2 Default 'N',
14 p_Acty_Ref_Perd_Cd In Varchar2 Default NULL,
15 p_Pgm_Uom In Varchar2 Default NULL);
16
17
18 procedure pl_validations(p_pl_id In number,
19 p_effective_date In date,
20 p_Business_Group_Id In Number Default hr_general.GET_BUSINESS_GROUP_ID,
21 p_dml_operation In varchar2,
22 p_pl_Typ_Id In Number Default NULL,
23 p_Mapping_Table_PK_ID In Number Default NULL,
24 p_pl_stat_cd IN Varchar2 Default 'I');
25
26
27
28 procedure plip_validations(p_plip_id In Number,
29 p_effective_date In Date,
30 p_dml_operation In Varchar2,
31 p_business_group_id In Number Default hr_general.GET_BUSINESS_GROUP_ID,
32 p_Plip_Stat_Cd In Varchar Default 'I');
33
34
35 procedure opt_validations(p_opt_id in number,
36 p_effective_date in date,
37 p_dml_operation in varchar2,
38 p_Business_Group_Id in Number Default hr_general.GET_BUSINESS_GROUP_ID,
39 p_mapping_table_pk_id in Number Default NULL);
40
41
42 procedure oipl_validations(p_oipl_id in number,
43 p_dml_operation in varchar2,
44 p_effective_date in date,
45 p_Business_Group_Id in Number Default hr_general.GET_BUSINESS_GROUP_ID,
46 p_oipl_stat_cd in Varchar2 Default 'I');
47
48
49 procedure abr_validations(p_abr_id in number,
50 p_dml_operation in varchar2,
51 p_effective_date in date,
52 p_business_group_id IN Number Default hr_general.GET_BUSINESS_GROUP_ID,
53 p_pl_id In Number Default NULL,
54 p_opt_id In Number Default NULL,
55 p_acty_typ_cd In Varchar2 Default NULL,
56 p_Acty_Base_RT_Stat_Cd In Varchar2 Default 'I');
57
58
59 Function is_pgm_type_gsp(p_Pgm_Id in Number,
60 p_Business_Group_Id in Number Default hr_general.GET_BUSINESS_GROUP_ID,
61 p_Effective_Date in Date
62 )
63 Return Varchar2;
64
65 end pqh_gsp_ben_validations;