APPS.PAY_STATUS_RULES_PKG dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 26: CURSOR C IS SELECT rowid FROM pay_status_processing_rules_f

22: X_Last_Update_Login NUMBER,
23: X_Created_By NUMBER,
24: X_Creation_Date DATE) IS
25:
26: CURSOR C IS SELECT rowid FROM pay_status_processing_rules_f
27: WHERE status_processing_rule_id= X_status_processing_rule_id
28: AND effective_start_date = X_Effective_Start_Date;
29:
30:

Line 40: INSERT INTO pay_status_processing_rules_f(

36: OPEN C2;
37: FETCH C2 INTO X_status_processing_rule_id;
38: CLOSE C2;
39: end if;
40: INSERT INTO pay_status_processing_rules_f(
41: status_processing_rule_id,
42: effective_start_date,
43: effective_end_date,
44: business_group_id,

Line 99: FROM pay_status_processing_rules_f

95: X_Comment_Id NUMBER,
96: X_Legislation_Subgroup VARCHAR2) IS
97: CURSOR C IS
98: SELECT *
99: FROM pay_status_processing_rules_f
100: WHERE rowid = X_Rowid
101: FOR UPDATE of status_processing_rule_id NOWAIT;
102: Recinfo C%ROWTYPE;
103: BEGIN

Line 170: UPDATE pay_status_processing_rules_f

166: X_Last_Updated_By NUMBER,
167: X_Last_Update_Login NUMBER
168: ) IS
169: BEGIN
170: UPDATE pay_status_processing_rules_f
171: SET
172:
173: status_processing_rule_id = X_Status_Processing_Rule_Id,
174: effective_start_date = X_Effective_Start_Date,

Line 200: DELETE FROM pay_status_processing_rules_f

196: p_session_date date,
197: p_delete_mode varchar2,
198: p_status_processing_rule_id number) IS
199: BEGIN
200: DELETE FROM pay_status_processing_rules_f
201: WHERE rowid = X_Rowid;
202:
203: if (SQL%NOTFOUND) then
204: RAISE NO_DATA_FOUND;

Line 210: 'PAY_STATUS_PROCESSING_RULES_F',

206: --
207: -- Cascade the action to formula result rules for this SPR
208: pay_formula_result_rules_pkg.parent_deleted (
209: --
210: 'PAY_STATUS_PROCESSING_RULES_F',
211: p_status_processing_rule_id,
212: p_session_date,
213: p_delete_mode );
214: --

Line 226: from pay_status_processing_rules_f

222: --******************************************************************************
223: --
224: cursor csr_spr_end_date is
225: select max(effective_end_date)
226: from pay_status_processing_rules_f
227: where status_processing_rule_id = p_status_processing_rule_id;
228: --
229: cursor csr_spr_formula_end_date is
230: select min(effective_start_date) -1

Line 231: from pay_status_processing_rules_f

227: where status_processing_rule_id = p_status_processing_rule_id;
228: --
229: cursor csr_spr_formula_end_date is
230: select min(effective_start_date) -1
231: from pay_status_processing_rules_f
232: where status_processing_rule_id = p_status_processing_rule_id
233: and formula_id <> p_formula_id;
234: --
235: v_date1 date;

Line 291: from pay_status_processing_rules_f

287: -- the parent being deleted.
288: --
289: cursor csr_rows_owned_by_parent is
290: select *
291: from pay_status_processing_rules_f
292: where element_type_id = p_element_type_id
293: for update;
294: --
295: begin

Line 316: delete from pay_status_processing_rules_f

312: and fetched_rule.effective_start_date > p_session_date) then
313: --
314: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',2);
315: --
316: delete from pay_status_processing_rules_f
317: where current of csr_rows_owned_by_parent;
318: --
319: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',3);
320: --

Line 331: update pay_status_processing_rules_f

327: and fetched_rule.effective_end_date then
328: --
329: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',4);
330: --
331: update pay_status_processing_rules_f
332: set effective_end_date = p_session_date
333: where current of csr_rows_owned_by_parent;
334: --
335: end if;

Line 342: 'PAY_STATUS_PROCESSING_RULES_F',

338: --
339: -- Cascade the action to formula result rules for this SPR
340: pay_formula_result_rules_pkg.parent_deleted (
341: --
342: 'PAY_STATUS_PROCESSING_RULES_F',
343: fetched_rule.status_processing_rule_id,
344: p_session_date,
345: p_delete_mode );
346: --

Line 462: from pay_status_processing_rules_f

458: p_rowid varchar2) return boolean is
459: --
460: cursor csr_dated_updates is
461: select 1
462: from pay_status_processing_rules_f
463: where status_processing_rule_id = p_status_processing_rule_id
464: and rowid <> p_rowid;
465:
466: date_effective_updates_exist boolean := FALSE;

Line 542: from pay_status_processing_rules_f sprf

538: -- Get the start date of the earliest future status rule if it exists.
539: begin
540: select min(sprf.effective_start_date)
541: into v_next_status_rule_start_date
542: from pay_status_processing_rules_f sprf
543: where sprf.element_type_id = p_element_type_id
544: and nvl(sprf.assignment_status_type_id,0) = nvl(p_assignment_status_type_id,0)
545: and sprf.processing_rule = p_processing_rule
546: and sprf.effective_end_date >= p_session_date