APPS.BIS_WEIGHTED_MEASURE_PUB dependencies on BIS_WEIGHTED_MEASURE_SCORES

Line 79: bis_weighted_measure_scores

75: END IF;
76:
77: FORALL i in 1..l_Weight_Ids.COUNT
78: DELETE FROM
79: bis_weighted_measure_scores
80: WHERE
81: weight_id = l_Weight_Ids(i);
82:
83: FORALL i in 1..l_Weight_Ids.COUNT

Line 1636: ------- APIs for table BIS_WEIGHTED_MEASURE_SCORES

1632: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1633: raise;
1634: END Delete_WM_Weight;
1635:
1636: ------- APIs for table BIS_WEIGHTED_MEASURE_SCORES
1637: /*******************************************************************
1638: *******************************************************************/
1639: PROCEDURE Create_WM_Score(
1640: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

Line 3760: INSERT INTO bis_weighted_measure_scores(

3756:
3757: FOR i in 1..p_Score_Values.COUNT LOOP
3758: IF (p_Lower_Ranges(i) IS NOT NULL OR p_Upper_Ranges(i) IS NOT NULL) THEN
3759: FORALL j IN 1..l_Weight_Ids.COUNT
3760: INSERT INTO bis_weighted_measure_scores(
3761: weight_id
3762: ,low_range
3763: ,high_range
3764: ,score

Line 3950: bis_weighted_measure_scores a,

3946: COUNT(1)
3947: INTO
3948: x_Param_Count
3949: FROM
3950: bis_weighted_measure_scores a,
3951: bis_weighted_measure_weights b
3952: WHERE
3953: a.weight_id = b.weight_id AND
3954: b.weighted_parameter_id in (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND