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.PA_CLIENT_EXTN_PROJ_STATUS dependencies on PA_PROJECT_REQUEST_PVT

Line 273: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805

269: CURSOR l_sel_proj_type_csr IS
270: select NVL(enable_project_wf_flag,'N')
271: FROM pa_project_types_all -- Bug#3807805 : Modified pa_project_types to pa_project_types_all
272: WHERE project_type = x_project_type
273: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805
274: */
275:
276: --Modified the cursor l_sel_proj_type_csr as below for Bug#5029322
277:

Line 306: --the value of PA_PROJECT_REQUEST_PVT.G_ORG_ID is populated from the cursor. This is to make sure that no regression happens after

302: BEGIN
303: x_err_code := 0;
304:
305: --Commented the code below For bug#5029322.Added the same code below after the cursor l_sel_proj_type_csr to make sure that
306: --the value of PA_PROJECT_REQUEST_PVT.G_ORG_ID is populated from the cursor. This is to make sure that no regression happens after
307: --Bug fix#5029322 as the value of PA_PROJECT_REQUEST_PVT.G_ORG_ID could be used at some other place also.
308:
309: /*
310: if PA_PROJECT_REQUEST_PVT.G_ORG_ID is null and x_project_type is not null then -- Added the if block for Bug#3807805

Line 307: --Bug fix#5029322 as the value of PA_PROJECT_REQUEST_PVT.G_ORG_ID could be used at some other place also.

303: x_err_code := 0;
304:
305: --Commented the code below For bug#5029322.Added the same code below after the cursor l_sel_proj_type_csr to make sure that
306: --the value of PA_PROJECT_REQUEST_PVT.G_ORG_ID is populated from the cursor. This is to make sure that no regression happens after
307: --Bug fix#5029322 as the value of PA_PROJECT_REQUEST_PVT.G_ORG_ID could be used at some other place also.
308:
309: /*
310: if PA_PROJECT_REQUEST_PVT.G_ORG_ID is null and x_project_type is not null then -- Added the if block for Bug#3807805
311: select org_id into PA_PROJECT_REQUEST_PVT.G_ORG_ID from pa_project_types where project_type = x_project_type;

Line 310: if PA_PROJECT_REQUEST_PVT.G_ORG_ID is null and x_project_type is not null then -- Added the if block for Bug#3807805

306: --the value of PA_PROJECT_REQUEST_PVT.G_ORG_ID is populated from the cursor. This is to make sure that no regression happens after
307: --Bug fix#5029322 as the value of PA_PROJECT_REQUEST_PVT.G_ORG_ID could be used at some other place also.
308:
309: /*
310: if PA_PROJECT_REQUEST_PVT.G_ORG_ID is null and x_project_type is not null then -- Added the if block for Bug#3807805
311: select org_id into PA_PROJECT_REQUEST_PVT.G_ORG_ID from pa_project_types where project_type = x_project_type;
312: end if;
313:
314: */ --End of commenting for Bug#5029322

Line 311: select org_id into PA_PROJECT_REQUEST_PVT.G_ORG_ID from pa_project_types where project_type = x_project_type;

307: --Bug fix#5029322 as the value of PA_PROJECT_REQUEST_PVT.G_ORG_ID could be used at some other place also.
308:
309: /*
310: if PA_PROJECT_REQUEST_PVT.G_ORG_ID is null and x_project_type is not null then -- Added the if block for Bug#3807805
311: select org_id into PA_PROJECT_REQUEST_PVT.G_ORG_ID from pa_project_types where project_type = x_project_type;
312: end if;
313:
314: */ --End of commenting for Bug#5029322
315:

Line 325: if PA_PROJECT_REQUEST_PVT.G_ORG_ID is null and x_project_type is not null then -- Added the if block for Bug#3807805

321: CLOSE l_sel_proj_type_csr;
322:
323: --Added the following IF condition for Bug#5029322
324:
325: if PA_PROJECT_REQUEST_PVT.G_ORG_ID is null and x_project_type is not null then -- Added the if block for Bug#3807805
326: PA_PROJECT_REQUEST_PVT.G_ORG_ID := l_org_id;
327: end if;
328:
329: -- End changes for Bug#5029322

Line 326: PA_PROJECT_REQUEST_PVT.G_ORG_ID := l_org_id;

322:
323: --Added the following IF condition for Bug#5029322
324:
325: if PA_PROJECT_REQUEST_PVT.G_ORG_ID is null and x_project_type is not null then -- Added the if block for Bug#3807805
326: PA_PROJECT_REQUEST_PVT.G_ORG_ID := l_org_id;
327: end if;
328:
329: -- End changes for Bug#5029322
330: -- If workflow has not been enabled for the project type then do not proceed