APPS.PJI_RM_SUM_EXTR dependencies on PJI_UTILS

Line 209: PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

205: return;
206: end if;
207:
208: l_min_date := to_number(to_char(to_date(
209: PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
210: PJI_RM_SUM_MAIN.g_date_mask), 'J'));
211:
212: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i
213: (

Line 616: PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

612: return;
613: end if;
614:
615: l_min_date := to_number(to_char(to_date(
616: PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
617: PJI_RM_SUM_MAIN.g_date_mask), 'J'));
618:
619: -- implicit commit
620: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

Line 620: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

616: PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
617: PJI_RM_SUM_MAIN.g_date_mask), 'J'));
618:
619: -- implicit commit
620: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
621: tabname => 'PJI_RM_REXT_FCSTITEM',
622: percent => 10,
623: degree => BIS_COMMON_PARAMETERS.
624: GET_DEGREE_OF_PARALLELISM);

Line 1673: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

1669: begin
1670:
1671: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1672:
1673: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1674:
1675: PJI_PJ_PROJ_CLASS_EXTR.CLEANUP(p_worker_id);
1676: PJI_FM_PLAN_EXTR.CLEANUP(p_worker_id);
1677: PJI_RM_SUM_ROLLUP_RES.CLEANUP(p_worker_id);

Line 1741: pji_utils.write2log(sqlerrm, true, 0);

1737: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PROCESS_RUNNING', 'F');
1738:
1739: commit;
1740:
1741: pji_utils.write2log(sqlerrm, true, 0);
1742:
1743: commit;
1744:
1745: end WRAPUP_FAILURE;

Line 1759: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

1755: PJI_PJI_EXTRACTION_UTILS.SEED_PJI_RM_STATS;
1756:
1757: PJI_PJI_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
1758:
1759: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1760: tabname => 'PJI_ORG_EXTR_INFO',
1761: percent => 10,
1762: degree => PJI_UTILS.
1763: GET_DEGREE_OF_PARALLELISM);

Line 1762: degree => PJI_UTILS.

1758:
1759: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1760: tabname => 'PJI_ORG_EXTR_INFO',
1761: percent => 10,
1762: degree => PJI_UTILS.
1763: GET_DEGREE_OF_PARALLELISM);
1764: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1765: indname => 'PJI_ORG_EXTR_INFO_N1',
1766: percent => 10);

Line 1764: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

1760: tabname => 'PJI_ORG_EXTR_INFO',
1761: percent => 10,
1762: degree => PJI_UTILS.
1763: GET_DEGREE_OF_PARALLELISM);
1764: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1765: indname => 'PJI_ORG_EXTR_INFO_N1',
1766: percent => 10);
1767:
1768: -- Reset status for Availability helper workers

Line 1971: pji_utils.write2log('Warning: Helper is already running.');

1967: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process,
1968: PJI_RM_SUM_MAIN.g_process ||
1969: to_char(p_worker_id))
1970: <> FND_GLOBAL.CONC_REQUEST_ID) then
1971: pji_utils.write2log('Warning: Helper is already running.');
1972: commit;
1973: retcode := 0;
1974: return;
1975: end if;

Line 2090: PJI_UTILS.GET_PJI_SCHEMA_NAME, -- Application name

2086: PJI_RM_SUM_MAIN.g_process,
2087: l_process,
2088: FND_REQUEST.SUBMIT_REQUEST
2089: (
2090: PJI_UTILS.GET_PJI_SCHEMA_NAME, -- Application name
2091: PJI_RM_SUM_MAIN.g_helper_name, -- concurrent program name
2092: null, -- description (optional)
2093: null, -- Start Time (optional)
2094: false, -- called from another conc. request