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_PROJ_ACCUM_MAIN dependencies on PA_PROJ_SUMM_TMP

Line 3899: DELETE FROM pa_proj_summ_tmp; -- BUG 10107257 Addition of DELETE

3895:
3896: DELETE FROM pa_commitment_txns_tmp;
3897: DELETE FROM pa_pjm_po_commitments_tmp; /* Bug 6408874 */
3898: DELETE FROM pa_pjm_req_commitments_tmp; /* Bug 6408874 */
3899: DELETE FROM pa_proj_summ_tmp; -- BUG 10107257 Addition of DELETE
3900: -- DELETE FROM pa_fp_ra_map_tmp;
3901:
3902: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3903: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);

Line 3923: INSERT INTO pa_proj_summ_tmp (project_id) -- BUG 10107257 Using global temp table instead of Bulk collect

3919: end if;
3920:
3921: IF (p_refresh_flag = 'N') THEN --Condition via bug 7175975
3922: -- bug 6408874. Introduced BULK Processing
3923: INSERT INTO pa_proj_summ_tmp (project_id) -- BUG 10107257 Using global temp table instead of Bulk collect
3924: (SELECT DISTINCT pfa.project_id project_id
3925: -- bulk collect into TmpProjectTab
3926: FROM pa_projects_for_accum pfa
3927: WHERE pfa.request_id = x_request_id

Line 3940: INSERT INTO pa_proj_summ_tmp (project_id) -- BUG 10107257 Using global temp table instead of Bulk collect

3936: AND pf.segment1 = pfa.segment1
3937: AND pf.action_flag IN ('PT', 'CL', 'BK', 'TR')));
3938: -- Added below for Bug# 7175975
3939: ELSIF (p_refresh_flag = 'Y') THEN
3940: INSERT INTO pa_proj_summ_tmp (project_id) -- BUG 10107257 Using global temp table instead of Bulk collect
3941: (SELECT ppr.project_id
3942: -- BULK COLLECT INTO TmpProjectTab
3943: FROM pa_projects ppr
3944: WHERE NVL(ppr.template_flag,'N') <> 'Y'

Line 4026: from pjm_req_commitments_v pmprd ,pa_proj_summ_tmp prj -- BUG 10107257 Addition of global temp table

4022: ,pmprd.inventory_item_name
4023: ,pmprd.uom_code
4024: ,pmprd.wip_resource_id
4025: ,pmprd.wip_resource_name
4026: from pjm_req_commitments_v pmprd ,pa_proj_summ_tmp prj -- BUG 10107257 Addition of global temp table
4027: where pmprd.project_id = prj.project_id; -- BUG 10107257 Using global temp table instead of Bulk collect
4028: -- where pmprd.project_id = TmpProjectTab(i); -- BUG 10107257 Commented the condition
4029: -- commented for bug 6408874
4030: -- where pmprd.project_id = TmpProjectTab(i);

Line 4136: from pjm_po_commitments_v pmppd, pa_proj_summ_tmp prj -- BUG 10107257 Addition of global temp table

4132: pmppd.inventory_item_name,
4133: pmppd.uom_code,
4134: pmppd.wip_resource_id,
4135: pmppd.wip_resource_name
4136: from pjm_po_commitments_v pmppd, pa_proj_summ_tmp prj -- BUG 10107257 Addition of global temp table
4137: where pmppd.project_id = prj.project_id; --BUG 10107257 Using global temp table instead of Bulk collect
4138: -- where pmppd.project_id = TmpProjectTab(i); -- bug 7491714
4139: -- commented for bug 6408874
4140: -- where pmppd.project_id = TmpProjectTab(i);

Line 4296: --, pa_proj_summ_tmp prj -- BUG 10107257 Addition of global temp table

4292: pctv.uom_code,
4293: pctv.wip_resource_id,
4294: pctv.resource_class
4295: FROM pa_commitments_v1 pctv
4296: --, pa_proj_summ_tmp prj -- BUG 10107257 Addition of global temp table
4297: --changed to pa_commitments_v1 for bug 14221415
4298: WHERE
4299: NVL(pctv.system_linkage_function,'X') = NVL(p_system_linkage_function,NVL(pctv.system_linkage_function,'X'));
4300: