DBA Data[Home] [Help]

APPS.HR_EFC_INFO dependencies on HR_API

Line 565: INSERT INTO hr_api_user_hook_reports

561: l_line_num := g_efc_message_line;
562: g_efc_message_line := g_efc_message_line +1;
563: END IF;
564:
565: INSERT INTO hr_api_user_hook_reports
566: (session_id,
567: line,
568: text)
569: VALUES

Line 1232: IF ((nvl(p_old_value,hr_api.g_varchar2) <>

1228: -- is NCU. This will tell us the "meaning" of the
1229: -- zero has been converted to Euro.
1230: -- Null values which remain null values should not
1231: -- be counted.
1232: IF ((nvl(p_old_value,hr_api.g_varchar2) <>
1233: nvl(p_new_value,hr_api.g_varchar2)) OR
1234: (p_old_value = '0' AND p_new_value = '0'
1235: AND hr_currency_pkg.efc_is_ncu_currency(p_currency))) THEN
1236: -- Value has changed - check if we need to add/update a row

Line 1233: nvl(p_new_value,hr_api.g_varchar2)) OR

1229: -- zero has been converted to Euro.
1230: -- Null values which remain null values should not
1231: -- be counted.
1232: IF ((nvl(p_old_value,hr_api.g_varchar2) <>
1233: nvl(p_new_value,hr_api.g_varchar2)) OR
1234: (p_old_value = '0' AND p_new_value = '0'
1235: AND hr_currency_pkg.efc_is_ncu_currency(p_currency))) THEN
1236: -- Value has changed - check if we need to add/update a row
1237: IF ((p_currency = p_last_curr) OR (p_last_curr IS NULL)) THEN

Line 1620: -- This procedure is a cover for hr_api_user_hooks_utility.clear_hook_report.

1616: -- |--------------------------< clear_efc_report >----------------------------|
1617: -- ----------------------------------------------------------------------------
1618: --
1619: -- Description:
1620: -- This procedure is a cover for hr_api_user_hooks_utility.clear_hook_report.
1621: --
1622: -- ----------------------------------------------------------------------------
1623: PROCEDURE clear_efc_report IS
1624: --

Line 1629: hr_api_user_hooks_utility.clear_hook_report;

1625: BEGIN
1626: --
1627:
1628: -- clear table of messages
1629: hr_api_user_hooks_utility.clear_hook_report;
1630:
1631: IF g_efc_error_message IS NOT NULL THEN
1632: hr_utility.set_message(g_efc_error_app,
1633: g_efc_error_message);