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

Line 139: pap.residual_input_value_id residual_input_value_id,

135: pap.accrual_plan_name accrual_plan_name,
136: pap.co_formula_id co_formula_id,
137: pap.accrual_plan_element_type_id accrual_plan_element_type_id,
138: pap.co_input_value_id co_input_value_id,
139: pap.residual_input_value_id residual_input_value_id,
140: pap.co_date_input_value_id co_date_input_value_id,
141: pap.co_exp_date_input_value_id co_exp_date_input_value_id,
142: pap.residual_date_input_value_id residual_date_input_value_id,
143: piv1.element_type_id co_element_type_id,

Line 142: pap.residual_date_input_value_id residual_date_input_value_id,

138: pap.co_input_value_id co_input_value_id,
139: pap.residual_input_value_id residual_input_value_id,
140: pap.co_date_input_value_id co_date_input_value_id,
141: pap.co_exp_date_input_value_id co_exp_date_input_value_id,
142: pap.residual_date_input_value_id residual_date_input_value_id,
143: piv1.element_type_id co_element_type_id,
144: piv2.element_type_id residual_element_type_id
145: from pay_accrual_plans pap,
146: pay_input_values_f piv1,

Line 144: piv2.element_type_id residual_element_type_id

140: pap.co_date_input_value_id co_date_input_value_id,
141: pap.co_exp_date_input_value_id co_exp_date_input_value_id,
142: pap.residual_date_input_value_id residual_date_input_value_id,
143: piv1.element_type_id co_element_type_id,
144: piv2.element_type_id residual_element_type_id
145: from pay_accrual_plans pap,
146: pay_input_values_f piv1,
147: pay_input_values_f piv2
148: where (pap.accrual_plan_id = nvl(p_plan_id, -1) OR

Line 154: and piv2.input_value_id = pap.RESIDUAL_INPUT_VALUE_ID

150: and pap.business_group_id = p_business_group_id
151: and piv1.input_value_id = pap.CO_INPUT_VALUE_ID
152: and P_date between piv1.effective_start_date and
153: piv1.effective_end_date
154: and piv2.input_value_id = pap.RESIDUAL_INPUT_VALUE_ID
155: and P_date between piv2.effective_start_date and
156: piv2.effective_end_date;
157: --
158: -- Local variables

Line 237: from dual;

233: where session_id = userenv('sessionid');
234: exception
235: when others then
236: select sysdate into l_session_date
237: from dual;
238: end;
239:
240: write_log('l_session_date: '||to_char(l_session_date), DEBUG);
241:

Line 297: P_res_ele_type_id => l_accrual_plan.residual_element_type_id,

293: P_co_ele_type_id => l_accrual_plan.co_element_type_id,
294: P_co_input_val_id => l_accrual_plan.co_input_value_id,
295: P_co_date_input_value_id => l_accrual_plan.co_date_input_value_id,
296: P_co_exp_date_input_value_id => l_accrual_plan.co_exp_date_input_value_id,
297: P_res_ele_type_id => l_accrual_plan.residual_element_type_id,
298: P_res_input_val_id => l_accrual_plan.residual_input_value_id,
299: P_res_date_input_value_id => l_accrual_plan.residual_date_input_value_id,
300: p_business_group_id => p_business_group_id,
301: P_Calculation_date => l_calculation_date,

Line 298: P_res_input_val_id => l_accrual_plan.residual_input_value_id,

294: P_co_input_val_id => l_accrual_plan.co_input_value_id,
295: P_co_date_input_value_id => l_accrual_plan.co_date_input_value_id,
296: P_co_exp_date_input_value_id => l_accrual_plan.co_exp_date_input_value_id,
297: P_res_ele_type_id => l_accrual_plan.residual_element_type_id,
298: P_res_input_val_id => l_accrual_plan.residual_input_value_id,
299: P_res_date_input_value_id => l_accrual_plan.residual_date_input_value_id,
300: p_business_group_id => p_business_group_id,
301: P_Calculation_date => l_calculation_date,
302: P_co_mode => p_mode,

Line 299: P_res_date_input_value_id => l_accrual_plan.residual_date_input_value_id,

295: P_co_date_input_value_id => l_accrual_plan.co_date_input_value_id,
296: P_co_exp_date_input_value_id => l_accrual_plan.co_exp_date_input_value_id,
297: P_res_ele_type_id => l_accrual_plan.residual_element_type_id,
298: P_res_input_val_id => l_accrual_plan.residual_input_value_id,
299: P_res_date_input_value_id => l_accrual_plan.residual_date_input_value_id,
300: p_business_group_id => p_business_group_id,
301: P_Calculation_date => l_calculation_date,
302: P_co_mode => p_mode,
303: p_accrual_term => p_accrual_term,

Line 665: l_residual number;

661: l_max_carryover number;
662: l_effective_date date;
663: l_expiry_date date;
664: l_carryover number;
665: l_residual number;
666: l_total_accrual number;
667: l_net_entitlement number;
668: l_payroll_id number;
669: l_co_ele_entry_id number := 0;

Line 791: -- Get the links for the co and residual elements

787:
788: write_log('2nd l_payroll_id: '||to_char(l_payroll_id), DEBUG);
789:
790: --
791: -- Get the links for the co and residual elements
792: --
793: write_log(l_proc||', 35', DEBUG);
794:
795: l_co_link_id := hr_entry_api.get_link(

Line 870: ,l_residual => l_residual

866: ,l_effective_date => l_effective_date
867: ,l_total_accrual => l_total_accrual
868: ,l_net_entitlement => l_net_entitlement
869: ,l_max_carryover => l_max_carryover
870: ,l_residual => l_residual
871: ,l_carryover => l_carryover
872: );
873:
874: Else

Line 879: l_residual := 0;

875: if l_net_entitlement <= l_max_carryover then
876: --
877: write_log(l_proc||', 70', DEBUG);
878: l_carryover := round(l_net_entitlement, 3);
879: l_residual := 0;
880: --
881: else
882: --
883: write_log(l_proc||', 75', DEBUG);

Line 885: l_residual := round((l_net_entitlement - l_max_carryover), 3);

881: else
882: --
883: write_log(l_proc||', 75', DEBUG);
884: l_carryover := round(l_max_carryover, 3);
885: l_residual := round((l_net_entitlement - l_max_carryover), 3);
886: --
887: end if;
888: End if;
889:

Line 898: l_residual := 0;

894: if l_net_entitlement <= l_max_carryover then
895: --
896: write_log(l_proc||', 70', DEBUG);
897: l_carryover := round(l_net_entitlement, 3);
898: l_residual := 0;
899: --
900: else
901: --
902: write_log(l_proc||', 75', DEBUG);

Line 904: l_residual := round((l_net_entitlement - l_max_carryover), 3);

900: else
901: --
902: write_log(l_proc||', 75', DEBUG);
903: l_carryover := round(l_max_carryover, 3);
904: l_residual := round((l_net_entitlement - l_max_carryover), 3);
905: --
906: end if;
907:
908: */

Line 911: write_log('l_residual: '||to_char(l_residual), DEBUG);

907:
908: */
909:
910: write_log('l_carryover: '||to_char(l_carryover), DEBUG);
911: write_log('l_residual: '||to_char(l_residual), DEBUG);
912:
913: --
914: -- We must get the payroll period start and end dates for
915: -- the period in which the element entry will be made,

Line 1034: -- Check whether a residual element entry already exists

1030:
1031: write_log(l_proc||', 120', DEBUG);
1032:
1033: --
1034: -- Check whether a residual element entry already exists
1035: -- for the given accrual plan, accrual term and assignment
1036: --
1037: open csr_check_ee_exist (l_res_link_id,
1038: l_effective_date + 1,

Line 1045: IF csr_check_ee_exist%NOTFOUND and l_residual <> 0 then

1041: fetch csr_check_ee_exist INTO l_res_ele_entry_id;
1042:
1043: write_log('l_res_ele_entry_id: '||to_char(l_res_ele_entry_id), DEBUG);
1044:
1045: IF csr_check_ee_exist%NOTFOUND and l_residual <> 0 then
1046: --
1047: -- Insert entry for Residual element
1048: --
1049: write_log(l_proc||', 130', DEBUG);

Line 1047: -- Insert entry for Residual element

1043: write_log('l_res_ele_entry_id: '||to_char(l_res_ele_entry_id), DEBUG);
1044:
1045: IF csr_check_ee_exist%NOTFOUND and l_residual <> 0 then
1046: --
1047: -- Insert entry for Residual element
1048: --
1049: write_log(l_proc||', 130', DEBUG);
1050:
1051: inp_value_id_tbl(1) := p_res_input_val_id;

Line 1052: scr_valuetbl(1) := to_char(l_residual); -- Bug 4752106

1048: --
1049: write_log(l_proc||', 130', DEBUG);
1050:
1051: inp_value_id_tbl(1) := p_res_input_val_id;
1052: scr_valuetbl(1) := to_char(l_residual); -- Bug 4752106
1053:
1054: inp_value_id_tbl(2) := p_res_date_input_value_id;
1055: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1);
1056:

Line 1073: -- Update Element entry for Residual element, using

1069: write_log(l_proc||', 135', DEBUG);
1070:
1071: elsif csr_check_ee_exist%FOUND AND p_co_mode = 'Y' THEN
1072: --
1073: -- Update Element entry for Residual element, using
1074: -- date track CORRECTION mode.
1075: --
1076: write_log(l_proc||', 140', DEBUG);
1077:

Line 1079: scr_valuetbl(1) := to_char(l_residual); -- Bug 4752106

1075: --
1076: write_log(l_proc||', 140', DEBUG);
1077:
1078: inp_value_id_tbl(1) := p_res_input_val_id;
1079: scr_valuetbl(1) := to_char(l_residual); -- Bug 4752106
1080:
1081: inp_value_id_tbl(2) := P_res_date_input_value_id;
1082: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1);
1083: