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: SELECT /+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)/ date_computed --Added hint for 15876400

398: --Added for performance improvements bug 2679612
399:
400: CURSOR cur_ppc(c_project_id NUMBER )
401: IS
402: SELECT /*+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)*/ date_computed --Added hint for 15876400
403: FROM pa_percent_completes
404: WHERE object_id = decode(p_object_id, null, p_task_id, p_object_id)
405: AND project_id = c_project_id
406: and object_type = p_object_type

Line 403: FROM pa_percent_completes

399:
400: CURSOR cur_ppc(c_project_id NUMBER )
401: IS
402: SELECT /*+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)*/ date_computed --Added hint for 15876400
403: FROM pa_percent_completes
404: WHERE object_id = decode(p_object_id, null, p_task_id, p_object_id)
405: AND project_id = c_project_id
406: and object_type = p_object_type
407: AND current_flag = 'Y'

Line 582: FROM pa_percent_completes

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

Line 597: FROM pa_percent_completes

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

Line 610: FROM pa_percent_completes

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

Line 637: FROM pa_percent_completes

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

Line 650: FROM pa_percent_completes

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

Line 789: select PA_PERCENT_COMPLETES_S.nextval

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

Line 1068: FROM pa_percent_completes

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

Line 1083: FROM pa_percent_completes

1079: -- Bug 3974627 : Added Cursors cur_pa_ppc_str_task, cur_pa_ppc_asgn, cur_pa_ppc_dlv
1080: CURSOR cur_pa_ppc_str_task
1081: IS
1082: SELECT max( date_computed )
1083: FROM pa_percent_completes
1084: WHERE project_id = p_Project_ID
1085: AND object_id = decode(p_object_id, null, p_task_id, p_object_id)
1086: AND current_flag = 'Y'
1087: AND published_flag = 'Y'

Line 1097: FROM pa_percent_completes

1093:
1094: CURSOR cur_pa_ppc_asgn
1095: IS
1096: SELECT max( date_computed )
1097: FROM pa_percent_completes
1098: WHERE project_id = p_Project_ID
1099: AND current_flag = 'Y'
1100: AND published_flag = 'Y'
1101: AND object_type IN ('PA_ASSIGNMENTS' ,'PA_TASKS')

Line 1121: FROM pa_percent_completes

1117:
1118: CURSOR cur_pa_ppc_dlv(c_task_id NUMBER)
1119: IS
1120: SELECT max( date_computed )
1121: FROM pa_percent_completes
1122: WHERE project_id = p_Project_ID
1123: 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)))
1124: AND current_flag = 'Y'
1125: AND published_flag = 'Y'

Line 1272: FROM pa_percent_completes

1268: /*
1269: CURSOR cur_pa_ppc
1270: IS
1271: SELECT max( date_computed )
1272: FROM pa_percent_completes
1273: WHERE project_id = p_Project_ID
1274: -- AND object_id = p_task_id
1275: AND object_id = decode(p_object_id, null, p_task_id, p_object_id) -- This is Done to avoid the impact
1276: AND object_type = p_object_type

Line 1289: FROM pa_percent_completes

1285: -- Bug 3974627 : Added Cursors cur_pa_ppc_str_task, cur_pa_ppc_asgn, cur_pa_ppc_dlv
1286: CURSOR cur_pa_ppc_str_task
1287: IS
1288: SELECT max( date_computed )
1289: FROM pa_percent_completes
1290: WHERE project_id = p_Project_ID
1291: AND object_id = decode(p_object_id, null, p_task_id, p_object_id)
1292: AND current_flag = 'Y'
1293: AND published_flag = 'Y'

Line 1303: FROM pa_percent_completes

1299:
1300: CURSOR cur_pa_ppc_asgn
1301: IS
1302: SELECT max( date_computed )
1303: FROM pa_percent_completes
1304: WHERE project_id = p_Project_ID
1305: AND current_flag = 'Y'
1306: AND published_flag = 'Y'
1307: AND ((object_type = 'PA_ASSIGNMENTS' and object_id = p_object_id AND NVL(cbs_element_id,-1) = NVL(p_cbs_element_id,-1)) --Added for CBS phase 2 16200605

Line 1328: FROM pa_percent_completes

1324:
1325: CURSOR cur_pa_ppc_dlv_notask
1326: IS
1327: SELECT max( date_computed )
1328: FROM pa_percent_completes
1329: WHERE project_id = p_Project_ID
1330: AND object_id = p_object_id
1331: AND current_flag = 'Y'
1332: AND published_flag = 'Y'

Line 1341: FROM pa_percent_completes

1337:
1338: CURSOR cur_pa_ppc_dlv_task(c_task_id NUMBER)
1339: IS
1340: SELECT max( date_computed )
1341: FROM pa_percent_completes
1342: WHERE project_id = p_Project_ID
1343: AND ((object_id = p_object_id and object_type = 'PA_DELIVERABLES') or
1344: (object_id = p_task_id and object_type = 'PA_TASKS'))
1345: AND current_flag = 'Y'

Line 1352: FROM pa_percent_completes

1348: ;
1349: CURSOR cur_pa_ppc_w
1350: IS
1351: SELECT max( date_computed )
1352: FROM pa_percent_completes
1353: WHERE project_id = p_Project_ID
1354: -- AND object_id = p_task_id
1355: AND object_id = decode(p_object_id, null, p_task_id, p_object_id) -- This is Done to avoid the impact
1356: AND object_type = p_object_type

Line 1546: SELECT /+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)/ decode( published_flag, 'Y', 'PUBLISHED', 'N', 'WORKING' ) --Added hint for 15876400

1542: ) RETURN VARCHAR2 IS
1543:
1544: CURSOR cur_ppc
1545: IS
1546: SELECT /*+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)*/ decode( published_flag, 'Y', 'PUBLISHED', 'N', 'WORKING' ) --Added hint for 15876400
1547: FROM pa_percent_completes
1548: WHERE object_id = nvl(p_object_id, p_task_id) /* Modified for IB4 Progress CR. */
1549: AND object_type = p_object_type
1550: AND project_id = p_project_id

Line 1547: FROM pa_percent_completes

1543:
1544: CURSOR cur_ppc
1545: IS
1546: SELECT /*+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)*/ decode( published_flag, 'Y', 'PUBLISHED', 'N', 'WORKING' ) --Added hint for 15876400
1547: FROM pa_percent_completes
1548: WHERE object_id = nvl(p_object_id, p_task_id) /* Modified for IB4 Progress CR. */
1549: AND object_type = p_object_type
1550: AND project_id = p_project_id
1551: AND date_computed = p_as_of_date

Line 1578: FROM pa_percent_completes

1574:
1575: CURSOR cur_ppc_id
1576: IS
1577: SELECT percent_complete_id
1578: FROM pa_percent_completes
1579: WHERE object_type = p_object_type
1580: AND object_id = p_object_id
1581: AND project_id = p_project_id
1582: -- AND object_version_id = p_object_version_id

Line 1681: FROM pa_percent_completes

1677:
1678: CURSOR cur_pa_prog_exists(c_project_id NUMBER )
1679: IS
1680: SELECT 'X'
1681: FROM pa_percent_completes
1682: WHERE object_id = p_task_id
1683: AND project_id = c_project_id;
1684: l_dummy_char VARCHAR2(1);
1685: BEGIN

Line 2008: FROM pa_percent_completes

2004: p_object_id NUMBER) RETURN VARCHAR2 IS
2005: CURSOR cur_pa_prog_exists
2006: IS
2007: SELECT 'X'
2008: FROM pa_percent_completes
2009: WHERE project_id = p_project_id
2010: AND object_id = decode(nvl(p_object_id,0),0,object_id,p_object_id)
2011: AND object_type = 'PA_STRUCTURES'
2012: AND task_id = 0;

Line 2035: FROM pa_percent_completes

