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 231: TYPE expenditure_type_id_t IS TABLE OF pa_rbs_plans_in_tmp.expenditure_type_id%TYPE;

227: l_resource_class_id NUMBER;
228: l_expenditure_category_id NUMBER;
229: l_event_type_id NUMBER;
230:
231: TYPE expenditure_type_id_t IS TABLE OF pa_rbs_plans_in_tmp.expenditure_type_id%TYPE;
232: l_EXPENDITURE_TYPE_ID_TBL expenditure_type_id_t := expenditure_type_id_t();
233:
234: TYPE non_labor_resource_id_t IS TABLE OF pa_rbs_plans_in_tmp.non_labor_resource_id%TYPE;
235: l_NON_LABOR_RESOURCE_ID_TBL non_labor_resource_id_t := non_labor_resource_id_t();

Line 234: TYPE non_labor_resource_id_t IS TABLE OF pa_rbs_plans_in_tmp.non_labor_resource_id%TYPE;

230:
231: TYPE expenditure_type_id_t IS TABLE OF pa_rbs_plans_in_tmp.expenditure_type_id%TYPE;
232: l_EXPENDITURE_TYPE_ID_TBL expenditure_type_id_t := expenditure_type_id_t();
233:
234: TYPE non_labor_resource_id_t IS TABLE OF pa_rbs_plans_in_tmp.non_labor_resource_id%TYPE;
235: l_NON_LABOR_RESOURCE_ID_TBL non_labor_resource_id_t := non_labor_resource_id_t();
236:
237: TYPE resource_class_id_t IS TABLE OF pa_rbs_plans_in_tmp.resource_class_id%TYPE;
238: l_RESOURCE_CLASS_ID_TBL resource_class_id_t := resource_class_id_t();

Line 237: TYPE resource_class_id_t IS TABLE OF pa_rbs_plans_in_tmp.resource_class_id%TYPE;

233:
234: TYPE non_labor_resource_id_t IS TABLE OF pa_rbs_plans_in_tmp.non_labor_resource_id%TYPE;
235: l_NON_LABOR_RESOURCE_ID_TBL non_labor_resource_id_t := non_labor_resource_id_t();
236:
237: TYPE resource_class_id_t IS TABLE OF pa_rbs_plans_in_tmp.resource_class_id%TYPE;
238: l_RESOURCE_CLASS_ID_TBL resource_class_id_t := resource_class_id_t();
239:
240: TYPE expenditure_category_id_t IS TABLE OF pa_rbs_plans_in_tmp.expenditure_category_id%TYPE;
241: L_expenditure_category_id_TBL expenditure_category_id_t := expenditure_category_id_t();

Line 240: TYPE expenditure_category_id_t IS TABLE OF pa_rbs_plans_in_tmp.expenditure_category_id%TYPE;

236:
237: TYPE resource_class_id_t IS TABLE OF pa_rbs_plans_in_tmp.resource_class_id%TYPE;
238: l_RESOURCE_CLASS_ID_TBL resource_class_id_t := resource_class_id_t();
239:
240: TYPE expenditure_category_id_t IS TABLE OF pa_rbs_plans_in_tmp.expenditure_category_id%TYPE;
241: L_expenditure_category_id_TBL expenditure_category_id_t := expenditure_category_id_t();
242:
243: TYPE event_type_id_t IS TABLE OF pa_rbs_plans_in_tmp.event_type_id%TYPE;
244: l_EVENT_TYPE_ID_TBL event_type_id_t := event_type_id_t();

Line 243: TYPE event_type_id_t IS TABLE OF pa_rbs_plans_in_tmp.event_type_id%TYPE;

239:
240: TYPE expenditure_category_id_t IS TABLE OF pa_rbs_plans_in_tmp.expenditure_category_id%TYPE;
241: L_expenditure_category_id_TBL expenditure_category_id_t := expenditure_category_id_t();
242:
243: TYPE event_type_id_t IS TABLE OF pa_rbs_plans_in_tmp.event_type_id%TYPE;
244: l_EVENT_TYPE_ID_TBL event_type_id_t := event_type_id_t();
245:
246: -- bug 14040849 end
247:

Line 252: DELETE FROM pa_rbs_plans_in_tmp ;

248: BEGIN
249: l_stage := 'Start of populate_rbsmap_tmp';
250: print_msg(g_debug_flag,l_stage);
251: /* Initialize the IN and OUT tmp tables */
252: DELETE FROM pa_rbs_plans_in_tmp ;
253: DELETE FROM pa_rbs_plans_out_tmp;
254: If p_calling_mode = 'BUDGET_VERSION' Then
255: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp for the budget version';
256: print_msg(g_debug_flag,l_stage);

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

251: /* Initialize the IN and OUT tmp tables */
252: DELETE FROM pa_rbs_plans_in_tmp ;
253: DELETE FROM pa_rbs_plans_out_tmp;
254: If p_calling_mode = 'BUDGET_VERSION' Then
255: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp for the budget version';
256: print_msg(g_debug_flag,l_stage);
257: INSERT INTO pa_rbs_plans_in_tmp
258: (source_id
259: ,person_id

Line 257: INSERT INTO pa_rbs_plans_in_tmp

253: DELETE FROM pa_rbs_plans_out_tmp;
254: If p_calling_mode = 'BUDGET_VERSION' Then
255: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp for the budget version';
256: print_msg(g_debug_flag,l_stage);
257: INSERT INTO pa_rbs_plans_in_tmp
258: (source_id
259: ,person_id
260: ,Job_id
261: ,organization_id

Line 319: UPDATE pa_rbs_plans_in_tmp tmp

315: /* bug fix: 3678165 added this update commented out the outer join from insert */
316: If g_rbs_numRecInserted > 0 Then
317: l_stage := 'Update the tmp table with exp,event,cate,Ids';
318: /* replaced the update stmt with the one below for bug 14040849
319: UPDATE pa_rbs_plans_in_tmp tmp
320: SET tmp.expenditure_type_id = (select et.expenditure_type_id
321: from pa_expenditure_types et
322: ,pa_resource_assignments ra
323: where et.expenditure_type = ra.expenditure_type

Line 387: UPDATE PA_RBS_PLANS_IN_TMP

383: SELECT EVT.EVENT_TYPE_ID into l_EVENT_TYPE_ID
384: FROM PA_EVENT_TYPES EVT WHERE EVT.EVENT_TYPE = l_get_res_asmts_rec.event_type;
385: END IF;
386:
387: UPDATE PA_RBS_PLANS_IN_TMP
388: SET EXPENDITURE_TYPE_ID = l_EXPENDITURE_TYPE_ID,
389: NON_LABOR_RESOURCE_ID = l_NON_LABOR_RESOURCE_ID,
390: RESOURCE_CLASS_ID = l_RESOURCE_CLASS_ID,
391: EXPENDITURE_CATEGORY_ID = l_EXPENDITURE_CATEGORY_ID,

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

394:
395: END LOOP;
396: -- bug 14040849 end
397:
398: print_msg(g_debug_flag,'Number of rows updated on pa_rbs_plans_in_tmp['||sql%Rowcount||']');
399: End IF;
400: Elsif p_calling_mode = 'PLSQL_TABLE' Then
401: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp from PLSQL tables';
402: print_msg(g_debug_flag,l_stage);

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

397:
398: print_msg(g_debug_flag,'Number of rows updated on pa_rbs_plans_in_tmp['||sql%Rowcount||']');
399: End IF;
400: Elsif p_calling_mode = 'PLSQL_TABLE' Then
401: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp from PLSQL tables';
402: print_msg(g_debug_flag,l_stage);
403:
404: /* Added for 14040849 Start*/
405: l_EXPENDITURE_TYPE_ID_TBL.extend(g_expenditure_type_sqltab.count);

Line 466: INSERT INTO pa_rbs_plans_in_tmp

462: END IF;
463: END LOOP;
464:
465: FORALL i IN g_txn_source_id_sqltab.FIRST .. g_txn_source_id_sqltab.LAST
466: INSERT INTO pa_rbs_plans_in_tmp
467: (source_id
468: ,person_id
469: ,Job_id
470: ,organization_id

Line 512: UPDATE pa_rbs_plans_in_tmp tmp

508: print_msg(g_debug_flag,l_stage);
509: -- added for 14040849 commented below update statement and added the same in insert itself
510: /*
511: FORALL i IN g_txn_source_id_sqltab.FIRST .. g_txn_source_id_sqltab.LAST
512: UPDATE pa_rbs_plans_in_tmp tmp
513: SET tmp.expenditure_type_id = l_EXPENDITURE_TYPE_ID_TBL(i)
514: , tmp.non_labor_resource_id = l_NON_LABOR_RESOURCE_ID_TBL(i)
515: ,tmp.resource_class_id = l_RESOURCE_CLASS_ID_TBL(i)
516: ,tmp.expenditure_category_id = L_expenditure_category_id_TBL(i)

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

518: /* ,tmp.event_type_id = l_EVENT_TYPE_ID_TBL(i)
519: WHERE tmp.source_id = g_txn_source_id_sqltab(i); */
520: /* end of 14040849 */
521: Elsif p_calling_mode = 'SYSTEM_TABLE' Then
522: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp from SYSTEM tables';
523: print_msg(g_debug_flag,l_stage);
524: /* Start of14040849 */
525: l_EXPENDITURE_TYPE_ID_TBL.extend(g_expenditure_type_systab.count);
526: For i in g_expenditure_type_systab.FIRST .. g_expenditure_type_systab.LAST LOOP

Line 586: INSERT INTO pa_rbs_plans_in_tmp

582: END IF;
583: END LOOP;
584:
585: FORALL i IN g_txn_source_id_systab.FIRST .. g_txn_source_id_systab.LAST
586: INSERT INTO pa_rbs_plans_in_tmp
587: (source_id
588: ,person_id
589: ,Job_id
590: ,organization_id

Line 632: UPDATE pa_rbs_plans_in_tmp

628: print_msg(g_debug_flag,l_stage);
629:
630: -- added for 14040849 commented below update statement and added the same in insert itself
631: /* FORALL i IN g_txn_source_id_systab.FIRST .. g_txn_source_id_systab.LAST
632: UPDATE pa_rbs_plans_in_tmp
633: SET expenditure_type_id = l_EXPENDITURE_TYPE_ID_TBL(i)
634: , non_labor_resource_id = l_NON_LABOR_RESOURCE_ID_TBL(i)
635: ,resource_class_id = l_RESOURCE_CLASS_ID_TBL(i)
636: ,expenditure_category_id = L_expenditure_category_id_TBL(i)

Line 646: UPDATE pa_rbs_plans_in_tmp tmp

642: End If;
643:
644: /* Bug fix: 3698579 */
645: -- update exp category id if null
646: UPDATE pa_rbs_plans_in_tmp tmp
647: SET tmp.expenditure_category_id = (select etc.expenditure_category_id
648: from pa_expenditure_types et
649: ,pa_expenditure_categories etc
650: where et.expenditure_type_id = tmp.expenditure_type_id

Line 659: UPDATE pa_rbs_plans_in_tmp tmp

655:
656:
657: /* Bug fix: 3999186 populate revenue category based on event types */
658: -- update revenue category if its null based on event types
659: UPDATE pa_rbs_plans_in_tmp tmp
660: SET tmp.Revenue_category_code = (select et.Revenue_category_code
661: from pa_event_types et
662: where et.event_type_id = tmp.event_type_id
663: )

Line 669: UPDATE pa_rbs_plans_in_tmp tmp

665: AND tmp.event_type_id is NOT NULL ;
666: /* end of Bug fix: 3999186 */
667:
668: -- update revenue category if its null based on expendiure types
669: UPDATE pa_rbs_plans_in_tmp tmp
670: SET tmp.Revenue_category_code = (select et.Revenue_category_code
671: from pa_expenditure_types et
672: where et.expenditure_type_id = tmp.expenditure_type_id
673: )

Line 678: UPDATE pa_rbs_plans_in_tmp tmp

674: WHERE tmp.Revenue_category_code is NULL
675: AND tmp.expenditure_type_id is NOT NULL ;
676:
677: -- update the default item category
678: UPDATE pa_rbs_plans_in_tmp tmp
679: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
680: FROM PA_RESOURCE_CLASSES_B classes
681: ,PA_PLAN_RES_DEFAULTS cls
682: ,MTL_ITEM_CATEGORIES cat