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 BIS_TABLE_OF_VARCHAR

Line 3512: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR

3508: PROCEDURE Delete_Mass_Update_Data(
3509: p_commit IN VARCHAR2 := FND_API.G_FALSE
3510: ,p_weighted_definition_id IN NUMBER
3511: ,p_dependent_measure_id IN NUMBER
3512: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
3513: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
3514: ,x_return_status OUT NOCOPY VARCHAR2
3515: ,x_msg_count OUT NOCOPY NUMBER
3516: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3513: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR

3509: p_commit IN VARCHAR2 := FND_API.G_FALSE
3510: ,p_weighted_definition_id IN NUMBER
3511: ,p_dependent_measure_id IN NUMBER
3512: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
3513: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
3514: ,x_return_status OUT NOCOPY VARCHAR2
3515: ,x_msg_count OUT NOCOPY NUMBER
3516: ,x_msg_data OUT NOCOPY VARCHAR2
3517: )

Line 3535: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,

3531: (SELECT
3532: a.column_value filter_level_value_id,
3533: b.column_value time_level_value_id
3534: FROM
3535: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
3536: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams
3537: WHERE
3538: params.weighted_definition_id = p_weighted_definition_id AND
3539: params.time_level_value_id <> 'DEFAULT' AND

Line 3536: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams

3532: a.column_value filter_level_value_id,
3533: b.column_value time_level_value_id
3534: FROM
3535: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
3536: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams
3537: WHERE
3538: params.weighted_definition_id = p_weighted_definition_id AND
3539: params.time_level_value_id <> 'DEFAULT' AND
3540: params.filter_level_value_id <> 'DEFAULT' AND

Line 3609: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR

3605: ,p_weighted_definition_id IN NUMBER
3606: ,p_dependent_measure_id IN 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

Line 3610: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR

3606: ,p_dependent_measure_id IN 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

Line 3619: l_Create_Time_Values BIS_TABLE_OF_VARCHAR;

3615: ,x_msg_count OUT NOCOPY NUMBER
3616: ,x_msg_data OUT NOCOPY VARCHAR2
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;

Line 3620: l_Create_Filter_Values BIS_TABLE_OF_VARCHAR;

3616: ,x_msg_data OUT NOCOPY VARCHAR2
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;

Line 3652: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,

3648: ( SELECT
3649: a.column_value filter_level_value_id,
3650: b.column_value time_level_value_id
3651: FROM
3652: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
3653: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B
3654: MINUS
3655: SELECT
3656: params.filter_level_value_id ,

Line 3653: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B

3649: a.column_value filter_level_value_id,
3650: b.column_value time_level_value_id
3651: FROM
3652: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
3653: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B
3654: MINUS
3655: SELECT
3656: params.filter_level_value_id ,
3657: params.time_level_value_id

Line 3699: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,

3695: (SELECT
3696: a.column_value filter_level_value_id,
3697: b.column_value time_level_value_id
3698: FROM
3699: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
3700: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams
3701: WHERE
3702: params.weighted_definition_id = p_weighted_definition_id AND
3703: params.time_level_value_id <> 'DEFAULT' AND

Line 3700: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams

3696: a.column_value filter_level_value_id,
3697: b.column_value time_level_value_id
3698: FROM
3699: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
3700: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams
3701: WHERE
3702: params.weighted_definition_id = p_weighted_definition_id AND
3703: params.time_level_value_id <> 'DEFAULT' AND
3704: params.filter_level_value_id <> 'DEFAULT' AND

Line 3816: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR

3812: ,p_weighted_measure_id IN NUMBER
3813: ,p_dependent_measure_id IN 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

Line 3817: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR

3813: ,p_dependent_measure_id IN 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

Line 3915: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR

3911: ************************************************************************************/
3912: PROCEDURE Validate_Overwrite_Scores(
3913: p_weighted_measure_id IN NUMBER
3914: ,p_dependent_measure_id IN NUMBER
3915: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
3916: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
3917: ,x_Param_Count OUT NOCOPY NUMBER
3918: ) IS
3919:

Line 3916: ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR

3912: PROCEDURE Validate_Overwrite_Scores(
3913: p_weighted_measure_id IN NUMBER
3914: ,p_dependent_measure_id IN NUMBER
3915: ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
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;

Line 3934: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,

3930: (SELECT
3931: a.column_value filter_level_value_id,
3932: b.column_value time_level_value_id
3933: FROM
3934: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
3935: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams
3936: WHERE
3937: defns.weighted_measure_id = p_weighted_measure_id AND
3938: params.weighted_definition_id = defns.weighted_definition_id AND

Line 3935: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams

3931: a.column_value filter_level_value_id,
3932: b.column_value time_level_value_id
3933: FROM
3934: (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
3935: (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams
3936: WHERE
3937: defns.weighted_measure_id = p_weighted_measure_id AND
3938: params.weighted_definition_id = defns.weighted_definition_id AND
3939: params.time_level_value_id <> 'DEFAULT' AND