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_PA_DEL_MAIN dependencies on FND_GLOBAL

Line 174: and wp.conc_request_id = FND_GLOBAL.CONC_REQUEST_ID; /* Modified for bug 9049425 */

170: from pa_projects_all pa, pa_proj_elem_ver_structure wp
171: where pa.segment1 between p_from_proj and p_to_proj
172: and pa.project_id = wp.project_id
173: and wp.purged_flag = 'Y'
174: and wp.conc_request_id = FND_GLOBAL.CONC_REQUEST_ID; /* Modified for bug 9049425 */
175:
176: cursor proj_fp(p_from_proj varchar2,p_to_proj varchar2) is
177: select pa.segment1 num,fp.version_name fp_name
178: from pa_projects_all pa, pa_budget_versions fp

Line 183: and fp.request_id = FND_GLOBAL.CONC_REQUEST_ID; /* Modified for bug 9049425 */

179: where pa.segment1 between p_from_proj and p_to_proj
180: and pa.project_id = fp.project_id
181: and fp.purged_flag = 'Y'
182: and fp.fin_plan_type_id <> 10
183: and fp.request_id = FND_GLOBAL.CONC_REQUEST_ID; /* Modified for bug 9049425 */
184:
185: begin
186:
187: l_from_proj_num := p_from_project;

Line 218: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

214:
215: FND_MESSAGE.SET_NAME('PA', 'PA_PMC_WORKPLAN_VER');
216: l_wp_version := FND_MESSAGE.GET;
217:
218: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
219: '-----------------------------------------------------------------------------------------------------------------------------------------' );
220:
221: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
222: ' '||l_rpt_header);

Line 221: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

217:
218: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
219: '-----------------------------------------------------------------------------------------------------------------------------------------' );
220:
221: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
222: ' '||l_rpt_header);
223: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
224: '-----------------------------------------------------------------------------------------------------------------------------------------' );
225:

Line 223: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

219: '-----------------------------------------------------------------------------------------------------------------------------------------' );
220:
221: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
222: ' '||l_rpt_header);
223: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
224: '-----------------------------------------------------------------------------------------------------------------------------------------' );
225:
226: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
227: l_Proj_Number||' '||l_wp_version );

Line 226: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

222: ' '||l_rpt_header);
223: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
224: '-----------------------------------------------------------------------------------------------------------------------------------------' );
225:
226: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
227: l_Proj_Number||' '||l_wp_version );
228: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
229: '====================== =================' );
230:

Line 228: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

224: '-----------------------------------------------------------------------------------------------------------------------------------------' );
225:
226: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
227: l_Proj_Number||' '||l_wp_version );
228: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
229: '====================== =================' );
230:
231: for rec in proj_wp(l_from_proj_num,l_to_proj_num) loop
232: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(rec.num,27,' ')||rec.wp_name);

Line 232: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(rec.num,27,' ')||rec.wp_name);

228: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
229: '====================== =================' );
230:
231: for rec in proj_wp(l_from_proj_num,l_to_proj_num) loop
232: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(rec.num,27,' ')||rec.wp_name);
233: END LOOp;
234:
235: IF g_wp_option IS NOT NULL THEN
236: OPEN proj_wp(l_from_proj_num,l_to_proj_num);

Line 240: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||'No workplan version found eligible for deleting');

236: OPEN proj_wp(l_from_proj_num,l_to_proj_num);
237: FETCH proj_wp INTO l_temp_proj_num, l_temp_plan_name;
238: IF l_temp_proj_num IS NULL THEN
239:
240: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||'No workplan version found eligible for deleting');
241:
242: END IF;
243: CLOSE proj_wp;
244: END IF;

Line 249: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

245: l_temp_proj_num := '';
246: l_temp_plan_name := '';
247:
248:
249: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
250: '-----------------------------------------------------------------------------------------------------------------------------------------' );
251:
252: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
253: l_Proj_Number||' '||l_version_name );

Line 252: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

248:
249: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
250: '-----------------------------------------------------------------------------------------------------------------------------------------' );
251:
252: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
253: l_Proj_Number||' '||l_version_name );
254: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
255: '====================== ======================' );
256:

Line 254: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

250: '-----------------------------------------------------------------------------------------------------------------------------------------' );
251:
252: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
253: l_Proj_Number||' '||l_version_name );
254: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
255: '====================== ======================' );
256:
257: for rec in proj_fp(l_from_proj_num,l_to_proj_num) loop
258: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(rec.num,27,' ')||rec.fp_name);

Line 258: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(rec.num,27,' ')||rec.fp_name);

254: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
255: '====================== ======================' );
256:
257: for rec in proj_fp(l_from_proj_num,l_to_proj_num) loop
258: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(rec.num,27,' ')||rec.fp_name);
259: END LOOp;
260:
261: IF g_fp_option IS NOT NULL THEN
262: OPEN proj_fp(l_from_proj_num,l_to_proj_num);

Line 266: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||'No financial plan found eligible for deleting');

262: OPEN proj_fp(l_from_proj_num,l_to_proj_num);
263: FETCH proj_fp INTO l_temp_proj_num, l_temp_plan_name;
264: IF l_temp_proj_num IS NULL THEN
265:
266: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||'No financial plan found eligible for deleting');
267:
268: END IF;
269: CLOSE proj_fp;
270: END IF;

Line 271: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

267:
268: END IF;
269: CLOSE proj_fp;
270: END IF;
271: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
272: '----------------------------------------------------------'||l_rpt_footer||'----------------------------------------------------------');
273:
274: pa_debug.log_message('======= Print Output End ========== :', 1);
275: