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 68: FROM pa_rbs_mapping_rules

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

496: j := 1 ;
497: l_prev_token := 'NULL' ;
498: FOR i IN REVERSE 2..p_level LOOP
499: l_token:= get_level(p_rule_id,i);
500: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;
501: IF substr(l_token,0,1) <> 'I' THEN
502: l_res_type_cols(j) := get_resource_type_cols(substr(l_token,3,3));
503: 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));
504: j := j+1 ;

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

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

Line 773: from pa_rbs_mapping_rules

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

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

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

Line 1711: FROM pa_rbs_mapping_rules

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

Line 1716: ' FROM pa_rbs_mapping_rules ' ||

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

Line 2995: --insert rule into pa_rbs_mapping_rules

2991:
2992: END;
2993:
2994: ---------------------------------------------------
2995: --insert rule into pa_rbs_mapping_rules
2996: ---------------------------------------------------
2997:
2998: PROCEDURE insert_rule
2999: (

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

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' ||
3061: ' (ELEMENT_VERSION_ID, ' ||
3062: ' RULE_ID, ' ||
3063: ' RBS_ELEMENT_ID, ' ||
3064: ' RULE_FLAG, ' ||

Line 3392: from pa_rbs_mapping_rules

3388:
3389: select count(1) into l_count from dual
3390: where exists
3391: (select 1
3392: from pa_rbs_mapping_rules
3393: where element_version_id = p_rbs_version_id);
3394:
3395:
3396: IF l_count =0 THEN