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_PROGRESS_UTILS dependencies on PA_PERCENT_COMPLETES

Line 80: from pa_percent_completes

76: x_record_exists VARCHAR2(1);
77: BEGIN
78: select 'Y'
79: into x_record_exists
80: from pa_percent_completes
81: where object_version_id = p_element_version_id
82: and object_type = p_object_type
83: and published_flag = 'Y'
84: and project_id = p_project_id; -- Fixed bug # 3688901

Line 143: from pa_percent_completes

139: BEGIN
140:
141: select percent_complete_id
142: into l_percent_complete_id
143: from pa_percent_completes
144: where project_id = p_project_id
145: and task_id = p_task_id
146: and current_flag = 'N'
147: and published_flag = 'N';

Line 316: from pa_percent_completes

312: x_record_exists VARCHAR2(1);
313: BEGIN
314: select 'Y'
315: into x_record_exists
316: from pa_percent_completes
317: where project_id = p_project_id
318: and task_id = decode(p_task_id,0,task_id,p_task_id)
319: and published_flag = 'Y';
320:

Line 335: from pa_percent_completes

331: prior_pc NUMBER;
332: /*--Added by rtarway, bug 4324504
333: CURSOR c_get_prior_percent_complete(l_task_id NUMBER, l_project_id NUMBER, l_as_of_date DATE) IS
334: select completed_percentage
335: from pa_percent_completes
336: where project_id = l_project_id
337: and task_id = l_task_id
338: and published_flag = 'Y'
339: and structure_type = 'WORKPLAN'

Line 359: from pa_percent_completes

355: BEGIN
356: --Commented by rtarway, bug 4324504
357: /*select completed_percentage
358: into prior_pc
359: from pa_percent_completes
360: where project_id = p_project_id
361: and task_id = p_task_id
362: and published_flag = 'Y'
363: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 402: FROM pa_percent_completes

398:
399: CURSOR cur_ppc(c_project_id NUMBER )
400: IS
401: SELECT date_computed
402: FROM pa_percent_completes
403: WHERE object_id = decode(p_object_id, null, p_task_id, p_object_id)
404: AND project_id = c_project_id
405: and object_type = p_object_type
406: AND current_flag = 'Y'

Line 580: FROM pa_percent_completes

576: /*
577: CURSOR cur_pa_ppc
578: IS
579: SELECT max( date_computed )
580: FROM pa_percent_completes
581: WHERE project_id = X_Project_ID
582: AND object_id = x_object_id
583: AND object_type = x_object_type
584: AND current_flag = 'Y'

Line 595: FROM pa_percent_completes

591: -- Bug 3974627 : Added Cursors cur_pa_ppc_str_task, cur_pa_ppc_asgn, cur_pa_ppc_dlv
592: CURSOR cur_pa_ppc_str_task
593: IS
594: SELECT max( date_computed )
595: FROM pa_percent_completes
596: WHERE project_id = X_Project_ID
597: AND object_id = x_object_id
598: AND current_flag = 'Y'
599: AND published_flag = 'Y'

Line 608: FROM pa_percent_completes

604:
605: CURSOR cur_pa_ppc_asgn
606: IS
607: SELECT max( date_computed )
608: FROM pa_percent_completes
609: WHERE project_id = X_Project_ID
610: AND current_flag = 'Y'
611: AND published_flag = 'Y'
612: AND ((object_type = 'PA_ASSIGNMENTS' and object_id = x_object_id)

Line 635: FROM pa_percent_completes

631:
632: CURSOR cur_pa_ppc_dlv_notask
633: IS
634: SELECT max( date_computed )
635: FROM pa_percent_completes
636: WHERE project_id = X_Project_ID
637: AND object_id = x_object_id
638: AND current_flag = 'Y'
639: AND published_flag = 'Y'

Line 648: FROM pa_percent_completes

644:
645: CURSOR cur_pa_ppc_dlv_task(c_task_id NUMBER)
646: IS
647: SELECT max( date_computed )
648: FROM pa_percent_completes
649: WHERE project_id = X_Project_ID
650: AND ((object_id = x_object_id and object_type = 'PA_DELIVERABLES') or
651: (object_id = c_task_id and object_type = 'PA_TASKS'))
652: AND current_flag = 'Y'

Line 787: select PA_PERCENT_COMPLETES_S.nextval

783:
784: FUNCTION get_next_ppc_id RETURN NUMBER IS
785: l_return_ppc_id NUMBER;
786: BEGIN
787: select PA_PERCENT_COMPLETES_S.nextval
788: into l_return_ppc_id
789: from dual;
790:
791: RETURN l_return_ppc_id;

Line 1063: FROM pa_percent_completes

1059: /* Bug 3974627 : Commnted and added new cusrosrs
1060: CURSOR cur_pa_ppc
1061: IS
1062: SELECT max( date_computed )
1063: FROM pa_percent_completes
1064: WHERE project_id = p_Project_ID
1065: AND object_id = decode(p_object_id, null, p_task_id, p_object_id) -- This is done to avoid any impact of parameter additions
1066: AND current_flag = 'Y'
1067: AND published_flag = 'Y'

Line 1078: FROM pa_percent_completes

1074: -- Bug 3974627 : Added Cursors cur_pa_ppc_str_task, cur_pa_ppc_asgn, cur_pa_ppc_dlv
1075: CURSOR cur_pa_ppc_str_task
1076: IS
1077: SELECT max( date_computed )
1078: FROM pa_percent_completes
1079: WHERE project_id = p_Project_ID
1080: AND object_id = decode(p_object_id, null, p_task_id, p_object_id)
1081: AND current_flag = 'Y'
1082: AND published_flag = 'Y'

Line 1091: FROM pa_percent_completes

1087:
1088: CURSOR cur_pa_ppc_asgn
1089: IS
1090: SELECT max( date_computed )
1091: FROM pa_percent_completes
1092: WHERE project_id = p_Project_ID
1093: AND current_flag = 'Y'
1094: AND published_flag = 'Y'
1095: AND object_type IN ('PA_ASSIGNMENTS' ,'PA_TASKS')

Line 1115: FROM pa_percent_completes

1111:
1112: CURSOR cur_pa_ppc_dlv(c_task_id NUMBER)
1113: IS
1114: SELECT max( date_computed )
1115: FROM pa_percent_completes
1116: WHERE project_id = p_Project_ID
1117: AND ((c_task_id IS NULL AND object_id =p_object_id) OR (c_task_id IS NOT NULL AND object_id IN (c_task_id, p_object_id)))
1118: AND current_flag = 'Y'
1119: AND published_flag = 'Y'

Line 1265: FROM pa_percent_completes

1261: /*
1262: CURSOR cur_pa_ppc
1263: IS
1264: SELECT max( date_computed )
1265: FROM pa_percent_completes
1266: WHERE project_id = p_Project_ID
1267: -- AND object_id = p_task_id
1268: AND object_id = decode(p_object_id, null, p_task_id, p_object_id) -- This is Done to avoid the impact
1269: AND object_type = p_object_type

Line 1282: FROM pa_percent_completes

1278: -- Bug 3974627 : Added Cursors cur_pa_ppc_str_task, cur_pa_ppc_asgn, cur_pa_ppc_dlv
1279: CURSOR cur_pa_ppc_str_task
1280: IS
1281: SELECT max( date_computed )
1282: FROM pa_percent_completes
1283: WHERE project_id = p_Project_ID
1284: AND object_id = decode(p_object_id, null, p_task_id, p_object_id)
1285: AND current_flag = 'Y'
1286: AND published_flag = 'Y'

Line 1295: FROM pa_percent_completes

1291:
1292: CURSOR cur_pa_ppc_asgn
1293: IS
1294: SELECT max( date_computed )
1295: FROM pa_percent_completes
1296: WHERE project_id = p_Project_ID
1297: AND current_flag = 'Y'
1298: AND published_flag = 'Y'
1299: AND ((object_type = 'PA_ASSIGNMENTS' and object_id = p_object_id)

Line 1320: FROM pa_percent_completes

1316:
1317: CURSOR cur_pa_ppc_dlv_notask
1318: IS
1319: SELECT max( date_computed )
1320: FROM pa_percent_completes
1321: WHERE project_id = p_Project_ID
1322: AND object_id = p_object_id
1323: AND current_flag = 'Y'
1324: AND published_flag = 'Y'

Line 1333: FROM pa_percent_completes

1329:
1330: CURSOR cur_pa_ppc_dlv_task(c_task_id NUMBER)
1331: IS
1332: SELECT max( date_computed )
1333: FROM pa_percent_completes
1334: WHERE project_id = p_Project_ID
1335: AND ((object_id = p_object_id and object_type = 'PA_DELIVERABLES') or
1336: (object_id = p_task_id and object_type = 'PA_TASKS'))
1337: AND current_flag = 'Y'

Line 1344: FROM pa_percent_completes

1340: ;
1341: CURSOR cur_pa_ppc_w
1342: IS
1343: SELECT max( date_computed )
1344: FROM pa_percent_completes
1345: WHERE project_id = p_Project_ID
1346: -- AND object_id = p_task_id
1347: AND object_id = decode(p_object_id, null, p_task_id, p_object_id) -- This is Done to avoid the impact
1348: AND object_type = p_object_type

Line 1531: FROM pa_percent_completes

1527:
1528: CURSOR cur_ppc
1529: IS
1530: SELECT decode( published_flag, 'Y', 'PUBLISHED', 'N', 'WORKING' )
1531: FROM pa_percent_completes
1532: WHERE object_id = nvl(p_object_id, p_task_id) /* Modified for IB4 Progress CR. */
1533: AND object_type = p_object_type
1534: AND project_id = p_project_id
1535: AND date_computed = p_as_of_date

