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_PROJECTS_ALL

Line 32: from pa_projects_all

28:
29: BEGIN
30: select count(*), olap_group
31: into l_count, l_olap_group
32: from pa_projects_all
33: where olap_group is not null
34: group by olap_group
35: having count(*) < p_group_size;
36:

Line 45: update pa_projects_all

41:
42: IF l_olap_group IS NOT NULL THEN
43: l_curr_olap_group_count := p_group_size - l_count;
44:
45: update pa_projects_all
46: set olap_group = l_olap_group --,
47: --struct_change_flag = 'Y'
48: where olap_group is null
49: and rownum <= l_curr_olap_group_count;

Line 53: select count(*) into l_prj_count from pa_projects_all where olap_group is null;

49: and rownum <= l_curr_olap_group_count;
50:
51: END IF;
52:
53: select count(*) into l_prj_count from pa_projects_all where olap_group is null;
54:
55: select ceil(l_prj_count/p_group_size) into l_loop from dual;
56:
57: FOR i in 1..l_loop LOOP

Line 60: update pa_projects_all

56:
57: FOR i in 1..l_loop LOOP
58: select PA_OLAP_GROUP_S.nextval into l_olap_group from dual;
59:
60: update pa_projects_all
61: set olap_group = l_olap_group --,
62: -- struct_change_flag = 'Y'
63: where olap_group is null
64: and rownum <= p_group_size;

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 100: from pa_budget_versions_olap_tmp1 b, pa_projects_all p

96: budget_version_id,
97: currency_code
98: )
99: select 'ALL', p.project_id, b.budget_version_id, p.PROJFUNC_CURRENCY_CODE
100: from pa_budget_versions_olap_tmp1 b, pa_projects_all p
101: where b.project_id = p.project_id
102: and p.PROJFUNC_CURRENCY_CODE = p.PROJECT_CURRENCY_CODE
103: UNION
104: select 'PFC', p.project_id, b.budget_version_id, p.PROJFUNC_CURRENCY_CODE

Line 105: from pa_budget_versions_olap_tmp1 b, pa_projects_all p

101: where b.project_id = p.project_id
102: and p.PROJFUNC_CURRENCY_CODE = p.PROJECT_CURRENCY_CODE
103: UNION
104: select 'PFC', p.project_id, b.budget_version_id, p.PROJFUNC_CURRENCY_CODE
105: from pa_budget_versions_olap_tmp1 b, pa_projects_all p
106: where b.project_id = p.project_id
107: and p.PROJFUNC_CURRENCY_CODE <> p.PROJECT_CURRENCY_CODE
108: UNION
109: select 'PC', p.project_id, b.budget_version_id, p.PROJECT_CURRENCY_CODE

Line 110: from pa_budget_versions_olap_tmp1 b, pa_projects_all p

106: where b.project_id = p.project_id
107: and p.PROJFUNC_CURRENCY_CODE <> p.PROJECT_CURRENCY_CODE
108: UNION
109: select 'PC', p.project_id, b.budget_version_id, p.PROJECT_CURRENCY_CODE
110: from pa_budget_versions_olap_tmp1 b, pa_projects_all p
111: where b.project_id = p.project_id
112: and p.PROJFUNC_CURRENCY_CODE <> p.PROJECT_CURRENCY_CODE;
113:
114:

Line 174: , pa_projects_all ppa -- @pjdev115 ppa

170: ) lp_flag
171: FROM
172: pa_budget_versions bv -- @pjdev115 bv
173: , pa_proj_fp_options fpo -- @pjdev115 fpo
174: , pa_projects_all ppa -- @pjdev115 ppa
175: , pa_budget_versions_olap_tmp1 b1
176: WHERE 1=1
177: AND ppa.project_id = bv.project_id
178: AND bv.budget_version_id = b1.budget_version_id

Line 432: pa_projects_all p1,

428: pa_budget_versions b1,
429: pa_resource_assignments ra,
430: pa_budget_lines bl,
431: pji_time_cal_period per,
432: pa_projects_all p1,
433: pa_proj_fp_options fpo,
434: PJI_ORG_EXTR_INFO inf
435: where
436: b.budget_version_id = b1.budget_version_id

Line 678: pa_projects_all p1,

