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

Line 311: SELECT fnd_date.canonical_to_date(prrv.result_value)

307: FUNCTION get_previous_payout_date (p_element_entry_id IN NUMBER, p_attachment_seq_no IN VARCHAR2) RETURN DATE
308: IS
309:
310: CURSOR csr_prev_payout IS
311: SELECT fnd_date.canonical_to_date(prrv.result_value)
312: from pay_run_results prr
313: ,pay_run_result_values prrv
314: ,pay_element_types_f pet
315: ,pay_input_values_f piv

Line 335: SELECT fnd_date.canonical_to_date(prrv.result_value)

331: -- Removed join with pay_element_types_f and used the cursor csr_etype
332: -- to get the element_type_id of 'WG Results'
333: --
334: CURSOR csr_prev_payout_bal_adj(p_element_type_id IN NUMBER) IS
335: SELECT fnd_date.canonical_to_date(prrv.result_value)
336: from pay_payroll_actions ppa
337: ,pay_assignment_actions paa
338: ,pay_run_results prr
339: ,pay_run_result_values prrv

Line 964: g_court_orders(l_court_order_no).interest_from_date1 := fnd_date.canonical_to_date(i.interest_from_date1);

960: g_court_orders(l_court_order_no).interest_base = 0 AND
961: NOT l_interest_loaded
962: THEN
963:
964: g_court_orders(l_court_order_no).interest_from_date1 := fnd_date.canonical_to_date(i.interest_from_date1);
965: g_court_orders(l_court_order_no).interest_from_date2 := fnd_date.canonical_to_date(i.interest_from_date2);
966: g_court_orders(l_court_order_no).interest_from_date3 := fnd_date.canonical_to_date(i.interest_from_date3);
967: g_court_orders(l_court_order_no).interest_from_date4 := fnd_date.canonical_to_date(i.interest_from_date4);
968: g_court_orders(l_court_order_no).interest_from_date5 := fnd_date.canonical_to_date(i.interest_from_date5);

Line 965: g_court_orders(l_court_order_no).interest_from_date2 := fnd_date.canonical_to_date(i.interest_from_date2);

961: NOT l_interest_loaded
962: THEN
963:
964: g_court_orders(l_court_order_no).interest_from_date1 := fnd_date.canonical_to_date(i.interest_from_date1);
965: g_court_orders(l_court_order_no).interest_from_date2 := fnd_date.canonical_to_date(i.interest_from_date2);
966: g_court_orders(l_court_order_no).interest_from_date3 := fnd_date.canonical_to_date(i.interest_from_date3);
967: g_court_orders(l_court_order_no).interest_from_date4 := fnd_date.canonical_to_date(i.interest_from_date4);
968: g_court_orders(l_court_order_no).interest_from_date5 := fnd_date.canonical_to_date(i.interest_from_date5);
969: -------------------------------------------------------------------------------

Line 966: g_court_orders(l_court_order_no).interest_from_date3 := fnd_date.canonical_to_date(i.interest_from_date3);

962: THEN
963:
964: g_court_orders(l_court_order_no).interest_from_date1 := fnd_date.canonical_to_date(i.interest_from_date1);
965: g_court_orders(l_court_order_no).interest_from_date2 := fnd_date.canonical_to_date(i.interest_from_date2);
966: g_court_orders(l_court_order_no).interest_from_date3 := fnd_date.canonical_to_date(i.interest_from_date3);
967: g_court_orders(l_court_order_no).interest_from_date4 := fnd_date.canonical_to_date(i.interest_from_date4);
968: g_court_orders(l_court_order_no).interest_from_date5 := fnd_date.canonical_to_date(i.interest_from_date5);
969: -------------------------------------------------------------------------------
970: -- If interest_to_date is null, then populate payout_date-1 in interest_to_date

Line 967: g_court_orders(l_court_order_no).interest_from_date4 := fnd_date.canonical_to_date(i.interest_from_date4);

963:
964: g_court_orders(l_court_order_no).interest_from_date1 := fnd_date.canonical_to_date(i.interest_from_date1);
965: g_court_orders(l_court_order_no).interest_from_date2 := fnd_date.canonical_to_date(i.interest_from_date2);
966: g_court_orders(l_court_order_no).interest_from_date3 := fnd_date.canonical_to_date(i.interest_from_date3);
967: g_court_orders(l_court_order_no).interest_from_date4 := fnd_date.canonical_to_date(i.interest_from_date4);
968: g_court_orders(l_court_order_no).interest_from_date5 := fnd_date.canonical_to_date(i.interest_from_date5);
969: -------------------------------------------------------------------------------
970: -- If interest_to_date is null, then populate payout_date-1 in interest_to_date
971: -------------------------------------------------------------------------------

