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_RLMI_RBS_MAP_PUB dependencies on PA_RBS_PLANS_IN_TMP

Line 218: DELETE FROM pa_rbs_plans_in_tmp ;

214: BEGIN
215: l_stage := 'Start of populate_rbsmap_tmp';
216: print_msg(g_debug_flag,l_stage);
217: /* Initialize the IN and OUT tmp tables */
218: DELETE FROM pa_rbs_plans_in_tmp ;
219: DELETE FROM pa_rbs_plans_out_tmp;
220: If p_calling_mode = 'BUDGET_VERSION' Then
221: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp for the budget version';
222: print_msg(g_debug_flag,l_stage);

Line 221: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp for the budget version';

217: /* Initialize the IN and OUT tmp tables */
218: DELETE FROM pa_rbs_plans_in_tmp ;
219: DELETE FROM pa_rbs_plans_out_tmp;
220: If p_calling_mode = 'BUDGET_VERSION' Then
221: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp for the budget version';
222: print_msg(g_debug_flag,l_stage);
223: INSERT INTO pa_rbs_plans_in_tmp
224: (source_id
225: ,person_id

Line 223: INSERT INTO pa_rbs_plans_in_tmp

219: DELETE FROM pa_rbs_plans_out_tmp;
220: If p_calling_mode = 'BUDGET_VERSION' Then
221: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp for the budget version';
222: print_msg(g_debug_flag,l_stage);
223: INSERT INTO pa_rbs_plans_in_tmp
224: (source_id
225: ,person_id
226: ,Job_id
227: ,organization_id

Line 284: UPDATE pa_rbs_plans_in_tmp tmp

280: print_msg(g_debug_flag,l_stage);
281: /* bug fix: 3678165 added this update commented out the outer join from insert */
282: If g_rbs_numRecInserted > 0 Then
283: l_stage := 'Update the tmp table with exp,event,cate,Ids';
284: UPDATE pa_rbs_plans_in_tmp tmp
285: SET tmp.expenditure_type_id = (select et.expenditure_type_id
286: from pa_expenditure_types et
287: ,pa_resource_assignments ra
288: where et.expenditure_type = ra.expenditure_type

Line 316: print_msg(g_debug_flag,'Number of rows updated on pa_rbs_plans_in_tmp['||sql%Rowcount||']');

312: where nvl(ra.incur_by_res_class_code,ra.resource_class_code) = rc.resource_class_code
313: and ra.resource_assignment_id = tmp.source_id
314: and rownum = 1) ;
315:
316: print_msg(g_debug_flag,'Number of rows updated on pa_rbs_plans_in_tmp['||sql%Rowcount||']');
317: End IF;
318: Elsif p_calling_mode = 'PLSQL_TABLE' Then
319: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp from PLSQL tables';
320: print_msg(g_debug_flag,l_stage);

Line 319: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp from PLSQL tables';

315:
316: print_msg(g_debug_flag,'Number of rows updated on pa_rbs_plans_in_tmp['||sql%Rowcount||']');
317: End IF;
318: Elsif p_calling_mode = 'PLSQL_TABLE' Then
319: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp from PLSQL tables';
320: print_msg(g_debug_flag,l_stage);
321: FORALL i IN g_txn_source_id_sqltab.FIRST .. g_txn_source_id_sqltab.LAST
322: INSERT INTO pa_rbs_plans_in_tmp
323: (source_id

Line 322: INSERT INTO pa_rbs_plans_in_tmp

318: Elsif p_calling_mode = 'PLSQL_TABLE' Then
319: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp from PLSQL tables';
320: print_msg(g_debug_flag,l_stage);
321: FORALL i IN g_txn_source_id_sqltab.FIRST .. g_txn_source_id_sqltab.LAST
322: INSERT INTO pa_rbs_plans_in_tmp
323: (source_id
324: ,person_id
325: ,Job_id
326: ,organization_id

Line 366: UPDATE pa_rbs_plans_in_tmp tmp

362: g_rbs_numRecInserted := g_txn_source_id_sqltab.Count ;
363: l_stage := 'Num Of Records Inserted ['||g_rbs_numRecInserted||']';
364: print_msg(g_debug_flag,l_stage);
365: FORALL i IN g_txn_source_id_sqltab.FIRST .. g_txn_source_id_sqltab.LAST
366: UPDATE pa_rbs_plans_in_tmp tmp
367: SET tmp.expenditure_type_id = (select et.expenditure_type_id
368: from pa_expenditure_types et
369: where et.expenditure_type = g_expenditure_type_sqltab(i))
370: , tmp.non_labor_resource_id = (select nlr.non_labor_resource_id

Line 386: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp from SYSTEM tables';

382: where evt.event_type = g_event_type_sqltab(i))
383: WHERE tmp.source_id = g_txn_source_id_sqltab(i);
384:
385: Elsif p_calling_mode = 'SYSTEM_TABLE' Then
386: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp from SYSTEM tables';
387: print_msg(g_debug_flag,l_stage);
388: FORALL i IN g_txn_source_id_systab.FIRST .. g_txn_source_id_systab.LAST
389: INSERT INTO pa_rbs_plans_in_tmp
390: (source_id

Line 389: INSERT INTO pa_rbs_plans_in_tmp

385: Elsif p_calling_mode = 'SYSTEM_TABLE' Then
386: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp from SYSTEM tables';
387: print_msg(g_debug_flag,l_stage);
388: FORALL i IN g_txn_source_id_systab.FIRST .. g_txn_source_id_systab.LAST
389: INSERT INTO pa_rbs_plans_in_tmp
390: (source_id
391: ,person_id
392: ,Job_id
393: ,organization_id

Line 433: UPDATE pa_rbs_plans_in_tmp

429: g_rbs_numRecInserted := g_txn_source_id_systab.count;
430: l_stage := 'Num Of Records Inserted ['||g_rbs_numRecInserted||']';
431: print_msg(g_debug_flag,l_stage);
432: FORALL i IN g_txn_source_id_systab.FIRST .. g_txn_source_id_systab.LAST
433: UPDATE pa_rbs_plans_in_tmp
434: SET expenditure_type_id = (select et.expenditure_type_id
435: from pa_expenditure_types et
436: where et.expenditure_type = g_expenditure_type_systab(i))
437: , non_labor_resource_id = (select nlr.non_labor_resource_id

Line 455: UPDATE pa_rbs_plans_in_tmp tmp

451: End If;
452:
453: /* Bug fix: 3698579 */
454: -- update exp category id if null
455: UPDATE pa_rbs_plans_in_tmp tmp
456: SET tmp.expenditure_category_id = (select etc.expenditure_category_id
457: from pa_expenditure_types et
458: ,pa_expenditure_categories etc
459: where et.expenditure_type_id = tmp.expenditure_type_id

Line 468: UPDATE pa_rbs_plans_in_tmp tmp

464:
465:
466: /* Bug fix: 3999186 populate revenue category based on event types */
467: -- update revenue category if its null based on event types
468: UPDATE pa_rbs_plans_in_tmp tmp
469: SET tmp.Revenue_category_code = (select et.Revenue_category_code
470: from pa_event_types et
471: where et.event_type_id = tmp.event_type_id
472: )

Line 478: UPDATE pa_rbs_plans_in_tmp tmp

474: AND tmp.event_type_id is NOT NULL ;
475: /* end of Bug fix: 3999186 */
476:
477: -- update revenue category if its null based on expendiure types
478: UPDATE pa_rbs_plans_in_tmp tmp
479: SET tmp.Revenue_category_code = (select et.Revenue_category_code
480: from pa_expenditure_types et
481: where et.expenditure_type_id = tmp.expenditure_type_id
482: )

Line 487: UPDATE pa_rbs_plans_in_tmp tmp

483: WHERE tmp.Revenue_category_code is NULL
484: AND tmp.expenditure_type_id is NOT NULL ;
485:
486: -- update the default item category
487: UPDATE pa_rbs_plans_in_tmp tmp
488: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
489: FROM PA_RESOURCE_CLASSES_B classes
490: ,PA_PLAN_RES_DEFAULTS cls
491: ,MTL_ITEM_CATEGORIES cat