APPS.HR_GL_SYNC_ORGS dependencies on HR_API

Line 1920: nvl(l_org_end_date, hr_api.g_sot) <> nvl(l_end, hr_api.g_sot) then

1916: --
1917: if l_sql_num = 1 then
1918: --
1919: if l_org_name <> l_name or l_org_start_date <> l_start or
1920: nvl(l_org_end_date, hr_api.g_sot) <> nvl(l_end, hr_api.g_sot) then
1921: --
1922: hr_utility.set_location(l_proc, 50);
1923: --
1924: update hr_all_organization_units units

Line 1961: nvl(l_org_end_date, hr_api.g_sot) <> nvl(l_end, hr_api.g_sot) then

1957: --
1958: elsif l_sql_num = 3 then
1959: --
1960: if l_org_start_date <> l_start or
1961: nvl(l_org_end_date, hr_api.g_sot) <> nvl(l_end, hr_api.g_sot) then
1962: --
1963: hr_utility.set_location(l_proc, 70);
1964: --
1965: update hr_all_organization_units units

Line 2651: nvl(l_org_end_date,hr_api.g_sot) <> nvl(l_end,hr_api.g_sot) THEN

2647:
2648: IF l_retcode = 0 THEN
2649: IF l_sql_num = 1 THEN
2650: IF l_org_name <> l_name OR l_org_start_date <> l_start OR
2651: nvl(l_org_end_date,hr_api.g_sot) <> nvl(l_end,hr_api.g_sot) THEN
2652:
2653: UPDATE hr_all_organization_units UNITS
2654: SET UNITS.name = l_org_name,
2655: UNITS.date_from = l_org_start_date,

Line 2672: nvl(l_org_end_date,hr_api.g_sot) <> nvl(l_end,hr_api.g_sot) THEN

2668: l_updrowcount := l_updrowcount+1;
2669: END IF;
2670: ELSIF l_sql_num = 3 THEN
2671: IF l_org_start_date <> l_start OR
2672: nvl(l_org_end_date,hr_api.g_sot) <> nvl(l_end,hr_api.g_sot) THEN
2673:
2674: UPDATE hr_all_organization_units UNITS
2675: SET UNITS.date_from = l_org_start_date,
2676: UNITS.date_to = l_org_end_date