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_FORMULA_RESULT_RULES_PKG dependencies on PAY_FORMULA_RESULT_RULES_PKG

Line 1: package body PAY_FORMULA_RESULT_RULES_PKG as

1: package body PAY_FORMULA_RESULT_RULES_PKG as
2: /* $Header: pyfrr.pkb 115.6 2002/12/10 18:44:52 dsaxby ship $ */
3: -------------------------------------------------------------------------------
4: --------------------------------------------------------------------------------
5: g_dummy number(1); -- Dummy for cursor returns which are not needed

Line 40: hr_utility.set_location ('pay_formula_result_rules_pkg.check_unique',3);

36: and effective_start_date <=p_effective_end_date
37: and effective_end_date >=p_session_date;
38: begin
39: --
40: hr_utility.set_location ('pay_formula_result_rules_pkg.check_unique',3);
41: --
42: open csr_duplicate_rule;
43: fetch csr_duplicate_rule into g_dummy;
44: v_duplicate_found := csr_duplicate_rule%found;

Line 68: hr_utility.set_location ('pay_formula_result_rules_pkg.check_unique',4);

64: and (p_rowid is null
65: or (p_rowid is not null and p_rowid <> rowid));
66: begin
67: --
68: hr_utility.set_location ('pay_formula_result_rules_pkg.check_unique',4);
69: --
70: open csr_duplicate_rule;
71: fetch csr_duplicate_rule into g_dummy;
72: v_duplicate_found := csr_duplicate_rule%found;

Line 98: hr_utility.set_location ('pay_formula_result_rules_pkg.check_unique',5);

94: and effective_end_date >=p_session_date
95: and element_type_id = p_element_type_id;
96: begin
97: --
98: hr_utility.set_location ('pay_formula_result_rules_pkg.check_unique',5);
99: --
100: open csr_duplicate_rule;
101: fetch csr_duplicate_rule into g_dummy;
102: v_duplicate_found := csr_duplicate_rule%found;

Line 128: hr_utility.set_location ('pay_formula_result_rules_pkg.check_unique',6);

124: and effective_start_date <=p_effective_end_date
125: and effective_end_date >=p_session_date;
126: begin
127: --
128: hr_utility.set_location ('pay_formula_result_rules_pkg.check_unique',6);
129: --
130: open csr_duplicate_rule;
131: fetch csr_duplicate_rule into g_dummy;
132: v_duplicate_found := csr_duplicate_rule%found;

Line 141: hr_utility.set_location ('pay_formula_result_rules_pkg.check_unique',1);

137: end other_rule_type_not_unique;
138: --
139: begin
140: --
141: hr_utility.set_location ('pay_formula_result_rules_pkg.check_unique',1);
142: --
143: --if (p_result_rule_type = 'D' and direct_result_rule_not_unique) then
144: --
145: -- hr_utility.set_message (801, 'HR_6503_FF_DIRECT');

Line 191: hr_utility.set_location ('pay_formula_result_rules_pkg.target_pay_value',1);

187:
188: --
189: begin
190: --
191: hr_utility.set_location ('pay_formula_result_rules_pkg.target_pay_value',1);
192: --
193: open csr_input_value;
194: fetch csr_input_value into v_input_value_id;
195: --

Line 233: hr_utility.set_location ('pay_formula_result_rules_pkg.insert_row',1);

229:
230: CURSOR C2 IS SELECT pay_formula_result_rules_s.nextval FROM sys.dual;
231: BEGIN
232: --
233: hr_utility.set_location ('pay_formula_result_rules_pkg.insert_row',1);
234: --
235: check_unique (p_status_processing_rule_id,
236: p_result_rule_type,
237: p_result_name,

Line 244: hr_utility.set_location ('pay_formula_result_rules_pkg.insert_row',2);

240: p_rowid,
241: p_element_type_id,
242: p_input_value_id) ;
243: --
244: hr_utility.set_location ('pay_formula_result_rules_pkg.insert_row',2);
245: --
246: if (p_formula_result_rule_id is NULL) then
247: OPEN C2;
248: FETCH C2 INTO p_formula_result_rule_id;

Line 252: hr_utility.set_location ('pay_formula_result_rules_pkg.insert_row',3);

248: FETCH C2 INTO p_formula_result_rule_id;
249: CLOSE C2;
250: end if;
251: --
252: hr_utility.set_location ('pay_formula_result_rules_pkg.insert_row',3);
253: --
254: insert into pay_formula_result_rules_f(
255: formula_result_rule_id,
256: effective_start_date,

Line 285: hr_utility.set_location ('pay_formula_result_rules_pkg.insert_row',4);

281: p_Input_Value_Id,
282: sysdate);
283:
284: --
285: hr_utility.set_location ('pay_formula_result_rules_pkg.insert_row',4);
286: --
287: OPEN C;
288: FETCH C INTO p_Rowid;
289: if (C%NOTFOUND) then

Line 510: -- pay_formula_result_rules_pkg.result_rule_end_date --

506: --
507: end parent_deleted;
508: ------------------------------------------------------------------------------
509: -- NAME --
510: -- pay_formula_result_rules_pkg.result_rule_end_date --
511: -- --
512: -- DESCRIPTION --
513: -- Returns the correct end date for a result rule. It takes into account --
514: -- the end date of any future result rules and corresponding business rules --

Line 610: -- pay_formula_result_rules_pkg.formula_results_changed --

606: end result_rule_end_date;
607: --------------------------------------------------------------------------------
608: ------------------------------------------------------------------------------
609: -- NAME --
610: -- pay_formula_result_rules_pkg.formula_results_changed --
611: -- --
612: -- DESCRIPTION --
613: -- Returns 'TRUE' if the formula has been changed to return different --
614: -- results which will now invalidate result rules. --

Line 651: end PAY_FORMULA_RESULT_RULES_PKG;

647: --
648: return results_changed;
649: end formula_results_changed;
650: --------------------------------------------------------------------------------
651: end PAY_FORMULA_RESULT_RULES_PKG;