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_FROM_PKG dependencies on PA_RBS_PLANS_OUT_TMP

Line 2234: ---->1.copy resource assignments will look at pa_rbs_plans_out_tmp table for rbs_element_id and txn_accum_header_id

2230: of pa_fp_ra_map_tmp table. System_reference4 column has the value.
2231:
2232: --Added parameter p_rbs_map_diff_flag for Bug 3974569. This parameter can be passed as Y if the RBS mapping of
2233: --the target resource assignments is different from that of the source resource assignments.If this is passed as Y then
2234: ---->1.copy resource assignments will look at pa_rbs_plans_out_tmp table for rbs_element_id and txn_accum_header_id
2235: ---->of target resource assignments and it assumes that source_id in pa_rbs_plans_out_tmp corresponds to the
2236: ----> resource_assignment_id in the source budget version.
2237:
2238: --Bug 3948128. Included scheduled_delay in the list of columns that would get copied.

Line 2235: ---->of target resource assignments and it assumes that source_id in pa_rbs_plans_out_tmp corresponds to the

2231:
2232: --Added parameter p_rbs_map_diff_flag for Bug 3974569. This parameter can be passed as Y if the RBS mapping of
2233: --the target resource assignments is different from that of the source resource assignments.If this is passed as Y then
2234: ---->1.copy resource assignments will look at pa_rbs_plans_out_tmp table for rbs_element_id and txn_accum_header_id
2235: ---->of target resource assignments and it assumes that source_id in pa_rbs_plans_out_tmp corresponds to the
2236: ----> resource_assignment_id in the source budget version.
2237:
2238: --Bug 3948128. Included scheduled_delay in the list of columns that would get copied.
2239: --Bug 4200168: Changed the logic so that the copy is not based on pa_fp_ra_map_tmp when

Line 2374: --Bug 3974569. Need not have pa_rbs_plans_out_tmp in the FROM clause if the parameter is N

2370: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2371: END IF;
2372: -- Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
2373:
2374: --Bug 3974569. Need not have pa_rbs_plans_out_tmp in the FROM clause if the parameter is N
2375: IF P_PA_DEBUG_MODE = 'Y' THEN
2376: pa_debug.g_err_stage:='p_rbs_map_diff_flag '||p_rbs_map_diff_flag;
2377: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2378: END IF;

Line 2640: --For Bug 3974569. Take rbs_element_id and txn_accum_header_id from pa_rbs_plans_out_tmp

2636: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
2637: AND pra.budget_version_id = p_source_plan_version_id ;
2638:
2639:
2640: --For Bug 3974569. Take rbs_element_id and txn_accum_header_id from pa_rbs_plans_out_tmp
2641: --API is called for in WORKPLAN CONTEXT for copying from source to target with different RBSs or Resource Lists
2642: ELSIF p_calling_context='WORKPLAN' AND p_rbs_map_diff_flag ='Y' THEN --IF p_rbs_map_diff_flag ='N' THEN
2643:
2644: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2659: FROM pa_rbs_plans_out_tmp;

2655: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2656:
2657: SELECT COUNT(*)
2658: INTO l_tmp
2659: FROM pa_rbs_plans_out_tmp;
2660:
2661: pa_debug.g_err_stage:='pa_rbs_plans_out_tmp count '||l_tmp;
2662: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2663:

Line 2661: pa_debug.g_err_stage:='pa_rbs_plans_out_tmp count '||l_tmp;

2657: SELECT COUNT(*)
2658: INTO l_tmp
2659: FROM pa_rbs_plans_out_tmp;
2660:
2661: pa_debug.g_err_stage:='pa_rbs_plans_out_tmp count '||l_tmp;
2662: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2663:
2664: END IF;
2665:

Line 2914: ,pa_rbs_plans_out_tmp rmap

2910: ,rmap.txn_accum_header_id
2911: ,scheduled_delay --For Bug 3948128
2912: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
2913: ,PA_RESOURCE_ASSIGNMENTS pra
2914: ,pa_rbs_plans_out_tmp rmap
2915: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
2916: AND pra.budget_version_id = p_source_plan_version_id
2917: AND rmap.source_id = pra.resource_assignment_id;
2918: