APPS.PJI_EXTRACTION_UTIL dependencies on PJI_PROJ_EXTR_STATUS

Line 32: from PJI_PROJ_EXTR_STATUS

28: begin
29:
30: select count(*)
31: into l_row_count
32: from PJI_PROJ_EXTR_STATUS
33: where ROWNUM = 1;
34:
35: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,
36: 'TRANSITION') = 'Y' and

Line 56: -- Delete from PJI_PROJ_EXTR_STATUS those projects deleted from

52: PJI_FM_SUM_MAIN.g_date_mask), 'J')) then
53: pji_utils.write2log('WARNING: Global start date has changed.');
54: end if;
55:
56: -- Delete from PJI_PROJ_EXTR_STATUS those projects deleted from
57: -- PA_PROJECTS_ALL. Note that a project cannot be deleted if it has any
58: -- actuals transactions, so we don't need to worry about purging data from
59: -- PJI facts.
60:

Line 62: from PJI_PROJ_EXTR_STATUS pji

58: -- actuals transactions, so we don't need to worry about purging data from
59: -- PJI facts.
60:
61: delete
62: from PJI_PROJ_EXTR_STATUS pji
63: where not exists (select 1
64: from PA_PROJECTS_ALL pa
65: where pa.PROJECT_ID = pji.PROJECT_ID);
66:

Line 67: insert into PJI_PROJ_EXTR_STATUS

63: where not exists (select 1
64: from PA_PROJECTS_ALL pa
65: where pa.PROJECT_ID = pji.PROJECT_ID);
66:
67: insert into PJI_PROJ_EXTR_STATUS
68: (
69: PROJECT_ID,
70: PROJECT_ORGANIZATION_ID,
71: PROJECT_NAME,

Line 114: from PJI_PROJ_EXTR_STATUS ps

110: prj.project_status_code = psc.project_status_code and
111: not exists
112: (
113: select 1
114: from PJI_PROJ_EXTR_STATUS ps
115: where ps.PROJECT_ID = prj.PROJECT_ID
116: ) and
117: prj.project_status_code = sts.project_status_code and
118: nvl(prj.ORG_ID, -1) = nvl(pt.ORG_ID, -1) and

Line 127: update PJI_PROJ_EXTR_STATUS extr

123: -- projects need to be updated, they should not be included in the current run.
124:
125: For rec_purge_projs in csr_purge_projs LOOP
126:
127: update PJI_PROJ_EXTR_STATUS extr
128: set extr.purge_status = rec_purge_projs.project_system_status_code
129: where extr.project_id = rec_purge_projs.project_id
130: and NVL(extr.purge_status, 'X') not in ('PARTIALLY_PURGED'
131: ,'PURGED'

Line 459: , tabname => 'PJI_PROJ_EXTR_STATUS'

455:
456: -- gather statistics for PJI metadata tables
457: FND_STATS.GATHER_TABLE_STATS(
458: ownname => l_schema
459: , tabname => 'PJI_PROJ_EXTR_STATUS'
460: , percent => 10
461: , degree => l_degree
462: );
463: FND_STATS.GATHER_INDEX_STATS(ownname => l_schema,

Line 464: indname => 'PJI_PROJ_EXTR_STATUS_U1',

460: , percent => 10
461: , degree => l_degree
462: );
463: FND_STATS.GATHER_INDEX_STATS(ownname => l_schema,
464: indname => 'PJI_PROJ_EXTR_STATUS_U1',
465: percent => 10);
466: -- Commenting this because the table is used in Stage2 Summarization . Bug#4997700
467: /* FND_STATS.GATHER_TABLE_STATS(
468: ownname => l_schema

Line 548: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PROJ_EXTR_STATUS', 'NORMAL', null);

544: -- PJI summarization tables with persistent data
545: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_MT_PRC_STEPS', 'NORMAL', null);
546: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_CONFIG_HIST', 'NORMAL', null);
547: delete from PJI_SYSTEM_PARAMETERS where NAME not in ('PJI_PJP_ENT_CURR_REP_PERIOD');
548: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PROJ_EXTR_STATUS', 'NORMAL', null);
549: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_DEBUG_MSG', 'NORMAL', null);
550:
551: insert into PJI_SYSTEM_CONFIG_HIST
552: (