[Home] [Help]
27: return boolean is
28: v_duplicate_found boolean := FALSE;
29: cursor csr_duplicate_rule is
30: select 1
31: from PAY_FORMULA_RESULT_RULES_F
32: where status_processing_rule_id = p_status_processing_rule_id
33: and result_rule_type = 'D'
34: and (p_rowid is null
35: or (p_rowid is not null and p_rowid <> rowid))
54: return boolean is
55: v_duplicate_found boolean := FALSE;
56: cursor csr_duplicate_rule is
57: select 1
58: from pay_formula_result_rules_f
59: where status_processing_rule_id = p_status_processing_rule_id
60: and result_rule_type = 'M'
61: and result_name = p_result_name
62: and effective_start_date <=p_effective_end_date
83: return boolean is
84: v_duplicate_found boolean := FALSE;
85: cursor csr_duplicate_rule is
86: select 1
87: from pay_formula_result_rules_f
88: where status_processing_rule_id = p_status_processing_rule_id
89: and result_rule_type = 'S'
90: and result_name = p_result_name
91: and (p_rowid is null
113: return boolean is
114: v_duplicate_found boolean := FALSE;
115: cursor csr_duplicate_rule is
116: select 1
117: from pay_formula_result_rules_f
118: where status_processing_rule_id = p_status_processing_rule_id
119: and result_rule_type = p_result_rule_type
120: and result_name = p_result_name
121: and input_value_id = p_input_value_id
220: p_Input_Value_Id NUMBER,
221: p_Created_By NUMBER,
222: p_session_date date
223: ) IS
224: CURSOR C IS SELECT rowid FROM pay_formula_result_rules_f
225: WHERE formula_result_rule_id = p_formula_result_rule_id
226: AND effective_start_date = p_Effective_Start_Date;
227:
228:
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,
257: effective_end_date,
258: business_group_id,
307: p_Input_Value_Id NUMBER
308: ) IS
309: CURSOR C IS
310: SELECT *
311: FROM pay_formula_result_rules_f
312: WHERE rowid = p_Rowid
313: FOR UPDATE of formula_result_rule_id NOWAIT;
314: Recinfo C%ROWTYPE;
315: BEGIN
382: p_Last_Updated_By NUMBER,
383: p_Last_Update_Login NUMBER
384: ) IS
385: BEGIN
386: UPDATE pay_formula_result_rules_f
387: SET
388:
389: formula_result_rule_id = p_Formula_Result_Rule_Id,
390: effective_start_date = p_Effective_Start_Date,
411: --------------------------------------------------------------------------------
412:
413: PROCEDURE Delete_Row(p_Rowid VARCHAR2) IS
414: BEGIN
415: DELETE FROM pay_formula_result_rules_f
416: WHERE rowid = p_Rowid;
417:
418: if (SQL%NOTFOUND) then
419: RAISE NO_DATA_FOUND;
441: -- the parent being deleted. The parent name identifies foreign key column
442: -- to use, thus the procedure is generic to any parent deletion
443: --
444: cursor csr_rows_owned_by_parent is
445: select rowid,pay_formula_result_rules_f.*
446: from pay_formula_result_rules_f
447: where p_parent_id = decode (p_parent_name,
448: 'PAY_STATUS_PROCESSING_RULES_F',status_processing_rule_id,
449: 'PAY_ELEMENT_TYPES_F',element_type_id,
442: -- to use, thus the procedure is generic to any parent deletion
443: --
444: cursor csr_rows_owned_by_parent is
445: select rowid,pay_formula_result_rules_f.*
446: from pay_formula_result_rules_f
447: where p_parent_id = decode (p_parent_name,
448: 'PAY_STATUS_PROCESSING_RULES_F',status_processing_rule_id,
449: 'PAY_ELEMENT_TYPES_F',element_type_id,
450: 'PAY_INPUT_VALUES_F',input_value_id)
476: hr_utility.set_message (801,'PAY_6157_ELEMENT_NO_DEL_FRR');
477: hr_utility.raise_error;
478: end if;
479: --
480: delete from pay_formula_result_rules_f
481: where current of csr_rows_owned_by_parent;
482: --
483: delete from hr_application_ownerships
484: where key_name = 'FORMULA_RESULT_RULE_ID'
487: elsif p_delete_mode = 'DELETE'
488: and p_session_date between fetched_row.effective_start_date
489: and fetched_row.effective_end_date then
490: --
491: update pay_formula_result_rules_f
492: set effective_end_date = p_session_date
493: where current of csr_rows_owned_by_parent;
494: --
495: elsif p_delete_mode = 'DELETE_NEXT_CHANGE'
529: v_result_rule_end_date date;
530: --
531: cursor c_direct_rule is
532: select min(frr.effective_start_date) -1
533: from pay_formula_result_rules_f frr
534: where frr.status_processing_rule_id = p_status_processing_rule_id
535: and frr.result_rule_type = 'D'
536: and frr.formula_result_rule_id <> nvl(p_formula_result_rule_id,0)
537: and frr.effective_end_date >= p_session_date;
537: and frr.effective_end_date >= p_session_date;
538: --
539: cursor c_message_rule is
540: select min(frr.effective_start_date) -1
541: from pay_formula_result_rules_f frr
542: where frr.status_processing_rule_id = p_status_processing_rule_id
543: and frr.result_rule_type = 'M'
544: and frr.result_name = p_result_name
545: and frr.formula_result_rule_id <> nvl(p_formula_result_rule_id,0)
546: and frr.effective_end_date >= p_session_date;
547: --
548: cursor c_stop_entry is
549: select min(frr.effective_start_date) -1
550: from pay_formula_result_rules_f frr
551: where frr.status_processing_rule_id = p_status_processing_rule_id
552: and frr.result_rule_type = 'S'
553: and frr.result_name = p_result_name
554: and frr.element_type_id = p_element_type_id
556: and frr.effective_end_date >= p_session_date;
557: --
558: cursor c_other_rules is
559: select min(frr.effective_start_date) -1
560: from pay_formula_result_rules_f frr
561: where frr.status_processing_rule_id = p_status_processing_rule_id
562: and frr.result_rule_type = p_result_rule_type
563: and frr.result_name = p_result_name
564: and frr.input_value_id = p_input_value_id