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 128: update PJI_PROJ_EXTR_STATUS extr

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

Line 460: , tabname => 'PJI_PROJ_EXTR_STATUS'

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

Line 465: indname => 'PJI_PROJ_EXTR_STATUS_U1',

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

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

548: -- PJI summarization tables with persistent data
549: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_MT_PRC_STEPS', 'NORMAL', null);
550: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_CONFIG_HIST', 'NORMAL', null);
551: delete from PJI_SYSTEM_PARAMETERS where NAME not in ('PJI_PJP_ENT_CURR_REP_PERIOD','PJP_SIN_PRG'); -- Bug 13451898
552: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PROJ_EXTR_STATUS', 'NORMAL', null);
553: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_DEBUG_MSG', 'NORMAL', null);
554:
555: insert into PJI_SYSTEM_CONFIG_HIST
556: (