APPS.IEX_SCORE_NEW_PVT dependencies on IEX_SCORE_COMPONENTS

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 367: || 1. new column METRIC_FLAG in iex_score_components

363: || 01/14/02 raverma created
364: || 03/12/02 raverma added function_flag to return tbl
365: || 10/18/04 clchang updated this procedure for scoring engine enhancement
366: || in 11.5.11.
367: || 1. new column METRIC_FLAG in iex_score_components
368: */
369: PROCEDURE getComponents(P_SCORE_ID IN NUMBER,
370: X_SCORE_COMP_TBL OUT NOCOPY IEX_SCORE_NEW_PVT.SCORE_ENG_COMP_TBL)
371: IS

Line 460: || 1. new column METRIC_FLAG in iex_score_components

456: || Major Modifications: when who what
457: || 01/14/02 raverma created
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;

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 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 1196: FROM iex_score_components sc,

1192: sc_typ.function_flag,
1193: sc.score_comp_weight,
1194: sc_typ.score_comp_value
1195: into l_score_comp_name,l_function_flg,l_score_comp_wgt,l_score_comp_val
1196: FROM iex_score_components sc,
1197: iex_score_comp_types_tl sc_typ_tl,
1198: iex_score_comp_types_b sc_typ
1199: WHERE sc.score_comp_type_id = sc_typ.score_comp_type_id
1200: AND sc_typ.score_comp_type_id= sc_typ_tl.score_comp_type_id

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 2851: from iex_score_components sc, iex_score_comp_types_tl sctl

2847: l_xml_body_1:=l_xml_body_1||l_new_line||''||l_score_component_id||'';
2848: begin
2849: select sctl.score_comp_name,sc.score_comp_weight
2850: into l_score_comp_name,l_score_comp_wtg
2851: from iex_score_components sc, iex_score_comp_types_tl sctl
2852: where sc.score_comp_type_id=sctl.score_comp_type_id
2853: and sc.score_component_id=l_score_component_id
2854: and sctl.language='US';
2855: l_xml_body_1:=l_xml_body_1||l_new_line||''||format_string(l_score_comp_name)||'';