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 166: UPDATE PA_FP_CALC_AMT_TMP1

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

Line 207: UPDATE PA_FP_CALC_AMT_TMP1

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

Line 222: UPDATE PA_FP_CALC_AMT_TMP1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 376: PA_FP_CALC_AMT_TMP1

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

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

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

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

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

Line 546: PA_FP_CALC_AMT_TMP1

542:
543: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'L' THEN
544: FORALL i IN 1..l_upd_target_ra_id_tab.count
545: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N3)*/
546: PA_FP_CALC_AMT_TMP1
547: SET target_res_asg_id = l_upd_target_ra_id_tab(i)
548: WHERE mapped_fin_task_id = l_upd_task_id_tab(i)
549: AND target_rlm_id = l_upd_rlm_id_tab(i)
550: AND nvl(cbs_element_id,-1) = nvl(l_upd_cbs_id_tab(i),-1)--bug#16791711

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

550: AND nvl(cbs_element_id,-1) = nvl(l_upd_cbs_id_tab(i),-1)--bug#16791711
551: ;
552: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'T' THEN
553: FORALL i IN 1..l_upd_target_ra_id_tab.count
554: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N3)*/
555: PA_FP_CALC_AMT_TMP1
556: SET target_res_asg_id = l_upd_target_ra_id_tab(i)
557: WHERE mapped_fin_task_id = l_upd_task_id_tab(i)
558: AND target_rlm_id = l_upd_rlm_id_tab(i)

Line 555: PA_FP_CALC_AMT_TMP1

551: ;
552: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'T' THEN
553: FORALL i IN 1..l_upd_target_ra_id_tab.count
554: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP1,PA_FP_CALC_AMT_TMP1_N3)*/
555: PA_FP_CALC_AMT_TMP1
556: SET target_res_asg_id = l_upd_target_ra_id_tab(i)
557: WHERE mapped_fin_task_id = l_upd_task_id_tab(i)
558: AND target_rlm_id = l_upd_rlm_id_tab(i)
559: AND nvl(cbs_element_id,-1) = nvl(l_upd_cbs_id_tab(i),-1)--bug#16791711

Line 566: UPDATE /+ LEADING(PA_FP_CALC_AMT_TMP1) /

562: FORALL i IN 1..l_upd_target_ra_id_tab.count
563: -- SQL Repository Bug 4884824; SQL ID 14901771
564: -- Fixed Full Index Scan violation by replacing
565: -- existing hint with leading hint.
566: UPDATE /*+ LEADING(PA_FP_CALC_AMT_TMP1) */
567: PA_FP_CALC_AMT_TMP1
568: SET target_res_asg_id = l_upd_target_ra_id_tab(i)
569: WHERE target_rlm_id = l_upd_rlm_id_tab(i)
570: AND nvl(cbs_element_id,-1) = nvl(l_upd_cbs_id_tab(i),-1)--bug#16791711

Line 567: PA_FP_CALC_AMT_TMP1

563: -- SQL Repository Bug 4884824; SQL ID 14901771
564: -- Fixed Full Index Scan violation by replacing
565: -- existing hint with leading hint.
566: UPDATE /*+ LEADING(PA_FP_CALC_AMT_TMP1) */
567: PA_FP_CALC_AMT_TMP1
568: SET target_res_asg_id = l_upd_target_ra_id_tab(i)
569: WHERE target_rlm_id = l_upd_rlm_id_tab(i)
570: AND nvl(cbs_element_id,-1) = nvl(l_upd_cbs_id_tab(i),-1)--bug#16791711
571: ;

Line 586: FROM PA_FP_CALC_AMT_TMP1;

582: SELECT DISTINCT target_res_asg_id, transaction_source_code
583: BULK COLLECT
584: INTO l_tgt_res_asg_id_tab,
585: l_txn_src_code_tab
586: FROM PA_FP_CALC_AMT_TMP1;
587: ELSIF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'Y' THEN
588: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
589: SELECT /*+ INDEX(tmp1,PA_FP_CALC_AMT_TMP1_N1)*/
590: DISTINCT tmp1.target_res_asg_id, tmp1.transaction_source_code

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

585: l_txn_src_code_tab
586: FROM PA_FP_CALC_AMT_TMP1;
587: ELSIF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'Y' THEN
588: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
589: SELECT /*+ INDEX(tmp1,PA_FP_CALC_AMT_TMP1_N1)*/
590: DISTINCT tmp1.target_res_asg_id, tmp1.transaction_source_code
591: BULK COLLECT
592: INTO l_tgt_res_asg_id_tab,
593: l_txn_src_code_tab

Line 594: FROM PA_FP_CALC_AMT_TMP1 tmp1,

590: DISTINCT tmp1.target_res_asg_id, tmp1.transaction_source_code
591: BULK COLLECT
592: INTO l_tgt_res_asg_id_tab,
593: l_txn_src_code_tab
594: FROM PA_FP_CALC_AMT_TMP1 tmp1,
595: pa_resource_assignments ra
596: WHERE ra.budget_version_id = p_budget_version_id
597: AND ra.resource_assignment_id = tmp1.target_res_asg_id
598: AND ( ra.transaction_source_code IS NOT NULL

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

603: ra.resource_assignment_id
604: AND bl.start_date >= l_etc_start_date
605: AND rownum = 1 )));
606: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
607: SELECT /*+ INDEX(tmp1,PA_FP_CALC_AMT_TMP1_N1)*/
608: DISTINCT tmp1.target_res_asg_id, tmp1.transaction_source_code
609: BULK COLLECT
610: INTO l_tgt_res_asg_id_tab,
611: l_txn_src_code_tab

Line 612: FROM PA_FP_CALC_AMT_TMP1 tmp1,

608: DISTINCT tmp1.target_res_asg_id, tmp1.transaction_source_code
609: BULK COLLECT
610: INTO l_tgt_res_asg_id_tab,
611: l_txn_src_code_tab
612: FROM PA_FP_CALC_AMT_TMP1 tmp1,
613: pa_resource_assignments ra
614: WHERE ra.budget_version_id = p_budget_version_id
615: AND ra.resource_assignment_id = tmp1.target_res_asg_id
616: AND ( ra.transaction_source_code IS NOT NULL

Line 645: FROM PA_FP_CALC_AMT_TMP1;

641: SELECT resource_assignment_id, target_res_asg_id
642: BULK COLLECT
643: INTO l_upd_ra_id_tab1,
644: l_upd_target_ra_id_tab1
645: FROM PA_FP_CALC_AMT_TMP1;
646:
647: --hr_utility.trace('??l_upd_ra_id_tab1.count:'||l_upd_ra_id_tab1.count);
648: --for i in 1.. l_upd_ra_id_tab1.count LOOP
649: --hr_utility.trace('??l_upd_ra_id_tab1(i):'||l_upd_ra_id_tab1(i));