eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJP_EXTRACTION_UTILS dependencies on PJI_PJP_PROJ_EXTR_STATUS

Line 85: from PJI_PJP_PROJ_EXTR_STATUS

81: l_last_update_login := FND_GLOBAL.LOGIN_ID;
82:
83: select count(*)
84: into l_count
85: from PJI_PJP_PROJ_EXTR_STATUS
86: where ROWNUM = 1;
87:
88: if (l_count > 0) then
89:

Line 118: PJI_PJP_PROJ_EXTR_STATUS pjp_status/*, Commented for bug 8916168

114: l_created_by,
115: l_last_update_login
116: from
117: PA_PROJECTS_ALL prj,
118: PJI_PJP_PROJ_EXTR_STATUS pjp_status/*, Commented for bug 8916168
119: PJI_PROJ_EXTR_STATUS fm_status Added for bug 8661279 */
120: where
121: prj.TEMPLATE_FLAG = 'N' and
122: prj.PROJECT_ID = pjp_status.PROJECT_ID (+) and

Line 130: from PJI_PJP_PROJ_EXTR_STATUS pjp

126: pjp_status.PROJECT_ID is null
127: and prj.project_type <> 'AWARD_PROJECT'; /* Added for Bug 6450518 */
128:
129: delete
130: from PJI_PJP_PROJ_EXTR_STATUS pjp
131: where not exists (select 1
132: from PA_PROJECTS_ALL prj
133: where prj.PROJECT_ID = pjp.PROJECT_ID);
134:

Line 135: /* This delete statement is added so that data in PJI_PJP_PROJ_EXTR_STATUS

131: where not exists (select 1
132: from PA_PROJECTS_ALL prj
133: where prj.PROJECT_ID = pjp.PROJECT_ID);
134:
135: /* This delete statement is added so that data in PJI_PJP_PROJ_EXTR_STATUS
136: is always in sync with data in PJI_PROJ_EXTR_STATUS.
137: Code added for bug 6748705 starts **** Commented for bug 9034593 ****
138: delete
139: from PJI_PJP_PROJ_EXTR_STATUS pjp

Line 139: from PJI_PJP_PROJ_EXTR_STATUS pjp

135: /* This delete statement is added so that data in PJI_PJP_PROJ_EXTR_STATUS
136: is always in sync with data in PJI_PROJ_EXTR_STATUS.
137: Code added for bug 6748705 starts **** Commented for bug 9034593 ****
138: delete
139: from PJI_PJP_PROJ_EXTR_STATUS pjp
140: where not exists (select 1
141: from PJI_PROJ_EXTR_STATUS prj
142: where prj.PROJECT_ID = pjp.PROJECT_ID);
143: /* Code added for bug 6748705 ends */

Line 147: -- the project from PJI_PJP_PROJ_EXTR_STATUS. Later if the status of the project was changed to APPROVED, then

143: /* Code added for bug 6748705 ends */
144:
145: /* Below delete added for Bug# 9749751 */
146: -- Commented the delete for bug 11785181 - When project went to CLOSED status, then the below delete was deleting
147: -- the project from PJI_PJP_PROJ_EXTR_STATUS. Later if the status of the project was changed to APPROVED, then
148: -- the insert statement was again inserting the project in 'F' status. Because of this, UPPD was running in FULL
149: -- mode for this project and was inserting duplicates in UPDATE_PROGRAM_WBS. Hence, we will not delete a project
150: -- which has been summarized before from PJI_PJP_PROJ_EXTR_STATUS. It will remain in PJI_PJP_PROJ_EXTR_STATUS
151: -- with extraction status as 'I'. In INIT_PROCESS procedure, while inserting into pji_pjp_proj_batch_map we

Line 150: -- which has been summarized before from PJI_PJP_PROJ_EXTR_STATUS. It will remain in PJI_PJP_PROJ_EXTR_STATUS

146: -- Commented the delete for bug 11785181 - When project went to CLOSED status, then the below delete was deleting
147: -- the project from PJI_PJP_PROJ_EXTR_STATUS. Later if the status of the project was changed to APPROVED, then
148: -- the insert statement was again inserting the project in 'F' status. Because of this, UPPD was running in FULL
149: -- mode for this project and was inserting duplicates in UPDATE_PROGRAM_WBS. Hence, we will not delete a project
150: -- which has been summarized before from PJI_PJP_PROJ_EXTR_STATUS. It will remain in PJI_PJP_PROJ_EXTR_STATUS
151: -- with extraction status as 'I'. In INIT_PROCESS procedure, while inserting into pji_pjp_proj_batch_map we
152: -- will select only those projects which are eligible for status reporting.
153: /*delete
154: from PJI_PJP_PROJ_EXTR_STATUS pjp

Line 154: from PJI_PJP_PROJ_EXTR_STATUS pjp

150: -- which has been summarized before from PJI_PJP_PROJ_EXTR_STATUS. It will remain in PJI_PJP_PROJ_EXTR_STATUS
151: -- with extraction status as 'I'. In INIT_PROCESS procedure, while inserting into pji_pjp_proj_batch_map we
152: -- will select only those projects which are eligible for status reporting.
153: /*delete
154: from PJI_PJP_PROJ_EXTR_STATUS pjp
155: where exists (select 1
156: from PA_PROJECTS_ALL prj
157: where prj.PROJECT_ID = pjp.PROJECT_ID
158: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(prj.PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'N'); */

