APPS.IEX_SCORE_NEW_PVT dependencies on IEX_SCORE_COMP_DET

Line 450: || Source Tables: iex_score_comp_det

446: ||
447: || 11/02/04 acaraujo x_scores_tbl returns the bridge to the next concurrent prog.
448: || and scores are store as per the G_BATCH_SIZE to the history table
449: ||
450: || Source Tables: iex_score_comp_det
451: ||
452: || Target Tables: NA
453: ||
454: || Creation date: 01/14/02 5:27:PM

Line 706: -- FROM iex_score_comp_det

702: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Failed to calculate for component ' || l_score_component_id );
703: -- END IF;
704: -- SELECT Range_Low
705: -- BULK COLLECT INTO l_component_range_tbl
706: -- FROM iex_score_comp_det
707: -- where score_component_id = l_score_component_id
708: -- order by value;
709: --
710: -- if l_component_range_tbl(1) < l_component_range_tbl(2) then

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

729: -- /* 4. For each component value, get the details of the component
730: -- and store the value for that score_comp_detail */
731: -- BEGIN
732: -- -- clchang updated 10/18/04 for 11.5.11
733: -- -- new column NEW_VALUE instead of VALUE in iex_score_comp_det;
734: -- --vSql := 'SELECT VALUE ' ||
735: -- vSql := 'SELECT upper(NEW_VALUE) ' ||
736: -- ' FROM IEX_SCORE_COMP_DET ' ||
737: -- ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||

Line 736: -- ' FROM IEX_SCORE_COMP_DET ' ||

732: -- -- clchang updated 10/18/04 for 11.5.11
733: -- -- new column NEW_VALUE instead of VALUE in iex_score_comp_det;
734: -- --vSql := 'SELECT VALUE ' ||
735: -- vSql := 'SELECT upper(NEW_VALUE) ' ||
736: -- ' FROM IEX_SCORE_COMP_DET ' ||
737: -- ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||
738: -- ' :p_component_score >= RANGE_LOW AND ' ||
739: -- ' :p_component_score <= RANGE_HIGH ';
740: -- if PG_DEBUG <= 5 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 1221: from iex_score_comp_det

1217:
1218: begin
1219: select count(*)
1220: into l_cnt
1221: from iex_score_comp_det
1222: where score_component_id=l_components_tbl(comp).score_component_id;
1223: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'count in comp_det tab-->'||l_cnt);
1224: for cnt in 1..l_cnt loop
1225: select range_low,range_high,new_value

Line 1227: from iex_score_comp_det sc_det

1223: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'count in comp_det tab-->'||l_cnt);
1224: for cnt in 1..l_cnt loop
1225: select range_low,range_high,new_value
1226: bulk collect into l_sc_range_low,l_sc_range_high,l_sc_val
1227: from iex_score_comp_det sc_det
1228: where score_component_id=l_components_tbl(comp).score_component_id;
1229: end loop;
1230: if l_sc_range_low.count > 0 then
1231: for val in l_sc_range_low.first..l_sc_range_low.last loop

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 2797: FROM iex_score_comp_det

2793: END IF;
2794:
2795: SELECT Range_Low
2796: BULK COLLECT INTO l_component_range_tbl
2797: FROM iex_score_comp_det
2798: where score_component_id = l_score_component_id
2799: order by value;
2800:
2801: IF PG_DEBUG <= 5 THEN

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

2864: /* 4. For each component value, get the details of the component
2865: and store the value for that score_comp_detail */
2866: BEGIN
2867: -- clchang updated 10/18/04 for 11.5.11
2868: -- new column NEW_VALUE instead of VALUE in iex_score_comp_det;
2869: --vSql := 'SELECT VALUE ' ||
2870: vSql := 'SELECT upper(NEW_VALUE) ' ||
2871: ' FROM IEX_SCORE_COMP_DET ' ||
2872: ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||

Line 2871: ' FROM IEX_SCORE_COMP_DET ' ||

2867: -- clchang updated 10/18/04 for 11.5.11
2868: -- new column NEW_VALUE instead of VALUE in iex_score_comp_det;
2869: --vSql := 'SELECT VALUE ' ||
2870: vSql := 'SELECT upper(NEW_VALUE) ' ||
2871: ' FROM IEX_SCORE_COMP_DET ' ||
2872: ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||
2873: ' :p_component_score >= RANGE_LOW AND ' ||
2874: ' :p_component_score <= RANGE_HIGH ';
2875: if PG_DEBUG <= 5 then