Line 1560: FROM pa_percent_completes

1556:
1557: CURSOR cur_ppc_id
1558: IS
1559: SELECT percent_complete_id
1560: FROM pa_percent_completes
1561: WHERE object_type = p_object_type
1562: AND object_id = p_object_id
1563: AND project_id = p_project_id
1564: -- AND object_version_id = p_object_version_id

Line 1659: FROM pa_percent_completes

1655:
1656: CURSOR cur_pa_prog_exists(c_project_id NUMBER )
1657: IS
1658: SELECT 'X'
1659: FROM pa_percent_completes
1660: WHERE object_id = p_task_id
1661: AND project_id = c_project_id;
1662: l_dummy_char VARCHAR2(1);
1663: BEGIN

Line 1986: FROM pa_percent_completes

1982: p_object_id NUMBER) RETURN VARCHAR2 IS
1983: CURSOR cur_pa_prog_exists
1984: IS
1985: SELECT 'X'
1986: FROM pa_percent_completes
1987: WHERE project_id = p_project_id
1988: AND object_id = decode(nvl(p_object_id,0),0,object_id,p_object_id)
1989: AND object_type = 'PA_STRUCTURES'
1990: AND task_id = 0;

Line 2013: FROM pa_percent_completes

2009: p_structure_type VARCHAR2 := null) RETURN VARCHAR2 IS -- added a new parameter for the BUG 6903050
2010: CURSOR cur_pa_prog_exists
2011: IS
2012: SELECT 'X'
2013: FROM pa_percent_completes
2014: WHERE project_id = p_project_id
2015: AND object_id = decode(nvl(p_object_id,0),0,object_id,p_object_id)
2016: AND object_type = 'PA_STRUCTURES'
2017: AND task_id = 0;

Line 2022: FROM pa_percent_completes

2018:
2019: CURSOR cur_pa_prog_exists_wp -- added a new cursor for the BUG 6903050
2020: IS
2021: SELECT 'X'
2022: FROM pa_percent_completes
2023: WHERE project_id = p_project_id
2024: AND object_id = decode(nvl(p_object_id,0),0,object_id,p_object_id)
2025: AND object_type = 'PA_STRUCTURES'
2026: AND task_id = 0

Line 2078: FROM pa_percent_completes

2074:
2075: CURSOR cur_pa_pcc
2076: IS
2077: SELECT date_computed
2078: FROM pa_percent_completes
2079: WHERE project_id = p_project_id
2080: AND object_id = nvl(p_object_id, p_task_id) /* Modified for IB4 Progress CR. */
2081: AND object_type = p_object_type
2082: AND structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 2103: select 'X' from pa_percent_completes

2099: p_status_code VARCHAR2 ) RETURN BOOLEAN
2100: is
2101: Cursor c_percent_complete
2102: is
2103: select 'X' from pa_percent_completes
2104: where ( progress_status_code = p_status_code
2105: or status_code = p_status_code)
2106: AND rownum <= 1;
2107:

Line 2206: FROM pa_percent_completes

2202:
2203: CURSOR cur_ppc(c_project_id NUMBER )
2204: IS
2205: SELECT MAX( date_computed )
2206: FROM pa_percent_completes
2207: WHERE object_id = p_task_id
2208: AND project_id = c_project_id
2209: AND date_computed < p_as_of_Date
2210: ;

Line 2340: from pa_percent_completes

2336: l_ppc_id number;
2337: begin
2338: select nvl(max(percent_complete_id),-99)
2339: into l_ppc_id
2340: from pa_percent_completes
2341: where project_id = p_project_id
2342: and object_id = p_object_id
2343: and object_type = p_object_type
2344: and date_computed <= p_as_of_date;

Line 2385: from pa_percent_completes

2381: and object_id = p_object_id
2382: and object_type = p_object_type
2383: and structure_type = p_structure_type -- FPM Dev CR 3
2384: and trunc(as_of_date) = (select max(trunc(date_computed))
2385: from pa_percent_completes
2386: where project_id = p_project_id
2387: and object_id = p_object_id
2388: and object_type = p_object_type
2389: and structure_type = p_structure_type -- FPM Dev CR 3

Line 2407: -- from pa_percent_completes

2403: and as_of_date <= p_as_of_date
2404: and ((p_structure_version_id is null AND structure_version_id is null) OR (p_structure_version_id is not null AND structure_version_id = p_structure_version_id))
2405: AND current_flag <> 'W' -- Bug 3879461
2406: -- and as_of_date not in (select trunc(date_computed)
2407: -- from pa_percent_completes
2408: -- where project_id = p_project_id
2409: -- and object_id = p_object_id
2410: -- and object_type = p_object_type
2411: -- and structure_type = p_structure_type

Line 2475: from pa_percent_completes

2471: )
2472: IS
2473: cursor get_ppc_id is
2474: select percent_complete_id
2475: from pa_percent_completes
2476: where project_id = p_project_id
2477: and object_id = p_object_id
2478: and object_type = p_object_type
2479: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 2500: X_from_entity_name => 'PA_PERCENT_COMPLETES',

2496: end if;
2497:
2498: if (l_from_pc_id is not null) then
2499: fnd_attached_documents2_pkg.copy_attachments(
2500: X_from_entity_name => 'PA_PERCENT_COMPLETES',
2501: X_from_pk1_value => l_from_pc_id,
2502: X_to_entity_name => 'PA_PERCENT_COMPLETES',
2503: X_to_pk1_value => p_to_pc_id,
2504: X_created_by => fnd_global.user_id,

Line 2502: X_to_entity_name => 'PA_PERCENT_COMPLETES',

2498: if (l_from_pc_id is not null) then
2499: fnd_attached_documents2_pkg.copy_attachments(
2500: X_from_entity_name => 'PA_PERCENT_COMPLETES',
2501: X_from_pk1_value => l_from_pc_id,
2502: X_to_entity_name => 'PA_PERCENT_COMPLETES',
2503: X_to_pk1_value => p_to_pc_id,
2504: X_created_by => fnd_global.user_id,
2505: X_last_update_login => fnd_global.login_id);
2506: end if;

Line 2737: FROM pa_percent_completes

2733:
2734: CURSOR cur_ppc
2735: IS
2736: SELECT min(date_computed)
2737: FROM pa_percent_completes
2738: WHERE object_id = p_object_id
2739: AND project_id = p_project_id
2740: and object_type = p_object_type
2741: AND structure_type = p_structure_type

Line 2855: -- SELECT 'X' FROM pa_percent_completes ppc

2851: NVL(p_proj_element_id, p_object_id)
2852: ) /* Amit : Modified for IB4 Progress CR. */
2853: -- AND NOT EXISTS
2854: -- (
2855: -- SELECT 'X' FROM pa_percent_completes ppc
2856: -- WHERE ppc.date_computed = ppr2.as_of_date
2857: -- AND ppc.project_id = p_project_id
2858: -- AND ppc.object_id = p_object_id
2859: -- AND ppc.object_type = p_object_type

Line 4858: -- ,pa_percent_completes ppc

4854: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)
4855: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4856: from pa_progress_rollup ppr
4857: -- Bug 3879461 : No need to have percent complete table join now we can directly check current_flag as W
4858: -- ,pa_percent_completes ppc
4859: where ppr.project_id = p_project_id
4860: and ppr.object_id = p_object_id
4861: -- and ppr.object_version_id = p_object_version_id
4862: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4888: from pa_progress_rollup ppr,pa_percent_completes ppc

4884: fetch c1 into l_c1rec;
4885: if c1%found then
4886: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)+nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)+nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
4887: into l_act_cost_pub
4888: from pa_progress_rollup ppr,pa_percent_completes ppc
4889: where ppr.project_id = ppc.project_id
4890: and ppr.object_id = ppc.object_id
4891: and ppr.object_version_id = ppc.object_version_id
4892: and ppr.as_of_date = ppc.date_computed (+)

