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: papt.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: pay_accrual_plans_tl papt

Line 157: and piv2.input_value_id = pap.RESIDUAL_INPUT_VALUE_ID

153: and pap.business_group_id = p_business_group_id
154: and piv1.input_value_id = pap.CO_INPUT_VALUE_ID
155: and P_date between piv1.effective_start_date and
156: piv1.effective_end_date
157: and piv2.input_value_id = pap.RESIDUAL_INPUT_VALUE_ID
158: and P_date between piv2.effective_start_date and
159: piv2.effective_end_date;
160: -- ER 13836303
161: --

Line 241: from dual;

237: where session_id = userenv('sessionid');
238: exception
239: when others then
240: select sysdate into l_session_date
241: from dual;
242: end;
243:
244: write_log('l_session_date: '||to_char(l_session_date), DEBUG);
245:

Line 301: P_res_ele_type_id => l_accrual_plan.residual_element_type_id,

297: P_co_ele_type_id => l_accrual_plan.co_element_type_id,
298: P_co_input_val_id => l_accrual_plan.co_input_value_id,
299: P_co_date_input_value_id => l_accrual_plan.co_date_input_value_id,
300: P_co_exp_date_input_value_id => l_accrual_plan.co_exp_date_input_value_id,
301: P_res_ele_type_id => l_accrual_plan.residual_element_type_id,
302: P_res_input_val_id => l_accrual_plan.residual_input_value_id,
303: P_res_date_input_value_id => l_accrual_plan.residual_date_input_value_id,
304: p_business_group_id => p_business_group_id,
305: P_Calculation_date => l_calculation_date,

Line 302: P_res_input_val_id => l_accrual_plan.residual_input_value_id,

298: P_co_input_val_id => l_accrual_plan.co_input_value_id,
299: P_co_date_input_value_id => l_accrual_plan.co_date_input_value_id,
300: P_co_exp_date_input_value_id => l_accrual_plan.co_exp_date_input_value_id,
301: P_res_ele_type_id => l_accrual_plan.residual_element_type_id,
302: P_res_input_val_id => l_accrual_plan.residual_input_value_id,
303: P_res_date_input_value_id => l_accrual_plan.residual_date_input_value_id,
304: p_business_group_id => p_business_group_id,
305: P_Calculation_date => l_calculation_date,
306: P_co_mode => p_mode,

Line 303: P_res_date_input_value_id => l_accrual_plan.residual_date_input_value_id,

299: P_co_date_input_value_id => l_accrual_plan.co_date_input_value_id,
300: P_co_exp_date_input_value_id => l_accrual_plan.co_exp_date_input_value_id,
301: P_res_ele_type_id => l_accrual_plan.residual_element_type_id,
302: P_res_input_val_id => l_accrual_plan.residual_input_value_id,
303: P_res_date_input_value_id => l_accrual_plan.residual_date_input_value_id,
304: p_business_group_id => p_business_group_id,
305: P_Calculation_date => l_calculation_date,
306: P_co_mode => p_mode,
307: p_accrual_term => p_accrual_term,

Line 693: l_residual number;

689: l_max_carryover number;
690: l_effective_date date;
691: l_expiry_date date;
692: l_carryover number;
693: l_residual number;
694: l_total_accrual number;
695: l_net_entitlement number;
696: l_payroll_id number;
697: l_co_ele_entry_id number := 0;

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

815:
816: write_log('2nd l_payroll_id: '||to_char(l_payroll_id), DEBUG);
817:
818: --
819: -- Get the links for the co and residual elements
820: --
821: write_log(l_proc||', 35', DEBUG);
822:
823: l_co_link_id := hr_entry_api.get_link(

Line 898: ,l_residual => l_residual

894: ,l_effective_date => l_effective_date
895: ,l_total_accrual => l_total_accrual
896: ,l_net_entitlement => l_net_entitlement
897: ,l_max_carryover => l_max_carryover
898: ,l_residual => l_residual
899: ,l_carryover => l_carryover
900: );
901:
902: Else

