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_FR_OVERTIME dependencies on FND_DATE

Line 624: fnd_date.date_to_canonical(p_range_start_date),

620: open get_elements('FR_REGULARISATION_WEEK','FR_REGULARISATION_WEEK_RETRO');
621: fetch get_elements into l_orig_ele_id,l_retr_ele_id;
622: close get_elements;
623: open c_get_regularisation(l_orig_ele_id,l_retr_ele_id,
624: fnd_date.date_to_canonical(p_range_start_date),
625: fnd_date.date_to_canonical(p_range_end_date));
626: fetch c_get_regularisation into l_last_regularisation,l_Proc_Seq_sum;
627: close c_get_regularisation;
628: --

Line 625: fnd_date.date_to_canonical(p_range_end_date));

621: fetch get_elements into l_orig_ele_id,l_retr_ele_id;
622: close get_elements;
623: open c_get_regularisation(l_orig_ele_id,l_retr_ele_id,
624: fnd_date.date_to_canonical(p_range_start_date),
625: fnd_date.date_to_canonical(p_range_end_date));
626: fetch c_get_regularisation into l_last_regularisation,l_Proc_Seq_sum;
627: close c_get_regularisation;
628: --
629: return fnd_date.canonical_to_date(l_last_regularisation);

Line 629: return fnd_date.canonical_to_date(l_last_regularisation);

625: fnd_date.date_to_canonical(p_range_end_date));
626: fetch c_get_regularisation into l_last_regularisation,l_Proc_Seq_sum;
627: close c_get_regularisation;
628: --
629: return fnd_date.canonical_to_date(l_last_regularisation);
630: end last_regularisation;
631: --
632: ------------------------------------------------------------------------
633: -- Function DETERMINE_REGULARISATION

Line 776: fnd_date.date_to_canonical(p_week_start_date)

772: where eev.input_value_id = iv.input_value_id
773: and eev.element_entry_id = ee.element_entry_id
774: and iv.name = 'Start Date'
775: and eev.screen_entry_value =
776: fnd_date.date_to_canonical(p_week_start_date)
777: )
778: and exists
779: (select null
780: from pay_element_entry_values_f eev

Line 786: fnd_date.date_to_canonical(p_week_end_date)

782: where eev.input_value_id = iv.input_value_id
783: and eev.element_entry_id = ee.element_entry_id
784: and iv.name = 'End Date'
785: and eev.screen_entry_value =
786: fnd_date.date_to_canonical(p_week_end_date)
787: );
788: --
789: l_entry_exists varchar2(1) := 'N';
790: --

Line 987: l_inputs(i).value := fnd_date.date_to_canonical(p_effective_date);

983: for i in l_inputs.first..l_inputs.last loop
984: if l_inputs(i).name = 'ASSIGNMENT_ID' then
985: l_inputs(i).value := p_assignment_id;
986: elsif l_inputs(i).name = 'DATE_EARNED' then
987: l_inputs(i).value := fnd_date.date_to_canonical(p_effective_date);
988: elsif l_inputs(i).name = 'BUSINESS_GROUP_ID' then
989: l_inputs(i).value := p_business_group_id;
990: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
991: l_inputs(i).value := p_assignment_action_id;

Line 995: l_inputs(i).value := fnd_date.date_to_canonical(p_week_start_date);

991: l_inputs(i).value := p_assignment_action_id;
992: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
993: l_inputs(i).value := p_payroll_action_id;
994: elsif l_inputs(i).name = 'WEEK_START_DATE' then
995: l_inputs(i).value := fnd_date.date_to_canonical(p_week_start_date);
996: elsif l_inputs(i).name = 'WEEK_END_DATE' then
997: l_inputs(i).value := fnd_date.date_to_canonical(p_week_end_date);
998: end if;
999: end loop;

Line 997: l_inputs(i).value := fnd_date.date_to_canonical(p_week_end_date);

993: l_inputs(i).value := p_payroll_action_id;
994: elsif l_inputs(i).name = 'WEEK_START_DATE' then
995: l_inputs(i).value := fnd_date.date_to_canonical(p_week_start_date);
996: elsif l_inputs(i).name = 'WEEK_END_DATE' then
997: l_inputs(i).value := fnd_date.date_to_canonical(p_week_end_date);
998: end if;
999: end loop;
1000: end if;
1001: --

Line 1148: l_inputs(i).value := fnd_date.date_to_canonical(p_effective_date);

1144: for i in l_inputs.first..l_inputs.last loop
1145: if l_inputs(i).name = 'ASSIGNMENT_ID' then
1146: l_inputs(i).value := p_assignment_id;
1147: elsif l_inputs(i).name = 'DATE_EARNED' then
1148: l_inputs(i).value := fnd_date.date_to_canonical(p_effective_date);
1149: elsif l_inputs(i).name = 'BUSINESS_GROUP_ID' then
1150: l_inputs(i).value := p_business_group_id;
1151: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
1152: l_inputs(i).value := p_assignment_action_id;

Line 1156: l_inputs(i).value := fnd_date.date_to_canonical(p_reg_period_start_date);

1152: l_inputs(i).value := p_assignment_action_id;
1153: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
1154: l_inputs(i).value := p_payroll_action_id;
1155: elsif l_inputs(i).name = 'REG_PERIOD_START_DATE' then
1156: l_inputs(i).value := fnd_date.date_to_canonical(p_reg_period_start_date);
1157: elsif l_inputs(i).name = 'REG_PERIOD_END_DATE' then
1158: l_inputs(i).value := fnd_date.date_to_canonical(p_reg_period_end_date);
1159: end if;
1160: end loop;

Line 1158: l_inputs(i).value := fnd_date.date_to_canonical(p_reg_period_end_date);

1154: l_inputs(i).value := p_payroll_action_id;
1155: elsif l_inputs(i).name = 'REG_PERIOD_START_DATE' then
1156: l_inputs(i).value := fnd_date.date_to_canonical(p_reg_period_start_date);
1157: elsif l_inputs(i).name = 'REG_PERIOD_END_DATE' then
1158: l_inputs(i).value := fnd_date.date_to_canonical(p_reg_period_end_date);
1159: end if;
1160: end loop;
1161: end if;
1162: --

Line 1401: fnd_date.date_to_canonical(p_week_end_date));

1397: open get_elements('FR_OVERTIME_WEEK_PROCESS','FR_OVERTIME_WEEK_PROCESS_RETRO');
1398: fetch get_elements into l_orig_ele_id,l_retr_ele_id;
1399: close get_elements;
1400: open get_existing_week(l_orig_ele_id,l_retr_ele_id,
1401: fnd_date.date_to_canonical(p_week_end_date));
1402: fetch get_existing_week into l_exists;
1403: close get_existing_week;
1404: --
1405: return l_exists;

Line 1481: fnd_date.date_to_canonical(p_start_date),

1477: fetch get_element into l_ele;
1478: if get_element%FOUND then
1479: open get_balance(l_ele.element_type_id,l_ele.value_iv,
1480: l_ele.start_iv, l_ele.end_iv,
1481: fnd_date.date_to_canonical(p_start_date),
1482: fnd_date.date_to_canonical(p_end_date));
1483: fetch get_balance into l_balance;
1484: close get_balance;
1485: end if;

Line 1482: fnd_date.date_to_canonical(p_end_date));

1478: if get_element%FOUND then
1479: open get_balance(l_ele.element_type_id,l_ele.value_iv,
1480: l_ele.start_iv, l_ele.end_iv,
1481: fnd_date.date_to_canonical(p_start_date),
1482: fnd_date.date_to_canonical(p_end_date));
1483: fetch get_balance into l_balance;
1484: close get_balance;
1485: end if;
1486: close get_element;