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_ACCRUAL_PLANS_PKG dependencies on DUAL

Line 11: X_Residual_Input_Value_Id NUMBER,

7: X_Business_Group_Id NUMBER,
8: X_Accrual_Plan_Element_Type_Id NUMBER,
9: X_Pto_Input_Value_Id NUMBER,
10: X_Co_Input_Value_Id NUMBER,
11: X_Residual_Input_Value_Id NUMBER,
12: X_Accrual_Category VARCHAR2,
13: X_Accrual_Plan_Name VARCHAR2,
14: X_Accrual_Start VARCHAR2,
15: X_Accrual_Units_Of_Measure VARCHAR2,

Line 22: CURSOR C2 IS SELECT pay_accrual_plans_s.nextval FROM sys.dual;

18: ) IS
19: CURSOR C IS SELECT rowid FROM PAY_ACCRUAL_PLANS
20: WHERE accrual_plan_id = X_Accrual_Plan_Id;
21:
22: CURSOR C2 IS SELECT pay_accrual_plans_s.nextval FROM sys.dual;
23: BEGIN
24:
25: if (X_Accrual_Plan_Id is NULL) then
26: OPEN C2;

Line 36: residual_input_value_id,

32: business_group_id,
33: accrual_plan_element_type_id,
34: pto_input_value_id,
35: co_input_value_id,
36: residual_input_value_id,
37: accrual_category,
38: accrual_plan_name,
39: accrual_start,
40: accrual_units_of_measure,

Line 49: X_Residual_Input_Value_Id,

45: X_Business_Group_Id,
46: X_Accrual_Plan_Element_Type_Id,
47: X_Pto_Input_Value_Id,
48: X_Co_Input_Value_Id,
49: X_Residual_Input_Value_Id,
50: X_Accrual_Category,
51: X_Accrual_Plan_Name,
52: X_Accrual_Start,
53: X_Accrual_Units_Of_Measure,

Line 72: X_Residual_Input_Value_Id NUMBER,

68: X_Business_Group_Id NUMBER,
69: X_Accrual_Plan_Element_Type_Id NUMBER,
70: X_Pto_Input_Value_Id NUMBER,
71: X_Co_Input_Value_Id NUMBER,
72: X_Residual_Input_Value_Id NUMBER,
73: X_Accrual_Category VARCHAR2,
74: X_Accrual_Plan_Name VARCHAR2,
75: X_Accrual_Start VARCHAR2,
76: X_Accrual_Units_Of_Measure VARCHAR2,

Line 119: AND ( (Recinfo.residual_input_value_id = X_Residual_Input_Value_Id)

115: AND (X_Pto_Input_Value_Id IS NULL)))
116: AND ( (Recinfo.co_input_value_id = X_Co_Input_Value_Id)
117: OR ( (Recinfo.co_input_value_id IS NULL)
118: AND (X_Co_Input_Value_Id IS NULL)))
119: AND ( (Recinfo.residual_input_value_id = X_Residual_Input_Value_Id)
120: OR ( (Recinfo.residual_input_value_id IS NULL)
121: AND (X_Residual_Input_Value_Id IS NULL)))
122: AND ( (Recinfo.accrual_category = X_Accrual_Category)
123: OR ( (Recinfo.accrual_category IS NULL)

Line 120: OR ( (Recinfo.residual_input_value_id IS NULL)

116: AND ( (Recinfo.co_input_value_id = X_Co_Input_Value_Id)
117: OR ( (Recinfo.co_input_value_id IS NULL)
118: AND (X_Co_Input_Value_Id IS NULL)))
119: AND ( (Recinfo.residual_input_value_id = X_Residual_Input_Value_Id)
120: OR ( (Recinfo.residual_input_value_id IS NULL)
121: AND (X_Residual_Input_Value_Id IS NULL)))
122: AND ( (Recinfo.accrual_category = X_Accrual_Category)
123: OR ( (Recinfo.accrual_category IS NULL)
124: AND (X_Accrual_Category IS NULL)))

Line 121: AND (X_Residual_Input_Value_Id IS NULL)))

117: OR ( (Recinfo.co_input_value_id IS NULL)
118: AND (X_Co_Input_Value_Id IS NULL)))
119: AND ( (Recinfo.residual_input_value_id = X_Residual_Input_Value_Id)
120: OR ( (Recinfo.residual_input_value_id IS NULL)
121: AND (X_Residual_Input_Value_Id IS NULL)))
122: AND ( (Recinfo.accrual_category = X_Accrual_Category)
123: OR ( (Recinfo.accrual_category IS NULL)
124: AND (X_Accrual_Category IS NULL)))
125: AND ( (Recinfo.accrual_plan_name = X_Accrual_Plan_Name)

Line 154: X_Residual_Input_Value_Id NUMBER,

150: X_Business_Group_Id NUMBER,
151: X_Accrual_Plan_Element_Type_Id NUMBER,
152: X_Pto_Input_Value_Id NUMBER,
153: X_Co_Input_Value_Id NUMBER,
154: X_Residual_Input_Value_Id NUMBER,
155: X_Accrual_Category VARCHAR2,
156: X_Accrual_Plan_Name VARCHAR2,
157: X_Accrual_Start VARCHAR2,
158: X_Accrual_Units_Of_Measure VARCHAR2,

Line 170: residual_input_value_id = X_Residual_Input_Value_Id,

166: business_group_id = X_Business_Group_Id,
167: accrual_plan_element_type_id = X_Accrual_Plan_Element_Type_Id,
168: pto_input_value_id = X_Pto_Input_Value_Id,
169: co_input_value_id = X_Co_Input_Value_Id,
170: residual_input_value_id = X_Residual_Input_Value_Id,
171: accrual_category = X_Accrual_Category,
172: accrual_plan_name = X_Accrual_Plan_Name,
173: accrual_start = X_Accrual_Start,
174: accrual_units_of_measure = X_Accrual_Units_Of_Measure,

Line 228: 'RESIDUAL ' || upper(p_plan_name),

224: select 'Y'
225: from PAY_ELEMENT_TYPES_F
226: where upper(ELEMENT_NAME) in
227: (upper(p_plan_name),
228: 'RESIDUAL ' || upper(p_plan_name),
229: 'CARRIED OVER ' || upper(p_plan_name));
230: --
231: BEGIN
232: --

Line 484: p_residual_input_value_id OUT number,

480: p_business_group_id IN number,
481: p_accrual_plan_element_type_id OUT number,
482: p_co_input_value_id OUT number,
483: p_co_element_type_id OUT number,
484: p_residual_input_value_id OUT number,
485: p_residual_element_type_id OUT number) IS
486: --
487: l_element_type_id number;
488: l_element_name varchar2(80);

Line 485: p_residual_element_type_id OUT number) IS

481: p_accrual_plan_element_type_id OUT number,
482: p_co_input_value_id OUT number,
483: p_co_element_type_id OUT number,
484: p_residual_input_value_id OUT number,
485: p_residual_element_type_id OUT number) IS
486: --
487: l_element_type_id number;
488: l_element_name varchar2(80);
489: l_element_description varchar2(240);

Line 654: -- and finally, Esther, the residual element type and input value.

650: p_co_element_type_id := l_element_type_id;
651: p_co_input_value_id := l_input_value_id;
652: --
653: --
654: -- and finally, Esther, the residual element type and input value.
655: --
656: --
657: l_element_name := substr('Residual ' || p_plan_name, 1, 80);
658: l_element_description :=

Line 657: l_element_name := substr('Residual ' || p_plan_name, 1, 80);

653: --
654: -- and finally, Esther, the residual element type and input value.
655: --
656: --
657: l_element_name := substr('Residual ' || p_plan_name, 1, 80);
658: l_element_description :=
659: 'Residual entitlement for accrual plan ' || p_plan_name;
660: --
661: l_element_type_id := PAY_ACCRUAL_PLANS_PKG.CREATE_ELEMENT(

Line 659: 'Residual entitlement for accrual plan ' || p_plan_name;

655: --
656: --
657: l_element_name := substr('Residual ' || p_plan_name, 1, 80);
658: l_element_description :=
659: 'Residual entitlement for accrual plan ' || p_plan_name;
660: --
661: l_element_type_id := PAY_ACCRUAL_PLANS_PKG.CREATE_ELEMENT(
662: l_element_name,
663: l_element_description,

Line 683: p_residual_element_type_id := l_element_type_id;

679: 'N',
680: l_leg_code,
681: l_classification_type);
682: --
683: p_residual_element_type_id := l_element_type_id;
684: p_residual_input_value_id := l_input_value_id;
685: --
686: --
687: END pre_insert_actions;

Line 684: p_residual_input_value_id := l_input_value_id;

680: l_leg_code,
681: l_classification_type);
682: --
683: p_residual_element_type_id := l_element_type_id;
684: p_residual_input_value_id := l_input_value_id;
685: --
686: --
687: END pre_insert_actions;
688: --

Line 729: from dual;

725: p_accrual_plan_id,
726: p_business_group_id,
727: p_pto_input_value_id,
728: -1
729: from dual;
730: --
731: -- insert the carried over input value (always increases entitlement)
732: --
733: hr_utility.set_location('pay_accrual_plans_pkg.post_insert_actions',2);

Line 746: from dual;

742: p_accrual_plan_id,
743: p_business_group_id,
744: p_co_input_value_id,
745: 1
746: from dual;
747: --
748: hr_utility.set_location('pay_accrual_plans_pkg.post_insert_actions',3);
749: --
750: -- The update below was originally written as a separate implicit SELECT

Line 842: from dual

838: p_accrual_plan_id,
839: p_business_group_id,
840: p_pto_input_value_id,
841: -1
842: from dual
843: where not exists(
844: select 1
845: from pay_net_calculation_rules
846: where input_value_id = p_pto_input_value_id

Line 862: delete the residual element type;

858: DESCRIPTION performs all of the actions required before deleting the plan -
859: delete all child accrual bands;
860: delete all child net calculation rules;
861: delete the element type created for the accrual plan;
862: delete the residual element type;
863: delete the carried over element type.
864:
865: NOTES none
866: ****************************************************************************

Line 871: p_residual_element_type_id IN number,

867: */
868: PROCEDURE pre_delete_actions(p_accrual_plan_id IN number,
869: p_accrual_plan_element_type_id IN number,
870: p_co_element_type_id IN number,
871: p_residual_element_type_id IN number,
872: p_session_date IN date) IS
873: --
874: l_effective_start_date date;
875: l_effective_end_date date;

Line 947: -- ...then the residual element type.

943: delete from pay_element_types_f
944: where element_type_id = p_co_element_type_id;
945: --
946: --
947: -- ...then the residual element type.
948: --
949: --
950: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 9);
951: hr_elements.chk_del_element_type (

Line 953: p_residual_element_type_id,

949: --
950: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 9);
951: hr_elements.chk_del_element_type (
952: 'ZAP',
953: p_residual_element_type_id,
954: '',
955: p_session_date,
956: l_effective_start_date,
957: l_effective_end_date);

Line 961: p_residual_element_type_id,

957: l_effective_end_date);
958: --
959: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 10);
960: hr_elements.del_3p_element_type (
961: p_residual_element_type_id,
962: 'ZAP',
963: p_session_date,
964: l_effective_start_date,
965: l_effective_end_date,

Line 970: where element_type_id = p_residual_element_type_id;

966: '');
967: --
968: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 11);
969: delete from pay_element_types_f
970: where element_type_id = p_residual_element_type_id;
971: --
972: END pre_delete_actions;
973: --
974: --