[Home] [Help]
2937: IF p_structure_type = 'WORKPLAN' THEN
2938: BEGIN
2939: SELECT
2940:
2941: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
2942: PERIOD_NAME
2943: , ACT_PRJ_BRDN_COST-ACT_PRJ_EQUIP_BRDN_COST-ACT_PRJ_LABOR_BRDN_COST
2944: , ACT_PRJ_LABOR_BRDN_COST
2945: , ACT_PRJ_EQUIP_BRDN_COST
3025: , l_POU_EQUIP_RAW_COST
3026: , l_PRJ_EQUIP_RAW_COST
3027: , l_POU_OTH_RAW_COST
3028: , l_PRJ_OTH_RAW_COST
3029: FROM PJI_FM_XBS_ACCUM_TMP1
3030: WHERE project_id = p_project_id
3031: AND struct_version_id = p_structure_version_id
3032: AND project_element_id = cur_reverse_tree_rec.proj_element_id
3033: AND plan_version_id > 0
3039: null;
3040: WHEN OTHERS THEN
3041: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
3042: p_procedure_name => 'ROLLUP_PROGRESS_PVT',
3043: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_TMP1 Failed:'||SQLERRM,1,120));
3044: RAISE FND_API.G_EXC_ERROR;
3045: END;
3046:
3047:
4994:
4995: BEGIN
4996: SELECT
4997: */
4998: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
4999: /*
5000: PERIOD_NAME
5001: , ACT_PRJ_BRDN_COST-ACT_PRJ_EQUIP_BRDN_COST-ACT_PRJ_LABOR_BRDN_COST
5002: , ACT_PRJ_LABOR_BRDN_COST
5082: , l_POU_EQUIP_RAW_COST
5083: , l_PRJ_EQUIP_RAW_COST
5084: , l_POU_OTH_RAW_COST
5085: , l_PRJ_OTH_RAW_COST
5086: FROM PJI_FM_XBS_ACCUM_TMP1
5087: WHERE project_id = l_c1rec.parent_project_id
5088: AND struct_version_id = l_c1rec.parent_structure_ver_id
5089: AND project_element_id = l_c1rec.parent_task_id
5090: AND plan_version_id > 0
5096: null;
5097: WHEN OTHERS THEN
5098: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
5099: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
5100: p_error_text => SUBSTRB('Select from PJI_FM_XBS_ACCUM_TMP1 Failed: SQLERRM'||SQLERRM,1,120));
5101: RAISE FND_API.G_EXC_ERROR;
5102: END;
5103:
5104:
6067: AND ppr.structure_version_id is null
6068: -- This query returns etc value = planned value when ther is no progress for the immediate sub-tasks.
6069: UNION ALL
6070: SELECT
6071: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
6072: obj.object_id_from1 object_id_from1
6073: , ppev1.object_type parent_object_type
6074: , ppev1.wbs_level-1 parent_wbs_level
6075: , ppev2.element_version_id object_id_to1
6188: , 'N' base_progress_status_code
6189: FROM pa_proj_element_versions ppev1,
6190: pa_proj_element_versions ppev2,
6191: pa_object_relationships obj,
6192: pji_fm_xbs_accum_tmp1 pfxat,
6193: pa_proj_elements ppe -- 4392189
6194: WHERE obj.object_id_from1 = c_task_ver_id
6195: AND obj.object_id_from1 = ppev1.element_version_id
6196: AND obj.object_id_to1 = ppev2.element_version_id
6780:
6781: --- sql id: 14906260 bug 4871809
6782: CURSOR c_get_sub_project_progress (c_sub_project_id NUMBER, c_sub_str_version_id NUMBER, c_sub_proj_element_id NUMBER
6783: , c_as_of_date Date, c_task_per_comp_deriv_method VARCHAR2) IS
6784: SELECT /*+ index(pfxat pji_fm_xbs_accum_tmp1_n1) */
6785: ppr.progress_rollup_id
6786: , ppr.as_of_date
6787: , ppr.actual_start_date
6788: , ppr.actual_finish_date
6847: ,pa_project_statuses pps2
6848: ,pa_project_statuses pps3
6849: ,pa_project_statuses pps4
6850: ,pa_proj_elements ppe
6851: ,pji_fm_xbs_accum_tmp1 pfxat
6852: WHERE
6853: ppr.project_id = c_sub_project_id
6854: AND ppe.project_id = c_sub_project_id
6855: AND ppe.object_type = 'PA_STRUCTURES'
8488: ,l_POU_LABOR_RAW_COST
8489: ,l_PRJ_LABOR_RAW_COST
8490: ,l_POU_EQUIP_RAW_COST
8491: ,l_PRJ_EQUIP_RAW_COST
8492: FROM PJI_FM_XBS_ACCUM_TMP1
8493: WHERE project_id = p_project_id
8494: AND struct_version_id = p_structure_version_id
8495: AND project_element_id = p_task_id
8496: AND plan_version_id > 0
8502: null;
8503: WHEN OTHERS THEN
8504: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
8505: p_procedure_name => 'ASGN_DLV_TO_TASK_ROLLUP_PVT',
8506: p_error_text => SUBSTRB('PJI_FM_XBS_ACCUM_TMP1:'||SQLERRM,1,120));
8507: RAISE FND_API.G_EXC_ERROR;
8508: END;
8509: */
8510: --Bug 3614828 End
9117: l_subprj_id NUMBER;
9118: l_subprj_proj_elem_id NUMBER;
9119:
9120: -- We canot use directly the parent project
9121: -- from pji_fm_xbs_accum_tmp1 table
9122: -- because PJI table stores self amounts p_xxx
9123: -- only for PC and not for PFC.
9124:
9125: CURSOR c_get_subproj_act(c_str_version_id NUMBER, c_project_id NUMBER, c_proj_element_id NUMBER) IS
9151: ,ACT_POU_EQUIP_RAW_COST EQPMT_ACT_RAWCOST_TO_DATE_FC
9152: ,ACT_PRJ_EQUIP_RAW_COST EQPMT_ACT_RAWCOST_TO_DATE_PC
9153: ,ETC_POU_EQUIP_RAW_COST EQPMT_ETC_RAWCOST_FC
9154: ,ETC_PRJ_EQUIP_RAW_COST EQPMT_ETC_RAWCOST_PC
9155: FROM pji_fm_xbs_accum_tmp1 pjitmp
9156: WHERE pjitmp.project_id = c_project_id
9157: AND struct_version_id = c_str_version_id
9158: AND project_element_id = c_proj_element_id
9159: AND plan_version_id > 0
13156: IF p_structure_type = 'WORKPLAN' THEN
13157: BEGIN
13158: SELECT
13159:
13160: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
13161: PERIOD_NAME
13162: , ACT_PRJ_BRDN_COST-ACT_PRJ_EQUIP_BRDN_COST-ACT_PRJ_LABOR_BRDN_COST
13163: , ACT_PRJ_LABOR_BRDN_COST
13164: , ACT_PRJ_EQUIP_BRDN_COST
13244: , l_POU_EQUIP_RAW_COST
13245: , l_PRJ_EQUIP_RAW_COST
13246: , l_POU_OTH_RAW_COST
13247: , l_PRJ_OTH_RAW_COST
13248: FROM PJI_FM_XBS_ACCUM_TMP1
13249: WHERE project_id = p_project_id
13250: AND struct_version_id = p_structure_version_id
13251: AND project_element_id = cur_reverse_tree_rec.proj_element_id
13252: AND plan_version_id > 0
13258: null;
13259: WHEN OTHERS THEN
13260: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
13261: p_procedure_name => 'ROLLUP_PVT',
13262: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_TMP1 Failed:'||SQLERRM,1,120));
13263: RAISE FND_API.G_EXC_ERROR;
13264: END;
13265:
13266: IF g1_debug_mode = 'Y' THEN
16768: IF p_structure_type = 'WORKPLAN' THEN
16769: BEGIN
16770: SELECT
16771:
16772: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
16773: PERIOD_NAME
16774: , ACT_PRJ_BRDN_COST-ACT_PRJ_EQUIP_BRDN_COST-ACT_PRJ_LABOR_BRDN_COST
16775: , ACT_PRJ_LABOR_BRDN_COST
16776: , ACT_PRJ_EQUIP_BRDN_COST
16856: , l_POU_EQUIP_RAW_COST
16857: , l_PRJ_EQUIP_RAW_COST
16858: , l_POU_OTH_RAW_COST
16859: , l_PRJ_OTH_RAW_COST
16860: FROM PJI_FM_XBS_ACCUM_TMP1
16861: WHERE project_id = p_project_id
16862: AND struct_version_id = p_structure_version_id
16863: AND project_element_id = l_task_id -- sridhar_rollup cur_reverse_tree_rec.proj_element_id
16864: AND plan_version_id > 0
16870: null;
16871: WHEN OTHERS THEN
16872: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
16873: p_procedure_name => 'ROLLUP_PVT',
16874: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_TMP1 Failed:'||SQLERRM,1,120));
16875: RAISE FND_API.G_EXC_ERROR;
16876: END;
16877:
16878: IF g1_debug_mode = 'Y' THEN