2031: p_structure_type VARCHAR2 := null) RETURN VARCHAR2 IS -- added a new parameter for the BUG 6903050
2032: CURSOR cur_pa_prog_exists
2033: IS
2034: SELECT 'X'
2035: FROM pa_percent_completes
2036: WHERE project_id = p_project_id
2037: AND object_id = decode(nvl(p_object_id,0),0,object_id,p_object_id)
2038: AND object_type = 'PA_STRUCTURES'
2039: AND task_id = 0;

Line 2044: FROM pa_percent_completes

2040:
2041: CURSOR cur_pa_prog_exists_wp -- added a new cursor for the BUG 6903050
2042: IS
2043: SELECT 'X'
2044: FROM pa_percent_completes
2045: WHERE project_id = p_project_id
2046: AND object_id = decode(nvl(p_object_id,0),0,object_id,p_object_id)
2047: AND object_type = 'PA_STRUCTURES'
2048: AND task_id = 0

Line 2100: SELECT /+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)/ date_computed --Added hint for 15876400

2096: ) RETURN DATE IS
2097:
2098: CURSOR cur_pa_pcc
2099: IS
2100: SELECT /*+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)*/ date_computed --Added hint for 15876400
2101: FROM pa_percent_completes
2102: WHERE project_id = p_project_id
2103: AND object_id = nvl(p_object_id, p_task_id) /* Modified for IB4 Progress CR. */
2104: AND object_type = p_object_type

Line 2101: FROM pa_percent_completes

2097:
2098: CURSOR cur_pa_pcc
2099: IS
2100: SELECT /*+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)*/ date_computed --Added hint for 15876400
2101: FROM pa_percent_completes
2102: WHERE project_id = p_project_id
2103: AND object_id = nvl(p_object_id, p_task_id) /* Modified for IB4 Progress CR. */
2104: AND object_type = p_object_type
2105: AND structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 2127: select 'X' from pa_percent_completes

2123: p_status_code VARCHAR2 ) RETURN BOOLEAN
2124: is
2125: Cursor c_percent_complete
2126: is
2127: select 'X' from pa_percent_completes
2128: where ( progress_status_code = p_status_code
2129: or status_code = p_status_code)
2130: AND rownum <= 1;
2131:

Line 2230: FROM pa_percent_completes

2226:
2227: CURSOR cur_ppc(c_project_id NUMBER )
2228: IS
2229: SELECT MAX( date_computed )
2230: FROM pa_percent_completes
2231: WHERE object_id = p_task_id
2232: AND project_id = c_project_id
2233: AND date_computed < p_as_of_Date
2234: ;

Line 2364: from pa_percent_completes

2360: l_ppc_id number;
2361: begin
2362: select nvl(max(percent_complete_id),-99)
2363: into l_ppc_id
2364: from pa_percent_completes
2365: where project_id = p_project_id
2366: and object_id = p_object_id
2367: and object_type = p_object_type
2368: and date_computed <= p_as_of_date;

Line 2409: from pa_percent_completes

2405: and object_id = p_object_id
2406: and object_type = p_object_type
2407: and structure_type = p_structure_type -- FPM Dev CR 3
2408: and trunc(as_of_date) = (select max(trunc(date_computed))
2409: from pa_percent_completes
2410: where project_id = p_project_id
2411: and object_id = p_object_id
2412: and object_type = p_object_type
2413: and structure_type = p_structure_type -- FPM Dev CR 3

Line 2431: -- from pa_percent_completes

2427: and as_of_date <= p_as_of_date
2428: 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))
2429: AND current_flag <> 'W' -- Bug 3879461
2430: -- and as_of_date not in (select trunc(date_computed)
2431: -- from pa_percent_completes
2432: -- where project_id = p_project_id
2433: -- and object_id = p_object_id
2434: -- and object_type = p_object_type
2435: -- and structure_type = p_structure_type

Line 2500: from pa_percent_completes

2496: )
2497: IS
2498: cursor get_ppc_id is
2499: select percent_complete_id
2500: from pa_percent_completes
2501: where project_id = p_project_id
2502: and object_id = p_object_id
2503: and object_type = p_object_type
2504: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 2525: X_from_entity_name => 'PA_PERCENT_COMPLETES',

2521: end if;
2522:
2523: if (l_from_pc_id is not null) then
2524: fnd_attached_documents2_pkg.copy_attachments(
2525: X_from_entity_name => 'PA_PERCENT_COMPLETES',
2526: X_from_pk1_value => l_from_pc_id,
2527: X_to_entity_name => 'PA_PERCENT_COMPLETES',
2528: X_to_pk1_value => p_to_pc_id,
2529: X_created_by => fnd_global.user_id,

Line 2527: X_to_entity_name => 'PA_PERCENT_COMPLETES',

2523: if (l_from_pc_id is not null) then
2524: fnd_attached_documents2_pkg.copy_attachments(
2525: X_from_entity_name => 'PA_PERCENT_COMPLETES',
2526: X_from_pk1_value => l_from_pc_id,
2527: X_to_entity_name => 'PA_PERCENT_COMPLETES',
2528: X_to_pk1_value => p_to_pc_id,
2529: X_created_by => fnd_global.user_id,
2530: X_last_update_login => fnd_global.login_id);
2531: end if;

Line 2762: FROM pa_percent_completes

2758:
2759: CURSOR cur_ppc
2760: IS
2761: SELECT min(date_computed)
2762: FROM pa_percent_completes
2763: WHERE object_id = p_object_id
2764: AND project_id = p_project_id
2765: and object_type = p_object_type
2766: AND structure_type = p_structure_type

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

2876: NVL(p_proj_element_id, p_object_id)
2877: ) /* Amit : Modified for IB4 Progress CR. */
2878: -- AND NOT EXISTS
2879: -- (
2880: -- SELECT 'X' FROM pa_percent_completes ppc
2881: -- WHERE ppc.date_computed = ppr2.as_of_date
2882: -- AND ppc.project_id = p_project_id
2883: -- AND ppc.object_id = p_object_id
2884: -- AND ppc.object_type = p_object_type

Line 4890: -- ,pa_percent_completes ppc

4886: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)
4887: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4888: from pa_progress_rollup ppr
4889: -- Bug 3879461 : No need to have percent complete table join now we can directly check current_flag as W
4890: -- ,pa_percent_completes ppc
4891: where ppr.project_id = p_project_id
4892: and ppr.object_id = p_object_id
4893: AND NVL(ppr.cbs_element_id,-1) = NVL(p_cbs_element_id,-1) --Added for CBS phase 2 16200605
4894: -- and ppr.object_version_id = p_object_version_id

Line 4921: from pa_progress_rollup ppr,pa_percent_completes ppc

4917: fetch c1 into l_c1rec;
4918: if c1%found then
4919: 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_DT_TC,0)+nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
4920: into l_act_cost_pub
4921: from pa_progress_rollup ppr,pa_percent_completes ppc
4922: where ppr.project_id = ppc.project_id
4923: and ppr.object_id = ppc.object_id
4924: and ppr.object_version_id = ppc.object_version_id
4925: and ppr.as_of_date = ppc.date_computed (+)

Line 4935: from pa_percent_completes ppc2

4931: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4932: and ppr.structure_type = ppc.structure_type(+) -- FPM Dev CR 3
4933: and ppr.proj_element_id = ppc.task_id (+) -- Modified for IB4 Progress CR.
4934: and ppr.as_of_date = (select max(ppc2.date_computed)
4935: from pa_percent_completes ppc2
4936: where ppc2.project_id = p_project_id
4937: and ppc2.object_id = p_object_id
4938: -- and ppc2.object_version_id = p_object_version_id
4939: and ppc2.published_flag = 'Y'

Line 5249: from pa_progress_rollup ppr,pa_percent_completes ppc

5245: fetch c1 into l_c1rec;
5246: if c1%found then
5247: 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_DT_FC,0)+nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
5248: into l_act_cost_pub
5249: from pa_progress_rollup ppr,pa_percent_completes ppc
5250: where ppr.project_id = ppc.project_id
5251: and ppr.object_id = ppc.object_id
5252: and ppr.object_version_id = ppc.object_version_id
5253: and ppr.as_of_date = ppc.date_computed (+)

Line 5263: from pa_percent_completes ppc2

5259: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5260: and ppr.structure_type = ppc.structure_type(+) -- FPM Dev CR 3
5261: and ppr.proj_element_id = ppc.task_id (+) -- Modified for IB4 Progress CR.
5262: and ppr.as_of_date = (select max(ppc2.date_computed)
5263: from pa_percent_completes ppc2
5264: where ppc2.project_id = p_project_id
5265: and ppc2.object_id = p_object_id
5266: -- and ppc2.object_version_id = p_object_version_id
5267: and ppc2.published_flag = 'Y'

Line 5351: -- ,pa_percent_completes ppc

5347: cursor c_this_prog_rec is
5348: 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
5349: from pa_progress_rollup ppr
5350: -- Bug 3879461 : Now percent complete join is not required. current_flag = W can be used
5351: -- ,pa_percent_completes ppc
5352: where ppr.project_id = p_project_id
5353: and ppr.object_id = p_object_id
5354: -- and ppr.object_version_id = p_object_version_id
5355: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5386: -- from pa_progress_rollup ppr,pa_percent_completes ppc

5382: -- 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
5383: -- cursor cur_effort_this_period
5384: -- is
5385: -- 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))
5386: -- from pa_progress_rollup ppr,pa_percent_completes ppc
5387: -- where ppr.project_id = ppc.project_id
5388: -- and ppr.object_id = ppc.object_id
5389: -- and ppr.as_of_date = ppc.date_computed
5390: -- and ppr.project_id = p_project_id

Line 5412: from pa_progress_rollup ppr,pa_percent_completes ppc

5408: fetch c1 into l_c1rec;
5409: if c1%found then
5410: 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))
5411: into l_act_effort_pub
5412: from pa_progress_rollup ppr,pa_percent_completes ppc
5413: where ppr.project_id = ppc.project_id
5414: and ppr.object_id = ppc.object_id
5415: and ppr.object_version_id = ppc.object_version_id
5416: and ppr.as_of_date = ppc.date_computed (+)

Line 5424: from pa_percent_completes ppc2

5420: and ppr.percent_complete_id = ppc.percent_complete_id
5421: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5422: and ppr.structure_type = ppc.structure_type (+) -- FPM Dev CR 3
5423: and ppr.as_of_date = (select max(ppc2.date_computed)
5424: from pa_percent_completes ppc2
5425: where ppc2.project_id = p_project_id
5426: and ppc2.object_id = p_object_id
5427: -- and ppc2.object_version_id = p_object_version_id
5428: and ppc2.published_flag = 'Y'

Line 5500: from pa_percent_completes

5496: and current_flag = 'Y'
5497: and ppr.structure_version_id is null
5498: union
5499: select max(last_update_date) l_update_date
5500: from pa_percent_completes
5501: where project_id = p_project_id
5502: and structure_type = 'WORKPLAN'
5503: and published_flag = 'Y'));
5504:

Line 5520: from pa_percent_completes

5516: and current_flag = 'Y'
5517: and ppr.structure_version_id is null
5518: union
5519: select '1'
5520: from pa_percent_completes
5521: where project_id = p_project_id
5522: and structure_type = 'WORKPLAN'
5523: and published_flag = 'Y'); */
5524:

Line 5586: FROM pa_percent_completes ppr

5582: IF l_date_prog_applied_on_wver >= NVL(l_last_update_date,l_date_prog_applied_on_wver) THEN
5583: If nvl(l_program_flag,'N') = 'Y' then
5584: SELECT MAX(last_update_date)
5585: INTO l_last_update_date
5586: FROM pa_percent_completes ppr
5587: WHERE project_id = p_project_id
5588: AND structure_type = 'WORKPLAN'
5589: AND published_flag = 'Y'
5590: AND current_flag = 'Y';

