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_RBS_MAPPING dependencies on PA_RBS_ELEMENTS

Line 778: ' FROM pa_rbs_elements ' ||

774: where rule_id = p_rule_id ;
775:
776: --bug#3642329
777: l_sql_stmt := ' SELECT ' || l_res_type_cols(i) ||
778: ' FROM pa_rbs_elements ' ||
779: ' WHERE rbs_version_id = ' || p_struct_version_id ||
780: ' AND user_created_flag = ' || '''Y''' ||
781: ' AND rbs_element_id = ' || l_rbs_element_id ;
782:

Line 827: FROM pa_rbs_elements

823: BEGIN
824:
825: SELECT rbs_element_id
826: INTO l_parent_element_id
827: FROM pa_rbs_elements
828: WHERE rbs_level = p_level
829: CONNECT BY rbs_element_id = PRIOR parent_element_id
830: START WITH rbs_element_id = g_rbs_element_id ;
831:

Line 891: || 'pa_rbs_elements RBS ' ;

887: || get_sql_clause(p_rule_id,p_level,'RES_SOURCE') || ' ,'
888: || get_sql_clause(p_rule_id,p_level,'TMP') ;
889:
890: l_FROM_clause := 'FROM pa_rbs_map_tmp2 TMP,'
891: || 'pa_rbs_elements RBS ' ;
892:
893:
894:
895: IF g_rule_type = 'N' THEN

Line 996: || 'pa_rbs_elements_s.nextval,'

992: || ':p_struct_version_id,'
993: || 'RBS.rbs_element_id,'
994: || get_sql_clause(p_rule_id,p_level,'RES_TYP_ID') || ' ,'
995: || get_sql_clause(p_rule_id,p_level,'RES_SOURCE') || ' ,'
996: || 'pa_rbs_elements_s.nextval,'
997: || get_sql_clause(p_rule_id,p_level,'TMP') ;
998: l_tmp := 2 + p_counter ;
999:
1000: l_FROM_clause := ' FROM ( SELECT DISTINCT struct_version_id, '

Line 1005: || 'pa_rbs_elements RBS ' ;

1001: || get_sql_clause_unmap(p_rule_id,p_level ,'NONE') --bug#3749017
1002: || ' FROM pa_rbs_map_tmp' || l_tmp
1003: || ' WHERE parent_element_version_id IS NULL '
1004: || ' ) TMP,'
1005: || 'pa_rbs_elements RBS ' ;
1006:
1007:
1008: IF g_rule_type = 'Y' THEN
1009:

Line 1090: || ' pa_rbs_elements_s.nextval , '

1086: || ')' ;
1087:
1088: l_SELECT_clause := 'SELECT '
1089: || ':p_struct_version_id,'
1090: || ' pa_rbs_elements_s.nextval , '
1091: || ' -1 , '
1092: || ':p_struct_version_id';
1093:
1094: l_temp := 2+p_level ;

Line 1119: --create top rbs element inserting into pa_rbs_elements

1115:
1116: END;
1117:
1118: ------------------------------------------------------
1119: --create top rbs element inserting into pa_rbs_elements
1120: ------------------------------------------------------
1121:
1122: PROCEDURE create_top_rbs_element
1123: (

Line 1152: l_INSERT_clause := 'INSERT INTO pa_rbs_elements ('

1148: END IF;
1149:
1150: PA_RBS_UTILS.Populate_RBS_Element_Name(p_struct_version_id,-1,x_rbs_element_name_id,x_return_status);
1151:
1152: l_INSERT_clause := 'INSERT INTO pa_rbs_elements ('
1153: || 'rbs_version_id,'
1154: || 'rbs_element_id,'
1155: || 'resource_source_id,'
1156: || 'rbs_level,'

Line 1205: pa_debug.g_err_stage:= 'Exiting create_top_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;

1201:
1202:
1203:
1204: IF g_debug_mode = 'Y' THEN
1205: pa_debug.g_err_stage:= 'Exiting create_top_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;
1206: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1207: pa_debug.reset_curr_function;
1208: END IF;
1209:

Line 1214: --create rbs elements inserting into pa_rbs_elements

1210:
1211: END ;
1212:
1213: ------------------------------------------------------
1214: --create rbs elements inserting into pa_rbs_elements
1215: ------------------------------------------------------
1216:
1217: PROCEDURE create_rbs_element
1218: (

Line 1286: l_INSERT_clause := 'INSERT INTO pa_rbs_elements ( '

1282:
1283: PA_RBS_UTILS.Populate_RBS_Element_Name(x_resource_source_id,x_resource_type_id,x_rbs_element_name_id,x_return_status);
1284:
1285:
1286: l_INSERT_clause := 'INSERT INTO pa_rbs_elements ( '
1287: || 'rbs_version_id,'
1288: || 'rbs_element_id,'
1289: || 'parent_element_id,'
1290: || 'rbs_level,'

Line 1336: || 'pa_rbs_elements RBS ' ; --bug#3974663

1332: l_FROM_clause := ' FROM '
1333: || 'pa_rbs_map_tmp' || l_tmp1 || ' TMP, '
1334: || 'pa_rbs_map_tmp' || l_tmp2 || ' TMP1, '
1335: || 'pa_rbs_element_names_b name, '
1336: || 'pa_rbs_elements RBS ' ; --bug#3974663
1337: l_WHERE_clause := ' WHERE '
1338: || get_sql_clause_rule(p_rule_id,p_level-1,'EQUAL2') --bug#3759977
1339: || ' AND TMP.resource_type_id = name.resource_type_id '
1340: || ' AND TMP.resource_source_id = name.resource_source_id '

Line 1356: pa_debug.g_err_stage:= 'Exiting create_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;

1352:
1353: g_denorm_refresh := 'Y';
1354:
1355: IF g_debug_mode = 'Y' THEN
1356: pa_debug.g_err_stage:= 'Exiting create_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;
1357: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1358: pa_debug.reset_curr_function;
1359: END IF;
1360:

Line 1416: || 'pa_rbs_elements RBS' ;

1412: || ':g_user_id,'
1413: || ':g_login_id ';
1414: l_FROM_clause := ' FROM '
1415: || 'pa_rbs_map_tmp3 TMP, '
1416: || 'pa_rbs_elements RBS' ;
1417: l_WHERE_clause := ' WHERE '
1418: || get_sql_clause(p_rule_id,p_max_level,'EQUAL') || ' AND '
1419: || 'TMP.element_version_id IS NULL '
1420: || ' AND RBS.user_created_flag = ' || '''' || 'N' || ''''

Line 1506: EXECUTE IMMEDIATE 'UPDATE pa_rbs_map_tmp2 SET ( ' || l_sql_cols || ' ) = ( SELECT ' || l_sql_cols || ' FROM PA_RBS_ELEMENTS where rbs_element_id = :g_rbs_element_id) ' USING g_rbs_element_id;

1502: l_sql_cols := l_sql_cols || l_res_type_cols(i) || ' , ';
1503: END IF;
1504: END LOOP;
1505:
1506: EXECUTE IMMEDIATE 'UPDATE pa_rbs_map_tmp2 SET ( ' || l_sql_cols || ' ) = ( SELECT ' || l_sql_cols || ' FROM PA_RBS_ELEMENTS where rbs_element_id = :g_rbs_element_id) ' USING g_rbs_element_id;
1507:
1508: END IF;
1509:
1510: IF g_debug_mode = 'Y' THEN

Line 1554: select count(*) into l_count from pa_rbs_elements where

1550: WHERE struct_version_id = p_struct_version_id ) ;
1551:
1552:
1553: IF SQL%ROWCOUNT>0 THEN
1554: select count(*) into l_count from pa_rbs_elements where
1555: rbs_level = 1 and
1556: rbs_version_id = p_struct_version_id and
1557: user_created_flag = 'N' ;
1558:

Line 1562: SELECT pa_rbs_elements_s.nextval INTO l_sequence FROM dual ;

1558:
1559:
1560: IF l_count = 0 THEN
1561:
1562: SELECT pa_rbs_elements_s.nextval INTO l_sequence FROM dual ;
1563: PA_RBS_UTILS.Populate_RBS_Element_Name(p_struct_version_id, -1, x_rbs_element_name_id, x_return_status);
1564:
1565: INSERT INTO pa_rbs_elements (
1566: rbs_version_id,

Line 1565: INSERT INTO pa_rbs_elements (

1561:
1562: SELECT pa_rbs_elements_s.nextval INTO l_sequence FROM dual ;
1563: PA_RBS_UTILS.Populate_RBS_Element_Name(p_struct_version_id, -1, x_rbs_element_name_id, x_return_status);
1564:
1565: INSERT INTO pa_rbs_elements (
1566: rbs_version_id,
1567: rbs_element_id,
1568: rbs_level,
1569: rbs_element_name_id,

Line 1605: select rbs_element_id into l_sequence from pa_rbs_elements where rbs_level = 1 and

1601:
1602:
1603: ELSIF l_count = 1 THEN
1604:
1605: select rbs_element_id into l_sequence from pa_rbs_elements where rbs_level = 1 and
1606: rbs_version_id = p_struct_version_id and
1607: user_created_flag = 'N' ;
1608:
1609:

Line 3056: -- commented select below as its not required because rule_flag in pa_rbs_elements is not null column

3052: select PA_RBS_MAPPING_RULE_S.nextval
3053: into l_rule_id
3054: from dual;
3055:
3056: -- commented select below as its not required because rule_flag in pa_rbs_elements is not null column
3057: -- select decode(rule_flag,null,'null',''''||rule_flag||'''') into l_rule_flag from dual ;
3058:
3059: l_rule_flag := rule_flag; --l_rule_flag is redundant, we can remove and directly use rule_flag
3060: l_SQL_statement := 'INSERT INTO PA_RBS_MAPPING_RULES' ||

Line 3133: select bom_labor_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3129:
3130: BEGIN
3131:
3132: IF p_res_type_code = 'BOM_LABOR' THEN
3133: select bom_labor_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3134: if l_value = -1 then
3135: RETURN 'R:BML';
3136: elsif l_value > 0 then
3137: RETURN 'I:BML:'||l_value; --bug#3759977

Line 3140: select bom_equipment_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3136: elsif l_value > 0 then
3137: RETURN 'I:BML:'||l_value; --bug#3759977
3138: end if;
3139: ELSIF p_res_type_code = 'BOM_EQUIPMENT' THEN
3140: select bom_equipment_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3141: if l_value = -1 then
3142: RETURN 'R:BME';
3143: elsif l_value > 0 then
3144: RETURN 'I:BME:'||l_value; --bug#3759977

Line 3147: select person_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3143: elsif l_value > 0 then
3144: RETURN 'I:BME:'||l_value; --bug#3759977
3145: end if;
3146: ELSIF p_res_type_code = 'NAMED_PERSON' THEN
3147: select person_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3148: if l_value = -1 then
3149: RETURN 'R:PER';
3150: elsif l_value > 0 then
3151: RETURN 'I:PER:'||l_value; --bug#3759977

Line 3154: select event_type_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3150: elsif l_value > 0 then
3151: RETURN 'I:PER:'||l_value; --bug#3759977
3152: end if;
3153: ELSIF p_res_type_code = 'EVENT_TYPE' THEN
3154: select event_type_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3155: if l_value = -1 then
3156: RETURN 'R:EVT';
3157: elsif l_value > 0 then
3158: RETURN 'I:EVT:'||l_value; --bug#3759977

Line 3161: select expenditure_category_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3157: elsif l_value > 0 then
3158: RETURN 'I:EVT:'||l_value; --bug#3759977
3159: end if;
3160: ELSIF p_res_type_code = 'EXPENDITURE_CATEGORY' THEN
3161: select expenditure_category_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3162: if l_value = -1 then
3163: RETURN 'R:EXC';
3164: elsif l_value > 0 then
3165: RETURN 'I:EXC:'||l_value; --bug#3759977

Line 3168: select expenditure_type_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3164: elsif l_value > 0 then
3165: RETURN 'I:EXC:'||l_value; --bug#3759977
3166: end if;
3167: ELSIF p_res_type_code = 'EXPENDITURE_TYPE' THEN
3168: select expenditure_type_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3169: if l_value = -1 then
3170: RETURN 'R:EXT';
3171: elsif l_value > 0 then
3172: RETURN 'I:EXT:'||l_value; --bug#3759977

Line 3175: select item_category_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3171: elsif l_value > 0 then
3172: RETURN 'I:EXT:'||l_value; --bug#3759977
3173: end if;
3174: ELSIF p_res_type_code = 'ITEM_CATEGORY' THEN
3175: select item_category_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3176: if l_value = -1 then
3177: RETURN 'R:ITC';
3178: elsif l_value > 0 then
3179: RETURN 'I:ITC:'||l_value; --bug#3759977

Line 3182: select inventory_item_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3178: elsif l_value > 0 then
3179: RETURN 'I:ITC:'||l_value; --bug#3759977
3180: end if;
3181: ELSIF p_res_type_code = 'INVENTORY_ITEM' THEN
3182: select inventory_item_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3183: if l_value = -1 then
3184: RETURN 'R:ITM';
3185: elsif l_value > 0 then
3186: RETURN 'I:ITM:'||l_value; --bug#3759977

Line 3189: select job_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3185: elsif l_value > 0 then
3186: RETURN 'I:ITM:'||l_value; --bug#3759977
3187: end if;
3188: ELSIF p_res_type_code = 'JOB' THEN
3189: select job_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3190: if l_value = -1 then
3191: RETURN 'R:JOB';
3192: elsif l_value > 0 then
3193: RETURN 'I:JOB:'||l_value; --bug#3759977

Line 3196: select organization_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3192: elsif l_value > 0 then
3193: RETURN 'I:JOB:'||l_value; --bug#3759977
3194: end if;
3195: ELSIF p_res_type_code = 'ORGANIZATION' THEN
3196: select organization_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3197: if l_value = -1 then
3198: RETURN 'R:ORG';
3199: elsif l_value > 0 then
3200: RETURN 'I:ORG:'||l_value; --bug#3759977

Line 3203: select person_type_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3199: elsif l_value > 0 then
3200: RETURN 'I:ORG:'||l_value; --bug#3759977
3201: end if;
3202: ELSIF p_res_type_code = 'PERSON_TYPE' THEN
3203: select person_type_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3204: if l_value = -1 then
3205: RETURN 'R:PTP';
3206: elsif l_value > 0 then
3207: RETURN 'I:PTP:'||l_value; --bug#3759977

Line 3210: select non_labor_resource_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3206: elsif l_value > 0 then
3207: RETURN 'I:PTP:'||l_value; --bug#3759977
3208: end if;
3209: ELSIF p_res_type_code = 'NON_LABOR_RESOURCE' THEN
3210: select non_labor_resource_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3211: if l_value = -1 then
3212: RETURN 'R:NLR';
3213: elsif l_value > 0 then
3214: RETURN 'I:NLR:'||l_value; --bug#3759977

Line 3217: select resource_class_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3213: elsif l_value > 0 then
3214: RETURN 'I:NLR:'||l_value; --bug#3759977
3215: end if;
3216: ELSIF p_res_type_code = 'RESOURCE_CLASS' THEN
3217: select resource_class_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3218: if l_value = -1 then
3219: RETURN 'R:RES';
3220: elsif l_value > 0 then
3221: RETURN 'I:RES:'||l_value; --bug#3759977

Line 3224: select revenue_category_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3220: elsif l_value > 0 then
3221: RETURN 'I:RES:'||l_value; --bug#3759977
3222: end if;
3223: ELSIF p_res_type_code = 'REVENUE_CATEGORY' THEN
3224: select revenue_category_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3225: if l_value = -1 then
3226: RETURN 'R:RVC';
3227: elsif l_value > 0 then
3228: RETURN 'I:RVC:'||l_value; --bug#3759977

Line 3231: select role_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3227: elsif l_value > 0 then
3228: RETURN 'I:RVC:'||l_value; --bug#3759977
3229: end if;
3230: ELSIF p_res_type_code = 'ROLE' THEN
3231: select role_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3232: if l_value = -1 then
3233: RETURN 'R:ROL';
3234: elsif l_value > 0 then
3235: RETURN 'I:ROL:'||l_value; --bug#3759977

Line 3238: select supplier_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;

3234: elsif l_value > 0 then
3235: RETURN 'I:ROL:'||l_value; --bug#3759977
3236: end if;
3237: ELSIF p_res_type_code = 'SUPPLIER' THEN
3238: select supplier_id into l_value from pa_rbs_elements where rbs_element_id = p_elem_version_id ;
3239: if l_value = -1 then
3240: RETURN 'R:SUP';
3241: elsif l_value > 0 then
3242: RETURN 'I:SUP:'||l_value; --bug#3759977

Line 3255: from pa_rbs_elements where rbs_element_id = p_elem_version_id;

3251: l_value2,
3252: l_value3,
3253: l_value4,
3254: l_value5
3255: from pa_rbs_elements where rbs_element_id = p_elem_version_id;
3256:
3257: -- bug#3810558 changed CUS1 to CU1 etc
3258:
3259: If l_value5 is not null then

Line 3454: from PA_RBS_ELEMENTS

3450: USER_DEFINED_CUSTOM4_ID,
3451: USER_DEFINED_CUSTOM5_ID,
3452: RULE_FLAG,
3453: RESOURCE_TYPE_ID
3454: from PA_RBS_ELEMENTS
3455: where rbs_version_id = p_rbs_version_id and
3456: user_created_flag = 'Y';
3457:
3458: l_count_tmp1:=SQL%ROWCOUNT; --Bug#5248414