Line 161: update PJI_PJP_PROJ_EXTR_STATUS sts

157: where prj.PROJECT_ID = pjp.PROJECT_ID
158: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(prj.PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'N'); */
159: /* End for Bug# 9749751 */
160:
161: update PJI_PJP_PROJ_EXTR_STATUS sts
162: set sts.PROJECT_ORGANIZATION_ID =
163: (
164: select prj.CARRYING_OUT_ORGANIZATION_ID
165: from PA_PROJECTS_ALL prj

Line 177: insert into PJI_PJP_PROJ_EXTR_STATUS

173: prj.CARRYING_OUT_ORGANIZATION_ID <>
174: sts.PROJECT_ORGANIZATION_ID
175: );
176:
177: insert into PJI_PJP_PROJ_EXTR_STATUS
178: (
179: PROJECT_ID,
180: PROJECT_ORGANIZATION_ID,
181: PROJECT_NAME,

Line 207: PJI_PJP_PROJ_EXTR_STATUs pjp_status/*, Commented for bug 8916168

203: l_last_update_login
204: from
205: PA_PROJECTS_ALL prj,
206: PA_PROJECT_TYPES_ALL pt,
207: PJI_PJP_PROJ_EXTR_STATUs pjp_status/*, Commented for bug 8916168
208: PJI_PROJ_EXTR_STATUS fm_status Added for bug 6748705 */
209: where
210: prj.TEMPLATE_FLAG = 'N' and
211: prj.ORG_ID = pt.ORG_ID and /*5377131*/

Line 276: insert into PJI_PJP_PROJ_EXTR_STATUS pjp_i

272: log.ATTRIBUTE1 = prj.PROJECT_ID) Commented for bug 9340121 */
273: and prj.PROJECT_ID = fm_status.project_id /* Added for bug 8661279 */
274: and prj.project_type <> 'AWARD_PROJECT'; /* Added for Bug 6450518 */
275:
276: insert into PJI_PJP_PROJ_EXTR_STATUS pjp_i
277: (
278: PROJECT_ID,
279: PROJECT_ORGANIZATION_ID,
280: PROJECT_NAME,

Line 437: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);

433: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
434:
435: -- non-partitioned tables
436: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);
437: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);
438:
439: -- gather statistics for PJI metadata tables
440: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
441: tabname => 'PJI_PJP_PROJ_EXTR_STATUS',

Line 441: tabname => 'PJI_PJP_PROJ_EXTR_STATUS',

437: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);
438:
439: -- gather statistics for PJI metadata tables
440: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
441: tabname => 'PJI_PJP_PROJ_EXTR_STATUS',
442: percent => 10,
443: degree => l_degree);
444:
445: commit;

Line 620: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', 'NORMAL', null);

616: NAME like 'PJI_FPM_UPGRADE' or
617: NAME like 'PJI_PTC_UPGRADE' or /*4882640 */
618: NAME like 'PJP_FPM_UPGRADE_DATE' or
619: NAME like 'LAST_PJP_EXTR_DATE%';
620: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', 'NORMAL', null);
621:
622: -- PJP facts
623: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FP_XBS_ACCUM_F', 'NORMAL', null);
624: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_AC_XBS_ACCUM_F', 'NORMAL', null);

Line 642: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', 'NORMAL', null);

638: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RBS_DENORM', 'NORMAL', null);
639: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RBS_DENORM_DELTA', 'NORMAL', null);
640: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', 'NORMAL', null);
641: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FM_AGGR_RES_TYPES', 'NORMAL', null);
642: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', 'NORMAL', null);
643: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', 'NORMAL', null);
644: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', 'NORMAL', null);
645: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FP_AGGR_PJP0', 'NORMAL', null);
646: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_AC_AGGR_PJP0', 'NORMAL', null);

Line 740: from PJI_PJP_PROJ_EXTR_STATUS

736: begin
737:
738: select trunc(last_update_date)
739: into l_last_proj_extr_date
740: from PJI_PJP_PROJ_EXTR_STATUS
741: where project_id = p_project_id ;
742:
743: return l_last_proj_extr_date;
744: