APPS.PA_RBS_MAPPING dependencies on PA_RBS_PLANS_OUT_TMP

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

2208: END LOOP;
2209:
2210: IF g_debug_mode = 'Y' THEN
2211:
2212: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2213: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2214: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2215:
2216: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;

Line 2461: DELETE PA_RBS_PLANS_OUT_TMP;

2457: pa_debug.g_err_stage:= 'accum headers are inserted';
2458: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2459: END IF;
2460:
2461: DELETE PA_RBS_PLANS_OUT_TMP;
2462: INSERT INTO PA_RBS_PLANS_OUT_TMP
2463: (txn_accum_header_id,
2464: rbs_version_id,
2465: source_id,

Line 2462: INSERT INTO PA_RBS_PLANS_OUT_TMP

2458: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2459: END IF;
2460:
2461: DELETE PA_RBS_PLANS_OUT_TMP;
2462: INSERT INTO PA_RBS_PLANS_OUT_TMP
2463: (txn_accum_header_id,
2464: rbs_version_id,
2465: source_id,
2466: supplier_id,

Line 2522: UPDATE pa_rbs_plans_out_tmp dest

2518: head.bom_labor_resource_id = nvl(tmp.bom_labor_id,-1) AND
2519: head.person_type = nvl(tmp.person_type_code,'PJI$NULL') ;
2520:
2521: --bug#4098679
2522: UPDATE pa_rbs_plans_out_tmp dest
2523: SET revenue_category_id =
2524: ( SELECT
2525: src.resource_id
2526: FROM

Line 2534: UPDATE pa_rbs_plans_out_tmp dest

2530: src.resource_type_id = 14 )
2531: WHERE
2532: revenue_category_code is not null;
2533:
2534: UPDATE pa_rbs_plans_out_tmp dest
2535: SET person_type_id =
2536: ( SELECT
2537: src.resource_id
2538: FROM

Line 2546: UPDATE pa_rbs_plans_out_tmp dest

2542: src.resource_type_id = 11 )
2543: WHERE
2544: dest.person_type_code is not null;
2545: /** Commented for bug 6662808
2546: UPDATE pa_rbs_plans_out_tmp dest
2547: SET job_id =
2548: ( decode(job_id, null, null, l_job_group_id, null, job_id,
2549: PA_Cross_Business_Grp.IsMappedToJob(job_id, l_job_group_id)))
2550: WHERE

Line 2558: UPDATE pa_rbs_plans_out_tmp dest

2554: /** Added for bug 6662808 **/
2555:
2556: if l_job_group_id is not null then
2557:
2558: UPDATE pa_rbs_plans_out_tmp dest
2559: SET job_id= PA_Cross_Business_Grp.IsMappedToJob(job_id,l_job_group_id)
2560: WHERE dest.job_id is not null;
2561:
2562: end if;

Line 2608: FROM PA_RBS_PLANS_OUT_TMP a

2604: bom_equipment_id,
2605: bom_labor_id,
2606: -- get_res_type_numeric_id(person_type_code,11)
2607: person_type_id --bug#4098679
2608: FROM PA_RBS_PLANS_OUT_TMP a
2609: WHERE NOT EXISTS
2610: (SELECT 1
2611: FROM pa_rbs_txn_accum_map b
2612: WHERE b.struct_version_id = p_rbs_version_id and

Line 2693: UPDATE PA_RBS_PLANS_OUT_TMP tmp

2689: g_denorm_refresh := 'N';
2690:
2691: END IF;
2692:
2693: UPDATE PA_RBS_PLANS_OUT_TMP tmp
2694: SET tmp.rbs_element_id =
2695: (select map.element_id
2696: from pa_rbs_txn_accum_map map
2697: where map.txn_accum_header_id = tmp.txn_accum_header_id

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

2858: pa_debug.g_err_stage:= 'Exiting map_rbs_plans ' ;
2859: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2860: pa_debug.reset_curr_function;
2861:
2862: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2863: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2864: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2865: pa_debug.reset_curr_function;
2866: