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_RES_LIST_MAP_TMP1

Line 730: DELETE FROM pa_res_list_map_tmp1;

726: l_NumRecInserted := 0;
727: l_stage := 'Start of populate_resmap_tmp ';
728: print_msg(g_debug_flag,l_stage);
729: /* Initialize the IN and OUT tmp tables */
730: DELETE FROM pa_res_list_map_tmp1;
731: DELETE FROM pa_res_list_map_tmp4;
732:
733:
734: IF p_budget_version_id is NOT NULL Then

Line 768: l_stage := 'Inserting recrods into pa_res_list_map_tmp1 for the given budget version';

764: l_stage := 'l_uncategorized_flag IS '||l_uncategorized_flag;
765: print_msg(g_debug_flag,l_stage);
766:
767: IF p_calling_mode = 'BUDGET_VERSION' Then
768: l_stage := 'Inserting recrods into pa_res_list_map_tmp1 for the given budget version';
769: print_msg(g_debug_flag,l_stage);
770: IF l_uncategorized_flag = 'Y' THEN
771:
772: INSERT INTO pa_res_list_map_tmp4

Line 866: INSERT INTO pa_res_list_map_tmp1

862: WHERE ra.budget_version_id = p_budget_version_id;
863:
864: ELSE
865:
866: INSERT INTO pa_res_list_map_tmp1
867: (TXN_SOURCE_ID
868: ,TXN_SOURCE_TYPE_CODE
869: ,PERSON_ID
870: ,JOB_ID

Line 1063: l_stage := 'Inserting records into pa_res_list_map_tmp1 from PLSQL tables';

1059: FROM DUAL;
1060:
1061:
1062: ELSE -- IF l_uncategorized_flag = 'Y' THEN
1063: l_stage := 'Inserting records into pa_res_list_map_tmp1 from PLSQL tables';
1064: print_msg(g_debug_flag,l_stage);
1065: FORALL i IN g_TXN_SOURCE_ID_sqltab.FIRST .. g_TXN_SOURCE_ID_sqltab.LAST
1066: INSERT INTO pa_res_list_map_tmp1
1067: (TXN_SOURCE_ID

Line 1066: INSERT INTO pa_res_list_map_tmp1

1062: ELSE -- IF l_uncategorized_flag = 'Y' THEN
1063: l_stage := 'Inserting records into pa_res_list_map_tmp1 from PLSQL tables';
1064: print_msg(g_debug_flag,l_stage);
1065: FORALL i IN g_TXN_SOURCE_ID_sqltab.FIRST .. g_TXN_SOURCE_ID_sqltab.LAST
1066: INSERT INTO pa_res_list_map_tmp1
1067: (TXN_SOURCE_ID
1068: ,TXN_SOURCE_TYPE_CODE
1069: ,PERSON_ID
1070: ,JOB_ID

Line 1263: l_stage := 'Inserting records into pa_res_list_map_tmp1 from SYSTEM tables';

1259: FROM DUAL;
1260:
1261: ELSE--IF l_uncategorized_flag = 'Y' THEN
1262:
1263: l_stage := 'Inserting records into pa_res_list_map_tmp1 from SYSTEM tables';
1264: print_msg(g_debug_flag,l_stage);
1265: FORALL i IN g_TXN_SOURCE_ID_systab.FIRST .. g_TXN_SOURCE_ID_systab.LAST
1266: INSERT INTO pa_res_list_map_tmp1
1267: (TXN_SOURCE_ID

Line 1266: INSERT INTO pa_res_list_map_tmp1

1262:
1263: l_stage := 'Inserting records into pa_res_list_map_tmp1 from SYSTEM tables';
1264: print_msg(g_debug_flag,l_stage);
1265: FORALL i IN g_TXN_SOURCE_ID_systab.FIRST .. g_TXN_SOURCE_ID_systab.LAST
1266: INSERT INTO pa_res_list_map_tmp1
1267: (TXN_SOURCE_ID
1268: ,TXN_SOURCE_TYPE_CODE
1269: ,PERSON_ID
1270: ,JOB_ID

Line 1373: UPDATE pa_res_list_map_tmp1 tmp

1369: l_uncategorized_flag = 'N' THEN
1370:
1371: /* update the resource class id for the inseted rows*/
1372: --FORALL i IN g_txn_id_sqltab.FIRST .. g_txn_id_sqltab.LAST
1373: UPDATE pa_res_list_map_tmp1 tmp
1374: SET tmp.resource_class_id = (select rc.resource_class_id
1375: from pa_resource_classes_b rc
1376: where rc.resource_class_code = tmp.resource_class_code)
1377: WHERE tmp.resource_class_code is NOT NULL

Line 1382: UPDATE pa_res_list_map_tmp1 tmp

1378: ;
1379:
1380: /* Bug fix: 3698579 */
1381: -- update exp category id if null
1382: UPDATE pa_res_list_map_tmp1 tmp
1383: SET tmp.expenditure_category = (select etc.expenditure_category
1384: from pa_expenditure_types et
1385: ,pa_expenditure_categories etc
1386: where et.expenditure_type = tmp.expenditure_type

Line 1394: UPDATE pa_res_list_map_tmp1 tmp

1390: WHERE tmp.expenditure_category is NULL
1391: AND tmp.expenditure_type is NOT NULL ;
1392:
1393: -- update revenue category based on event type if its null
1394: UPDATE pa_res_list_map_tmp1 tmp
1395: SET tmp.revenue_category = (SELECT evt.revenue_category_code
1396: FROM pa_event_types evt
1397: WHERE evt.event_type=tmp.event_type)
1398: WHERE tmp.revenue_category IS NULL

Line 1402: UPDATE pa_res_list_map_tmp1 tmp

1398: WHERE tmp.revenue_category IS NULL
1399: AND tmp.event_type IS NOT NULL;
1400:
1401: -- update revenue category based on exp type if its null
1402: UPDATE pa_res_list_map_tmp1 tmp
1403: SET tmp.Revenue_category = (select et.Revenue_category_code
1404: from pa_expenditure_types et
1405: where et.expenditure_type = tmp.expenditure_type
1406: and rownum = 1

Line 1412: UPDATE pa_res_list_map_tmp1 tmp

1408: WHERE tmp.Revenue_category is NULL
1409: AND tmp.expenditure_type is NOT NULL ;
1410:
1411: -- update default item category id if the resource is a inventory item
1412: UPDATE pa_res_list_map_tmp1 tmp
1413: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
1414: FROM PA_RESOURCE_CLASSES_B classes
1415: ,PA_PLAN_RES_DEFAULTS cls
1416: ,MTL_ITEM_CATEGORIES cat

Line 1431: UPDATE pa_res_list_map_tmp1 tmp

1427: /* bug fix:3843815 ,3841480 if p_budget_version_id is not passed in plsql_table mode then
1428: * the sql to derive l_struct_ver_id causes no data found . so added if condition and
1429: * moved the select to cursor */
1430: IF l_struct_ver_id is NOT NULL Then
1431: UPDATE pa_res_list_map_tmp1 tmp
1432: SET tmp.TXN_WBS_ELEMENT_VERSION_ID = (Select pelm.element_version_id
1433: From pa_proj_element_versions pelm
1434: WHERE pelm.parent_structure_version_id = l_struct_ver_id
1435: AND pelm.proj_element_id = tmp.txn_task_id

Line 1444: UPDATE pa_res_list_map_tmp1 tmp

1440: End If;
1441: /* End of bug fix:3698579 */
1442:
1443: /* added this update for bug fix:3854817 */
1444: UPDATE pa_res_list_map_tmp1 tmp
1445: SET tmp.fc_res_type_code = DECODE(tmp.EXPENDITURE_TYPE,null
1446: ,DECODE(tmp.EVENT_TYPE,null
1447: ,DECODE(tmp.EXPENDITURE_CATEGORY,null
1448: ,DECODE(tmp.REVENUE_CATEGORY,null,NULL,'REVENUE_CATEGORY')