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.IEX_SCORE_NEW_PVT dependencies on IEX_SCORES

Line 103: || Source Tables: IEX_SCORES

99: || Parameter: p_score_id => scoring engine; p_object_type => type of object you wish to score
100: ||
101: || Return value: true=OK; FALSE=error
102: ||
103: || Source Tables: IEX_SCORES
104: ||
105: || Target Tables: NA
106: ||
107: || Creation date: 01/14/02 4:47:PM

Line 122: ' From iex_scores ' ||

118:
119: begin
120: Execute Immediate
121: ' Select jtf_object_code ' ||
122: ' From iex_scores ' ||
123: ' where score_id = :p_score_id'
124: into l_object_type
125: using p_score_id;
126: Exception

Line 283: FROM IEX_SCORES

279: SELECT NVL(WEIGHT_REQUIRED, 'N'),
280: NVL(SCORE_RANGE_LOW, IEX_SCORE_NEW_PVT.G_MIN_SCORE),
281: NVL(SCORE_RANGE_HIGH, IEX_SCORE_NEW_PVT.G_MAX_SCORE),
282: NVL(OUT_OF_RANGE_RULE, IEX_SCORE_NEW_PVT.G_RULE)
283: FROM IEX_SCORES
284: WHERE SCORE_ID = p_score_id;
285:
286: l_weight_required VARCHAR2(3);
287: l_low varchar2(2000);

Line 356: || Source Tables: IEX_SCORES, IEX_SCORE_COMPONENTS, IEX_SCORE_COMP_TYPES_B/TL

352: || X_SCORE_COMP_TBL = table of components attached to the Scoring engine
353: ||
354: || Return value: select statement for the Universe
355: ||
356: || Source Tables: IEX_SCORES, IEX_SCORE_COMPONENTS, IEX_SCORE_COMP_TYPES_B/TL
357: ||
358: || Target Tables: none
359: ||
360: || Creation date: 01/14/02 1:55:PM

Line 462: || SCORE_RANGE_HIGH, OUT_OF_RANGE_RULE' in iex_scores

458: || 10/18/04 clchang updated this procedure for scoring engine enhancement
459: || in 11.5.11.
460: || 1. new column METRIC_FLAG in iex_score_components
461: || 2. new columns 'WEIGHT_REQUIRED, SCORE_RANGE_LOW,
462: || SCORE_RANGE_HIGH, OUT_OF_RANGE_RULE' in iex_scores
463: || 3. no 1-100 score limitation;
464: || 4. weight_required decides the weight of comp;
465: || 5. in comp det, the value could be formula;
466: || (only one BIND Var :result could be used.)

Line 554: From IEX_SCORES scr, IEX_SCORE_COMPONENTS scomp

550: -- Begin - Andre Araujo - 12/17/2004 - Store del_buffers only if we need to
551: Begin -- This will be an exception block
552: Select NVL(CONCURRENT_PROG_NAME, 'X')
553: Into l_conc_prog_name
554: From IEX_SCORES scr, IEX_SCORE_COMPONENTS scomp
555: Where scomp.score_component_id = p_score_comp_tbl(1).SCORE_COMPONENT_ID
556: AND scr.Score_ID = scomp.score_id;
557: exception
558: when OTHERS THEN

Line 583: from iex_scores score

579: --Begin Bug 8933776 30-Nov-2009 barathsr
580: begin
581: select score.jtf_object_code
582: into l_jtf_obj_code
583: from iex_scores score
584: where score_id=p_score_comp_tbl(1).score_id;
585: fnd_file.put_line(fnd_file.log,'obj_code-->'||l_jtf_obj_code);
586: fnd_file.put_line(fnd_file.log,'unv_id-->'||t_object_ids(l_count));
587:

Line 891: from iex_scores

887: l_new_scores_tbl(l_scorecount) := l_running_score;
888: if l_scorecount >= G_BATCH_SIZE then
889: --start bug 13426796 by sunagesh on 25-11-2011
890: select jtf_object_code into t_object_code
891: from iex_scores
892: where score_id = l_score_comp_tbl(1).SCORE_ID;
893: if t_prf_score_trans = 'Y' then
894: storeScoreHistory ( l_score_comp_tbl(1).SCORE_ID, l_objects_tbl, l_new_scores_tbl );
895: else

Line 935: from iex_scores

931: --- Begin - Andre Araujo - 11/02/2004 - New storage mode, this one respects the commit size - TAR 4040621.994
932: if l_scorecount > 0 then -- Store the leftovers
933: --start bug 13426796 by sunagesh on 25-11-2011
934: select jtf_object_code into t_object_code
935: from iex_scores
936: where score_id = l_score_comp_tbl(1).SCORE_ID;
937: if t_prf_score_trans = 'Y' then
938: storeScoreHistory ( l_score_comp_tbl(1).SCORE_ID, l_objects_tbl, l_new_scores_tbl );
939: else

Line 983: || Source Tables: IEX_SCORES, IEX_SCORE_COMPONENTS_VL, IEX_SCORE_COMP_TYPES, IEX_SCORE_COMP_DET,

979: || Overview: score all objects for a given scoring engine
980: ||
981: || Parameter: p_score_id => scoring engine ID
982: ||
983: || Source Tables: IEX_SCORES, IEX_SCORE_COMPONENTS_VL, IEX_SCORE_COMP_TYPES, IEX_SCORE_COMP_DET,
984: || IEX_OBJECT_FILTERS
985: ||
986: || Target Tables:
987: ||

Line 1104: from iex_scores

