APPS.PA_RBS_MAPPING dependencies on PA_RBS_PLANS_OUT_TMP

Line 2241: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;

2237: END LOOP;
2238:
2239: IF g_debug_mode = 'Y' THEN
2240:
2241: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2242: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2243: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2244:
2245: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;

Line 2796: DELETE PA_RBS_PLANS_OUT_TMP;

2792: pa_debug.g_err_stage:= 'accum headers are inserted';
2793: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2794: END IF;
2795:
2796: DELETE PA_RBS_PLANS_OUT_TMP;
2797: INSERT INTO PA_RBS_PLANS_OUT_TMP
2798: (txn_accum_header_id,
2799: rbs_version_id,
2800: source_id,

Line 2797: INSERT INTO PA_RBS_PLANS_OUT_TMP

2793: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2794: END IF;
2795:
2796: DELETE PA_RBS_PLANS_OUT_TMP;
2797: INSERT INTO PA_RBS_PLANS_OUT_TMP
2798: (txn_accum_header_id,
2799: rbs_version_id,
2800: source_id,
2801: supplier_id,

Line 2857: UPDATE pa_rbs_plans_out_tmp dest

2853: head.bom_labor_resource_id = nvl(tmp.bom_labor_id,-1) AND
2854: head.person_type = nvl(tmp.person_type_code,'PJI$NULL') ;
2855:
2856: --bug#4098679
2857: UPDATE pa_rbs_plans_out_tmp dest
2858: SET revenue_category_id =
2859: ( SELECT
2860: src.resource_id
2861: FROM

Line 2869: UPDATE pa_rbs_plans_out_tmp dest

2865: src.resource_type_id = 14 )
2866: WHERE
2867: revenue_category_code is not null;
2868:
2869: UPDATE pa_rbs_plans_out_tmp dest
2870: SET person_type_id =
2871: ( SELECT
2872: src.resource_id
2873: FROM

Line 2881: UPDATE pa_rbs_plans_out_tmp dest

2877: src.resource_type_id = 11 )
2878: WHERE
2879: dest.person_type_code is not null;
2880: /** Commented for bug 6662808
2881: UPDATE pa_rbs_plans_out_tmp dest
2882: SET job_id =
2883: ( decode(job_id, null, null, l_job_group_id, null, job_id,
2884: PA_Cross_Business_Grp.IsMappedToJob(job_id, l_job_group_id)))
2885: WHERE

Line 2893: UPDATE pa_rbs_plans_out_tmp dest

2889: /** Added for bug 6662808 **/
2890:
2891: if l_job_group_id is not null then
2892:
2893: UPDATE pa_rbs_plans_out_tmp dest
2894: SET job_id= PA_Cross_Business_Grp.IsMappedToJob(job_id,l_job_group_id)
2895: WHERE dest.job_id is not null;
2896:
2897: end if;

Line 2943: FROM PA_RBS_PLANS_OUT_TMP a

2939: bom_equipment_id,
2940: bom_labor_id,
2941: -- get_res_type_numeric_id(person_type_code,11)
2942: person_type_id --bug#4098679
2943: FROM PA_RBS_PLANS_OUT_TMP a
2944: WHERE NOT EXISTS
2945: (SELECT 1
2946: FROM pa_rbs_txn_accum_map b
2947: WHERE b.struct_version_id = p_rbs_version_id and

Line 3028: UPDATE PA_RBS_PLANS_OUT_TMP tmp

3024: g_denorm_refresh := 'N';
3025:
3026: END IF;
3027:
3028: UPDATE PA_RBS_PLANS_OUT_TMP tmp
3029: SET tmp.rbs_element_id =
3030: (select map.element_id
3031: from pa_rbs_txn_accum_map map
3032: where map.txn_accum_header_id = tmp.txn_accum_header_id

Line 3197: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;

3193: pa_debug.g_err_stage:= 'Exiting map_rbs_plans ' ;
3194: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3195: pa_debug.reset_curr_function;
3196:
3197: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
3198: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
3199: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3200: pa_debug.reset_curr_function;
3201: