DBA Data[Home] [Help]

APPS.GHR_ELEMENT_API dependencies on HR_API

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

1467: --
1468: -- if one of the element entry values changed
1469: --
1470:
1471: if nvl(p_value1,hr_api.g_varchar2) <> nvl(l_value1,hr_api.g_varchar2) or
1472: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1473: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1474: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1475: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or

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

1468: -- if one of the element entry values changed
1469: --
1470:
1471: if nvl(p_value1,hr_api.g_varchar2) <> nvl(l_value1,hr_api.g_varchar2) or
1472: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1473: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1474: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1475: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1476: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or

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

1469: --
1470:
1471: if nvl(p_value1,hr_api.g_varchar2) <> nvl(l_value1,hr_api.g_varchar2) or
1472: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1473: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1474: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1475: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1476: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1477: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or

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

1470:
1471: if nvl(p_value1,hr_api.g_varchar2) <> nvl(l_value1,hr_api.g_varchar2) or
1472: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1473: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1474: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1475: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1476: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1477: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1478: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or

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

1471: if nvl(p_value1,hr_api.g_varchar2) <> nvl(l_value1,hr_api.g_varchar2) or
1472: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1473: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1474: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1475: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1476: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1477: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1478: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1479: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or

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

1472: nvl(p_value2,hr_api.g_varchar2) <> nvl(l_value2,hr_api.g_varchar2) or
1473: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1474: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1475: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1476: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1477: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1478: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1479: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1480: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or

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

1473: nvl(p_value3,hr_api.g_varchar2) <> nvl(l_value3,hr_api.g_varchar2) or
1474: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1475: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1476: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1477: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1478: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1479: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1480: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1481: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or

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

1474: nvl(p_value4,hr_api.g_varchar2) <> nvl(l_value4,hr_api.g_varchar2) or
1475: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1476: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1477: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1478: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1479: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1480: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1481: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1482: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or

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

1475: nvl(p_value5,hr_api.g_varchar2) <> nvl(l_value5,hr_api.g_varchar2) or
1476: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1477: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1478: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1479: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1480: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1481: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1482: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1483: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or

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

1476: nvl(p_value6,hr_api.g_varchar2) <> nvl(l_value6,hr_api.g_varchar2) or
1477: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1478: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1479: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1480: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1481: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1482: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1483: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1484: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or

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

1477: nvl(p_value7,hr_api.g_varchar2) <> nvl(l_value7,hr_api.g_varchar2) or
1478: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1479: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1480: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1481: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1482: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1483: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1484: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or
1485: nvl( l_p_value15,hr_api.g_varchar2) <> nvl(l_value15,hr_api.g_varchar2) then

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

1478: nvl(p_value8,hr_api.g_varchar2) <> nvl(l_value8,hr_api.g_varchar2) or
1479: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1480: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1481: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1482: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1483: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1484: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or
1485: nvl( l_p_value15,hr_api.g_varchar2) <> nvl(l_value15,hr_api.g_varchar2) then
1486: -- get session variable to determine if it is a 'CORRECTION'

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

1479: nvl(p_value9,hr_api.g_varchar2) <> nvl(l_value9,hr_api.g_varchar2) or
1480: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1481: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1482: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1483: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1484: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or
1485: nvl( l_p_value15,hr_api.g_varchar2) <> nvl(l_value15,hr_api.g_varchar2) then
1486: -- get session variable to determine if it is a 'CORRECTION'
1487:

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

1480: nvl( p_value10,hr_api.g_varchar2) <> nvl(l_value10,hr_api.g_varchar2) or
1481: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1482: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1483: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1484: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or
1485: nvl( l_p_value15,hr_api.g_varchar2) <> nvl(l_value15,hr_api.g_varchar2) then
1486: -- get session variable to determine if it is a 'CORRECTION'
1487:
1488: ghr_history_api.get_g_session_var(l_session);

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

1481: nvl( p_value11,hr_api.g_varchar2) <> nvl(l_value11,hr_api.g_varchar2) or
1482: nvl( p_value12,hr_api.g_varchar2) <> nvl(l_value12,hr_api.g_varchar2) or
1483: nvl( p_value13,hr_api.g_varchar2) <> nvl(l_value13,hr_api.g_varchar2) or
1484: nvl( p_value14,hr_api.g_varchar2) <> nvl(l_value14,hr_api.g_varchar2) or
1485: nvl( l_p_value15,hr_api.g_varchar2) <> nvl(l_value15,hr_api.g_varchar2) then
1486: -- get session variable to determine if it is a 'CORRECTION'
1487:
1488: ghr_history_api.get_g_session_var(l_session);
1489: