eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.BEN_ELIGY_CRITERIA_BK1

Source


1 package body BEN_ELIGY_CRITERIA_BK1 as
2 /* $Header: beeglapi.pkb 120.1 2005/07/29 09:06 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 21:31:37 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_ELIGY_CRITERIA_A
6 (P_ELIGY_CRITERIA_ID in NUMBER
7 ,P_NAME in VARCHAR2
8 ,P_SHORT_CODE in VARCHAR2
9 ,P_DESCRIPTION in VARCHAR2
10 ,P_CRITERIA_TYPE in VARCHAR2
11 ,P_CRIT_COL1_VAL_TYPE_CD in VARCHAR2
12 ,P_CRIT_COL1_DATATYPE in VARCHAR2
13 ,P_COL1_LOOKUP_TYPE in VARCHAR2
14 ,P_COL1_VALUE_SET_ID in NUMBER
15 ,P_ACCESS_TABLE_NAME1 in VARCHAR2
16 ,P_ACCESS_COLUMN_NAME1 in VARCHAR2
17 ,P_TIME_ENTRY_ACCESS_TAB_NAM1 in VARCHAR2
18 ,P_TIME_ENTRY_ACCESS_COL_NAM1 in VARCHAR2
19 ,P_CRIT_COL2_VAL_TYPE_CD in VARCHAR2
20 ,P_CRIT_COL2_DATATYPE in VARCHAR2
21 ,P_COL2_LOOKUP_TYPE in VARCHAR2
22 ,P_COL2_VALUE_SET_ID in NUMBER
23 ,P_ACCESS_TABLE_NAME2 in VARCHAR2
24 ,P_ACCESS_COLUMN_NAME2 in VARCHAR2
25 ,P_TIME_ENTRY_ACCESS_TAB_NAM2 in VARCHAR2
26 ,P_TIME_ENTRY_ACCESS_COL_NAM2 in VARCHAR2
27 ,P_ACCESS_CALC_RULE in NUMBER
28 ,P_ALLOW_RANGE_VALIDATION_FLG in VARCHAR2
29 ,P_USER_DEFINED_FLAG in VARCHAR2
30 ,P_BUSINESS_GROUP_ID in NUMBER
31 ,P_LEGISLATION_CODE in VARCHAR2
32 ,P_EGL_ATTRIBUTE_CATEGORY in VARCHAR2
33 ,P_EGL_ATTRIBUTE1 in VARCHAR2
34 ,P_EGL_ATTRIBUTE2 in VARCHAR2
35 ,P_EGL_ATTRIBUTE3 in VARCHAR2
36 ,P_EGL_ATTRIBUTE4 in VARCHAR2
37 ,P_EGL_ATTRIBUTE5 in VARCHAR2
38 ,P_EGL_ATTRIBUTE6 in VARCHAR2
39 ,P_EGL_ATTRIBUTE7 in VARCHAR2
40 ,P_EGL_ATTRIBUTE8 in VARCHAR2
41 ,P_EGL_ATTRIBUTE9 in VARCHAR2
42 ,P_EGL_ATTRIBUTE10 in VARCHAR2
43 ,P_EGL_ATTRIBUTE11 in VARCHAR2
44 ,P_EGL_ATTRIBUTE12 in VARCHAR2
45 ,P_EGL_ATTRIBUTE13 in VARCHAR2
46 ,P_EGL_ATTRIBUTE14 in VARCHAR2
47 ,P_EGL_ATTRIBUTE15 in VARCHAR2
48 ,P_EGL_ATTRIBUTE16 in VARCHAR2
49 ,P_EGL_ATTRIBUTE17 in VARCHAR2
50 ,P_EGL_ATTRIBUTE18 in VARCHAR2
51 ,P_EGL_ATTRIBUTE19 in VARCHAR2
52 ,P_EGL_ATTRIBUTE20 in VARCHAR2
53 ,P_EGL_ATTRIBUTE21 in VARCHAR2
54 ,P_EGL_ATTRIBUTE22 in VARCHAR2
55 ,P_EGL_ATTRIBUTE23 in VARCHAR2
56 ,P_EGL_ATTRIBUTE24 in VARCHAR2
57 ,P_EGL_ATTRIBUTE25 in VARCHAR2
58 ,P_EGL_ATTRIBUTE26 in VARCHAR2
59 ,P_EGL_ATTRIBUTE27 in VARCHAR2
60 ,P_EGL_ATTRIBUTE28 in VARCHAR2
61 ,P_EGL_ATTRIBUTE29 in VARCHAR2
62 ,P_EGL_ATTRIBUTE30 in VARCHAR2
63 ,P_OBJECT_VERSION_NUMBER in NUMBER
64 ,P_EFFECTIVE_DATE in DATE
65 ,P_ALLOW_RANGE_VALIDATION_FLAG2 in VARCHAR2
66 ,P_ACCESS_CALC_RULE2 in NUMBER
67 ,P_TIME_ACCESS_CALC_RULE1 in NUMBER
68 ,P_TIME_ACCESS_CALC_RULE2 in NUMBER
69 )is
70 begin
71 hr_utility.set_location('Entering: BEN_ELIGY_CRITERIA_BK1.CREATE_ELIGY_CRITERIA_A', 10);
72 hr_utility.set_location(' Leaving: BEN_ELIGY_CRITERIA_BK1.CREATE_ELIGY_CRITERIA_A', 20);
73 end CREATE_ELIGY_CRITERIA_A;
74 procedure CREATE_ELIGY_CRITERIA_B
75 (P_NAME in VARCHAR2
76 ,P_SHORT_CODE in VARCHAR2
77 ,P_DESCRIPTION in VARCHAR2
78 ,P_CRITERIA_TYPE in VARCHAR2
79 ,P_CRIT_COL1_VAL_TYPE_CD in VARCHAR2
80 ,P_CRIT_COL1_DATATYPE in VARCHAR2
81 ,P_COL1_LOOKUP_TYPE in VARCHAR2
82 ,P_COL1_VALUE_SET_ID in NUMBER
83 ,P_ACCESS_TABLE_NAME1 in VARCHAR2
84 ,P_ACCESS_COLUMN_NAME1 in VARCHAR2
85 ,P_TIME_ENTRY_ACCESS_TAB_NAM1 in VARCHAR2
86 ,P_TIME_ENTRY_ACCESS_COL_NAM1 in VARCHAR2
87 ,P_CRIT_COL2_VAL_TYPE_CD in VARCHAR2
88 ,P_CRIT_COL2_DATATYPE in VARCHAR2
89 ,P_COL2_LOOKUP_TYPE in VARCHAR2
90 ,P_COL2_VALUE_SET_ID in NUMBER
91 ,P_ACCESS_TABLE_NAME2 in VARCHAR2
92 ,P_ACCESS_COLUMN_NAME2 in VARCHAR2
93 ,P_TIME_ENTRY_ACCESS_TAB_NAM2 in VARCHAR2
94 ,P_TIME_ENTRY_ACCESS_COL_NAM2 in VARCHAR2
95 ,P_ACCESS_CALC_RULE in NUMBER
96 ,P_ALLOW_RANGE_VALIDATION_FLG in VARCHAR2
97 ,P_USER_DEFINED_FLAG in VARCHAR2
98 ,P_BUSINESS_GROUP_ID in NUMBER
99 ,P_LEGISLATION_CODE in VARCHAR2
100 ,P_EGL_ATTRIBUTE_CATEGORY in VARCHAR2
101 ,P_EGL_ATTRIBUTE1 in VARCHAR2
102 ,P_EGL_ATTRIBUTE2 in VARCHAR2
103 ,P_EGL_ATTRIBUTE3 in VARCHAR2
104 ,P_EGL_ATTRIBUTE4 in VARCHAR2
105 ,P_EGL_ATTRIBUTE5 in VARCHAR2
106 ,P_EGL_ATTRIBUTE6 in VARCHAR2
107 ,P_EGL_ATTRIBUTE7 in VARCHAR2
108 ,P_EGL_ATTRIBUTE8 in VARCHAR2
109 ,P_EGL_ATTRIBUTE9 in VARCHAR2
110 ,P_EGL_ATTRIBUTE10 in VARCHAR2
111 ,P_EGL_ATTRIBUTE11 in VARCHAR2
112 ,P_EGL_ATTRIBUTE12 in VARCHAR2
113 ,P_EGL_ATTRIBUTE13 in VARCHAR2
114 ,P_EGL_ATTRIBUTE14 in VARCHAR2
115 ,P_EGL_ATTRIBUTE15 in VARCHAR2
116 ,P_EGL_ATTRIBUTE16 in VARCHAR2
117 ,P_EGL_ATTRIBUTE17 in VARCHAR2
118 ,P_EGL_ATTRIBUTE18 in VARCHAR2
119 ,P_EGL_ATTRIBUTE19 in VARCHAR2
120 ,P_EGL_ATTRIBUTE20 in VARCHAR2
121 ,P_EGL_ATTRIBUTE21 in VARCHAR2
122 ,P_EGL_ATTRIBUTE22 in VARCHAR2
123 ,P_EGL_ATTRIBUTE23 in VARCHAR2
124 ,P_EGL_ATTRIBUTE24 in VARCHAR2
125 ,P_EGL_ATTRIBUTE25 in VARCHAR2
126 ,P_EGL_ATTRIBUTE26 in VARCHAR2
127 ,P_EGL_ATTRIBUTE27 in VARCHAR2
128 ,P_EGL_ATTRIBUTE28 in VARCHAR2
129 ,P_EGL_ATTRIBUTE29 in VARCHAR2
130 ,P_EGL_ATTRIBUTE30 in VARCHAR2
131 ,P_EFFECTIVE_DATE in DATE
132 ,P_ALLOW_RANGE_VALIDATION_FLAG2 in VARCHAR2
133 ,P_ACCESS_CALC_RULE2 in NUMBER
134 ,P_TIME_ACCESS_CALC_RULE1 in NUMBER
135 ,P_TIME_ACCESS_CALC_RULE2 in NUMBER
136 )is
137 begin
138 hr_utility.set_location('Entering: BEN_ELIGY_CRITERIA_BK1.CREATE_ELIGY_CRITERIA_B', 10);
139 hr_utility.set_location(' Leaving: BEN_ELIGY_CRITERIA_BK1.CREATE_ELIGY_CRITERIA_B', 20);
140 end CREATE_ELIGY_CRITERIA_B;
141 end BEN_ELIGY_CRITERIA_BK1;