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_PPR_OLAP_CONC_PROGRAM dependencies on PA_PJT_PROJ_BATCH

Line 88: from pa_budget_versions b, pa_projects_all p, pa_pjt_proj_batch batch

84: select p.project_id,
85: b.budget_version_id,
86: p.PROJFUNC_CURRENCY_CODE,
87: p.PROJECT_CURRENCY_CODE
88: from pa_budget_versions b, pa_projects_all p, pa_pjt_proj_batch batch
89: where b.olap_change_flag = 'Y'
90: and b.project_id = p.project_id
91: and p.project_id = batch.project_id;
92:

Line 1047: pa_pjt_proj_batch batch

1043: from
1044: PA_STAGE1_BATCH_OLAP map,
1045: PJI_FP_TXN_ACCUM bal,
1046: pa_projects_all pa,
1047: pa_pjt_proj_batch batch
1048: where
1049: g_extraction_type in ('FULL', 'PARTIAL') and
1050: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574
1051: -- l_plan_type_id IS NULL and -- Bug#5099574

Line 1128: pa_pjt_proj_batch batch

1124: from
1125: PA_STAGE1_BATCH_OLAP map,
1126: PJI_FP_TXN_ACCUM1 bal,
1127: pa_projects_all pa,
1128: pa_pjt_proj_batch batch
1129: where
1130: g_extraction_type in ('FULL', 'PARTIAL') and
1131: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574
1132: -- l_plan_type_id IS NULL and -- Bug#5099574

Line 1207: pa_projects_all pa, pa_pjt_proj_batch batch

1203: tmp7.cbs_version_id,
1204: tmp7.cbs_element_id
1205: from
1206: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
1207: pa_projects_all pa, pa_pjt_proj_batch batch
1208: where
1209: g_extraction_type = 'INCREMENTAL'
1210: and tmp7.project_id = proj_batch.project_id (+) and
1211: tmp7.project_id = pa.project_id and

Line 1285: pa_pjt_proj_batch batch

1281: bal.cbs_element_id
1282: from PJI_FP_TXN_ACCUM bal,
1283: PA_FIN7_OLAP fin7,
1284: pa_projects_all pa,
1285: pa_pjt_proj_batch batch
1286: where
1287: g_extraction_type = 'INCREMENTAL' and
1288: bal.project_id = fin7.project_id and
1289: bal.RECVR_PERIOD_TYPE = fin7.RECVR_PERIOD_TYPE and

Line 1480: pa_pjt_proj_batch batch

1476: PA_STAGE1_BATCH_OLAP map,
1477: PJI_FP_TXN_ACCUM bal,
1478: PA_RBS_PRJ_ASSIGNMENTS asg,
1479: pa_projects_all pa,
1480: pa_pjt_proj_batch batch
1481: where
1482: g_extraction_type in ('FULL', 'PARTIAL') and
1483: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574
1484: -- l_plan_type_id IS NULL and -- Bug#5099574

Line 1564: pa_pjt_proj_batch batch

1560: PA_STAGE1_BATCH_OLAP map,
1561: PJI_FP_TXN_ACCUM1 bal,
1562: PA_RBS_PRJ_ASSIGNMENTS asg,
1563: pa_projects_all pa,
1564: pa_pjt_proj_batch batch
1565: where
1566: g_extraction_type in ('FULL', 'PARTIAL') and
1567: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574
1568: -- l_plan_type_id IS NULL and -- Bug#5099574

Line 1645: PA_RBS_PRJ_ASSIGNMENTS asg, pa_projects_all pa, pa_pjt_proj_batch batch

1641: tmp7.cbs_version_id,
1642: tmp7.cbs_element_id
1643: from
1644: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
1645: PA_RBS_PRJ_ASSIGNMENTS asg, pa_projects_all pa, pa_pjt_proj_batch batch
1646: where
1647: g_extraction_type = 'INCREMENTAL'
1648: and tmp7.project_id = proj_batch.project_id (+) and
1649: asg.PROJECT_ID = tmp7.PROJECT_ID and

Line 1726: pa_pjt_proj_batch batch

1722: from PJI_FP_TXN_ACCUM bal,
1723: PA_RBS_PRJ_ASSIGNMENTS asg,
1724: PA_FIN7_OLAP fin7,
1725: pa_projects_all pa,
1726: pa_pjt_proj_batch batch
1727: where
1728: g_extraction_type = 'INCREMENTAL' and
1729: asg.PROJECT_ID = bal.PROJECT_ID and
1730: asg.REPORTING_USAGE_FLAG = 'Y' and

Line 1935: pa_pjt_proj_batch batch

1931: from
1932: PA_STAGE1_BATCH_OLAP map,
1933: PJI_FP_TXN_ACCUM bal,
1934: pa_projects_all pa,
1935: pa_pjt_proj_batch batch
1936: where
1937: g_extraction_type in ('FULL', 'PARTIAL') and
1938: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574
1939: -- l_plan_type_id IS NULL and -- Bug#5099574

Line 2017: pa_pjt_proj_batch batch

2013: from
2014: PA_STAGE1_BATCH_OLAP map,
2015: PJI_FP_TXN_ACCUM1 bal,
2016: pa_projects_all pa,
2017: pa_pjt_proj_batch batch
2018: where
2019: g_extraction_type in ('FULL', 'PARTIAL') and
2020: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574
2021: -- l_plan_type_id IS NULL and -- Bug#5099574

Line 2097: pa_projects_all pa, pa_pjt_proj_batch batch

2093: tmp7.cbs_version_id,
2094: tmp7.cbs_element_id
2095: from
2096: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
2097: pa_projects_all pa, pa_pjt_proj_batch batch
2098: where
2099: g_extraction_type = 'INCREMENTAL'
2100: and tmp7.project_id = proj_batch.project_id (+) and
2101: tmp7.project_id = pa.project_id and

Line 2176: pa_pjt_proj_batch batch

2172: bal.cbs_element_id
2173: from PJI_FP_TXN_ACCUM bal,
2174: PA_FIN7_OLAP fin7,
2175: pa_projects_all pa,
2176: pa_pjt_proj_batch batch
2177: where
2178: g_extraction_type = 'INCREMENTAL' and
2179: bal.project_id = fin7.project_id and
2180: bal.RECVR_PERIOD_TYPE = fin7.RECVR_PERIOD_TYPE and

Line 2373: pa_pjt_proj_batch batch

2369: PA_STAGE1_BATCH_OLAP map,
2370: PJI_FP_TXN_ACCUM bal,
2371: PA_RBS_PRJ_ASSIGNMENTS asg,
2372: pa_projects_all pa,
2373: pa_pjt_proj_batch batch
2374: where
2375: g_extraction_type in ('FULL', 'PARTIAL') and
2376: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574
2377: -- l_plan_type_id IS NULL and -- Bug#5099574

Line 2458: pa_pjt_proj_batch batch

2454: PA_STAGE1_BATCH_OLAP map,
2455: PJI_FP_TXN_ACCUM1 bal,
2456: PA_RBS_PRJ_ASSIGNMENTS asg,
2457: pa_projects_all pa,
2458: pa_pjt_proj_batch batch
2459: where
2460: g_extraction_type in ('FULL', 'PARTIAL') and
2461: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574
2462: -- l_plan_type_id IS NULL and -- Bug#5099574

Line 2540: PA_RBS_PRJ_ASSIGNMENTS asg, pa_projects_all pa, pa_pjt_proj_batch batch

2536: tmp7.cbs_version_id,
2537: tmp7.cbs_element_id
2538: from
2539: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
2540: PA_RBS_PRJ_ASSIGNMENTS asg, pa_projects_all pa, pa_pjt_proj_batch batch
2541: where
2542: g_extraction_type = 'INCREMENTAL'
2543: and tmp7.project_id = proj_batch.project_id (+) and
2544: asg.PROJECT_ID = tmp7.PROJECT_ID and

Line 2622: pa_pjt_proj_batch batch

2618: from PJI_FP_TXN_ACCUM bal,
2619: PA_RBS_PRJ_ASSIGNMENTS asg,
2620: PA_FIN7_OLAP fin7,
2621: pa_projects_all pa,
2622: pa_pjt_proj_batch batch
2623: where
2624: g_extraction_type = 'INCREMENTAL' and
2625: asg.PROJECT_ID = bal.PROJECT_ID and
2626: asg.REPORTING_USAGE_FLAG = 'Y' and

Line 2769: pa_pjt_proj_batch batch

2765: from
2766: PJI_FM_AGGR_ACT4 src,
2767: PA_PROJECTS_ALL prj,
2768: PJI_ORG_EXTR_INFO info,
2769: pa_pjt_proj_batch batch
2770: where
2771: src.PROJECT_ID = prj.PROJECT_ID and
2772: prj.ORG_ID = info.ORG_ID and
2773: prj.project_id = batch.project_id and

Line 2913: pa_pjt_proj_batch batch

2909: from
2910: PJI_FM_AGGR_ACT4 src,
2911: PA_PROJECTS_ALL prj,
2912: PJI_ORG_EXTR_INFO info,
2913: pa_pjt_proj_batch batch
2914: where
2915: src.PROJECT_ID = prj.PROJECT_ID and
2916: prj.ORG_ID = info.ORG_ID and
2917: prj.project_id = batch.project_id and

Line 2989: insert into pa_pjt_proj_batch

2985: If p_project_id_tbl.count > 0 then
2986:
2987: Forall i in p_project_id_tbl.first..p_project_id_tbl.last
2988:
2989: insert into pa_pjt_proj_batch
2990: (
2991: WORKER_ID,
2992: PROJECT_ID,
2993: PJI_PROJECT_STATUS,

Line 3024: delete from pa_pjt_proj_batch;

3020: maintain_actuals_projfunc(p_group_size);
3021: maintain_activity_data_prj(p_group_size);
3022: maintain_activity_data_pf(p_group_size);
3023:
3024: delete from pa_pjt_proj_batch;
3025: exit when c1%notfound;
3026: Else
3027: Exit;
3028: