DBA Data[Home] [Help]

APPS.GHR_ELEMENT_API dependencies on HR_API

Line 1444: if nvl(p_value1,hr_api.g_varchar2) <> nvl(l_value1,hr_api.g_varchar2) or

1440: --
1441: -- if one of the element entry values changed
1442: --
1443:
1444: if nvl(p_value1,hr_api.g_varchar2) <> nvl(l_value1,hr_api.g_varchar2) or
1445: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1446: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1447: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1448: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or

Line 1445: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or

1441: -- if one of the element entry values changed
1442: --
1443:
1444: if nvl(p_value1,hr_api.g_varchar2) <> nvl(l_value1,hr_api.g_varchar2) or
1445: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1446: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1447: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1448: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1449: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or

Line 1446: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or

1442: --
1443:
1444: if nvl(p_value1,hr_api.g_varchar2) <> nvl(l_value1,hr_api.g_varchar2) or
1445: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1446: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1447: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1448: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1449: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1450: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or

Line 1447: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or

1443:
1444: if nvl(p_value1,hr_api.g_varchar2) <> nvl(l_value1,hr_api.g_varchar2) or
1445: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1446: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1447: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1448: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1449: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1450: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1451: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or

Line 1448: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or

1444: if nvl(p_value1,hr_api.g_varchar2) <> nvl(l_value1,hr_api.g_varchar2) or
1445: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1446: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1447: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1448: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1449: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1450: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1451: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1452: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or

Line 1449: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or

1445: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1446: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1447: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1448: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1449: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1450: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1451: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1452: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1453: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or

Line 1450: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or

1446: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1447: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1448: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1449: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1450: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1451: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1452: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1453: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1454: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or

Line 1451: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or

1447: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1448: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1449: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1450: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1451: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1452: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1453: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1454: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1455: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or

Line 1452: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or

1448: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1449: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1450: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1451: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1452: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1453: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1454: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1455: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1456: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or

Line 1453: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or

1449: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1450: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1451: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1452: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1453: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1454: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1455: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1456: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1457: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or

Line 1454: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or

1450: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1451: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1452: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1453: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1454: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1455: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1456: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1457: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or
1458: nvl( l_p_value15,hr_api.g_varchar2) <> nvl(l_value15,hr_api.g_varchar2) then

Line 1455: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or

1451: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1452: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1453: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1454: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1455: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1456: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1457: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or
1458: nvl( l_p_value15,hr_api.g_varchar2) <> nvl(l_value15,hr_api.g_varchar2) then
1459: -- get session variable to determine if it is a 'CORRECTION'

Line 1456: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or

1452: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1453: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1454: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1455: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1456: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1457: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or
1458: nvl( l_p_value15,hr_api.g_varchar2) <> nvl(l_value15,hr_api.g_varchar2) then
1459: -- get session variable to determine if it is a 'CORRECTION'
1460:

Line 1457: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or

1453: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1454: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1455: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1456: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1457: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or
1458: nvl( l_p_value15,hr_api.g_varchar2) <> nvl(l_value15,hr_api.g_varchar2) then
1459: -- get session variable to determine if it is a 'CORRECTION'
1460:
1461: ghr_history_api.get_g_session_var(l_session);

Line 1458: nvl( l_p_value15,hr_api.g_varchar2) <> nvl(l_value15,hr_api.g_varchar2) then

1454: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1455: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1456: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1457: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or
1458: nvl( l_p_value15,hr_api.g_varchar2) <> nvl(l_value15,hr_api.g_varchar2) then
1459: -- get session variable to determine if it is a 'CORRECTION'
1460:
1461: ghr_history_api.get_g_session_var(l_session);
1462: