DBA Data[Home] [Help]

APPS.HR_PERSON_FLEX_LOGIC dependencies on FND_DATE

Line 54: l_inputs(i).value := FND_Date.Date_To_Canonical (p_effective_date);

50: -- dbms_output.put_line('HR_PERSON_FLEX_LOGIC.GetABV - 20');
51:
52: if l_inputs(i).name = 'DATE_EARNED' then
53:
54: l_inputs(i).value := FND_Date.Date_To_Canonical (p_effective_date);
55:
56: -- dbms_output.put_line('HR_PERSON_FLEX_LOGIC.GetABV - 25');
57:
58: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then

Line 248: l_inputs(i).value := FND_Date.Date_To_Canonical (p_effective_date);

244:
245: -- dbms_output.put_line('Function GetAsgWorkerType - 30');
246:
247: if l_inputs(i).name = 'DATE_EARNED' then
248: l_inputs(i).value := FND_Date.Date_To_Canonical (p_effective_date);
249:
250: -- dbms_output.put_line('Function GetAsgWorkerType - 35');
251:
252: elsif

Line 844: nvl(fnd_date.canonical_to_date(org_information3),hr_api.g_sot)

840: from hr_organization_information
841: where organization_id = P_ORGANIZATION_ID
842: and org_information_context = 'Organization Name Alias'
843: and P_REPORT_DATE between
844: nvl(fnd_date.canonical_to_date(org_information3),hr_api.g_sot)
845: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot);
846:
847: cursor c_org_name is
848: select name

Line 845: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot);

841: where organization_id = P_ORGANIZATION_ID
842: and org_information_context = 'Organization Name Alias'
843: and P_REPORT_DATE between
844: nvl(fnd_date.canonical_to_date(org_information3),hr_api.g_sot)
845: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot);
846:
847: cursor c_org_name is
848: select name
849: from hr_organization_units