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.

APPS.PAY_PYEPFREQ_PKG dependencies on PAY_PYEPFREQ_PKG

Line 1: PACKAGE BODY pay_pyepfreq_pkg AS

1: PACKAGE BODY pay_pyepfreq_pkg AS
2: /* $Header: pyepf01t.pkb 120.2 2005/06/15 06:36:21 susivasu noship $ */
3: --
4: PROCEDURE hr_ele_pay_freq_rules (
5: p_context IN VARCHAR2,

Line 119: hr_utility.set_location('pay_pyepfreq_pkg', 10);

115: -- Delete existing frequency rules:
116: --
117: begin
118:
119: hr_utility.set_location('pay_pyepfreq_pkg', 10);
120:
121: SELECT ele_payroll_freq_rule_id
122: INTO v_ele_pay_freq_rule_id
123: FROM pay_ele_payroll_freq_rules

Line 128: hr_utility.set_location('pay_pyepfreq_pkg', 20);

124: WHERE element_type_id = p_eletype_id
125: AND payroll_id = p_payroll_id
126: AND business_group_id + 0 = p_bg_id;
127: --
128: hr_utility.set_location('pay_pyepfreq_pkg', 20);
129: DELETE FROM pay_ele_payroll_freq_rules
130: WHERE ele_payroll_freq_rule_id = v_ele_pay_freq_rule_id;
131: --
132: hr_utility.set_location('pay_pyepfreq_pkg', 30);

Line 132: hr_utility.set_location('pay_pyepfreq_pkg', 30);

128: hr_utility.set_location('pay_pyepfreq_pkg', 20);
129: DELETE FROM pay_ele_payroll_freq_rules
130: WHERE ele_payroll_freq_rule_id = v_ele_pay_freq_rule_id;
131: --
132: hr_utility.set_location('pay_pyepfreq_pkg', 30);
133: DELETE FROM pay_freq_rule_periods
134: WHERE ele_payroll_freq_rule_id = v_ele_pay_freq_rule_id;
135: --
136: -- If either of the above fail, then it's ok, we're just cleaning up

Line 153: hr_utility.set_location('pay_pyepfreq_pkg', 40);

149: -- of, say, every other month or every third month.
150: --
151: begin
152:
153: hr_utility.set_location('pay_pyepfreq_pkg', 40);
154: SELECT number_per_fiscal_year
155: INTO v_number_per_fy
156: FROM per_time_period_types
157: WHERE period_type = p_period_type;

Line 179: hr_utility.set_location('pay_pyepfreq_pkg', 50);

175: UPPER(p_period_3) = 'Y' or
176: UPPER(p_period_4) = 'Y' or
177: UPPER(p_period_5) = 'Y' )
178: then
179: hr_utility.set_location('pay_pyepfreq_pkg', 50);
180: SELECT pay_ele_payroll_freq_rules_s.nextval
181: INTO v_ele_pay_freq_rule_id
182: FROM sys.dual;
183: --

Line 184: hr_utility.set_location('pay_pyepfreq_pkg', 60);

180: SELECT pay_ele_payroll_freq_rules_s.nextval
181: INTO v_ele_pay_freq_rule_id
182: FROM sys.dual;
183: --
184: hr_utility.set_location('pay_pyepfreq_pkg', 60);
185: INSERT INTO pay_ele_payroll_freq_rules (
186: ele_payroll_freq_rule_id,
187: element_type_id,
188: payroll_id,

Line 219: hr_utility.set_location('pay_pyepfreq_pkg', 70);

215: --
216: -- insert freq rule period where period_n = 'Y'
217: --
218: IF UPPER(p_period_1) = 'Y' THEN
219: hr_utility.set_location('pay_pyepfreq_pkg', 70);
220: ins_freq_rule_period( v_ele_pay_freq_rule_id,
221: 1,
222: p_bg_id,
223: v_eff_start_date);

Line 226: hr_utility.set_location('pay_pyepfreq_pkg', 80);

222: p_bg_id,
223: v_eff_start_date);
224: END IF;
225: IF UPPER(p_period_2) = 'Y' THEN
226: hr_utility.set_location('pay_pyepfreq_pkg', 80);
227: ins_freq_rule_period( v_ele_pay_freq_rule_id,
228: 2,
229: p_bg_id,
230: v_eff_start_date);

Line 233: hr_utility.set_location('pay_pyepfreq_pkg', 90);

229: p_bg_id,
230: v_eff_start_date);
231: END IF;
232: IF UPPER(p_period_3) = 'Y' THEN
233: hr_utility.set_location('pay_pyepfreq_pkg', 90);
234: ins_freq_rule_period( v_ele_pay_freq_rule_id,
235: 3,
236: p_bg_id,
237: v_eff_start_date);

Line 240: hr_utility.set_location('pay_pyepfreq_pkg', 100);

236: p_bg_id,
237: v_eff_start_date);
238: END IF;
239: IF UPPER(p_period_4) = 'Y' THEN
240: hr_utility.set_location('pay_pyepfreq_pkg', 100);
241: ins_freq_rule_period( v_ele_pay_freq_rule_id,
242: 4,
243: p_bg_id,
244: v_eff_start_date);

Line 247: hr_utility.set_location('pay_pyepfreq_pkg', 110);

243: p_bg_id,
244: v_eff_start_date);
245: END IF;
246: IF UPPER(p_period_5) = 'Y' THEN
247: hr_utility.set_location('pay_pyepfreq_pkg', 110);
248: ins_freq_rule_period( v_ele_pay_freq_rule_id,
249: 5,
250: p_bg_id,
251: v_eff_start_date);

Line 254: hr_utility.set_location('pay_pyepfreq_pkg', 120);

250: p_bg_id,
251: v_eff_start_date);
252: END IF;
253: IF UPPER(p_period_6) = 'Y' THEN
254: hr_utility.set_location('pay_pyepfreq_pkg', 120);
255: ins_freq_rule_period( v_ele_pay_freq_rule_id,
256: 6,
257: p_bg_id,
258: v_eff_start_date);

Line 352: if pay_pyepfreq_pkg.g_freq_rule_table.count > 0 then

348: hr_utility.trace('element_type_id = '||to_char(p_element_type_id));
349: hr_utility.trace('payroll_id = '||to_char(p_payroll_id));
350: hr_utility.trace('business_group_id = '||to_char(p_bg_id));
351:
352: if pay_pyepfreq_pkg.g_freq_rule_table.count > 0 then
353: hr_utility.trace('g_freq_rule_table.count > 0 satisfied ');
354: for i in g_freq_rule_table.first..g_freq_rule_table.last
355: loop
356: hr_utility.trace('record i = '||to_char(i));

Line 368: end if; --pay_pyepfreq_pkg.g_freq_rule_table.count > 0

364:
365: end if;
366:
367: end loop; -- g_freq_rule_table.first..g_freq_rule_table.last
368: end if; --pay_pyepfreq_pkg.g_freq_rule_table.count > 0
369:
370: if lv_record_found = 'N' then
371: ln_index2 := pay_pyepfreq_pkg.g_freq_rule_table.count;
372: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).element_type_id :=

Line 371: ln_index2 := pay_pyepfreq_pkg.g_freq_rule_table.count;

367: end loop; -- g_freq_rule_table.first..g_freq_rule_table.last
368: end if; --pay_pyepfreq_pkg.g_freq_rule_table.count > 0
369:
370: if lv_record_found = 'N' then
371: ln_index2 := pay_pyepfreq_pkg.g_freq_rule_table.count;
372: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).element_type_id :=
373: p_element_type_id;
374: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).payroll_id :=
375: p_payroll_id;

Line 372: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).element_type_id :=

368: end if; --pay_pyepfreq_pkg.g_freq_rule_table.count > 0
369:
370: if lv_record_found = 'N' then
371: ln_index2 := pay_pyepfreq_pkg.g_freq_rule_table.count;
372: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).element_type_id :=
373: p_element_type_id;
374: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).payroll_id :=
375: p_payroll_id;
376: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).business_group_id :=

Line 374: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).payroll_id :=

370: if lv_record_found = 'N' then
371: ln_index2 := pay_pyepfreq_pkg.g_freq_rule_table.count;
372: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).element_type_id :=
373: p_element_type_id;
374: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).payroll_id :=
375: p_payroll_id;
376: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).business_group_id :=
377: p_bg_id;
378:

