APPS.IEX_SCORE_NEW_PVT dependencies on IEX_SCORE_COMP_DET

Line 346: || Source Tables: iex_score_comp_det

342: ||
343: || 11/02/04 acaraujo x_scores_tbl returns the bridge to the next concurrent prog.
344: || and scores are store as per the G_BATCH_SIZE to the history table
345: ||
346: || Source Tables: iex_score_comp_det
347: ||
348: || Target Tables: NA
349: ||
350: || Creation date: 01/14/02 5:27:PM

Line 513: -- FROM iex_score_comp_det

509: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Failed to calculate for component ' || l_score_component_id );
510: -- END IF;
511: -- SELECT Range_Low
512: -- BULK COLLECT INTO l_component_range_tbl
513: -- FROM iex_score_comp_det
514: -- where score_component_id = l_score_component_id
515: -- order by value;
516: --
517: -- if l_component_range_tbl(1) < l_component_range_tbl(2) then

Line 540: -- -- new column NEW_VALUE instead of VALUE in iex_score_comp_det;

536: -- /* 4. For each component value, get the details of the component
537: -- and store the value for that score_comp_detail */
538: -- BEGIN
539: -- -- clchang updated 10/18/04 for 11.5.11
540: -- -- new column NEW_VALUE instead of VALUE in iex_score_comp_det;
541: -- --vSql := 'SELECT VALUE ' ||
542: -- vSql := 'SELECT upper(NEW_VALUE) ' ||
543: -- ' FROM IEX_SCORE_COMP_DET ' ||
544: -- ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||

Line 543: -- ' FROM IEX_SCORE_COMP_DET ' ||

539: -- -- clchang updated 10/18/04 for 11.5.11
540: -- -- new column NEW_VALUE instead of VALUE in iex_score_comp_det;
541: -- --vSql := 'SELECT VALUE ' ||
542: -- vSql := 'SELECT upper(NEW_VALUE) ' ||
543: -- ' FROM IEX_SCORE_COMP_DET ' ||
544: -- ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||
545: -- ' :p_component_score >= RANGE_LOW AND ' ||
546: -- ' :p_component_score <= RANGE_HIGH ';
547: -- if PG_DEBUG <= 5 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 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 2096: FROM iex_score_comp_det

2092: END IF;
2093:
2094: SELECT Range_Low
2095: BULK COLLECT INTO l_component_range_tbl
2096: FROM iex_score_comp_det
2097: where score_component_id = l_score_component_id
2098: order by value;
2099:
2100: IF PG_DEBUG <= 5 THEN

Line 2133: -- new column NEW_VALUE instead of VALUE in iex_score_comp_det;

2129: /* 4. For each component value, get the details of the component
2130: and store the value for that score_comp_detail */
2131: BEGIN
2132: -- clchang updated 10/18/04 for 11.5.11
2133: -- new column NEW_VALUE instead of VALUE in iex_score_comp_det;
2134: --vSql := 'SELECT VALUE ' ||
2135: vSql := 'SELECT upper(NEW_VALUE) ' ||
2136: ' FROM IEX_SCORE_COMP_DET ' ||
2137: ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||

Line 2136: ' FROM IEX_SCORE_COMP_DET ' ||

2132: -- clchang updated 10/18/04 for 11.5.11
2133: -- new column NEW_VALUE instead of VALUE in iex_score_comp_det;
2134: --vSql := 'SELECT VALUE ' ||
2135: vSql := 'SELECT upper(NEW_VALUE) ' ||
2136: ' FROM IEX_SCORE_COMP_DET ' ||
2137: ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||
2138: ' :p_component_score >= RANGE_LOW AND ' ||
2139: ' :p_component_score <= RANGE_HIGH ';
2140: if PG_DEBUG <= 5 then