Line 968: g_court_orders(l_court_order_no).interest_from_date5 := fnd_date.canonical_to_date(i.interest_from_date5);

964: g_court_orders(l_court_order_no).interest_from_date1 := fnd_date.canonical_to_date(i.interest_from_date1);
965: g_court_orders(l_court_order_no).interest_from_date2 := fnd_date.canonical_to_date(i.interest_from_date2);
966: g_court_orders(l_court_order_no).interest_from_date3 := fnd_date.canonical_to_date(i.interest_from_date3);
967: g_court_orders(l_court_order_no).interest_from_date4 := fnd_date.canonical_to_date(i.interest_from_date4);
968: g_court_orders(l_court_order_no).interest_from_date5 := fnd_date.canonical_to_date(i.interest_from_date5);
969: -------------------------------------------------------------------------------
970: -- If interest_to_date is null, then populate payout_date-1 in interest_to_date
971: -------------------------------------------------------------------------------
972: g_court_orders(l_court_order_no).interest_to_date1 := nvl(fnd_date.canonical_to_date(i.interest_to_date1), l_payout_date-1);

Line 972: g_court_orders(l_court_order_no).interest_to_date1 := nvl(fnd_date.canonical_to_date(i.interest_to_date1), l_payout_date-1);

968: g_court_orders(l_court_order_no).interest_from_date5 := fnd_date.canonical_to_date(i.interest_from_date5);
969: -------------------------------------------------------------------------------
970: -- If interest_to_date is null, then populate payout_date-1 in interest_to_date
971: -------------------------------------------------------------------------------
972: g_court_orders(l_court_order_no).interest_to_date1 := nvl(fnd_date.canonical_to_date(i.interest_to_date1), l_payout_date-1);
973: g_court_orders(l_court_order_no).interest_to_date2 := nvl(fnd_date.canonical_to_date(i.interest_to_date2), l_payout_date-1);
974: g_court_orders(l_court_order_no).interest_to_date3 := nvl(fnd_date.canonical_to_date(i.interest_to_date3), l_payout_date-1);
975: g_court_orders(l_court_order_no).interest_to_date4 := nvl(fnd_date.canonical_to_date(i.interest_to_date4), l_payout_date-1);
976: g_court_orders(l_court_order_no).interest_to_date5 := nvl(fnd_date.canonical_to_date(i.interest_to_date5), l_payout_date-1);

Line 973: g_court_orders(l_court_order_no).interest_to_date2 := nvl(fnd_date.canonical_to_date(i.interest_to_date2), l_payout_date-1);

969: -------------------------------------------------------------------------------
970: -- If interest_to_date is null, then populate payout_date-1 in interest_to_date
971: -------------------------------------------------------------------------------
972: g_court_orders(l_court_order_no).interest_to_date1 := nvl(fnd_date.canonical_to_date(i.interest_to_date1), l_payout_date-1);
973: g_court_orders(l_court_order_no).interest_to_date2 := nvl(fnd_date.canonical_to_date(i.interest_to_date2), l_payout_date-1);
974: g_court_orders(l_court_order_no).interest_to_date3 := nvl(fnd_date.canonical_to_date(i.interest_to_date3), l_payout_date-1);
975: g_court_orders(l_court_order_no).interest_to_date4 := nvl(fnd_date.canonical_to_date(i.interest_to_date4), l_payout_date-1);
976: g_court_orders(l_court_order_no).interest_to_date5 := nvl(fnd_date.canonical_to_date(i.interest_to_date5), l_payout_date-1);
977: --------------------------------------------------------------------------------------

Line 974: g_court_orders(l_court_order_no).interest_to_date3 := nvl(fnd_date.canonical_to_date(i.interest_to_date3), l_payout_date-1);

