DBA Data[Home] [Help]

PACKAGE BODY: APPS.BEN_VPF_RKD

Source


1 package body ben_vpf_RKD as
2 /* $Header: bevpfrhi.pkb 120.1.12010000.1 2008/07/29 13:07:55 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:17:35 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_DELETE
6 (P_VRBL_RT_PRFL_ID in NUMBER
7 ,P_DATETRACK_MODE in VARCHAR2
8 ,P_VALIDATION_START_DATE in DATE
9 ,P_VALIDATION_END_DATE in DATE
10 ,P_EFFECTIVE_START_DATE in DATE
11 ,P_EFFECTIVE_END_DATE in DATE
12 ,P_EFFECTIVE_START_DATE_O in DATE
13 ,P_EFFECTIVE_END_DATE_O in DATE
14 ,P_PL_TYP_OPT_TYP_ID_O in NUMBER
15 ,P_PL_ID_O in NUMBER
16 ,P_OIPL_ID_O in NUMBER
17 ,P_COMP_LVL_FCTR_ID_O in NUMBER
18 ,P_BUSINESS_GROUP_ID_O in NUMBER
19 ,P_ACTY_TYP_CD_O in VARCHAR2
20 ,P_RT_TYP_CD_O in VARCHAR2
21 ,P_BNFT_RT_TYP_CD_O in VARCHAR2
22 ,P_TX_TYP_CD_O in VARCHAR2
23 ,P_VRBL_RT_TRTMT_CD_O in VARCHAR2
24 ,P_ACTY_REF_PERD_CD_O in VARCHAR2
25 ,P_MLT_CD_O in VARCHAR2
26 ,P_INCRMNT_ELCN_VAL_O in NUMBER
27 ,P_DFLT_ELCN_VAL_O in NUMBER
28 ,P_MX_ELCN_VAL_O in NUMBER
29 ,P_MN_ELCN_VAL_O in NUMBER
30 ,P_LWR_LMT_VAL_O in NUMBER
31 ,P_LWR_LMT_CALC_RL_O in NUMBER
32 ,P_UPR_LMT_VAL_O in NUMBER
33 ,P_UPR_LMT_CALC_RL_O in NUMBER
34 ,P_ULTMT_UPR_LMT_O in NUMBER
35 ,P_ULTMT_LWR_LMT_O in NUMBER
36 ,P_ULTMT_UPR_LMT_CALC_RL_O in NUMBER
37 ,P_ULTMT_LWR_LMT_CALC_RL_O in NUMBER
38 ,P_ANN_MN_ELCN_VAL_O in NUMBER
39 ,P_ANN_MX_ELCN_VAL_O in NUMBER
40 ,P_VAL_O in NUMBER
41 ,P_NAME_O in VARCHAR2
42 ,P_NO_MN_ELCN_VAL_DFND_FLAG_O in VARCHAR2
43 ,P_NO_MX_ELCN_VAL_DFND_FLAG_O in VARCHAR2
44 ,P_ALWYS_SUM_ALL_CVG_FLAG_O in VARCHAR2
45 ,P_ALWYS_CNT_ALL_PRTTS_FLAG_O in VARCHAR2
46 ,P_VAL_CALC_RL_O in NUMBER
47 ,P_VRBL_RT_PRFL_STAT_CD_O in VARCHAR2
48 ,P_VRBL_USG_CD_O in VARCHAR2
49 ,P_ASMT_TO_USE_CD_O in VARCHAR2
50 ,P_RNDG_CD_O in VARCHAR2
51 ,P_RNDG_RL_O in NUMBER
52 ,P_RT_HRLY_SLRD_FLAG_O in VARCHAR2
53 ,P_RT_PSTL_CD_FLAG_O in VARCHAR2
54 ,P_RT_LBR_MMBR_FLAG_O in VARCHAR2
55 ,P_RT_LGL_ENTY_FLAG_O in VARCHAR2
56 ,P_RT_BENFTS_GRP_FLAG_O in VARCHAR2
57 ,P_RT_WK_LOC_FLAG_O in VARCHAR2
58 ,P_RT_BRGNG_UNIT_FLAG_O in VARCHAR2
59 ,P_RT_AGE_FLAG_O in VARCHAR2
60 ,P_RT_LOS_FLAG_O in VARCHAR2
61 ,P_RT_PER_TYP_FLAG_O in VARCHAR2
62 ,P_RT_FL_TM_PT_TM_FLAG_O in VARCHAR2
63 ,P_RT_EE_STAT_FLAG_O in VARCHAR2
64 ,P_RT_GRD_FLAG_O in VARCHAR2
65 ,P_RT_PCT_FL_TM_FLAG_O in VARCHAR2
66 ,P_RT_ASNT_SET_FLAG_O in VARCHAR2
67 ,P_RT_HRS_WKD_FLAG_O in VARCHAR2
68 ,P_RT_COMP_LVL_FLAG_O in VARCHAR2
69 ,P_RT_ORG_UNIT_FLAG_O in VARCHAR2
70 ,P_RT_LOA_RSN_FLAG_O in VARCHAR2
71 ,P_RT_PYRL_FLAG_O in VARCHAR2
72 ,P_RT_SCHEDD_HRS_FLAG_O in VARCHAR2
73 ,P_RT_PY_BSS_FLAG_O in VARCHAR2
74 ,P_RT_PRFL_RL_FLAG_O in VARCHAR2
75 ,P_RT_CMBN_AGE_LOS_FLAG_O in VARCHAR2
76 ,P_RT_PRTT_PL_FLAG_O in VARCHAR2
77 ,P_RT_SVC_AREA_FLAG_O in VARCHAR2
78 ,P_RT_PPL_GRP_FLAG_O in VARCHAR2
79 ,P_RT_DSBLD_FLAG_O in VARCHAR2
80 ,P_RT_HLTH_CVG_FLAG_O in VARCHAR2
81 ,P_RT_POE_FLAG_O in VARCHAR2
82 ,P_RT_TTL_CVG_VOL_FLAG_O in VARCHAR2
83 ,P_RT_TTL_PRTT_FLAG_O in VARCHAR2
84 ,P_RT_GNDR_FLAG_O in VARCHAR2
85 ,P_RT_TBCO_USE_FLAG_O in VARCHAR2
86 ,P_VPF_ATTRIBUTE_CATEGORY_O in VARCHAR2
87 ,P_VPF_ATTRIBUTE1_O in VARCHAR2
88 ,P_VPF_ATTRIBUTE2_O in VARCHAR2
89 ,P_VPF_ATTRIBUTE3_O in VARCHAR2
90 ,P_VPF_ATTRIBUTE4_O in VARCHAR2
91 ,P_VPF_ATTRIBUTE5_O in VARCHAR2
92 ,P_VPF_ATTRIBUTE6_O in VARCHAR2
93 ,P_VPF_ATTRIBUTE7_O in VARCHAR2
94 ,P_VPF_ATTRIBUTE8_O in VARCHAR2
95 ,P_VPF_ATTRIBUTE9_O in VARCHAR2
96 ,P_VPF_ATTRIBUTE10_O in VARCHAR2
97 ,P_VPF_ATTRIBUTE11_O in VARCHAR2
98 ,P_VPF_ATTRIBUTE12_O in VARCHAR2
99 ,P_VPF_ATTRIBUTE13_O in VARCHAR2
100 ,P_VPF_ATTRIBUTE14_O in VARCHAR2
101 ,P_VPF_ATTRIBUTE15_O in VARCHAR2
102 ,P_VPF_ATTRIBUTE16_O in VARCHAR2
103 ,P_VPF_ATTRIBUTE17_O in VARCHAR2
104 ,P_VPF_ATTRIBUTE18_O in VARCHAR2
105 ,P_VPF_ATTRIBUTE19_O in VARCHAR2
106 ,P_VPF_ATTRIBUTE20_O in VARCHAR2
107 ,P_VPF_ATTRIBUTE21_O in VARCHAR2
108 ,P_VPF_ATTRIBUTE22_O in VARCHAR2
109 ,P_VPF_ATTRIBUTE23_O in VARCHAR2
110 ,P_VPF_ATTRIBUTE24_O in VARCHAR2
111 ,P_VPF_ATTRIBUTE25_O in VARCHAR2
112 ,P_VPF_ATTRIBUTE26_O in VARCHAR2
113 ,P_VPF_ATTRIBUTE27_O in VARCHAR2
114 ,P_VPF_ATTRIBUTE28_O in VARCHAR2
115 ,P_VPF_ATTRIBUTE29_O in VARCHAR2
116 ,P_VPF_ATTRIBUTE30_O in VARCHAR2
117 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
118 ,P_RT_CNTNG_PRTN_PRFL_FLAG_O in VARCHAR2
119 ,P_RT_CBR_QUALD_BNF_FLAG_O in VARCHAR2
120 ,P_RT_OPTD_MDCR_FLAG_O in VARCHAR2
121 ,P_RT_LVG_RSN_FLAG_O in VARCHAR2
122 ,P_RT_PSTN_FLAG_O in VARCHAR2
123 ,P_RT_COMPTNCY_FLAG_O in VARCHAR2
124 ,P_RT_JOB_FLAG_O in VARCHAR2
125 ,P_RT_QUAL_TITL_FLAG_O in VARCHAR2
126 ,P_RT_DPNT_CVRD_PL_FLAG_O in VARCHAR2
127 ,P_RT_DPNT_CVRD_PLIP_FLAG_O in VARCHAR2
128 ,P_RT_DPNT_CVRD_PTIP_FLAG_O in VARCHAR2
129 ,P_RT_DPNT_CVRD_PGM_FLAG_O in VARCHAR2
130 ,P_RT_ENRLD_OIPL_FLAG_O in VARCHAR2
131 ,P_RT_ENRLD_PL_FLAG_O in VARCHAR2
132 ,P_RT_ENRLD_PLIP_FLAG_O in VARCHAR2
133 ,P_RT_ENRLD_PTIP_FLAG_O in VARCHAR2
134 ,P_RT_ENRLD_PGM_FLAG_O in VARCHAR2
135 ,P_RT_PRTT_ANTHR_PL_FLAG_O in VARCHAR2
136 ,P_RT_OTHR_PTIP_FLAG_O in VARCHAR2
137 ,P_RT_NO_OTHR_CVG_FLAG_O in VARCHAR2
138 ,P_RT_DPNT_OTHR_PTIP_FLAG_O in VARCHAR2
139 ,P_RT_QUA_IN_GR_FLAG_O in VARCHAR2
140 ,P_RT_PERF_RTNG_FLAG_O in VARCHAR2
141 ,P_RT_ELIG_PRFL_FLAG_O in VARCHAR2
142 )is
143 begin
144 hr_utility.set_location('Entering: ben_vpf_RKD.AFTER_DELETE', 10);
145 hr_utility.set_location(' Leaving: ben_vpf_RKD.AFTER_DELETE', 20);
146 end AFTER_DELETE;
147 end ben_vpf_RKD;