Line 907: l_residual := 0;

903: if l_net_entitlement <= l_max_carryover then
904: --
905: write_log(l_proc||', 70', DEBUG);
906: l_carryover := round(l_net_entitlement, 3);
907: l_residual := 0;
908: --
909: else
910: --
911: write_log(l_proc||', 75', DEBUG);

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

909: else
910: --
911: write_log(l_proc||', 75', DEBUG);
912: l_carryover := round(l_max_carryover, 3);
913: l_residual := round((l_net_entitlement - l_max_carryover), 3);
914: --
915: end if;
916: End if;
917:

Line 926: l_residual := 0;

922: if l_net_entitlement <= l_max_carryover then
923: --
924: write_log(l_proc||', 70', DEBUG);
925: l_carryover := round(l_net_entitlement, 3);
926: l_residual := 0;
927: --
928: else
929: --
930: write_log(l_proc||', 75', DEBUG);

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

928: else
929: --
930: write_log(l_proc||', 75', DEBUG);
931: l_carryover := round(l_max_carryover, 3);
932: l_residual := round((l_net_entitlement - l_max_carryover), 3);
933: --
934: end if;
935:
936: */

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

935:
936: */
937:
938: write_log('l_carryover: '||to_char(l_carryover), DEBUG);
939: write_log('l_residual: '||to_char(l_residual), DEBUG);
940:
941: --
942: -- We must get the payroll period start and end dates for
943: -- the period in which the element entry will be made,

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

1064:
1065: write_log(l_proc||', 120', DEBUG);
1066:
1067: --
1068: -- Check whether a residual element entry already exists
1069: -- for the given accrual plan, accrual term and assignment
1070: --
1071: open csr_check_ee_exist (l_res_link_id,
1072: l_effective_date + 1,

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

1075: fetch csr_check_ee_exist INTO l_res_ele_entry_id;
1076:
1077: write_log('l_res_ele_entry_id: '||to_char(l_res_ele_entry_id), DEBUG);
1078:
1079: IF csr_check_ee_exist%NOTFOUND and l_residual <> 0 then
1080: --
1081: -- Insert entry for Residual element
1082: --
1083: write_log(l_proc||', 130', DEBUG);

Line 1081: -- Insert entry for Residual element

1077: write_log('l_res_ele_entry_id: '||to_char(l_res_ele_entry_id), DEBUG);
1078:
1079: IF csr_check_ee_exist%NOTFOUND and l_residual <> 0 then
1080: --
1081: -- Insert entry for Residual element
1082: --
1083: write_log(l_proc||', 130', DEBUG);
1084:
1085: inp_value_id_tbl(1) := p_res_input_val_id;

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

1082: --
1083: write_log(l_proc||', 130', DEBUG);
1084:
1085: inp_value_id_tbl(1) := p_res_input_val_id;
1086: scr_valuetbl(1) := to_char(l_residual); -- Bug 4752106
1087:
1088: inp_value_id_tbl(2) := p_res_date_input_value_id;
1089: -- scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */
1090: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */

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

1105: write_log(l_proc||', 135', DEBUG);
1106:
1107: elsif csr_check_ee_exist%FOUND AND p_co_mode = 'Y' THEN
1108: --
1109: -- Update Element entry for Residual element, using
1110: -- date track CORRECTION mode.
1111: --
1112: write_log(l_proc||', 140', DEBUG);
1113:

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

1111: --
1112: write_log(l_proc||', 140', DEBUG);
1113:
1114: inp_value_id_tbl(1) := p_res_input_val_id;
1115: scr_valuetbl(1) := to_char(l_residual); -- Bug 4752106
1116:
1117: inp_value_id_tbl(2) := P_res_date_input_value_id;
1118: -- scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */
1119: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */