DBA Data[Home] [Help]

APPS.HRI_OPL_SUP_STATUS_HST dependencies on HRI_OPL_SUP_STATUS_HST

Line 1: PACKAGE BODY HRI_OPL_SUP_STATUS_HST AS

1: PACKAGE BODY HRI_OPL_SUP_STATUS_HST AS
2: /* $Header: hrioshst.pkb 120.7 2006/12/13 10:34:17 jtitmas noship $ */
3: --
4: -- Information to be held for each link in a chain
5: --

Line 90: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'

86: -- Bug 4105868: Collection Diagnostics
87: --
88: hri_bpl_conc_log.log_process_info
89: (p_msg_type => 'WARNING'
90: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'
91: ,p_msg_group => 'SUP_STS_HST'
92: ,p_msg_sub_group => 'RUN_SQL_STMT_NOERR'
93: ,p_sql_err_code => SQLCODE
94: ,p_note => SUBSTR(p_sql_stmt, 1, 3900)

Line 1611: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'

1607: --
1608: hri_bpl_conc_log.log_process_info
1609: (p_msg_type => 'ERROR'
1610: ,p_note => SQLERRM
1611: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'
1612: ,p_msg_sub_group => g_msg_sub_group
1613: ,p_sql_err_code => SQLCODE
1614: ,p_msg_group => 'SUP_STS_HST');
1615: --

Line 1740: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'

1736: --
1737: hri_bpl_conc_log.log_process_info
1738: (p_msg_type => 'ERROR'
1739: ,p_note => SQLERRM
1740: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'
1741: ,p_msg_sub_group => g_msg_sub_group
1742: ,p_sql_err_code => SQLCODE
1743: ,p_msg_group => 'SUP_STS_HST');
1744: --

Line 1815: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'

1811: --
1812: hri_bpl_conc_log.log_process_info
1813: (p_msg_type => 'WARNING'
1814: ,p_note => l_message
1815: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'
1816: ,p_msg_sub_group => 'RUN_REQUEST'
1817: ,p_sql_err_code => SQLCODE
1818: ,p_msg_group => 'SUP_STS_HST'
1819: );

Line 1839: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'

1835: --
1836: hri_bpl_conc_log.log_process_info
1837: (p_msg_type => 'WARNING'
1838: ,p_note => l_message
1839: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'
1840: ,p_msg_sub_group => 'RUN_REQUEST'
1841: ,p_sql_err_code => SQLCODE
1842: ,p_msg_group => 'SUP_STS_HST');
1843: --

Line 1878: hri_opl_sup_status_hst.full_refresh(p_start_date => l_start_date

1874: IF (l_full_refresh = 'Y') THEN
1875: --
1876: dbg('Calling full refresh of supervisor status history');
1877: --
1878: hri_opl_sup_status_hst.full_refresh(p_start_date => l_start_date
1879: ,p_end_date => l_end_date);
1880: --
1881: ELSE
1882: --

Line 1885: hri_opl_sup_status_hst.incremental_update(p_start_date => l_start_date

1881: ELSE
1882: --
1883: dbg('Calling incremental update of supervisor status history');
1884: --
1885: hri_opl_sup_status_hst.incremental_update(p_start_date => l_start_date
1886: ,p_end_date => l_end_date);
1887: --
1888: END IF;
1889: --

Line 1920: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'

1916: --
1917: hri_bpl_conc_log.log_process_info
1918: (p_msg_type => 'ERROR'
1919: ,p_note => SQLERRM
1920: ,p_package_name => 'HRI_OPL_SUP_STATUS_HST'
1921: ,p_msg_sub_group => g_msg_sub_group
1922: ,p_sql_err_code => SQLCODE
1923: ,p_msg_group => 'SUP_STS_HST');
1924: --

Line 1936: END HRI_OPL_SUP_STATUS_HST;

1932: --
1933: --
1934: END run_request;
1935: --
1936: END HRI_OPL_SUP_STATUS_HST;