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 755: into the tmp table PA_FP_PLANNING_RES_TMP1. Because, the task id value is referred

751:
752: /* updating the project element id ( task id ) to NULL
753: when the value is <= 0 for addressing the P1 bug 3841480.
754: Please note that we cannot resolve the issue by populating the NULL value
755: into the tmp table PA_FP_PLANNING_RES_TMP1. Because, the task id value is referred
756: in the pji_fm_xbs_accum_tmp1 table later in the code. */
757:
758: update pji_fm_xbs_accum_tmp1 set project_element_id = null
759: where NVL(project_element_id,0) <= 0;

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

757:
758: update pji_fm_xbs_accum_tmp1 set project_element_id = null
759: where NVL(project_element_id,0) <= 0;
760:
761: /**Populating PA_FP_PLANNING_RES_TMP1, call COPY_ACUTALS_PUB.CREATE_RES_ASG to create
762: *missing resource assignment in pa_resource_assignment table. After that, resource_
763: *assignment_id will be populated pa_fp_planning_res_tmp1.
764: **/
765: DELETE FROM PA_FP_PLANNING_RES_TMP1;

Line 763: *assignment_id will be populated pa_fp_planning_res_tmp1.

759: where NVL(project_element_id,0) <= 0;
760:
761: /**Populating PA_FP_PLANNING_RES_TMP1, call COPY_ACUTALS_PUB.CREATE_RES_ASG to create
762: *missing resource assignment in pa_resource_assignment table. After that, resource_
763: *assignment_id will be populated pa_fp_planning_res_tmp1.
764: **/
765: DELETE FROM PA_FP_PLANNING_RES_TMP1;
766: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
767: TASK_ID,

Line 765: DELETE FROM PA_FP_PLANNING_RES_TMP1;

761: /**Populating PA_FP_PLANNING_RES_TMP1, call COPY_ACUTALS_PUB.CREATE_RES_ASG to create
762: *missing resource assignment in pa_resource_assignment table. After that, resource_
763: *assignment_id will be populated pa_fp_planning_res_tmp1.
764: **/
765: DELETE FROM PA_FP_PLANNING_RES_TMP1;
766: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
767: TASK_ID,
768: RESOURCE_LIST_MEMBER_ID,
769: RESOURCE_ASSIGNMENT_ID,

Line 766: INSERT INTO PA_FP_PLANNING_RES_TMP1 (

762: *missing resource assignment in pa_resource_assignment table. After that, resource_
763: *assignment_id will be populated pa_fp_planning_res_tmp1.
764: **/
765: DELETE FROM PA_FP_PLANNING_RES_TMP1;
766: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
767: TASK_ID,
768: RESOURCE_LIST_MEMBER_ID,
769: RESOURCE_ASSIGNMENT_ID,
770: CBS_ELEMENT_ID --bug#16791711

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

801: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
802: END IF;
803:
804: /**Calling update_res_asg to populate the newly created resource_assignment_id back to
805: *pa_fp_planning_res_tmp1. Then this value needs to populated back to pji_fm_xbs_accum_tmp1
806: **/
807: IF P_PA_DEBUG_MODE = 'Y' THEN
808: pa_fp_gen_amount_utils.fp_debug
809: (p_msg => 'Before calling update_res_asg',

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

829: END IF;
830:
831: UPDATE PJI_FM_XBS_ACCUM_TMP1 tmp1
832: SET source_id =
833: (SELECT /*+ INDEX(ra,PA_FP_PLANNING_RES_TMP1_N2)*/ resource_assignment_id
834: FROM PA_FP_PLANNING_RES_TMP1 ra
835: WHERE nvl(ra.task_id,0) = nvl(tmp1.project_element_id,0)
836: AND ra.resource_list_member_id = tmp1.res_list_member_id
837: AND nvl(ra.CBS_ELEMENT_ID,-1) = nvl(tmp1.CBS_ELEMENT_ID,-1) --bug#16791711

Line 834: FROM PA_FP_PLANNING_RES_TMP1 ra

830:
831: UPDATE PJI_FM_XBS_ACCUM_TMP1 tmp1
832: SET source_id =
833: (SELECT /*+ INDEX(ra,PA_FP_PLANNING_RES_TMP1_N2)*/ resource_assignment_id
834: FROM PA_FP_PLANNING_RES_TMP1 ra
835: WHERE nvl(ra.task_id,0) = nvl(tmp1.project_element_id,0)
836: AND ra.resource_list_member_id = tmp1.res_list_member_id
837: AND nvl(ra.CBS_ELEMENT_ID,-1) = nvl(tmp1.CBS_ELEMENT_ID,-1) --bug#16791711
838: );

Line 1253: FROM PA_FP_PLANNING_RES_TMP1 tmp1

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

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

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

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

1264: CURSOR lowestTask_res_asg_cur
1265: ( p_proj_start_date DATE,
1266: p_proj_completion_date DATE,
1267: c_gen_etc_source_code VARCHAR2 ) IS
1268: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N1)*/
1269: distinct tmp1.task_id,
1270: tmp1.resource_list_member_id,
1271: tmp1.CBS_ELEMENT_ID, --bug#16791711
1272: DECODE(p_calling_process, 'COPY_ACTUALS',

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.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
1283: WHERE nvl(tmp1.task_id,0) > 0
1284: AND tmp1.task_id = task.task_id
1285: AND NOT EXISTS (

Line 1304: FROM PA_FP_PLANNING_RES_TMP1 tmp1

1300: DECODE(p_calling_process, 'COPY_ACTUALS',
1301: p_proj_completion_date,
1302: tmp1.planning_end_date),
1303: NVL(c_gen_etc_source_code, NULL)
1304: FROM PA_FP_PLANNING_RES_TMP1 tmp1
1305: WHERE nvl(tmp1.task_id,0) = 0
1306: AND NOT EXISTS (
1307: SELECT /*+ INDEX(tmp1,PA_RESOURCE_ASSIGNMENTS_U2)*/ 1 -- Changed For Bug10331270
1308: FROM pa_resource_assignments ra

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

1315: CURSOR topTask_res_asg_cur
1316: ( p_proj_start_date DATE,
1317: p_proj_completion_date DATE,
1318: c_gen_etc_source_code VARCHAR2 ) IS
1319: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N1)*/
1320: task_t.task_id,
1321: tmp1.resource_list_member_id,
1322: tmp1.CBS_ELEMENT_ID, --bug#16791711
1323: MIN(DECODE(p_calling_process, 'COPY_ACTUALS',

Line 1332: FROM PA_FP_PLANNING_RES_TMP1 tmp1,

1328: tmp1.planning_end_date)),
1329: NVL(c_gen_etc_source_code,
1330: DECODE(p_calling_process, 'COPY_ACTUALS', NULL,task_t.GEN_ETC_SOURCE_CODE)) -- Bug 4193368 for staffing plan src should not be
1331: -- based on task's etc source
1332: FROM PA_FP_PLANNING_RES_TMP1 tmp1,
1333: pa_tasks task, pa_tasks task_t
1334: WHERE nvl(tmp1.task_id,0) > 0
1335: AND tmp1.task_id = task.task_id
1336: AND task.top_task_id = task_t.task_id

Line 1362: FROM PA_FP_PLANNING_RES_TMP1 tmp1

1358: MAX(DECODE(p_calling_process, 'COPY_ACTUALS',
1359: p_proj_completion_date,
1360: tmp1.planning_end_date)),
1361: NVL(c_gen_etc_source_code, NULL)
1362: FROM PA_FP_PLANNING_RES_TMP1 tmp1
1363: WHERE nvl(tmp1.task_id,0) = 0
1364: AND NOT EXISTS (
1365: SELECT /*+ INDEX(tmp1,PA_RESOURCE_ASSIGNMENTS_U2)*/ 1 -- Changed For Bug10331270
1366: FROM pa_resource_assignments ra

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

1378: CURSOR lowestTask_res_asg_cur_cbs
1379: ( p_proj_start_date DATE,
1380: p_proj_completion_date DATE,
1381: c_gen_etc_source_code VARCHAR2 ) IS
1382: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N1)*/
1383: distinct tmp1.task_id,
1384: tmp1.resource_list_member_id,
1385: tmp1.CBS_ELEMENT_ID,
1386: DECODE(p_calling_process, 'COPY_ACTUALS',

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

1415: CURSOR topTask_res_asg_cur_cbs
1416: ( p_proj_start_date DATE,
1417: p_proj_completion_date DATE,
1418: c_gen_etc_source_code VARCHAR2 ) IS
1419: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N1)*/
1420: task_t.task_id,
1421: tmp1.resource_list_member_id,
1422: tmp1.CBS_ELEMENT_ID,
1423: MIN(DECODE(p_calling_process, 'COPY_ACTUALS',

Line 1864: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1

1860: (l_proj_struct_sharing_code = 'SPLIT_NO_MAPPING' AND
1861: p_fp_cols_rec.x_version_type = 'REVENUE' AND
1862: p_fp_cols_rec.x_gen_etc_src_code = 'WORKPLAN_RESOURCES')) THEN
1863:
1864: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1865: SET resource_assignment_id =
1866: (SELECT resource_assignment_id
1867: FROM pa_resource_assignments ra
1868: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID

Line 1877: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1

1873: );
1874:
1875: ELSIF l_res_plan_level = 'L' THEN
1876:
1877: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1878: SET resource_assignment_id =
1879: (SELECT resource_assignment_id
1880: FROM pa_resource_assignments ra
1881: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID

Line 1890: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1

1886: )
1887: WHERE tmp1.task_id is NOT NULL
1888: AND tmp1.task_id > 0;
1889:
1890: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1891: SET resource_assignment_id =
1892: (SELECT resource_assignment_id
1893: FROM pa_resource_assignments ra
1894: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID

Line 1904: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1

1900: WHERE nvl(tmp1.task_id,0) = 0;
1901:
1902: ELSIF l_res_plan_level = 'T' THEN
1903:
1904: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1905: SET resource_assignment_id =
1906: (SELECT resource_assignment_id
1907: FROM pa_resource_assignments ra,
1908: pa_tasks t

Line 1919: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1

1915: )
1916: WHERE tmp1.task_id is NOT NULL
1917: AND tmp1.task_id > 0;
1918:
1919: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1920: SET resource_assignment_id =
1921: (SELECT resource_assignment_id
1922: FROM pa_resource_assignments ra
1923: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID