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_ORG_FCST_GEN_PUB dependencies on PA_FP_RA_MAP_TMP

Line 4208: pa_fp_ra_map_tmp.source_res_assignment_id%TYPE

4204: l_err_stage VARCHAR2(2000);
4205: l_err_stack VARCHAR2(2000);
4206:
4207: TYPE ra_map_tmp_tbl1_type IS TABLE OF
4208: pa_fp_ra_map_tmp.source_res_assignment_id%TYPE
4209: INDEX BY BINARY_INTEGER;
4210:
4211: TYPE ra_map_tmp_tbl2_type IS TABLE OF
4212: pa_fp_ra_map_tmp.target_res_assignment_id%TYPE

Line 4212: pa_fp_ra_map_tmp.target_res_assignment_id%TYPE

4208: pa_fp_ra_map_tmp.source_res_assignment_id%TYPE
4209: INDEX BY BINARY_INTEGER;
4210:
4211: TYPE ra_map_tmp_tbl2_type IS TABLE OF
4212: pa_fp_ra_map_tmp.target_res_assignment_id%TYPE
4213: INDEX BY BINARY_INTEGER;
4214:
4215: TYPE ra_map_tmp_tbl3_type IS TABLE OF
4216: pa_fp_ra_map_tmp.resource_assignment_id%TYPE

Line 4216: pa_fp_ra_map_tmp.resource_assignment_id%TYPE

4212: pa_fp_ra_map_tmp.target_res_assignment_id%TYPE
4213: INDEX BY BINARY_INTEGER;
4214:
4215: TYPE ra_map_tmp_tbl3_type IS TABLE OF
4216: pa_fp_ra_map_tmp.resource_assignment_id%TYPE
4217: INDEX BY BINARY_INTEGER;
4218:
4219: TYPE ra_map_tmp_tbl4_type IS TABLE OF
4220: pa_fp_ra_map_tmp.source_task_id%TYPE

Line 4220: pa_fp_ra_map_tmp.source_task_id%TYPE

4216: pa_fp_ra_map_tmp.resource_assignment_id%TYPE
4217: INDEX BY BINARY_INTEGER;
4218:
4219: TYPE ra_map_tmp_tbl4_type IS TABLE OF
4220: pa_fp_ra_map_tmp.source_task_id%TYPE
4221: INDEX BY BINARY_INTEGER;
4222:
4223: TYPE ra_map_tmp_tbl5_type IS TABLE OF
4224: pa_fp_ra_map_tmp.target_task_id%TYPE

Line 4224: pa_fp_ra_map_tmp.target_task_id%TYPE

4220: pa_fp_ra_map_tmp.source_task_id%TYPE
4221: INDEX BY BINARY_INTEGER;
4222:
4223: TYPE ra_map_tmp_tbl5_type IS TABLE OF
4224: pa_fp_ra_map_tmp.target_task_id%TYPE
4225: INDEX BY BINARY_INTEGER;
4226:
4227: --Added the following table types for bug 3354518
4228:

Line 4230: pa_fp_ra_map_tmp.system_reference1%TYPE

4226:
4227: --Added the following table types for bug 3354518
4228:
4229: TYPE ra_map_tmp_tbl6_type IS TABLE OF
4230: pa_fp_ra_map_tmp.system_reference1%TYPE
4231: INDEX BY BINARY_INTEGER;
4232:
4233: TYPE ra_map_tmp_tbl7_type IS TABLE OF
4234: pa_fp_ra_map_tmp.system_reference2%TYPE

Line 4234: pa_fp_ra_map_tmp.system_reference2%TYPE

4230: pa_fp_ra_map_tmp.system_reference1%TYPE
4231: INDEX BY BINARY_INTEGER;
4232:
4233: TYPE ra_map_tmp_tbl7_type IS TABLE OF
4234: pa_fp_ra_map_tmp.system_reference2%TYPE
4235: INDEX BY BINARY_INTEGER;
4236:
4237: TYPE ra_map_tmp_tbl8_type IS TABLE OF
4238: pa_fp_ra_map_tmp.system_reference3%TYPE

Line 4238: pa_fp_ra_map_tmp.system_reference3%TYPE

4234: pa_fp_ra_map_tmp.system_reference2%TYPE
4235: INDEX BY BINARY_INTEGER;
4236:
4237: TYPE ra_map_tmp_tbl8_type IS TABLE OF
4238: pa_fp_ra_map_tmp.system_reference3%TYPE
4239: INDEX BY BINARY_INTEGER;
4240:
4241: TYPE ra_map_tmp_tbl9_type IS TABLE OF
4242: pa_fp_ra_map_tmp.planning_start_date%TYPE

Line 4242: pa_fp_ra_map_tmp.planning_start_date%TYPE

4238: pa_fp_ra_map_tmp.system_reference3%TYPE
4239: INDEX BY BINARY_INTEGER;
4240:
4241: TYPE ra_map_tmp_tbl9_type IS TABLE OF
4242: pa_fp_ra_map_tmp.planning_start_date%TYPE
4243: INDEX BY BINARY_INTEGER;
4244:
4245: TYPE ra_map_tmp_tbl10_type IS TABLE OF
4246: pa_fp_ra_map_tmp.planning_end_date%TYPE

Line 4246: pa_fp_ra_map_tmp.planning_end_date%TYPE

4242: pa_fp_ra_map_tmp.planning_start_date%TYPE
4243: INDEX BY BINARY_INTEGER;
4244:
4245: TYPE ra_map_tmp_tbl10_type IS TABLE OF
4246: pa_fp_ra_map_tmp.planning_end_date%TYPE
4247: INDEX BY BINARY_INTEGER;
4248:
4249: TYPE ra_map_tmp_tbl11_type IS TABLE OF
4250: pa_fp_ra_map_tmp.schedule_start_date%TYPE

Line 4250: pa_fp_ra_map_tmp.schedule_start_date%TYPE

4246: pa_fp_ra_map_tmp.planning_end_date%TYPE
4247: INDEX BY BINARY_INTEGER;
4248:
4249: TYPE ra_map_tmp_tbl11_type IS TABLE OF
4250: pa_fp_ra_map_tmp.schedule_start_date%TYPE
4251: INDEX BY BINARY_INTEGER;
4252:
4253: TYPE ra_map_tmp_tbl12_type IS TABLE OF
4254: pa_fp_ra_map_tmp.schedule_end_date%TYPE

Line 4254: pa_fp_ra_map_tmp.schedule_end_date%TYPE

4250: pa_fp_ra_map_tmp.schedule_start_date%TYPE
4251: INDEX BY BINARY_INTEGER;
4252:
4253: TYPE ra_map_tmp_tbl12_type IS TABLE OF
4254: pa_fp_ra_map_tmp.schedule_end_date%TYPE
4255: INDEX BY BINARY_INTEGER;
4256:
4257: -- Declared for bug 3615617
4258: TYPE ra_map_tmp_tbl13_type IS TABLE OF

Line 4259: pa_fp_ra_map_tmp.system_reference4%TYPE

4255: INDEX BY BINARY_INTEGER;
4256:
4257: -- Declared for bug 3615617
4258: TYPE ra_map_tmp_tbl13_type IS TABLE OF
4259: pa_fp_ra_map_tmp.system_reference4%TYPE
4260: INDEX BY BINARY_INTEGER;
4261:
4262: l_ra_map_tmp_tbl1 ra_map_tmp_tbl1_type;
4263: l_ra_map_tmp_tbl2 ra_map_tmp_tbl2_type;

Line 4491: -- Remove the old records, if any,from pa_fp_ra_map_tmp

4487: pa_debug.write('create_res_task_maps: ' || g_module_name,pa_debug.g_err_stage,3);
4488: END IF;
4489:
4490:
4491: -- Remove the old records, if any,from pa_fp_ra_map_tmp
4492:
4493: DELETE FROM pa_fp_ra_map_tmp;
4494:
4495: --Using bulk insert logic here

Line 4493: DELETE FROM pa_fp_ra_map_tmp;

4489:
4490:
4491: -- Remove the old records, if any,from pa_fp_ra_map_tmp
4492:
4493: DELETE FROM pa_fp_ra_map_tmp;
4494:
4495: --Using bulk insert logic here
4496:
4497: IF (l_source_project_id = l_target_project_id) THEN

Line 4588: INSERT INTO pa_fp_ra_map_tmp

