APPS.HRI_OPL_WMV dependencies on FND_INSTALLATION

Line 147: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema)) THEN

143: /************************/
144: /* FULL REFRESH SECTION */
145: /************************/
146: /* Truncate the table if a full refresh is selected */
147: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema)) THEN
148:
149: /* If it's a full refresh */
150: IF (g_full_refresh = 'Y') THEN
151:

Line 1258: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema)) THEN

1254: -- Bug 2911335 - Collect stats for full refresh
1255: --
1256: IF (g_full_refresh = 'Y') THEN
1257: --
1258: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema)) THEN
1259: --
1260: output('Full Refresh selected - gathering stats');
1261: fnd_stats.gather_table_stats(l_schema,'HRI_MB_WMV');
1262: --

Line 1338: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema)) THEN

1334:
1335: /* Truncate the table if a full refresh is selected */
1336: IF (g_full_refresh = 'Y') THEN
1337:
1338: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema)) THEN
1339:
1340: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_WMV';
1341: EXECUTE IMMEDIATE(l_sql_stmt);
1342:

Line 1404: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema)) THEN

1400: hri_bpl_conc_log.record_process_start('HRI_MB_WMV');
1401: --
1402: -- Truncate the table
1403: --
1404: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema)) THEN
1405: --
1406: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_WMV';
1407: EXECUTE IMMEDIATE(l_sql_stmt);
1408: --

Line 1460: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema)) THEN

1456: AND trunc(SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date;
1457: --
1458: -- Gather Statistics
1459: --
1460: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema)) THEN
1461: --
1462: fnd_stats.gather_table_stats(l_schema,'HRI_MB_WMV');
1463: --
1464: END IF;