eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_WEIGHTED_MEASURE_PUB dependencies on FND_TABLE_OF_NUMBER

Line 44: ,p_Param_Ids IN FND_TABLE_OF_NUMBER

40: -- entries in Step1
41: ************************************************************************************/
42: PROCEDURE Delete_Bulk_Weights_Scores(
43: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
44: ,p_Param_Ids IN FND_TABLE_OF_NUMBER
45: ,p_dependent_measure_id IN NUMBER := NULL
46: ,x_return_status OUT NOCOPY VARCHAR2
47: ,x_msg_count OUT NOCOPY NUMBER
48: ,x_msg_data OUT NOCOPY VARCHAR2

Line 50: l_Weight_Ids FND_TABLE_OF_NUMBER;

46: ,x_return_status OUT NOCOPY VARCHAR2
47: ,x_msg_count OUT NOCOPY NUMBER
48: ,x_msg_data OUT NOCOPY VARCHAR2
49: ) IS
50: l_Weight_Ids FND_TABLE_OF_NUMBER;
51: BEGIN
52: SAVEPOINT BisDeleteBulkWeightsScores;
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:

Line 64: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(p_Param_Ids AS FND_TABLE_OF_NUMBER)));

60: l_Weight_Ids
61: FROM
62: bis_weighted_measure_weights weights
63: WHERE
64: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(p_Param_Ids AS FND_TABLE_OF_NUMBER)));
65: ELSE
66: SELECT
67: weights.weight_id
68: BULK COLLECT INTO

Line 73: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(p_Param_Ids AS FND_TABLE_OF_NUMBER))) AND

69: l_Weight_Ids
70: FROM
71: bis_weighted_measure_weights weights
72: WHERE
73: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(p_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
74: dependent_measure_id = p_dependent_measure_id;
75: END IF;
76:
77: FORALL i in 1..l_Weight_Ids.COUNT

Line 151: l_Param_Ids FND_TABLE_OF_NUMBER;

147: ,x_return_status OUT NOCOPY VARCHAR2
148: ,x_msg_count OUT NOCOPY NUMBER
149: ,x_msg_data OUT NOCOPY VARCHAR2
150: ) IS
151: l_Param_Ids FND_TABLE_OF_NUMBER;
152: l_Weight_Ids FND_TABLE_OF_NUMBER;
153: BEGIN
154: SAVEPOINT BisDeleteCascadeWMParameters;
155: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 152: l_Weight_Ids FND_TABLE_OF_NUMBER;

148: ,x_msg_count OUT NOCOPY NUMBER
149: ,x_msg_data OUT NOCOPY VARCHAR2
150: ) IS
151: l_Param_Ids FND_TABLE_OF_NUMBER;
152: l_Weight_Ids FND_TABLE_OF_NUMBER;
153: BEGIN
154: SAVEPOINT BisDeleteCascadeWMParameters;
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156:

Line 174: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER)));

170: l_Weight_Ids
171: FROM
172: bis_weighted_measure_weights weights
173: WHERE
174: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER)));
175:
176: Delete_Bulk_Weights_Scores (
177: p_commit => FND_API.G_FALSE
178: ,p_Param_Ids => l_Param_Ids

Line 3171: l_Definition_Ids FND_TABLE_OF_NUMBER;

3167: ,x_return_status OUT NOCOPY VARCHAR2
3168: ,x_msg_count OUT NOCOPY NUMBER
3169: ,x_msg_data OUT NOCOPY VARCHAR2
3170: ) IS
3171: l_Definition_Ids FND_TABLE_OF_NUMBER;
3172: l_Param_Ids FND_TABLE_OF_NUMBER;
3173: l_Insert_Param_Ids FND_TABLE_OF_NUMBER;
3174: l_Update_Param_Ids FND_TABLE_OF_NUMBER;
3175: l_count NUMBER;

Line 3172: l_Param_Ids FND_TABLE_OF_NUMBER;

3168: ,x_msg_count OUT NOCOPY NUMBER
3169: ,x_msg_data OUT NOCOPY VARCHAR2
3170: ) IS
3171: l_Definition_Ids FND_TABLE_OF_NUMBER;
3172: l_Param_Ids FND_TABLE_OF_NUMBER;
3173: l_Insert_Param_Ids FND_TABLE_OF_NUMBER;
3174: l_Update_Param_Ids FND_TABLE_OF_NUMBER;
3175: l_count NUMBER;
3176: l_User_Id NUMBER;

Line 3173: l_Insert_Param_Ids FND_TABLE_OF_NUMBER;

3169: ,x_msg_data OUT NOCOPY VARCHAR2
3170: ) IS
3171: l_Definition_Ids FND_TABLE_OF_NUMBER;
3172: l_Param_Ids FND_TABLE_OF_NUMBER;
3173: l_Insert_Param_Ids FND_TABLE_OF_NUMBER;
3174: l_Update_Param_Ids FND_TABLE_OF_NUMBER;
3175: l_count NUMBER;
3176: l_User_Id NUMBER;
3177: l_Login_Id NUMBER;

Line 3174: l_Update_Param_Ids FND_TABLE_OF_NUMBER;

3170: ) IS
3171: l_Definition_Ids FND_TABLE_OF_NUMBER;
3172: l_Param_Ids FND_TABLE_OF_NUMBER;
3173: l_Insert_Param_Ids FND_TABLE_OF_NUMBER;
3174: l_Update_Param_Ids FND_TABLE_OF_NUMBER;
3175: l_count NUMBER;
3176: l_User_Id NUMBER;
3177: l_Login_Id NUMBER;
3178:

Line 3220: params.weighted_definition_id in (SELECT column_value FROM TABLE(CAST(l_Definition_Ids AS FND_TABLE_OF_NUMBER)));

3216: l_Param_Ids
3217: FROM
3218: bis_weighted_measure_params params
3219: WHERE
3220: params.weighted_definition_id in (SELECT column_value FROM TABLE(CAST(l_Definition_Ids AS FND_TABLE_OF_NUMBER)));
3221:
3222: IF l_Param_Ids.COUNT > 0 THEN
3223: SELECT
3224: column_value

Line 3228: (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))

3224: column_value
3225: BULK COLLECT INTO
3226: l_Insert_Param_Ids
3227: FROM
3228: (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))
3229: MINUS
3230: SELECT
3231: weights.weighted_parameter_id
3232: FROM

Line 3235: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND

3231: weights.weighted_parameter_id
3232: FROM
3233: bis_weighted_measure_weights weights
3234: WHERE
3235: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
3236: weights.dependent_measure_id = p_dependent_measure_id);
3237:
3238: SELECT
3239: weights.weighted_parameter_id

Line 3245: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND

3241: l_Update_Param_Ids
3242: FROM
3243: bis_weighted_measure_weights weights
3244: WHERE
3245: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
3246: weights.dependent_measure_id = p_dependent_measure_id;
3247:
3248: IF l_Update_Param_Ids.COUNT > 0 THEN
3249: IF p_Weight IS NOT NULL THEN

Line 3346: ,p_weights IN FND_TABLE_OF_NUMBER

3342: Procedure Set_Weights_Data(
3343: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
3344: ,p_weighted_measure_id IN NUMBER
3345: ,p_depend_measure_short_names IN FND_TABLE_OF_VARCHAR2_30
3346: ,p_weights IN FND_TABLE_OF_NUMBER
3347: ,x_return_status OUT NOCOPY VARCHAR2
3348: ,x_msg_count OUT NOCOPY NUMBER
3349: ,x_msg_data OUT NOCOPY VARCHAR2
3350: )is

Line 3519: l_Param_Ids FND_TABLE_OF_NUMBER;

3515: ,x_msg_count OUT NOCOPY NUMBER
3516: ,x_msg_data OUT NOCOPY VARCHAR2
3517: )
3518: IS
3519: l_Param_Ids FND_TABLE_OF_NUMBER;
3520: l_Weight_Ids FND_TABLE_OF_NUMBER;
3521: BEGIN
3522: x_return_status := FND_API.G_RET_STS_SUCCESS;
3523: SAVEPOINT Bis_Delete_Mass_Update_Data;

Line 3520: l_Weight_Ids FND_TABLE_OF_NUMBER;

3516: ,x_msg_data OUT NOCOPY VARCHAR2
3517: )
3518: IS
3519: l_Param_Ids FND_TABLE_OF_NUMBER;
3520: l_Weight_Ids FND_TABLE_OF_NUMBER;
3521: BEGIN
3522: x_return_status := FND_API.G_RET_STS_SUCCESS;
3523: SAVEPOINT Bis_Delete_Mass_Update_Data;
3524:

Line 3553: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER)));

3549: FROM
3550: bis_weighted_measure_weights weights
3551: WHERE
3552: weights.dependent_measure_id = p_dependent_measure_id AND
3553: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER)));
3554:
3555: IF l_Weight_Ids.COUNT > 0 THEN
3556: Delete_Bulk_Weights_Scores (
3557: p_commit => FND_API.G_FALSE

Line 3611: ,p_Score_Values IN FND_TABLE_OF_NUMBER

3607: ,p_Time_Level IN VARCHAR2
3608: ,p_Filter_Level IN VARCHAR2
3609: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
3610: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
3611: ,p_Score_Values IN FND_TABLE_OF_NUMBER
3612: ,p_Lower_Ranges IN FND_TABLE_OF_NUMBER
3613: ,p_Upper_Ranges IN FND_TABLE_OF_NUMBER
3614: ,x_return_status OUT NOCOPY VARCHAR2
3615: ,x_msg_count OUT NOCOPY NUMBER

Line 3612: ,p_Lower_Ranges IN FND_TABLE_OF_NUMBER

3608: ,p_Filter_Level IN VARCHAR2
3609: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
3610: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
3611: ,p_Score_Values IN FND_TABLE_OF_NUMBER
3612: ,p_Lower_Ranges IN FND_TABLE_OF_NUMBER
3613: ,p_Upper_Ranges IN FND_TABLE_OF_NUMBER
3614: ,x_return_status OUT NOCOPY VARCHAR2
3615: ,x_msg_count OUT NOCOPY NUMBER
3616: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3613: ,p_Upper_Ranges IN FND_TABLE_OF_NUMBER

3609: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
3610: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
3611: ,p_Score_Values IN FND_TABLE_OF_NUMBER
3612: ,p_Lower_Ranges IN FND_TABLE_OF_NUMBER
3613: ,p_Upper_Ranges IN FND_TABLE_OF_NUMBER
3614: ,x_return_status OUT NOCOPY VARCHAR2
3615: ,x_msg_count OUT NOCOPY NUMBER
3616: ,x_msg_data OUT NOCOPY VARCHAR2
3617: )

Line 3621: l_depend_Measure_Ids FND_TABLE_OF_NUMBER;

3617: )
3618: IS
3619: l_Create_Time_Values BIS_TABLE_OF_VARCHAR;
3620: l_Create_Filter_Values BIS_TABLE_OF_VARCHAR;
3621: l_depend_Measure_Ids FND_TABLE_OF_NUMBER;
3622: l_Param_Ids FND_TABLE_OF_NUMBER;
3623: l_Weight_Ids FND_TABLE_OF_NUMBER;
3624: l_Default_Weight NUMBER;
3625: l_Count NUMBER := 0;

Line 3622: l_Param_Ids FND_TABLE_OF_NUMBER;

3618: IS
3619: l_Create_Time_Values BIS_TABLE_OF_VARCHAR;
3620: l_Create_Filter_Values BIS_TABLE_OF_VARCHAR;
3621: l_depend_Measure_Ids FND_TABLE_OF_NUMBER;
3622: l_Param_Ids FND_TABLE_OF_NUMBER;
3623: l_Weight_Ids FND_TABLE_OF_NUMBER;
3624: l_Default_Weight NUMBER;
3625: l_Count NUMBER := 0;
3626: l_Is_Update BOOLEAN;

Line 3623: l_Weight_Ids FND_TABLE_OF_NUMBER;

3619: l_Create_Time_Values BIS_TABLE_OF_VARCHAR;
3620: l_Create_Filter_Values BIS_TABLE_OF_VARCHAR;
3621: l_depend_Measure_Ids FND_TABLE_OF_NUMBER;
3622: l_Param_Ids FND_TABLE_OF_NUMBER;
3623: l_Weight_Ids FND_TABLE_OF_NUMBER;
3624: l_Default_Weight NUMBER;
3625: l_Count NUMBER := 0;
3626: l_Is_Update BOOLEAN;
3627: l_User_Id NUMBER;

Line 3753: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND

3749: l_Weight_Ids
3750: FROM
3751: bis_weighted_measure_weights weights
3752: WHERE
3753: weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
3754: weights.dependent_measure_id = p_dependent_measure_id;
3755:
3756:
3757: FOR i in 1..p_Score_Values.COUNT LOOP

Line 3818: ,p_Score_Values IN FND_TABLE_OF_NUMBER

3814: ,p_Time_Level IN VARCHAR2
3815: ,p_Filter_Level IN VARCHAR2
3816: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
3817: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
3818: ,p_Score_Values IN FND_TABLE_OF_NUMBER
3819: ,p_Lower_Ranges IN FND_TABLE_OF_NUMBER
3820: ,p_Upper_Ranges IN FND_TABLE_OF_NUMBER
3821: ,x_return_status OUT NOCOPY VARCHAR2
3822: ,x_msg_count OUT NOCOPY NUMBER

Line 3819: ,p_Lower_Ranges IN FND_TABLE_OF_NUMBER

3815: ,p_Filter_Level IN VARCHAR2
3816: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
3817: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
3818: ,p_Score_Values IN FND_TABLE_OF_NUMBER
3819: ,p_Lower_Ranges IN FND_TABLE_OF_NUMBER
3820: ,p_Upper_Ranges IN FND_TABLE_OF_NUMBER
3821: ,x_return_status OUT NOCOPY VARCHAR2
3822: ,x_msg_count OUT NOCOPY NUMBER
3823: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3820: ,p_Upper_Ranges IN FND_TABLE_OF_NUMBER

3816: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
3817: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
3818: ,p_Score_Values IN FND_TABLE_OF_NUMBER
3819: ,p_Lower_Ranges IN FND_TABLE_OF_NUMBER
3820: ,p_Upper_Ranges IN FND_TABLE_OF_NUMBER
3821: ,x_return_status OUT NOCOPY VARCHAR2
3822: ,x_msg_count OUT NOCOPY NUMBER
3823: ,x_msg_data OUT NOCOPY VARCHAR2
3824: )

Line 3920: l_Param_Ids FND_TABLE_OF_NUMBER;

3916: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
3917: ,x_Param_Count OUT NOCOPY NUMBER
3918: ) IS
3919:
3920: l_Param_Ids FND_TABLE_OF_NUMBER;
3921:
3922: BEGIN
3923: SELECT
3924: params.weighted_parameter_id

Line 3954: b.weighted_parameter_id in (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND

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
3955: b.dependent_measure_id = p_dependent_measure_id;
3956: END IF;
3957:
3958: EXCEPTION