970: -- If interest_to_date is null, then populate payout_date-1 in interest_to_date
971: -------------------------------------------------------------------------------
972: g_court_orders(l_court_order_no).interest_to_date1 := nvl(fnd_date.canonical_to_date(i.interest_to_date1), l_payout_date-1);
973: g_court_orders(l_court_order_no).interest_to_date2 := nvl(fnd_date.canonical_to_date(i.interest_to_date2), l_payout_date-1);
974: g_court_orders(l_court_order_no).interest_to_date3 := nvl(fnd_date.canonical_to_date(i.interest_to_date3), l_payout_date-1);
975: g_court_orders(l_court_order_no).interest_to_date4 := nvl(fnd_date.canonical_to_date(i.interest_to_date4), l_payout_date-1);
976: g_court_orders(l_court_order_no).interest_to_date5 := nvl(fnd_date.canonical_to_date(i.interest_to_date5), l_payout_date-1);
977: --------------------------------------------------------------------------------------
978: -- Bug 2893245

Line 975: g_court_orders(l_court_order_no).interest_to_date4 := nvl(fnd_date.canonical_to_date(i.interest_to_date4), l_payout_date-1);

971: -------------------------------------------------------------------------------
972: g_court_orders(l_court_order_no).interest_to_date1 := nvl(fnd_date.canonical_to_date(i.interest_to_date1), l_payout_date-1);
973: g_court_orders(l_court_order_no).interest_to_date2 := nvl(fnd_date.canonical_to_date(i.interest_to_date2), l_payout_date-1);
974: g_court_orders(l_court_order_no).interest_to_date3 := nvl(fnd_date.canonical_to_date(i.interest_to_date3), l_payout_date-1);
975: g_court_orders(l_court_order_no).interest_to_date4 := nvl(fnd_date.canonical_to_date(i.interest_to_date4), l_payout_date-1);
976: g_court_orders(l_court_order_no).interest_to_date5 := nvl(fnd_date.canonical_to_date(i.interest_to_date5), l_payout_date-1);
977: --------------------------------------------------------------------------------------
978: -- Bug 2893245
979: -- Previous Payout Date is now computed only for the interest rate based court orders.

Line 976: g_court_orders(l_court_order_no).interest_to_date5 := nvl(fnd_date.canonical_to_date(i.interest_to_date5), l_payout_date-1);

972: g_court_orders(l_court_order_no).interest_to_date1 := nvl(fnd_date.canonical_to_date(i.interest_to_date1), l_payout_date-1);
973: g_court_orders(l_court_order_no).interest_to_date2 := nvl(fnd_date.canonical_to_date(i.interest_to_date2), l_payout_date-1);
974: g_court_orders(l_court_order_no).interest_to_date3 := nvl(fnd_date.canonical_to_date(i.interest_to_date3), l_payout_date-1);
975: g_court_orders(l_court_order_no).interest_to_date4 := nvl(fnd_date.canonical_to_date(i.interest_to_date4), l_payout_date-1);
976: g_court_orders(l_court_order_no).interest_to_date5 := nvl(fnd_date.canonical_to_date(i.interest_to_date5), l_payout_date-1);
977: --------------------------------------------------------------------------------------
978: -- Bug 2893245
979: -- Previous Payout Date is now computed only for the interest rate based court orders.
980: --------------------------------------------------------------------------------------

Line 1947: l_payout_date := fnd_date.canonical_to_date (pay_kr_ff_functions_pkg.get_legislative_parameter(

1943: -- Bug 2762097 Fetch payoutdate from legislative_parameters in pay_payroll_actions table
1944: -- Bug 3021794 payout date is now stored in canonical format in legislative parameter.
1945: -- Thus modified the function call to get_legislative_parameter
1946:
1947: l_payout_date := fnd_date.canonical_to_date (pay_kr_ff_functions_pkg.get_legislative_parameter(
1948: P_PAYROLL_ACTION_ID => l_payroll_action_id,
1949: P_PARAMETER_NAME => 'PAYOUTDATE',
1950: P_DEFAULT_VALUE => fnd_date.date_to_canonical(l_period_end_date)));
1951:

Line 1950: P_DEFAULT_VALUE => fnd_date.date_to_canonical(l_period_end_date)));

1946:
1947: l_payout_date := fnd_date.canonical_to_date (pay_kr_ff_functions_pkg.get_legislative_parameter(
1948: P_PAYROLL_ACTION_ID => l_payroll_action_id,
1949: P_PARAMETER_NAME => 'PAYOUTDATE',
1950: P_DEFAULT_VALUE => fnd_date.date_to_canonical(l_period_end_date)));
1951:
1952: -- Load court orders only if this is the first assignment or is not previously processed
1953:
1954: IF (g_last_assignment_processed IS NULL) OR (p_assignment_id <> g_last_assignment_processed) THEN