Line 376: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).business_group_id :=

372: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).element_type_id :=
373: p_element_type_id;
374: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).payroll_id :=
375: p_payroll_id;
376: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).business_group_id :=
377: p_bg_id;
378:
379: for i in 1..6 loop
380: lv_freq_rule_exists := null;

Line 397: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_1 :=

393: end if;
394:
395: if i = 1 then
396: hr_utility.trace('period 1 = '||lv_freq_rule_exists);
397: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_1 :=
398: lv_freq_rule_exists;
399: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).rule_date_code :=
400: lv_rule_date_code;
401: elsif i = 2 then

Line 399: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).rule_date_code :=

395: if i = 1 then
396: hr_utility.trace('period 1 = '||lv_freq_rule_exists);
397: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_1 :=
398: lv_freq_rule_exists;
399: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).rule_date_code :=
400: lv_rule_date_code;
401: elsif i = 2 then
402: hr_utility.trace('period 2 = '||lv_freq_rule_exists);
403: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_2 :=

Line 403: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_2 :=

399: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).rule_date_code :=
400: lv_rule_date_code;
401: elsif i = 2 then
402: hr_utility.trace('period 2 = '||lv_freq_rule_exists);
403: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_2 :=
404: lv_freq_rule_exists;
405: elsif i = 3 then
406: hr_utility.trace('period 3 = '||lv_freq_rule_exists);
407: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_3 :=

Line 407: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_3 :=

403: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_2 :=
404: lv_freq_rule_exists;
405: elsif i = 3 then
406: hr_utility.trace('period 3 = '||lv_freq_rule_exists);
407: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_3 :=
408: lv_freq_rule_exists;
409: elsif i = 4 then
410: hr_utility.trace('period 4 = '||lv_freq_rule_exists);
411: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_4 :=

Line 411: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_4 :=

407: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_3 :=
408: lv_freq_rule_exists;
409: elsif i = 4 then
410: hr_utility.trace('period 4 = '||lv_freq_rule_exists);
411: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_4 :=
412: lv_freq_rule_exists;
413: elsif i = 5 then
414: hr_utility.trace('period 5 = '||lv_freq_rule_exists);
415: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_5 :=

Line 415: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_5 :=

411: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_4 :=
412: lv_freq_rule_exists;
413: elsif i = 5 then
414: hr_utility.trace('period 5 = '||lv_freq_rule_exists);
415: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_5 :=
416: lv_freq_rule_exists;
417: elsif i = 6 then
418: hr_utility.trace('period 6 = '||lv_freq_rule_exists);
419: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_6 :=

Line 419: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_6 :=

415: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_5 :=
416: lv_freq_rule_exists;
417: elsif i = 6 then
418: hr_utility.trace('period 6 = '||lv_freq_rule_exists);
419: pay_pyepfreq_pkg.g_freq_rule_table(ln_index2).period_6 :=
420: lv_freq_rule_exists;
421: end if;
422:
423: end loop;

Line 467: if pay_pyepfreq_pkg.g_freq_rule_table.count > 0 then

463: PROCEDURE remove_freq_rule_period(p_ele_type_id IN NUMBER,
464: p_payroll_id IN NUMBER) is
465:
466: begin
467: if pay_pyepfreq_pkg.g_freq_rule_table.count > 0 then
468: for i in g_freq_rule_table.first..g_freq_rule_table.last
469: loop
470: if (g_freq_rule_table(i).element_type_id = p_ele_type_id
471: and g_freq_rule_table(i).payroll_id = p_payroll_id) then

Line 497: pay_pyepfreq_pkg.g_freq_rule_table.delete;

493: BEGIN
494:
495: hr_utility.trace('deleting g_freq_rule_table plsql table');
496:
497: pay_pyepfreq_pkg.g_freq_rule_table.delete;
498:
499: END initialise_freqrule_table;
500:
501: END pay_pyepfreq_pkg;

Line 501: END pay_pyepfreq_pkg;

497: pay_pyepfreq_pkg.g_freq_rule_table.delete;
498:
499: END initialise_freqrule_table;
500:
501: END pay_pyepfreq_pkg;