APPS.IEX_SCORE_NEW_PVT dependencies on IEX_SCORES

Line 99: || Source Tables: IEX_SCORES

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

Line 118: ' From iex_scores ' ||

114:
115: begin
116: Execute Immediate
117: ' Select jtf_object_code ' ||
118: ' From iex_scores ' ||
119: ' where score_id = :p_score_id'
120: into l_object_type
121: using p_score_id;
122: Exception

Line 180: FROM IEX_SCORES

176: SELECT NVL(WEIGHT_REQUIRED, 'N'),
177: NVL(SCORE_RANGE_LOW, IEX_SCORE_NEW_PVT.G_MIN_SCORE),
178: NVL(SCORE_RANGE_HIGH, IEX_SCORE_NEW_PVT.G_MAX_SCORE),
179: NVL(OUT_OF_RANGE_RULE, IEX_SCORE_NEW_PVT.G_RULE)
180: FROM IEX_SCORES
181: WHERE SCORE_ID = p_score_id;
182:
183: l_weight_required VARCHAR2(3);
184: l_low varchar2(2000);

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

249: || X_SCORE_COMP_TBL = table of components attached to the Scoring engine
250: ||
251: || Return value: select statement for the Universe
252: ||
253: || Source Tables: IEX_SCORES, IEX_SCORE_COMPONENTS, IEX_SCORE_COMP_TYPES_B/TL
254: ||
255: || Target Tables: none
256: ||
257: || Creation date: 01/14/02 1:55:PM

Line 358: || SCORE_RANGE_HIGH, OUT_OF_RANGE_RULE' in iex_scores

354: || 10/18/04 clchang updated this procedure for scoring engine enhancement
355: || in 11.5.11.
356: || 1. new column METRIC_FLAG in iex_score_components
357: || 2. new columns 'WEIGHT_REQUIRED, SCORE_RANGE_LOW,
358: || SCORE_RANGE_HIGH, OUT_OF_RANGE_RULE' in iex_scores
359: || 3. no 1-100 score limitation;
360: || 4. weight_required decides the weight of comp;
361: || 5. in comp det, the value could be formula;
362: || (only one BIND Var :result could be used.)

Line 441: From IEX_SCORES scr, IEX_SCORE_COMPONENTS scomp

437: -- Begin - Andre Araujo - 12/17/2004 - Store del_buffers only if we need to
438: Begin -- This will be an exception block
439: Select NVL(CONCURRENT_PROG_NAME, 'X')
440: Into l_conc_prog_name
441: From IEX_SCORES scr, IEX_SCORE_COMPONENTS scomp
442: Where scomp.score_component_id = p_score_comp_tbl(1).SCORE_COMPONENT_ID
443: AND scr.Score_ID = scomp.score_id;
444: exception
445: when OTHERS THEN

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

729: || Overview: score all objects for a given scoring engine
730: ||
731: || Parameter: p_score_id => scoring engine ID
732: ||
733: || Source Tables: IEX_SCORES, IEX_SCORE_COMPONENTS_VL, IEX_SCORE_COMP_TYPES, IEX_SCORE_COMP_DET,
734: || IEX_OBJECT_FILTERS
735: ||
736: || Target Tables:
737: ||

Line 824: from iex_scores

820: --
821:
822: -- initial variables needed
823: select jtf_object_code into l_object_type
824: from iex_scores
825: where score_id = p_score_id;
826:
827: -- enumerate components for this scoring engine
828: iex_score_new_pvt.getComponents(p_score_id => p_score_id ,

Line 929: From IEX_SCORES scr, fnd_concurrent_programs cp

925: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Finding any process to spawn...');
926: END IF;
927: Select NVL(cp.Concurrent_Program_Name, 'X')
928: Into l_conc_prog_name
929: From IEX_SCORES scr, fnd_concurrent_programs cp
930: Where scr.concurrent_prog_name = cp.concurrent_program_name AND
931: scr.Score_ID = p_score_id;
932: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: Spawning ' || l_conc_prog_name);
933:

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

1076: || Overview: score a single object given it's ID, it's Type, and it's Scoring Engine
1077: ||
1078: || Parameter: p_score_id => scoring engine ID
1079: ||
1080: || Source Tables: IEX_SCORES, IEX_SCORE_COMPONENTS_VL, IEX_SCORE_COMP_TYPES, IEX_SCORE_COMP_DET,
1081: || IEX_OBJECT_FILTERS
1082: ||
1083: || Target Tables:
1084: ||

Line 1823: from iex_scores

1819: END IF;
1820:
1821: -- initial variables needed
1822: select jtf_object_code into l_object_type
1823: from iex_scores
1824: where score_id = p_score_id;
1825:
1826: FORALL n in i..i + p_scores_tbl.count - 1
1827: insert into iex_score_histories(SCORE_HISTORY_ID

Line 1936: from iex_scores

1932: END IF;
1933:
1934: -- initial variables needed
1935: select jtf_object_code into l_object_type
1936: from iex_scores
1937: where score_id = p_score_id;
1938:
1939:
1940: FORALL n in i..i + p_scores_tbl.count - 1