Line 5632: FROM pa_percent_completes

5628: SELECT 'N'
5629: INTO l_return_value
5630: FROM DUAL
5631: WHERE EXISTS ( SELECT '1'
5632: FROM pa_percent_completes
5633: WHERE project_id = p_project_id
5634: AND structure_type = 'WORKPLAN'
5635: AND published_flag = 'Y');
5636:

Line 5785: FROM pa_percent_completes

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

Line 5820: FROM pa_percent_completes

5816: l_first_date Date;
5817: CURSOR cur_ppc
5818: IS
5819: SELECT max(trunc(last_update_date))
5820: FROM pa_percent_completes
5821: WHERE object_id = p_object_id
5822: AND project_id = p_project_id
5823: and object_type = p_object_type
5824: AND published_flag = 'Y'

Line 5849: from pa_percent_completes ppc

5845: l_return_date DATE;
5846: CURSOR cur_latest_date
5847: IS
5848: select max(date_computed)
5849: from pa_percent_completes ppc
5850: where ppc.project_id = p_project_id
5851: and ppc.structure_type = p_structure_type;
5852:
5853: BEGIN

Line 6865: from pa_percent_completes ppc

6861: BEGIN
6862:
6863: select max(date_computed)
6864: into l_return_date
6865: from pa_percent_completes ppc
6866: where ppc.project_id = p_project_id
6867: and ppc.structure_type = p_structure_type
6868: and ppc.object_id = p_object_id
6869: and ppc.object_type = p_object_type

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

7494: AND ppr2.structure_version_id is null -- Bug 3879461
7495: and ppr2.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR.*/
7496: AND ppr2.current_flag <> 'W' -- Bug 3879461
7497: -- AND NOT EXISTS (
7498: -- SELECT 'X' FROM pa_percent_completes ppc
7499: -- WHERE ppc.date_computed = ppr2.as_of_date
7500: -- AND ppc.project_id = p_project_id
7501: -- AND ppc.object_id = p_object_id
7502: -- AND ppc.object_type = p_object_type

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

7622: AND ppr2.structure_version_id is null -- Bug 3879461
7623: AND ppr2.current_flag <> 'W' -- Bug 3879461
7624: -- AND NOT EXISTS
7625: -- (
7626: -- SELECT 'X' FROM pa_percent_completes ppc
7627: -- WHERE ppc.date_computed = ppr2.as_of_date
7628: -- AND ppc.project_id = p_project_id
7629: -- AND ppc.object_id = p_object_id
7630: -- AND ppc.object_type = p_object_type

Line 7901: from pa_progress_rollup ppr,pa_percent_completes ppc

7897: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
7898: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_PC,0)
7899: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
7900: into l_act_rawcost_pub
7901: from pa_progress_rollup ppr,pa_percent_completes ppc
7902: where ppr.project_id = ppc.project_id
7903: and ppr.object_id = ppc.object_id
7904: and ppr.object_version_id = ppc.object_version_id
7905: and ppr.as_of_date = ppc.date_computed (+)

Line 7915: from pa_percent_completes ppc2

7911: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7912: and ppr.structure_type = ppc.structure_type(+) -- FPM Dev CR 3
7913: and ppr.proj_element_id = ppc.task_id (+) -- Modified for IB4 Progress CR.
7914: and ppr.as_of_date = (select max(ppc2.date_computed)
7915: from pa_percent_completes ppc2
7916: where ppc2.project_id = p_project_id
7917: and ppc2.object_id = p_object_id
7918: -- and ppc2.object_version_id = p_object_version_id
7919: and ppc2.published_flag = 'Y'

Line 7989: from pa_progress_rollup ppr,pa_percent_completes ppc

7985: is
7986: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
7987: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
7988: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
7989: from pa_progress_rollup ppr,pa_percent_completes ppc
7990: where ppr.project_id = ppc.project_id
7991: and ppr.object_id = ppc.object_id
7992: and ppr.as_of_date = ppc.date_computed
7993: and ppr.project_id = p_project_id

Line 8071: -- ,pa_percent_completes ppc

8067: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
8068: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
8069: from pa_progress_rollup ppr
8070: -- Bug 3879461 : percemnt compete join is not required. current_flag = W is sufficient
8071: -- ,pa_percent_completes ppc
8072: where ppr.project_id = p_project_id
8073: and ppr.object_id = p_object_id
8074: -- and ppr.object_version_id = p_object_version_id
8075: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8105: from pa_progress_rollup ppr,pa_percent_completes ppc

8101: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
8102: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
8103: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
8104: into l_act_rawcost_pub
8105: from pa_progress_rollup ppr,pa_percent_completes ppc
8106: where ppr.project_id = ppc.project_id
8107: and ppr.object_id = ppc.object_id
8108: and ppr.object_version_id = ppc.object_version_id
8109: and ppr.as_of_date = ppc.date_computed (+)

Line 8117: from pa_percent_completes ppc2

8113: and ppr.percent_complete_id = ppc.percent_complete_id
8114: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8115: and ppr.structure_type = ppc.structure_type(+) -- FPM Dev CR 3
8116: and ppr.as_of_date = (select max(ppc2.date_computed)
8117: from pa_percent_completes ppc2
8118: where ppc2.project_id = p_project_id
8119: and ppc2.object_id = p_object_id
8120: -- and ppc2.object_version_id = p_object_version_id
8121: and ppc2.published_flag = 'Y'

Line 8265: from pa_progress_rollup ppr,pa_percent_completes ppc

8261: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
8262: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_FC,0)
8263: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
8264: into l_act_rawcost_pub
8265: from pa_progress_rollup ppr,pa_percent_completes ppc
8266: where ppr.project_id = ppc.project_id
8267: and ppr.object_id = ppc.object_id
8268: and ppr.object_version_id = ppc.object_version_id
8269: and ppr.as_of_date = ppc.date_computed (+)

Line 8279: from pa_percent_completes ppc2

8275: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8276: and ppr.structure_type = ppc.structure_type(+) -- FPM Dev CR 3
8277: and ppr.proj_element_id = ppc.task_id (+) -- Modified for IB4 Progress CR.
8278: and ppr.as_of_date = (select max(ppc2.date_computed)
8279: from pa_percent_completes ppc2
8280: where ppc2.project_id = p_project_id
8281: and ppc2.object_id = p_object_id
8282: -- and ppc2.object_version_id = p_object_version_id
8283: and ppc2.published_flag = 'Y'

Line 9632: FROM PA_PERCENT_COMPLETES

9628:
9629: CURSOR published_rec_exists
9630: IS
9631: SELECT 'Y'
9632: FROM PA_PERCENT_COMPLETES
9633: WHERE object_id = p_dlv_proj_elt_id
9634: AND object_type = 'PA_DELIVERABLES'
9635: AND project_id = p_project_id
9636: AND structure_type = 'WORKPLAN'

Line 11094: FROM pa_percent_completes ppc

11090: CURSOR cur_ppc_assgn(c_object_id NUMBER, c_task_id NUMBER, c_object_type VARCHAR2
11091: , c_project_id NUMBER, c_structure_type VARCHAR2)
11092: IS
11093: SELECT 'Y'
11094: FROM pa_percent_completes ppc
11095: WHERE ppc.object_id = c_object_id
11096: AND ppc.task_id = c_task_id
11097: AND ppc.object_type = c_object_type
11098: AND ppc.project_id = c_project_id

Line 11134: FROM pa_percent_completes ppc

11130: CURSOR cur_ppc_task(c_task_id NUMBER, c_object_type VARCHAR2
11131: , c_project_id NUMBER, c_structure_type VARCHAR2)
11132: IS
11133: SELECT 'Y'
11134: FROM pa_percent_completes ppc
11135: WHERE ppc.task_id = c_task_id
11136: AND ppc.object_type = c_object_type
11137: AND ppc.project_id = c_project_id
11138: AND ppc.structure_type = c_structure_type