APPS.BEN_DERIVABLE_FACTOR dependencies on HR_UTILITY

Line 65: hr_utility.set_location('Entering '||l_proc,10);

61: and owner=upper(p_oracle_schema);
62: --
63: begin
64: --
65: hr_utility.set_location('Entering '||l_proc,10);
66: --
67: --
68: -- Parameter validation
69: --

Line 117: hr_utility.set_location('Create event ',10);

113: --
114: if p_event = 'CREATE' then
115: --
116: -- rchase bug 1568561 - added paren pair around ors
117: hr_utility.set_location('Create event ',10);
118: --
119: l_strg := 'update '||p_table_name||' t set drvbl_fctr_prtn_elig_flag = :1
120:
121: where '||p_col_name|| '= :2 and (

Line 149: hr_utility.set_location('update event ',10);

145: cep.eligy_prfl_id = epf.eligy_prfl_id))';
146: execute immediate l_strg using 'Y',p_col_id,p_col_id,p_col_id,p_col_id,p_col_id,p_col_id,p_col_id;
147: --
148: elsif p_event = 'DELETE' then
149: hr_utility.set_location('update event ',10);
150: l_strg := 'update '||p_table_name||' t set drvbl_fctr_prtn_elig_flag = :1
151: where '||p_col_name|| '= :2 and
152: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
153: ben_prtn_elig_prfl_f cep

Line 180: hr_utility.set_location('Leaving '||l_proc,10);

176: execute immediate l_strg using 'N',p_col_id,p_col_id,p_col_id,p_col_id,p_col_id,p_col_id,p_col_id;
177: --
178: end if;
179: --
180: hr_utility.set_location('Leaving '||l_proc,10);
181: --
182: end eligy_prfl_handler;
183: -----------------------------------------------------------------------
184: procedure derivable_factor_handler

Line 199: hr_utility.set_location('Entering '||l_proc,10);

195: --
196:
197: begin
198: --
199: hr_utility.set_location('Entering '||l_proc,10);
200: --
201: --
202: -- Parameter validation
203: --