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_MAPPING_RULES

Line 41: --Gets the sorted rules from pa_rbs_mapping_rules

37: RETURN lockhndl;
38: END;
39:
40: --------------------------------------------------
41: --Gets the sorted rules from pa_rbs_mapping_rules
42: --given rbs structure version and resource class
43: --------------------------------------------------
44: FUNCTION get_sorted_rules
45: (

Line 71: FROM pa_rbs_mapping_rules

67: rule_id
68: BULK COLLECT INTO
69: l_precedence,
70: l_sorted_rules
71: FROM pa_rbs_mapping_rules
72: WHERE element_version_id = p_struct_version_id
73: ORDER BY
74: max_level desc ,
75: 1 ,

Line 239: -- Get the Level from the pa_rbs_mapping_rules for the Rule Id

235:
236: END ;
237:
238: -------------------------------------------------------------------
239: -- Get the Level from the pa_rbs_mapping_rules for the Rule Id
240: -------------------------------------------------------------------
241:
242: --modified function below for bug#4478902
243:

Line 265: Select Level1 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

261: END IF;
262:
263: CASE p_level
264: WHEN 1 THEN
265: Select Level1 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
266: WHEN 2 THEN
267: Select Level2 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
268: WHEN 3 THEN
269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 267: Select Level2 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

263: CASE p_level
264: WHEN 1 THEN
265: Select Level1 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
266: WHEN 2 THEN
267: Select Level2 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
268: WHEN 3 THEN
269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
270: WHEN 4 THEN
271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

265: Select Level1 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
266: WHEN 2 THEN
267: Select Level2 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
268: WHEN 3 THEN
269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
270: WHEN 4 THEN
271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
272: WHEN 5 THEN
273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

267: Select Level2 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
268: WHEN 3 THEN
269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
270: WHEN 4 THEN
271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
272: WHEN 5 THEN
273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
274: WHEN 6 THEN
275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
270: WHEN 4 THEN
271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
272: WHEN 5 THEN
273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
274: WHEN 6 THEN
275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
276: WHEN 7 THEN
277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
272: WHEN 5 THEN
273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
274: WHEN 6 THEN
275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
276: WHEN 7 THEN
277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
278: WHEN 8 THEN
279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
274: WHEN 6 THEN
275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
276: WHEN 7 THEN
277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
278: WHEN 8 THEN
279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
280: WHEN 9 THEN
281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
276: WHEN 7 THEN
277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
278: WHEN 8 THEN
279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
280: WHEN 9 THEN
281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
282: WHEN 10 THEN
283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
278: WHEN 8 THEN
279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
280: WHEN 9 THEN
281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
282: WHEN 10 THEN
283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
284: WHEN 11 THEN
285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
280: WHEN 9 THEN
281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
282: WHEN 10 THEN
283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
284: WHEN 11 THEN
285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
286: WHEN 12 THEN
287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
282: WHEN 10 THEN
283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
284: WHEN 11 THEN
285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
286: WHEN 12 THEN
287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
288: WHEN 13 THEN
289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
284: WHEN 11 THEN
285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
286: WHEN 12 THEN
287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
288: WHEN 13 THEN
289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
290: WHEN 14 THEN
291: Select Level14 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
286: WHEN 12 THEN
287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
288: WHEN 13 THEN
289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
290: WHEN 14 THEN
291: Select Level14 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
292: WHEN 15 THEN
293: Select Level15 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 291: Select Level14 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
288: WHEN 13 THEN
289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
290: WHEN 14 THEN
291: Select Level14 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
292: WHEN 15 THEN
293: Select Level15 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
294: ELSE
295: l_value:=NULL;

Line 293: Select Level15 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
290: WHEN 14 THEN
291: Select Level14 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
292: WHEN 15 THEN
293: Select Level15 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
294: ELSE
295: l_value:=NULL;
296: END CASE;
297:

Line 395: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;

391:
392: j := 1;
393: FOR i IN 2..g_max_level LOOP
394: l_token:= get_level(p_rule_id,i);
395: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;
396: --commented if and endif for custom nodes
397: --IF substr(l_token,1,1) = 'R' OR substr(l_token,1,1) = 'I' THEN -- condition should be false for custom based node
398: l_res_type_cols(j) := get_resource_type_cols(substr(l_token,3,3)); --bug#3759977
399: j := j+1;

Line 444: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;

440: l_prev_token := 'NULL' ;
441: FOR i IN REVERSE 2..p_level LOOP
442: l_token:= get_level(p_rule_id,i);
443:
444: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;
445: IF substr(l_token,0,1) = 'I' AND substr(l_token,3,3) <> l_prev_token THEN
446: l_res_type_cols(j) := ' TMP.' || get_resource_type_cols(substr(l_token,3,3));
447: l_res_type_cols(j) := l_res_type_cols(j) || ' = ' || substr(l_token,7);
448: j := j+1 ;

Line 503: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;

499: j := 1 ;
500: l_prev_token := 'NULL' ;
501: FOR i IN REVERSE 2..p_level LOOP
502: l_token:= get_level(p_rule_id,i);
503: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;
504: IF substr(l_token,0,1) <> 'I' THEN
505: l_res_type_cols(j) := get_resource_type_cols(substr(l_token,3,3));
506: l_res_type_cols2(j) := 'RBS.' || get_resource_type_cols(substr(l_token,3,3)) || ' (+) = TMP.' || get_resource_type_cols(substr(l_token,3,3));
507: j := j+1 ;

Line 580: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;

576: j := 1 ;
577: FOR i IN REVERSE 2..p_level LOOP
578: l_token:= get_level(p_rule_id,i);
579:
580: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;
581: IF substr(l_token,0,1) <> 'I' THEN
582: l_res_type_cols(j) := get_resource_type_cols(substr(l_token,3,3));
583: j := j+1 ;
584: END IF;

Line 776: from pa_rbs_mapping_rules

772: FOR i IN 1..l_res_type_cols.COUNT LOOP
773: /*
774: select rbs_element_id
775: into l_rbs_element_id
776: from pa_rbs_mapping_rules
777: where rule_id = p_rule_id ;
778:
779: --bug#3642329
780: l_sql_stmt := ' SELECT ' || l_res_type_cols(i) ||

Line 1493: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = :p_rule_id' INTO l_token USING p_rule_id ;

1489: FOR i IN 2..g_max_level LOOP
1490:
1491: l_token:= get_level(p_rule_id,i);
1492:
1493: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = :p_rule_id' INTO l_token USING p_rule_id ;
1494: IF substr(l_token,1,1) = 'C' THEN
1495: l_res_type_cols(j) := get_resource_type_cols(substr(l_token,3));
1496: j := j+1;
1497: END IF;

Line 1714: FROM pa_rbs_mapping_rules

1710:
1711: FOR k IN 1..l_sorted_rule_id.COUNT-1 LOOP
1712: SELECT rule_flag, max_level, rbs_element_id
1713: INTO g_rule_type, g_max_level, g_rbs_element_id
1714: FROM pa_rbs_mapping_rules
1715: WHERE rule_id = l_sorted_rule_id(k);
1716:
1717: -- checking for wheteher leaf node of the rule is custom then processing for the rule would be ignored
1718: l_sql_stmt := 'SELECT level' || g_max_level ||

Line 1719: ' FROM pa_rbs_mapping_rules ' ||

1715: WHERE rule_id = l_sorted_rule_id(k);
1716:
1717: -- checking for wheteher leaf node of the rule is custom then processing for the rule would be ignored
1718: l_sql_stmt := 'SELECT level' || g_max_level ||
1719: ' FROM pa_rbs_mapping_rules ' ||
1720: ' WHERE rule_id = :rule_id' ;
1721:
1722: l_leaf_type:= get_level(l_sorted_rule_id(k),g_max_level);
1723:

Line 3330: --insert rule into pa_rbs_mapping_rules

3326:
3327: END;
3328:
3329: ---------------------------------------------------
3330: --insert rule into pa_rbs_mapping_rules
3331: ---------------------------------------------------
3332:
3333: PROCEDURE insert_rule
3334: (

Line 3395: l_SQL_statement := 'INSERT INTO PA_RBS_MAPPING_RULES' ||

3391: -- commented select below as its not required because rule_flag in pa_rbs_elements is not null column
3392: -- select decode(rule_flag,null,'null',''''||rule_flag||'''') into l_rule_flag from dual ;
3393:
3394: l_rule_flag := rule_flag; --l_rule_flag is redundant, we can remove and directly use rule_flag
3395: l_SQL_statement := 'INSERT INTO PA_RBS_MAPPING_RULES' ||
3396: ' (ELEMENT_VERSION_ID, ' ||
3397: ' RULE_ID, ' ||
3398: ' RBS_ELEMENT_ID, ' ||
3399: ' RULE_FLAG, ' ||

Line 3729: from pa_rbs_mapping_rules

3725:
3726: select count(1) into l_count from dual
3727: where exists
3728: (select 1
3729: from pa_rbs_mapping_rules
3730: where element_version_id = p_rbs_version_id);
3731:
3732:
3733: IF l_count =0 THEN