674: pa_budget_versions b1,
675: pa_resource_assignments ra,
676: pa_budget_lines bl,
677: pji_time_cal_period per,
678: pa_projects_all p1,
679: pa_proj_fp_options fpo,
680: PJI_ORG_EXTR_INFO inf
681: where
682: b.budget_version_id = b1.budget_version_id

Line 853: from pji_fp_aggr_pjp1 bv, pa_projects_all p

849: -1 ,
850: sysdate ,
851: -1 ,
852: -1
853: from pji_fp_aggr_pjp1 bv, pa_projects_all p
854: where bv.project_id = p.project_id;
855:
856: delete from pji_time_cal_period where cal_period_id = -1;
857:

Line 1046: pa_projects_all pa,

1042: bal.cbs_element_id
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

Line 1127: pa_projects_all pa,

1123: bal.cbs_element_id
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

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 1284: pa_projects_all pa,

1280: bal.cbs_version_id,
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

Line 1294: ) tmp1, pa_projects_all p

1290: bal.RECVR_PERIOD_ID = fin7.RECVR_PERIOD_ID and
1291: bal.project_id = pa.project_id and
1292: pa.project_id = batch.project_id and
1293: pa.pjt_rollup_enabled_flag = 'Y'
1294: ) tmp1, pa_projects_all p
1295: where tmp1.project_id = p.project_id;
1296:
1297: INSERT INTO pa_olap_stage(
1298: OLAP_GROUP ,

Line 1479: pa_projects_all pa,

1475: from
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

Line 1563: pa_projects_all pa,

1559: from
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

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 1725: pa_projects_all pa,

1721: bal.cbs_element_id
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

Line 1738: pa_rbs_txn_accum_map rbs, pa_projects_all p

1734: bal.project_id = pa.project_id and
1735: pa.project_id = batch.project_id and
1736: pa.pjt_rollup_enabled_flag = 'Y'
1737: ) tmp1,
1738: pa_rbs_txn_accum_map rbs, pa_projects_all p
1739: where tmp1.project_id = p.project_id and
1740: tmp1.txn_accum_header_id = rbs.txn_accum_header_id (+) and
1741: tmp1.rbs_version_id = rbs.struct_version_id(+)
1742: ;

Line 1934: pa_projects_all pa,

1930: bal.cbs_element_id
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

Line 2016: pa_projects_all pa,

2012: bal.cbs_element_id
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

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 2175: pa_projects_all pa,

2171: bal.cbs_version_id,
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

Line 2186: ) tmp1, pa_projects_all p

2182: bal.project_id = pa.project_id and
2183: pa.project_id = batch.project_id and
2184: pa.pjt_rollup_enabled_flag = 'Y' and
2185: pa.project_currency_code <> pa.projfunc_currency_code
2186: ) tmp1, pa_projects_all p
2187: where tmp1.project_id = p.project_id;
2188:
2189: INSERT INTO pa_olap_stage(
2190: OLAP_GROUP ,

Line 2372: pa_projects_all pa,

2368: from
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

Line 2457: pa_projects_all pa,

2453: from
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

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 2621: pa_projects_all pa,

2617: bal.cbs_element_id
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

Line 2635: pa_rbs_txn_accum_map rbs, pa_projects_all p

2631: pa.project_id = batch.project_id and
2632: pa.pjt_rollup_enabled_flag = 'Y' and
2633: pa.project_currency_code <> pa.projfunc_currency_code
2634: ) tmp1,
2635: pa_rbs_txn_accum_map rbs, pa_projects_all p
2636: where tmp1.project_id = p.project_id and
2637: tmp1.txn_accum_header_id = rbs.txn_accum_header_id (+) and
2638: tmp1.rbs_version_id = rbs.struct_version_id(+)
2639: ;

Line 2767: PA_PROJECTS_ALL prj,

2763: 0,
2764: 0
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

Line 2911: PA_PROJECTS_ALL prj,

2907: 0,
2908: 0
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

Line 2957: from pa_projects_all

2953: p_group_size NUMBER := 100; --satya
2954:
2955: cursor c1 is
2956: select project_id
2957: from pa_projects_all
2958: where template_flag = 'N';
2959:
2960: TYPE NUM_TBL_TYPE is TABLE of NUMBER index by binary_integer;
2961: p_project_id_tbl NUM_TBL_TYPE;