DBA Data[Home] [Help]

PACKAGE: APPS.PQH_GSP_BEN_VALIDATIONS

Source


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;