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_FP_COPY_ACTUALS_PUB dependencies on PA_FP_PLANNING_RES_TMP1

Line 719: into the tmp table PA_FP_PLANNING_RES_TMP1. Because, the task id value is referred

715:
716: /* updating the project element id ( task id ) to NULL
717: when the value is <= 0 for addressing the P1 bug 3841480.
718: Please note that we cannot resolve the issue by populating the NULL value
719: into the tmp table PA_FP_PLANNING_RES_TMP1. Because, the task id value is referred
720: in the pji_fm_xbs_accum_tmp1 table later in the code. */
721:
722: update pji_fm_xbs_accum_tmp1 set project_element_id = null
723: where NVL(project_element_id,0) <= 0;

Line 725: /**Populating PA_FP_PLANNING_RES_TMP1, call COPY_ACUTALS_PUB.CREATE_RES_ASG to create

721:
722: update pji_fm_xbs_accum_tmp1 set project_element_id = null
723: where NVL(project_element_id,0) <= 0;
724:
725: /**Populating PA_FP_PLANNING_RES_TMP1, call COPY_ACUTALS_PUB.CREATE_RES_ASG to create
726: *missing resource assignment in pa_resource_assignment table. After that, resource_
727: *assignment_id will be populated pa_fp_planning_res_tmp1.
728: **/
729: DELETE FROM PA_FP_PLANNING_RES_TMP1;

Line 727: *assignment_id will be populated pa_fp_planning_res_tmp1.

723: where NVL(project_element_id,0) <= 0;
724:
725: /**Populating PA_FP_PLANNING_RES_TMP1, call COPY_ACUTALS_PUB.CREATE_RES_ASG to create
726: *missing resource assignment in pa_resource_assignment table. After that, resource_
727: *assignment_id will be populated pa_fp_planning_res_tmp1.
728: **/
729: DELETE FROM PA_FP_PLANNING_RES_TMP1;
730: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
731: TASK_ID,

Line 729: DELETE FROM PA_FP_PLANNING_RES_TMP1;

725: /**Populating PA_FP_PLANNING_RES_TMP1, call COPY_ACUTALS_PUB.CREATE_RES_ASG to create
726: *missing resource assignment in pa_resource_assignment table. After that, resource_
727: *assignment_id will be populated pa_fp_planning_res_tmp1.
728: **/
729: DELETE FROM PA_FP_PLANNING_RES_TMP1;
730: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
731: TASK_ID,
732: RESOURCE_LIST_MEMBER_ID,
733: RESOURCE_ASSIGNMENT_ID )

Line 730: INSERT INTO PA_FP_PLANNING_RES_TMP1 (

726: *missing resource assignment in pa_resource_assignment table. After that, resource_
727: *assignment_id will be populated pa_fp_planning_res_tmp1.
728: **/
729: DELETE FROM PA_FP_PLANNING_RES_TMP1;
730: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
731: TASK_ID,
732: RESOURCE_LIST_MEMBER_ID,
733: RESOURCE_ASSIGNMENT_ID )
734: ( SELECT DISTINCT PROJECT_ELEMENT_ID,

Line 766: *pa_fp_planning_res_tmp1. Then this value needs to populated back to pji_fm_xbs_accum_tmp1

762: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
763: END IF;
764:
765: /**Calling update_res_asg to populate the newly created resource_assignment_id back to
766: *pa_fp_planning_res_tmp1. Then this value needs to populated back to pji_fm_xbs_accum_tmp1
767: **/
768: IF P_PA_DEBUG_MODE = 'Y' THEN
769: pa_fp_gen_amount_utils.fp_debug
770: (p_msg => 'Before calling update_res_asg',

Line 794: (SELECT /+ INDEX(ra,PA_FP_PLANNING_RES_TMP1_N2)/ resource_assignment_id

790: END IF;
791:
792: UPDATE PJI_FM_XBS_ACCUM_TMP1 tmp1
793: SET source_id =
794: (SELECT /*+ INDEX(ra,PA_FP_PLANNING_RES_TMP1_N2)*/ resource_assignment_id
795: FROM PA_FP_PLANNING_RES_TMP1 ra
796: WHERE nvl(ra.task_id,0) = nvl(tmp1.project_element_id,0)
797: AND ra.resource_list_member_id = tmp1.res_list_member_id );
798: --dbms_output.put_line('No.of rows updated in pji_fm_xbs_accum_tmp1 table: '||sql%rowcount);

Line 795: FROM PA_FP_PLANNING_RES_TMP1 ra

791:
792: UPDATE PJI_FM_XBS_ACCUM_TMP1 tmp1
793: SET source_id =
794: (SELECT /*+ INDEX(ra,PA_FP_PLANNING_RES_TMP1_N2)*/ resource_assignment_id
795: FROM PA_FP_PLANNING_RES_TMP1 ra
796: WHERE nvl(ra.task_id,0) = nvl(tmp1.project_element_id,0)
797: AND ra.resource_list_member_id = tmp1.res_list_member_id );
798: --dbms_output.put_line('No.of rows updated in pji_fm_xbs_accum_tmp1 table: '||sql%rowcount);
799: --dbms_output.put_line('Opening distinct_ra_curr_cursor');

Line 1211: FROM PA_FP_PLANNING_RES_TMP1 tmp1

1207: DECODE(p_calling_process, 'COPY_ACTUALS',
1208: p_proj_completion_date,
1209: tmp1.planning_end_date),
1210: NVL(c_gen_etc_source_code, NULL)
1211: FROM PA_FP_PLANNING_RES_TMP1 tmp1
1212: WHERE nvl(tmp1.task_id,0) = 0
1213: AND NOT EXISTS (
1214: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1215: FROM pa_resource_assignments ra

Line 1214: SELECT /+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)/ 1

1210: NVL(c_gen_etc_source_code, NULL)
1211: FROM PA_FP_PLANNING_RES_TMP1 tmp1
1212: WHERE nvl(tmp1.task_id,0) = 0
1213: AND NOT EXISTS (
1214: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1215: FROM pa_resource_assignments ra
1216: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1217: AND NVL(ra.task_id,0) = 0
1218: AND ra.resource_list_member_id = tmp1.resource_list_member_id);

Line 1224: SELECT /+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N1)/

1220: CURSOR lowestTask_res_asg_cur
1221: ( p_proj_start_date DATE,
1222: p_proj_completion_date DATE,
1223: c_gen_etc_source_code VARCHAR2 ) IS
1224: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N1)*/
1225: distinct tmp1.task_id,
1226: tmp1.resource_list_member_id,
1227: DECODE(p_calling_process, 'COPY_ACTUALS',
1228: NVL(task.start_date, p_proj_start_date),

Line 1236: FROM PA_FP_PLANNING_RES_TMP1 tmp1,

1232: tmp1.planning_end_date),
1233: NVL(c_gen_etc_source_code,
1234: DECODE(p_calling_process, 'COPY_ACTUALS', NULL,task.GEN_ETC_SOURCE_CODE)) -- Bug 4193368 for staffing plan src should not be
1235: -- based on task's etc source
1236: FROM PA_FP_PLANNING_RES_TMP1 tmp1,
1237: pa_tasks task
1238: WHERE nvl(tmp1.task_id,0) > 0
1239: AND tmp1.task_id = task.task_id
1240: AND NOT EXISTS (

Line 1241: SELECT /+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)/ 1

1237: pa_tasks task
1238: WHERE nvl(tmp1.task_id,0) > 0
1239: AND tmp1.task_id = task.task_id
1240: AND NOT EXISTS (
1241: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1242: FROM pa_resource_assignments ra
1243: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1244: AND nvl(ra.task_id,0) = nvl(tmp1.task_id,0)
1245: AND ra.resource_list_member_id = tmp1.resource_list_member_id)

Line 1256: FROM PA_FP_PLANNING_RES_TMP1 tmp1

1252: DECODE(p_calling_process, 'COPY_ACTUALS',
1253: p_proj_completion_date,
1254: tmp1.planning_end_date),
1255: NVL(c_gen_etc_source_code, NULL)
1256: FROM PA_FP_PLANNING_RES_TMP1 tmp1
1257: WHERE nvl(tmp1.task_id,0) = 0
1258: AND NOT EXISTS (
1259: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1260: FROM pa_resource_assignments ra

Line 1259: SELECT /+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)/ 1

1255: NVL(c_gen_etc_source_code, NULL)
1256: FROM PA_FP_PLANNING_RES_TMP1 tmp1
1257: WHERE nvl(tmp1.task_id,0) = 0
1258: AND NOT EXISTS (
1259: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1260: FROM pa_resource_assignments ra
1261: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1262: AND NVL(ra.task_id,0) = 0
1263: AND ra.resource_list_member_id = tmp1.resource_list_member_id);

Line 1269: SELECT /+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N1)/

1265: CURSOR topTask_res_asg_cur
1266: ( p_proj_start_date DATE,
1267: p_proj_completion_date DATE,
1268: c_gen_etc_source_code VARCHAR2 ) IS
1269: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N1)*/
1270: task_t.task_id,
1271: tmp1.resource_list_member_id,
1272: MIN(DECODE(p_calling_process, 'COPY_ACTUALS',
1273: NVL(task_t.start_date, p_proj_start_date),

Line 1281: FROM PA_FP_PLANNING_RES_TMP1 tmp1,

1277: tmp1.planning_end_date)),
1278: NVL(c_gen_etc_source_code,
1279: DECODE(p_calling_process, 'COPY_ACTUALS', NULL,task_t.GEN_ETC_SOURCE_CODE)) -- Bug 4193368 for staffing plan src should not be
1280: -- based on task's etc source
1281: FROM PA_FP_PLANNING_RES_TMP1 tmp1,
1282: pa_tasks task, pa_tasks task_t
1283: WHERE nvl(tmp1.task_id,0) > 0
1284: AND tmp1.task_id = task.task_id
1285: AND task.top_task_id = task_t.task_id

Line 1287: SELECT /+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)/ 1

1283: WHERE nvl(tmp1.task_id,0) > 0
1284: AND tmp1.task_id = task.task_id
1285: AND task.top_task_id = task_t.task_id
1286: AND NOT EXISTS (
1287: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1288: FROM pa_resource_assignments ra
1289: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1290: AND nvl(ra.task_id,0) = task_t.task_id
1291: AND ra.resource_list_member_id = tmp1.resource_list_member_id)

Line 1307: FROM PA_FP_PLANNING_RES_TMP1 tmp1

1303: MAX(DECODE(p_calling_process, 'COPY_ACTUALS',
1304: p_proj_completion_date,
1305: tmp1.planning_end_date)),
1306: NVL(c_gen_etc_source_code, NULL)
1307: FROM PA_FP_PLANNING_RES_TMP1 tmp1
1308: WHERE nvl(tmp1.task_id,0) = 0
1309: AND NOT EXISTS (
1310: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1311: FROM pa_resource_assignments ra

Line 1310: SELECT /+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)/ 1

1306: NVL(c_gen_etc_source_code, NULL)
1307: FROM PA_FP_PLANNING_RES_TMP1 tmp1
1308: WHERE nvl(tmp1.task_id,0) = 0
1309: AND NOT EXISTS (
1310: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1311: FROM pa_resource_assignments ra
1312: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1313: AND NVL(ra.task_id,0) = 0
1314: AND ra.resource_list_member_id = tmp1.resource_list_member_id)

Line 1629: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1

1625: (l_proj_struct_sharing_code = 'SPLIT_NO_MAPPING' AND
1626: p_fp_cols_rec.x_version_type = 'REVENUE' AND
1627: p_fp_cols_rec.x_gen_etc_src_code = 'WORKPLAN_RESOURCES')) THEN
1628:
1629: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1630: SET resource_assignment_id =
1631: (SELECT resource_assignment_id
1632: FROM pa_resource_assignments ra
1633: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID

Line 1640: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1

1636: AND ra.resource_list_member_id = tmp1.resource_list_member_id);
1637:
1638: ELSIF l_res_plan_level = 'L' THEN
1639:
1640: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1641: SET resource_assignment_id =
1642: (SELECT resource_assignment_id
1643: FROM pa_resource_assignments ra
1644: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID

Line 1651: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1

1647: AND ra.resource_list_member_id = tmp1.resource_list_member_id)
1648: WHERE tmp1.task_id is NOT NULL
1649: AND tmp1.task_id > 0;
1650:
1651: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1652: SET resource_assignment_id =
1653: (SELECT resource_assignment_id
1654: FROM pa_resource_assignments ra
1655: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID

Line 1663: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1

1659: WHERE nvl(tmp1.task_id,0) = 0;
1660:
1661: ELSIF l_res_plan_level = 'T' THEN
1662:
1663: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1664: SET resource_assignment_id =
1665: (SELECT resource_assignment_id
1666: FROM pa_resource_assignments ra,
1667: pa_tasks t

Line 1676: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1

1672: AND ra.resource_list_member_id = tmp1.resource_list_member_id)
1673: WHERE tmp1.task_id is NOT NULL
1674: AND tmp1.task_id > 0;
1675:
1676: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1677: SET resource_assignment_id =
1678: (SELECT resource_assignment_id
1679: FROM pa_resource_assignments ra
1680: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID