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_GEN_FCST_RMAP_PKG dependencies on PA_FP_CALC_AMT_TMP1

Line 52: FROM PA_FP_CALC_AMT_TMP1 tmp1

48: NULL, --TXN_WBS_ELEMENT_VER_ID
49: NULL, --tmp1.TXN_RBS_ELEMENT_ID,
50: tmp1.planning_start_date, --TXN_PLAN_START_DATE,
51: tmp1.planning_end_date --TXN_PLAN_END_DATE
52: FROM PA_FP_CALC_AMT_TMP1 tmp1
53: WHERE RESOURCE_ASSIGNMENT_ID > 0
54: AND TRANSACTION_SOURCE_CODE <> 'OPEN_COMMITMENTS'
55: AND TARGET_RLM_ID IS NULL;
56:

Line 164: UPDATE PA_FP_CALC_AMT_TMP1

160: l_rlm_id := PA_FP_GEN_AMOUNT_UTILS.GET_RLM_ID
161: ( p_project_id => p_project_id,
162: p_resource_list_id => p_fp_cols_rec.X_RESOURCE_LIST_ID,
163: p_resource_class_code => 'FINANCIAL_ELEMENTS' );
164: UPDATE PA_FP_CALC_AMT_TMP1
165: SET target_rlm_id = l_rlm_id;
166: ELSIF l_uncategorized_flag = 'N' THEN
167:
168: -- Beginning of code change for Bug 4070976 --

Line 205: UPDATE PA_FP_CALC_AMT_TMP1

201: FROM pa_budget_versions
202: WHERE budget_version_id = l_fp_cols_rec.x_gen_src_wp_version_id;
203:
204: IF l_fp_cols_rec.x_resource_list_id = l_resource_list_id THEN
205: UPDATE PA_FP_CALC_AMT_TMP1
206: SET target_rlm_id = resource_list_member_id
207: WHERE transaction_source_code = 'WORKPLAN_RESOURCES';
208: END IF;
209: END IF;

Line 220: UPDATE PA_FP_CALC_AMT_TMP1

216: FROM pa_budget_versions
217: WHERE budget_version_id = l_fp_cols_rec.x_gen_src_plan_version_id;
218:
219: IF l_fp_cols_rec.x_resource_list_id = l_resource_list_id THEN
220: UPDATE PA_FP_CALC_AMT_TMP1
221: SET target_rlm_id = resource_list_member_id
222: WHERE transaction_source_code = 'FINANCIAL_PLAN';
223: END IF;
224: END IF;

Line 281: -- select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;

277: END IF;
278:
279: /* bug 3576766 : p_project_id parameter added for
280: non centrally controlled resource list mapping. */
281: -- select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;
282: -- hr_utility.trace('=!!!=PA_FP_CALC_AMT_TMP1.count bef calling res map api'||l_count_tmp);
283: PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS (
284: P_PROJECT_ID => p_project_id,
285: P_BUDGET_VERSION_ID => NULL,

Line 282: -- hr_utility.trace('=!!!=PA_FP_CALC_AMT_TMP1.count bef calling res map api'||l_count_tmp);

278:
279: /* bug 3576766 : p_project_id parameter added for
280: non centrally controlled resource list mapping. */
281: -- select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;
282: -- hr_utility.trace('=!!!=PA_FP_CALC_AMT_TMP1.count bef calling res map api'||l_count_tmp);
283: PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS (
284: P_PROJECT_ID => p_project_id,
285: P_BUDGET_VERSION_ID => NULL,
286: P_RESOURCE_LIST_ID => P_FP_COLS_REC.X_RESOURCE_LIST_ID,

Line 348: --select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;

344: but, if planning at task level, project_structure_version_id is already
345: in pa_budget_versions, if planning at project level,project_structure
346: version_id not needed in pa_budget_versions. So update deleted **/
347:
348: --select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;
349:
350: /*IF p_pa_debug_mode = 'Y' THEN
351: pa_fp_gen_amount_utils.fp_debug
352: (p_msg => 'Count of PA_FP_CALC_AMT_TMP1: '||l_count_tmp,

Line 352: (p_msg => 'Count of PA_FP_CALC_AMT_TMP1: '||l_count_tmp,

348: --select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;
349:
350: /*IF p_pa_debug_mode = 'Y' THEN
351: pa_fp_gen_amount_utils.fp_debug
352: (p_msg => 'Count of PA_FP_CALC_AMT_TMP1: '||l_count_tmp,
353: p_module_name => l_module_name,
354: p_log_level => 5);
355: END IF;*/
356:

Line 358: --select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1

354: p_log_level => 5);
355: END IF;*/
356:
357: --dbms_output.put_line('@@tmp1 has:'||l_count_tmp);
358: --select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1
359: --where task_id = 0;
360: --dbms_output.put_line('@@tmp1 with 0 task_id has:'||l_count_tmp);
361:
362: /* hr_utility.trace('==PA_FP_CALC_AMT_TMP1.count aft res map call'||l_count_tmp);

Line 362: /* hr_utility.trace('==PA_FP_CALC_AMT_TMP1.count aft res map call'||l_count_tmp);

358: --select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1
359: --where task_id = 0;
360: --dbms_output.put_line('@@tmp1 with 0 task_id has:'||l_count_tmp);
361:
362: /* hr_utility.trace('==PA_FP_CALC_AMT_TMP1.count aft res map call'||l_count_tmp);
363: hr_utility.trace('map rlm id tab count '||l_map_rlm_id_tab.count);
364: hr_utility.trace('map src id tab count '||l_map_txn_source_id_tab.count); */
365: /*IF p_pa_debug_mode = 'Y' THEN
366: pa_fp_gen_amount_utils.fp_debug

Line 373: UPDATE /+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N2)/

369: p_log_level => 5);
370: END IF;*/
371:
372: FORALL i IN 1..l_map_rlm_id_tab.count
373: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N2)*/
374: PA_FP_CALC_AMT_TMP1
375: SET target_rlm_id = l_map_rlm_id_tab(i)
376: WHERE resource_assignment_id = l_map_txn_source_id_tab(i);
377:

Line 374: PA_FP_CALC_AMT_TMP1

370: END IF;*/
371:
372: FORALL i IN 1..l_map_rlm_id_tab.count
373: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N2)*/
374: PA_FP_CALC_AMT_TMP1
375: SET target_rlm_id = l_map_rlm_id_tab(i)
376: WHERE resource_assignment_id = l_map_txn_source_id_tab(i);
377:
378: -- hr_utility.trace('no of rows updated in tmp1 aft res map:'||sql%rowcount);

Line 380: -- insert into calc_amt_tmp1 select * from pa_fp_calc_amt_tmp1;

376: WHERE resource_assignment_id = l_map_txn_source_id_tab(i);
377:
378: -- hr_utility.trace('no of rows updated in tmp1 aft res map:'||sql%rowcount);
379: -- delete from calc_amt_tmp1;
380: -- insert into calc_amt_tmp1 select * from pa_fp_calc_amt_tmp1;
381: END IF;
382: /* end if for table count greater than zero */
383: END IF;
384: /* uncategorized flag check */

Line 540: UPDATE /+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N3)/

536: --hr_utility.trace('==l_upd_task_id_tab.count'||l_upd_task_id_tab.count);
537:
538: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'L' THEN
539: FORALL i IN 1..l_upd_target_ra_id_tab.count
540: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N3)*/
541: PA_FP_CALC_AMT_TMP1
542: SET target_res_asg_id = l_upd_target_ra_id_tab(i)
543: WHERE mapped_fin_task_id = l_upd_task_id_tab(i)
544: AND target_rlm_id = l_upd_rlm_id_tab(i);

Line 541: PA_FP_CALC_AMT_TMP1

537:
538: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'L' THEN
539: FORALL i IN 1..l_upd_target_ra_id_tab.count
540: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N3)*/
541: PA_FP_CALC_AMT_TMP1
542: SET target_res_asg_id = l_upd_target_ra_id_tab(i)
543: WHERE mapped_fin_task_id = l_upd_task_id_tab(i)
544: AND target_rlm_id = l_upd_rlm_id_tab(i);
545: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'T' THEN

Line 547: UPDATE /+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N3)/

543: WHERE mapped_fin_task_id = l_upd_task_id_tab(i)
544: AND target_rlm_id = l_upd_rlm_id_tab(i);
545: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'T' THEN
546: FORALL i IN 1..l_upd_target_ra_id_tab.count
547: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N3)*/
548: PA_FP_CALC_AMT_TMP1
549: SET target_res_asg_id = l_upd_target_ra_id_tab(i)
550: WHERE mapped_fin_task_id = l_upd_task_id_tab(i)
551: AND target_rlm_id = l_upd_rlm_id_tab(i);

Line 548: PA_FP_CALC_AMT_TMP1

544: AND target_rlm_id = l_upd_rlm_id_tab(i);
545: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'T' THEN
546: FORALL i IN 1..l_upd_target_ra_id_tab.count
547: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N3)*/
548: PA_FP_CALC_AMT_TMP1
549: SET target_res_asg_id = l_upd_target_ra_id_tab(i)
550: WHERE mapped_fin_task_id = l_upd_task_id_tab(i)
551: AND target_rlm_id = l_upd_rlm_id_tab(i);
552: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'P' THEN

Line 557: UPDATE /+ LEADING(PA_FP_CALC_AMT_TMP1) /

553: FORALL i IN 1..l_upd_target_ra_id_tab.count
554: -- SQL Repository Bug 4884824; SQL ID 14901771
555: -- Fixed Full Index Scan violation by replacing
556: -- existing hint with leading hint.
557: UPDATE /*+ LEADING(PA_FP_CALC_AMT_TMP1) */
558: PA_FP_CALC_AMT_TMP1
559: SET target_res_asg_id = l_upd_target_ra_id_tab(i)
560: WHERE target_rlm_id = l_upd_rlm_id_tab(i);
561: END IF;

Line 558: PA_FP_CALC_AMT_TMP1

554: -- SQL Repository Bug 4884824; SQL ID 14901771
555: -- Fixed Full Index Scan violation by replacing
556: -- existing hint with leading hint.
557: UPDATE /*+ LEADING(PA_FP_CALC_AMT_TMP1) */
558: PA_FP_CALC_AMT_TMP1
559: SET target_res_asg_id = l_upd_target_ra_id_tab(i)
560: WHERE target_rlm_id = l_upd_rlm_id_tab(i);
561: END IF;
562:

Line 575: FROM PA_FP_CALC_AMT_TMP1;

571: SELECT DISTINCT target_res_asg_id, transaction_source_code
572: BULK COLLECT
573: INTO l_tgt_res_asg_id_tab,
574: l_txn_src_code_tab
575: FROM PA_FP_CALC_AMT_TMP1;
576: ELSIF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'Y' THEN
577: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
578: SELECT /*+ INDEX(tmp1,PA_FP_CALC_AMT_TMP1_N1)*/
579: DISTINCT tmp1.target_res_asg_id, tmp1.transaction_source_code

Line 578: SELECT /+ INDEX(tmp1,PA_FP_CALC_AMT_TMP1_N1)/

574: l_txn_src_code_tab
575: FROM PA_FP_CALC_AMT_TMP1;
576: ELSIF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'Y' THEN
577: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
578: SELECT /*+ INDEX(tmp1,PA_FP_CALC_AMT_TMP1_N1)*/
579: DISTINCT tmp1.target_res_asg_id, tmp1.transaction_source_code
580: BULK COLLECT
581: INTO l_tgt_res_asg_id_tab,
582: l_txn_src_code_tab

Line 583: FROM PA_FP_CALC_AMT_TMP1 tmp1,

579: DISTINCT tmp1.target_res_asg_id, tmp1.transaction_source_code
580: BULK COLLECT
581: INTO l_tgt_res_asg_id_tab,
582: l_txn_src_code_tab
583: FROM PA_FP_CALC_AMT_TMP1 tmp1,
584: pa_resource_assignments ra
585: WHERE ra.budget_version_id = p_budget_version_id
586: AND ra.resource_assignment_id = tmp1.target_res_asg_id
587: AND ( ra.transaction_source_code IS NOT NULL

Line 596: SELECT /+ INDEX(tmp1,PA_FP_CALC_AMT_TMP1_N1)/

592: ra.resource_assignment_id
593: AND bl.start_date >= l_etc_start_date
594: AND rownum = 1 )));
595: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
596: SELECT /*+ INDEX(tmp1,PA_FP_CALC_AMT_TMP1_N1)*/
597: DISTINCT tmp1.target_res_asg_id, tmp1.transaction_source_code
598: BULK COLLECT
599: INTO l_tgt_res_asg_id_tab,
600: l_txn_src_code_tab

Line 601: FROM PA_FP_CALC_AMT_TMP1 tmp1,

597: DISTINCT tmp1.target_res_asg_id, tmp1.transaction_source_code
598: BULK COLLECT
599: INTO l_tgt_res_asg_id_tab,
600: l_txn_src_code_tab
601: FROM PA_FP_CALC_AMT_TMP1 tmp1,
602: pa_resource_assignments ra
603: WHERE ra.budget_version_id = p_budget_version_id
604: AND ra.resource_assignment_id = tmp1.target_res_asg_id
605: AND ( ra.transaction_source_code IS NOT NULL

Line 634: FROM PA_FP_CALC_AMT_TMP1;

630: SELECT resource_assignment_id, target_res_asg_id
631: BULK COLLECT
632: INTO l_upd_ra_id_tab1,
633: l_upd_target_ra_id_tab1
634: FROM PA_FP_CALC_AMT_TMP1;
635:
636: --hr_utility.trace('??l_upd_ra_id_tab1.count:'||l_upd_ra_id_tab1.count);
637: --for i in 1.. l_upd_ra_id_tab1.count LOOP
638: --hr_utility.trace('??l_upd_ra_id_tab1(i):'||l_upd_ra_id_tab1(i));