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 539: DELETE FROM pa_res_list_map_tmp1;

535: l_NumRecInserted := 0;
536: l_stage := 'Start of populate_resmap_tmp ';
537: print_msg(g_debug_flag,l_stage);
538: /* Initialize the IN and OUT tmp tables */
539: DELETE FROM pa_res_list_map_tmp1;
540: DELETE FROM pa_res_list_map_tmp4;
541:
542:
543: IF p_budget_version_id is NOT NULL Then

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

573: l_stage := 'l_uncategorized_flag IS '||l_uncategorized_flag;
574: print_msg(g_debug_flag,l_stage);
575:
576: IF p_calling_mode = 'BUDGET_VERSION' Then
577: l_stage := 'Inserting recrods into pa_res_list_map_tmp1 for the given budget version';
578: print_msg(g_debug_flag,l_stage);
579: IF l_uncategorized_flag = 'Y' THEN
580:
581: INSERT INTO pa_res_list_map_tmp4

Line 672: INSERT INTO pa_res_list_map_tmp1

668: WHERE ra.budget_version_id = p_budget_version_id;
669:
670: ELSE
671:
672: INSERT INTO pa_res_list_map_tmp1
673: (TXN_SOURCE_ID
674: ,TXN_SOURCE_TYPE_CODE
675: ,PERSON_ID
676: ,JOB_ID

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

858: ,l_financial_res_class_rlm_id
859: FROM DUAL;
860:
861: ELSE -- IF l_uncategorized_flag = 'Y' THEN
862: l_stage := 'Inserting records into pa_res_list_map_tmp1 from PLSQL tables';
863: print_msg(g_debug_flag,l_stage);
864: FORALL i IN g_TXN_SOURCE_ID_sqltab.FIRST .. g_TXN_SOURCE_ID_sqltab.LAST
865: INSERT INTO pa_res_list_map_tmp1
866: (TXN_SOURCE_ID

Line 865: INSERT INTO pa_res_list_map_tmp1

861: ELSE -- IF l_uncategorized_flag = 'Y' THEN
862: l_stage := 'Inserting records into pa_res_list_map_tmp1 from PLSQL tables';
863: print_msg(g_debug_flag,l_stage);
864: FORALL i IN g_TXN_SOURCE_ID_sqltab.FIRST .. g_TXN_SOURCE_ID_sqltab.LAST
865: INSERT INTO pa_res_list_map_tmp1
866: (TXN_SOURCE_ID
867: ,TXN_SOURCE_TYPE_CODE
868: ,PERSON_ID
869: ,JOB_ID

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

1050: FROM DUAL;
1051:
1052: ELSE--IF l_uncategorized_flag = 'Y' THEN
1053:
1054: l_stage := 'Inserting records into pa_res_list_map_tmp1 from SYSTEM tables';
1055: print_msg(g_debug_flag,l_stage);
1056: FORALL i IN g_TXN_SOURCE_ID_systab.FIRST .. g_TXN_SOURCE_ID_systab.LAST
1057: INSERT INTO pa_res_list_map_tmp1
1058: (TXN_SOURCE_ID

Line 1057: INSERT INTO pa_res_list_map_tmp1

1053:
1054: l_stage := 'Inserting records into pa_res_list_map_tmp1 from SYSTEM tables';
1055: print_msg(g_debug_flag,l_stage);
1056: FORALL i IN g_TXN_SOURCE_ID_systab.FIRST .. g_TXN_SOURCE_ID_systab.LAST
1057: INSERT INTO pa_res_list_map_tmp1
1058: (TXN_SOURCE_ID
1059: ,TXN_SOURCE_TYPE_CODE
1060: ,PERSON_ID
1061: ,JOB_ID

Line 1161: UPDATE pa_res_list_map_tmp1 tmp

1157: l_uncategorized_flag = 'N' THEN
1158:
1159: /* update the resource class id for the inseted rows*/
1160: --FORALL i IN g_txn_id_sqltab.FIRST .. g_txn_id_sqltab.LAST
1161: UPDATE pa_res_list_map_tmp1 tmp
1162: SET tmp.resource_class_id = (select rc.resource_class_id
1163: from pa_resource_classes_b rc
1164: where rc.resource_class_code = tmp.resource_class_code)
1165: WHERE tmp.resource_class_code is NOT NULL

Line 1170: UPDATE pa_res_list_map_tmp1 tmp

1166: ;
1167:
1168: /* Bug fix: 3698579 */
1169: -- update exp category id if null
1170: UPDATE pa_res_list_map_tmp1 tmp
1171: SET tmp.expenditure_category = (select etc.expenditure_category
1172: from pa_expenditure_types et
1173: ,pa_expenditure_categories etc
1174: where et.expenditure_type = tmp.expenditure_type

Line 1182: UPDATE pa_res_list_map_tmp1 tmp

1178: WHERE tmp.expenditure_category is NULL
1179: AND tmp.expenditure_type is NOT NULL ;
1180:
1181: -- update revenue category based on event type if its null
1182: UPDATE pa_res_list_map_tmp1 tmp
1183: SET tmp.revenue_category = (SELECT evt.revenue_category_code
1184: FROM pa_event_types evt
1185: WHERE evt.event_type=tmp.event_type)
1186: WHERE tmp.revenue_category IS NULL

Line 1190: UPDATE pa_res_list_map_tmp1 tmp

1186: WHERE tmp.revenue_category IS NULL
1187: AND tmp.event_type IS NOT NULL;
1188:
1189: -- update revenue category based on exp type if its null
1190: UPDATE pa_res_list_map_tmp1 tmp
1191: SET tmp.Revenue_category = (select et.Revenue_category_code
1192: from pa_expenditure_types et
1193: where et.expenditure_type = tmp.expenditure_type
1194: and rownum = 1

Line 1200: UPDATE pa_res_list_map_tmp1 tmp

1196: WHERE tmp.Revenue_category is NULL
1197: AND tmp.expenditure_type is NOT NULL ;
1198:
1199: -- update default item category id if the resource is a inventory item
1200: UPDATE pa_res_list_map_tmp1 tmp
1201: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
1202: FROM PA_RESOURCE_CLASSES_B classes
1203: ,PA_PLAN_RES_DEFAULTS cls
1204: ,MTL_ITEM_CATEGORIES cat

Line 1219: UPDATE pa_res_list_map_tmp1 tmp

1215: /* bug fix:3843815 ,3841480 if p_budget_version_id is not passed in plsql_table mode then
1216: * the sql to derive l_struct_ver_id causes no data found . so added if condition and
1217: * moved the select to cursor */
1218: IF l_struct_ver_id is NOT NULL Then
1219: UPDATE pa_res_list_map_tmp1 tmp
1220: SET tmp.TXN_WBS_ELEMENT_VERSION_ID = (Select pelm.element_version_id
1221: From pa_proj_element_versions pelm
1222: WHERE pelm.parent_structure_version_id = l_struct_ver_id
1223: AND pelm.proj_element_id = tmp.txn_task_id

Line 1232: UPDATE pa_res_list_map_tmp1 tmp

1228: End If;
1229: /* End of bug fix:3698579 */
1230:
1231: /* added this update for bug fix:3854817 */
1232: UPDATE pa_res_list_map_tmp1 tmp
1233: SET tmp.fc_res_type_code = DECODE(tmp.EXPENDITURE_TYPE,null
1234: ,DECODE(tmp.EVENT_TYPE,null
1235: ,DECODE(tmp.EXPENDITURE_CATEGORY,null
1236: ,DECODE(tmp.REVENUE_CATEGORY,null,NULL,'REVENUE_CATEGORY')