4584: --Only if something is fetched
4585:
4586: FORALL i in l_ra_map_tmp_tbl1.first..l_ra_map_tmp_tbl1.last
4587:
4588: INSERT INTO pa_fp_ra_map_tmp
4589: (source_res_assignment_id
4590: ,target_res_assignment_id
4591: ,resource_assignment_id --parent of source res_assignment_id
4592: ,source_task_id

Line 4770: INSERT INTO pa_fp_ra_map_tmp

4766: /* only if something is fetched */
4767:
4768: FORALL i IN l_ra_map_tmp_tbl1.first..l_ra_map_tmp_tbl1.last
4769:
4770: INSERT INTO pa_fp_ra_map_tmp
4771: (source_res_assignment_id
4772: ,target_res_assignment_id
4773: ,resource_assignment_id --parent of source res_assignment_id
4774: ,source_task_id

Line 4841: INSERT INTO pa_fp_ra_map_tmp

4837: /* only if something is fetched */
4838:
4839: FORALL i IN l_ra_map_tmp_tbl1.first..l_ra_map_tmp_tbl1.last
4840:
4841: INSERT INTO pa_fp_ra_map_tmp
4842: (source_res_assignment_id
4843: ,target_res_assignment_id
4844: ,resource_assignment_id --parent of source res_assignment_id
4845: ,source_task_id

Line 4938: go thru pa_fp_ra_map_tmp). The code is copied without any change from the version 115.196 of

4934:
4935: /*************************************************************************
4936: sgoteti 03/03/2005.This API was previously in PAFPCPFB.pls, Copied it here as this will be used
4937: only in Org Forecasting Context. (Note: copy_resource_assignments in latest PAFPCPFB.pls will not
4938: go thru pa_fp_ra_map_tmp). The code is copied without any change from the version 115.196 of
4939: PAFPCPFB.pls to reduce the impact. The parameter p_rbs_map_diff_flag can be considered as an
4940: obsolete parameter in org forecasting flow.
4941: **************************************************************************/
4942:

Line 5043: --Inserting records into pa_resource_assignments using pa_fp_ra_map_tmp

5039: pa_debug.g_err_stage:='l_target_project_id ='||l_target_project_id;
5040: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
5041: END IF;
5042: */
5043: --Inserting records into pa_resource_assignments using pa_fp_ra_map_tmp
5044:
5045: IF P_PA_DEBUG_MODE = 'Y' THEN
5046: pa_debug.g_err_stage:='Copying the source version records as target version records';
5047: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);

Line 5304: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165

5300: ,pra.named_role
5301: ,pra.txn_accum_header_id
5302: ,scheduled_delay --For Bug 3948128
5303: ,pra.CBS_ELEMENT_ID -- bug#16200605
5304: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
5305: ,PA_RESOURCE_ASSIGNMENTS pra
5306: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
5307: AND pra.budget_version_id = p_source_plan_version_id ;
5308:

Line 5316: FROM PA_FP_RA_MAP_TMP;

5312: IF P_PA_DEBUG_MODE = 'Y' THEN
5313:
5314: SELECT COUNT(*)
5315: INTO l_tmp
5316: FROM PA_FP_RA_MAP_TMP;
5317:
5318: pa_debug.g_err_stage:='PA_FP_RA_MAP_TMP count '||l_tmp;
5319: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
5320:

Line 5318: pa_debug.g_err_stage:='PA_FP_RA_MAP_TMP count '||l_tmp;

5314: SELECT COUNT(*)
5315: INTO l_tmp
5316: FROM PA_FP_RA_MAP_TMP;
5317:
5318: pa_debug.g_err_stage:='PA_FP_RA_MAP_TMP count '||l_tmp;
5319: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
5320:
5321: SELECT COUNT(*)
5322: INTO l_tmp

Line 5574: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165

5570: ,pra.named_role
5571: ,rmap.txn_accum_header_id
5572: ,scheduled_delay --For Bug 3948128
5573: ,pra.CBS_ELEMENT_ID -- bug#16200605
5574: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
5575: ,PA_RESOURCE_ASSIGNMENTS pra
5576: ,pa_rbs_plans_out_tmp rmap
5577: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
5578: AND pra.budget_version_id = p_source_plan_version_id

Line 5641: go thru pa_fp_ra_map_tmp). The code is copied without any change from the version 115.196 of P

5637:
5638: /*===================================================================
5639: sgoteti 03/03/2005.This API was previously in PAFPCPFB.pls, Copied it here as this will be used
5640: only in Org Forecasting Context. (Note: Copy_Budget_Lines in latest PAFPCPFB.pls will not
5641: go thru pa_fp_ra_map_tmp). The code is copied without any change from the version 115.196 of P
5642: PAFPCPFB.pls to reduce the impact.
5643: ===================================================================*/
5644:
5645: PROCEDURE Copy_Budget_Lines(

Line 6050: ,PA_FP_RA_MAP_TMP pfrmt

6046: ,cost_ind_compiled_set_id
6047: ,Decode(l_adj_percentage,0,pc_cur_conv_rejection_code,null)
6048: ,Decode(l_adj_percentage,0,pfc_cur_conv_rejection_code,null)
6049: FROM PA_BUDGET_LINES pbl
6050: ,PA_FP_RA_MAP_TMP pfrmt
6051: ,pa_fp_bl_map_tmp bmt /* FPB2 */
6052: WHERE pbl.resource_assignment_id = pfrmt.source_res_assignment_id
6053: AND bmt.source_budget_line_id = pbl.budget_line_id /* FPB2 */
6054: AND pbl.budget_version_id = p_source_plan_version_id;