Line 4902: from pa_percent_completes ppc2

4898: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4899: and ppr.structure_type = ppc.structure_type(+) -- FPM Dev CR 3
4900: and ppr.proj_element_id = ppc.task_id (+) -- Modified for IB4 Progress CR.
4901: and ppr.as_of_date = (select max(ppc2.date_computed)
4902: from pa_percent_completes ppc2
4903: where ppc2.project_id = p_project_id
4904: and ppc2.object_id = p_object_id
4905: -- and ppc2.object_version_id = p_object_version_id
4906: and ppc2.published_flag = 'Y'

Line 5216: from pa_progress_rollup ppr,pa_percent_completes ppc

5212: fetch c1 into l_c1rec;
5213: if c1%found then
5214: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)+nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.subprj_oth_act_cost_to_date_fc,0)+nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
5215: into l_act_cost_pub
5216: from pa_progress_rollup ppr,pa_percent_completes ppc
5217: where ppr.project_id = ppc.project_id
5218: and ppr.object_id = ppc.object_id
5219: and ppr.object_version_id = ppc.object_version_id
5220: and ppr.as_of_date = ppc.date_computed (+)

Line 5230: from pa_percent_completes ppc2

5226: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5227: and ppr.structure_type = ppc.structure_type(+) -- FPM Dev CR 3
5228: and ppr.proj_element_id = ppc.task_id (+) -- Modified for IB4 Progress CR.
5229: and ppr.as_of_date = (select max(ppc2.date_computed)
5230: from pa_percent_completes ppc2
5231: where ppc2.project_id = p_project_id
5232: and ppc2.object_id = p_object_id
5233: -- and ppc2.object_version_id = p_object_version_id
5234: and ppc2.published_flag = 'Y'

Line 5318: -- ,pa_percent_completes ppc

5314: cursor c_this_prog_rec is
5315: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0)) act_effort_to_date
5316: from pa_progress_rollup ppr
5317: -- Bug 3879461 : Now percent complete join is not required. current_flag = W can be used
5318: -- ,pa_percent_completes ppc
5319: where ppr.project_id = p_project_id
5320: and ppr.object_id = p_object_id
5321: -- and ppr.object_version_id = p_object_version_id
5322: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5353: -- from pa_progress_rollup ppr,pa_percent_completes ppc

5349: -- Bug 3764224 : RLM Changes : This code is commented, the earlier cusrsor code c1 was fine expept instead of greater than it should have been less than sign
5350: -- cursor cur_effort_this_period
5351: -- is
5352: -- select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
5353: -- from pa_progress_rollup ppr,pa_percent_completes ppc
5354: -- where ppr.project_id = ppc.project_id
5355: -- and ppr.object_id = ppc.object_id
5356: -- and ppr.as_of_date = ppc.date_computed
5357: -- and ppr.project_id = p_project_id

Line 5379: from pa_progress_rollup ppr,pa_percent_completes ppc

5375: fetch c1 into l_c1rec;
5376: if c1%found then
5377: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
5378: into l_act_effort_pub
5379: from pa_progress_rollup ppr,pa_percent_completes ppc
5380: where ppr.project_id = ppc.project_id
5381: and ppr.object_id = ppc.object_id
5382: and ppr.object_version_id = ppc.object_version_id
5383: and ppr.as_of_date = ppc.date_computed (+)

Line 5391: from pa_percent_completes ppc2

5387: and ppr.percent_complete_id = ppc.percent_complete_id
5388: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5389: and ppr.structure_type = ppc.structure_type (+) -- FPM Dev CR 3
5390: and ppr.as_of_date = (select max(ppc2.date_computed)
5391: from pa_percent_completes ppc2
5392: where ppc2.project_id = p_project_id
5393: and ppc2.object_id = p_object_id
5394: -- and ppc2.object_version_id = p_object_version_id
5395: and ppc2.published_flag = 'Y'

Line 5467: from pa_percent_completes

5463: and current_flag = 'Y'
5464: and ppr.structure_version_id is null
5465: union
5466: select max(last_update_date) l_update_date
5467: from pa_percent_completes
5468: where project_id = p_project_id
5469: and structure_type = 'WORKPLAN'
5470: and published_flag = 'Y'));
5471:

Line 5487: from pa_percent_completes

5483: and current_flag = 'Y'
5484: and ppr.structure_version_id is null
5485: union
5486: select '1'
5487: from pa_percent_completes
5488: where project_id = p_project_id
5489: and structure_type = 'WORKPLAN'
5490: and published_flag = 'Y'); */
5491:

Line 5553: FROM pa_percent_completes ppr

5549: IF l_date_prog_applied_on_wver >= NVL(l_last_update_date,l_date_prog_applied_on_wver) THEN
5550: If nvl(l_program_flag,'N') = 'Y' then
5551: SELECT MAX(last_update_date)
5552: INTO l_last_update_date
5553: FROM pa_percent_completes ppr
5554: WHERE project_id = p_project_id
5555: AND structure_type = 'WORKPLAN'
5556: AND published_flag = 'Y'
5557: AND current_flag = 'Y';

Line 5599: FROM pa_percent_completes

5595: SELECT 'N'
5596: INTO l_return_value
5597: FROM DUAL
5598: WHERE EXISTS ( SELECT '1'
5599: FROM pa_percent_completes
5600: WHERE project_id = p_project_id
5601: AND structure_type = 'WORKPLAN'
5602: AND published_flag = 'Y');
5603:

Line 5752: FROM pa_percent_completes

5748: l_first_date Date;
5749: CURSOR cur_ppc
5750: IS
5751: SELECT min(trunc(last_update_date))
5752: FROM pa_percent_completes
5753: WHERE object_id = p_object_id
5754: AND project_id = p_project_id
5755: and object_type = p_object_type
5756: AND published_flag = 'Y'

Line 5786: FROM pa_percent_completes

5782: l_first_date Date;
5783: CURSOR cur_ppc
5784: IS
5785: SELECT max(trunc(last_update_date))
5786: FROM pa_percent_completes
5787: WHERE object_id = p_object_id
5788: AND project_id = p_project_id
5789: and object_type = p_object_type
5790: AND published_flag = 'Y'

Line 5814: from pa_percent_completes ppc

5810: l_return_date DATE;
5811: CURSOR cur_latest_date
5812: IS
5813: select max(date_computed)
5814: from pa_percent_completes ppc
5815: where ppc.project_id = p_project_id
5816: and ppc.structure_type = p_structure_type;
5817:
5818: BEGIN

Line 6825: from pa_percent_completes ppc

6821: BEGIN
6822:
6823: select max(date_computed)
6824: into l_return_date
6825: from pa_percent_completes ppc
6826: where ppc.project_id = p_project_id
6827: and ppc.structure_type = p_structure_type
6828: and ppc.object_id = p_object_id
6829: and ppc.object_type = p_object_type

Line 7458: -- SELECT 'X' FROM pa_percent_completes ppc

7454: AND ppr2.structure_version_id is null -- Bug 3879461
7455: and ppr2.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR.*/
7456: AND ppr2.current_flag <> 'W' -- Bug 3879461
7457: -- AND NOT EXISTS (
7458: -- SELECT 'X' FROM pa_percent_completes ppc
7459: -- WHERE ppc.date_computed = ppr2.as_of_date
7460: -- AND ppc.project_id = p_project_id
7461: -- AND ppc.object_id = p_object_id
7462: -- AND ppc.object_type = p_object_type

Line 7586: -- SELECT 'X' FROM pa_percent_completes ppc

7582: AND ppr2.structure_version_id is null -- Bug 3879461
7583: AND ppr2.current_flag <> 'W' -- Bug 3879461
7584: -- AND NOT EXISTS
7585: -- (
7586: -- SELECT 'X' FROM pa_percent_completes ppc
7587: -- WHERE ppc.date_computed = ppr2.as_of_date
7588: -- AND ppc.project_id = p_project_id
7589: -- AND ppc.object_id = p_object_id
7590: -- AND ppc.object_type = p_object_type

Line 7859: from pa_progress_rollup ppr,pa_percent_completes ppc

7855: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
7856: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_pc,0)
7857: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
7858: into l_act_rawcost_pub
7859: from pa_progress_rollup ppr,pa_percent_completes ppc
7860: where ppr.project_id = ppc.project_id
7861: and ppr.object_id = ppc.object_id
7862: and ppr.object_version_id = ppc.object_version_id
7863: and ppr.as_of_date = ppc.date_computed (+)

Line 7873: from pa_percent_completes ppc2

7869: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7870: and ppr.structure_type = ppc.structure_type(+) -- FPM Dev CR 3
7871: and ppr.proj_element_id = ppc.task_id (+) -- Modified for IB4 Progress CR.
7872: and ppr.as_of_date = (select max(ppc2.date_computed)
7873: from pa_percent_completes ppc2
7874: where ppc2.project_id = p_project_id
7875: and ppc2.object_id = p_object_id
7876: -- and ppc2.object_version_id = p_object_version_id
7877: and ppc2.published_flag = 'Y'

Line 7945: from pa_progress_rollup ppr,pa_percent_completes ppc

7941: is
7942: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
7943: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
7944: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
7945: from pa_progress_rollup ppr,pa_percent_completes ppc
7946: where ppr.project_id = ppc.project_id
7947: and ppr.object_id = ppc.object_id
7948: and ppr.as_of_date = ppc.date_computed
7949: and ppr.project_id = p_project_id

Line 8026: -- ,pa_percent_completes ppc

8022: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
8023: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
8024: from pa_progress_rollup ppr
8025: -- Bug 3879461 : percemnt compete join is not required. current_flag = W is sufficient
8026: -- ,pa_percent_completes ppc
8027: where ppr.project_id = p_project_id
8028: and ppr.object_id = p_object_id
8029: -- and ppr.object_version_id = p_object_version_id
8030: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8059: from pa_progress_rollup ppr,pa_percent_completes ppc

8055: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
8056: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
8057: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
8058: into l_act_rawcost_pub
8059: from pa_progress_rollup ppr,pa_percent_completes ppc
8060: where ppr.project_id = ppc.project_id
8061: and ppr.object_id = ppc.object_id
8062: and ppr.object_version_id = ppc.object_version_id
8063: and ppr.as_of_date = ppc.date_computed (+)

Line 8071: from pa_percent_completes ppc2

8067: and ppr.percent_complete_id = ppc.percent_complete_id
8068: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8069: and ppr.structure_type = ppc.structure_type(+) -- FPM Dev CR 3
8070: and ppr.as_of_date = (select max(ppc2.date_computed)
8071: from pa_percent_completes ppc2
8072: where ppc2.project_id = p_project_id
8073: and ppc2.object_id = p_object_id
8074: -- and ppc2.object_version_id = p_object_version_id
8075: and ppc2.published_flag = 'Y'

Line 8219: from pa_progress_rollup ppr,pa_percent_completes ppc

8215: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
8216: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_fc,0)
8217: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
8218: into l_act_rawcost_pub
8219: from pa_progress_rollup ppr,pa_percent_completes ppc
8220: where ppr.project_id = ppc.project_id
8221: and ppr.object_id = ppc.object_id
8222: and ppr.object_version_id = ppc.object_version_id
8223: and ppr.as_of_date = ppc.date_computed (+)

Line 8233: from pa_percent_completes ppc2

8229: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8230: and ppr.structure_type = ppc.structure_type(+) -- FPM Dev CR 3
8231: and ppr.proj_element_id = ppc.task_id (+) -- Modified for IB4 Progress CR.
8232: and ppr.as_of_date = (select max(ppc2.date_computed)
8233: from pa_percent_completes ppc2
8234: where ppc2.project_id = p_project_id
8235: and ppc2.object_id = p_object_id
8236: -- and ppc2.object_version_id = p_object_version_id
8237: and ppc2.published_flag = 'Y'

Line 9558: FROM PA_PERCENT_COMPLETES

9554:
9555: CURSOR published_rec_exists
9556: IS
9557: SELECT 'Y'
9558: FROM PA_PERCENT_COMPLETES
9559: WHERE object_id = p_dlv_proj_elt_id
9560: AND object_type = 'PA_DELIVERABLES'
9561: AND project_id = p_project_id
9562: AND structure_type = 'WORKPLAN'

Line 11018: FROM pa_percent_completes ppc

11014: CURSOR cur_ppc_assgn(c_object_id NUMBER, c_task_id NUMBER, c_object_type VARCHAR2
11015: , c_project_id NUMBER, c_structure_type VARCHAR2)
11016: IS
11017: SELECT 'Y'
11018: FROM pa_percent_completes ppc
11019: WHERE ppc.object_id = c_object_id
11020: AND ppc.task_id = c_task_id
11021: AND ppc.object_type = c_object_type
11022: AND ppc.project_id = c_project_id

Line 11056: FROM pa_percent_completes ppc

11052: CURSOR cur_ppc_task(c_task_id NUMBER, c_object_type VARCHAR2
11053: , c_project_id NUMBER, c_structure_type VARCHAR2)
11054: IS
11055: SELECT 'Y'
11056: FROM pa_percent_completes ppc
11057: WHERE ppc.task_id = c_task_id
11058: AND ppc.object_type = c_object_type
11059: AND ppc.project_id = c_project_id
11060: AND ppc.structure_type = c_structure_type