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

Line 69: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);

65: -- Set up parameter values for the formula
66: for i in g_inputs.first..g_inputs.last loop
67: --
68: if g_inputs(i).name = 'DATE_EARNED' then
69: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);
70: elsif g_inputs(i).name = 'ASSIGNMENT_ID' then
71: g_inputs(i).value := p_assignment_id;
72: elsif g_inputs(i).name = 'SOURCE_TEXT' then
73: g_inputs(i).value := p_process_type;

Line 158: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);

154: -- Set up parameter values for the formula
155: for i in g_inputs.first..g_inputs.last loop
156: --
157: if g_inputs(i).name = 'DATE_EARNED' then
158: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);
159: elsif g_inputs(i).name = 'PROCESS_TYPE' then
160: g_inputs(i).value := p_process_type;
161: elsif g_inputs(i).name = 'SOURCE_TEXT' then
162: g_inputs(i).value := p_process_type;

Line 227: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);

223: -- Set up parameter values for the formula
224: for i in g_inputs.first..g_inputs.last loop
225: --
226: if g_inputs(i).name = 'DATE_EARNED' then
227: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);
228: elsif g_inputs(i).name = 'SOURCE_TEXT' then
229: g_inputs(i).value := p_process_type;
230: elsif g_inputs(i).name = 'PROCESS_TYPE' then
231: g_inputs(i).value := p_process_type;

Line 299: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);

295: -- Set up parameter values for the formula
296: for i in g_inputs.first..g_inputs.last loop
297: --
298: if g_inputs(i).name = 'DATE_EARNED' then
299: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);
300: elsif g_inputs(i).name = 'PROCESS_TYPE' then
301: g_inputs(i).value := p_process_type;
302: elsif g_inputs(i).name = 'SOURCE_TEXT' then
303: g_inputs(i).value := p_process_type;

Line 373: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);

369: -- Set up parameter values for the formula
370: for i in g_inputs.first..g_inputs.last loop
371: --
372: if g_inputs(i).name = 'DATE_EARNED' then
373: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);
374: elsif g_inputs(i).name = 'PROCESS_TYPE' then
375: g_inputs(i).value := p_process_type;
376: elsif g_inputs(i).name = 'SOURCE_TEXT' then
377: g_inputs(i).value := p_process_type;

Line 445: p_date_from between fnd_date.canonical_to_date(hoi.org_information1)

441: select 'X'
442: from hr_organization_information hoi
443: where (
444: (
445: p_date_from between fnd_date.canonical_to_date(hoi.org_information1)
446: and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
447: ,fnd_date.canonical_to_date(hoi.org_information2))
448: )
449: or

Line 446: and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)

442: from hr_organization_information hoi
443: where (
444: (
445: p_date_from between fnd_date.canonical_to_date(hoi.org_information1)
446: and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
447: ,fnd_date.canonical_to_date(hoi.org_information2))
448: )
449: or
450: (

Line 447: ,fnd_date.canonical_to_date(hoi.org_information2))

443: where (
444: (
445: p_date_from between fnd_date.canonical_to_date(hoi.org_information1)
446: and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
447: ,fnd_date.canonical_to_date(hoi.org_information2))
448: )
449: or
450: (
451: l_end_date between fnd_date.canonical_to_date(hoi.org_information1)

Line 451: l_end_date between fnd_date.canonical_to_date(hoi.org_information1)

447: ,fnd_date.canonical_to_date(hoi.org_information2))
448: )
449: or
450: (
451: l_end_date between fnd_date.canonical_to_date(hoi.org_information1)
452: and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
453: ,fnd_date.canonical_to_date(hoi.org_information2))
454: )
455: or

Line 452: and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)

448: )
449: or
450: (
451: l_end_date between fnd_date.canonical_to_date(hoi.org_information1)
452: and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
453: ,fnd_date.canonical_to_date(hoi.org_information2))
454: )
455: or
456: (

Line 453: ,fnd_date.canonical_to_date(hoi.org_information2))

449: or
450: (
451: l_end_date between fnd_date.canonical_to_date(hoi.org_information1)
452: and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
453: ,fnd_date.canonical_to_date(hoi.org_information2))
454: )
455: or
456: (
457: l_end_date >= decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)

Line 457: l_end_date >= decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)

453: ,fnd_date.canonical_to_date(hoi.org_information2))
454: )
455: or
456: (
457: l_end_date >= decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
458: ,fnd_date.canonical_to_date(hoi.org_information2))
459: and p_date_from <= fnd_date.canonical_to_date(hoi.org_information1)
460: )
461: )

Line 458: ,fnd_date.canonical_to_date(hoi.org_information2))

454: )
455: or
456: (
457: l_end_date >= decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
458: ,fnd_date.canonical_to_date(hoi.org_information2))
459: and p_date_from <= fnd_date.canonical_to_date(hoi.org_information1)
460: )
461: )
462: and hoi.org_information_context = decode(p_information_type,'FR_ESTAB_ROBIEN',

Line 459: and p_date_from <= fnd_date.canonical_to_date(hoi.org_information1)

455: or
456: (
457: l_end_date >= decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
458: ,fnd_date.canonical_to_date(hoi.org_information2))
459: and p_date_from <= fnd_date.canonical_to_date(hoi.org_information1)
460: )
461: )
462: and hoi.org_information_context = decode(p_information_type,'FR_ESTAB_ROBIEN',
463: 'FR_ESTAB_AUBRY_I','FR_ESTAB_ROBIEN')

Line 571: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);

567: g_inputs(i).value := p_process_type;
568: elsif g_inputs(i).name = 'SOURCE_TEXT' then
569: g_inputs(i).value := p_process_type;
570: elsif g_inputs(i).name = 'DATE_EARNED' then
571: g_inputs(i).value := fnd_date.date_to_canonical(p_date_earned);
572: elsif g_inputs(i).name = 'ASSIGNMENT_ID' then
573: g_inputs(i).value := p_assignment_id;
574: elsif g_inputs(i).name = 'TAX_UNIT_ID' then
575: g_inputs(i).value := p_tax_unit_id;