1100: x_return_status := FND_API.G_RET_STS_SUCCESS;
1101:
1102: /*select score_name
1103: into l_score_name
1104: from iex_scores
1105: where score_id=p_score_id;
1106: --
1107: -- Api body
1108: --

Line 1112: from iex_scores

1108: --
1109:
1110: -- initial variables needed
1111: select jtf_object_code into l_object_type
1112: from iex_scores
1113: where score_id = p_score_id;*/
1114: --Begin Bug 8933776 30-Nov-2009 barathsr
1115: begin
1116: SELECT score.score_name,

Line 1126: FROM iex_scores score,

1122: score.score_range_low,
1123: score.score_range_high
1124: into l_score_name,l_object_code,l_obj_filter_name,l_obj_filter_view,
1125: l_cp_name,l_sts_det,l_score_low,l_score_high
1126: FROM iex_scores score,
1127: iex_object_filters obj
1128: WHERE score.score_id =obj.object_id
1129: AND obj.object_filter_type='IEXSCORE'
1130: and score.score_id=p_score_id;

Line 1390: From IEX_SCORES scr, fnd_concurrent_programs cp

1386: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Finding any process to spawn...');
1387: END IF;
1388: Select NVL(cp.Concurrent_Program_Name, 'X')
1389: Into l_conc_prog_name
1390: From IEX_SCORES scr, fnd_concurrent_programs cp
1391: Where scr.concurrent_prog_name = cp.concurrent_program_name AND
1392: scr.Score_ID = p_score_id;
1393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: Spawning ' || l_conc_prog_name);
1394:

Line 1550: || Source Tables: IEX_SCORES, IEX_SCORE_COMPONENTS_VL, IEX_SCORE_COMP_TYPES, IEX_SCORE_COMP_DET,

1546: || Overview: score a single object given it's ID, it's Type, and it's Scoring Engine
1547: ||
1548: || Parameter: p_score_id => scoring engine ID
1549: ||
1550: || Source Tables: IEX_SCORES, IEX_SCORE_COMPONENTS_VL, IEX_SCORE_COMP_TYPES, IEX_SCORE_COMP_DET,
1551: || IEX_OBJECT_FILTERS
1552: ||
1553: || Target Tables:
1554: ||

Line 1769: select score_name into l_score_name1 from iex_scores where score_id=p_score_id1;

1765: --l_xml_header:=l_xml_header||l_new_line||''||l_org_id||'';
1766: l_xml_header:=l_xml_header||l_new_line||''||''||''; -- bug 13629982
1767:
1768: if p_score_id1 is not null then
1769: select score_name into l_score_name1 from iex_scores where score_id=p_score_id1;
1770: else
1771: l_score_name1:='NA';
1772: end if;
1773: l_xml_header:=l_xml_header||l_new_line||''||format_string(l_score_name1)||'';

Line 1775: select score_name into l_score_name2 from iex_scores where score_id=p_score_id2;

1771: l_score_name1:='NA';
1772: end if;
1773: l_xml_header:=l_xml_header||l_new_line||''||format_string(l_score_name1)||'';
1774: if p_score_id2 is not null then
1775: select score_name into l_score_name2 from iex_scores where score_id=p_score_id2;
1776: else
1777: l_score_name2:='NA';
1778: end if;
1779: l_xml_header:=l_xml_header||l_new_line||''||format_string(l_score_name2)||'';

Line 1781: select score_name into l_score_name3 from iex_scores where score_id=p_score_id3;

1777: l_score_name2:='NA';
1778: end if;
1779: l_xml_header:=l_xml_header||l_new_line||''||format_string(l_score_name2)||'';
1780: if p_score_id3 is not null then
1781: select score_name into l_score_name3 from iex_scores where score_id=p_score_id3;
1782: else
1783: l_score_name3:='NA';
1784: end if;
1785: l_xml_header:=l_xml_header||l_new_line||''||format_string(l_score_name3)||'';

Line 1787: select score_name into l_score_name4 from iex_scores where score_id=p_score_id4;

1783: l_score_name3:='NA';
1784: end if;
1785: l_xml_header:=l_xml_header||l_new_line||''||format_string(l_score_name3)||'';
1786: if p_score_id4 is not null then
1787: select score_name into l_score_name4 from iex_scores where score_id=p_score_id4;
1788: else
1789: l_score_name4:='NA';
1790: end if;
1791: l_xml_header:=l_xml_header||l_new_line||''||format_string(l_score_name4)||'';

Line 1793: select score_name into l_score_name5 from iex_scores where score_id=p_score_id5;

1789: l_score_name4:='NA';
1790: end if;
1791: l_xml_header:=l_xml_header||l_new_line||''||format_string(l_score_name4)||'';
1792: if p_score_id5 is not null then
1793: select score_name into l_score_name5 from iex_scores where score_id=p_score_id5;
1794: else
1795: l_score_name5:='NA';
1796: end if;
1797: l_xml_header:=l_xml_header||l_new_line||''||format_string(l_score_name5)||'';

Line 2502: from iex_scores

2498: END IF;
2499:
2500: -- initial variables needed
2501: select jtf_object_code into l_object_type
2502: from iex_scores
2503: where score_id = p_score_id;
2504:
2505: FORALL n in i..i + p_scores_tbl.count - 1
2506: insert into iex_score_histories(SCORE_HISTORY_ID

Line 2618: from iex_scores

2614: END IF;
2615:
2616: -- initial variables needed
2617: select jtf_object_code into l_object_type
2618: from iex_scores
2619: where score_id = p_score_id;
2620:
2621:
2622: FORALL n in i..i + p_scores_tbl.count - 1