APPS.BIS_CORRECTIVE_ACTION_PVT dependencies on BIS_TARGET_LEVEL_PUB

Line 237: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

233: l_item_type VARCHAR2(32000);
234: l_process VARCHAR2(32000);
235: l_Alert_recipients_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
236: l_Alert_recipients_sh_nm_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
237: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
238:
239: l_message VARCHAR2(32000);
240: l_message_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
241: l_schedule_date VARCHAR2(32000);

Line 363: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;

359: l_actual_rec BIS_ACTUAL_PUB.Actual_rec_type;
360: l_actual_rec1 BIS_ACTUAL_PUB.Actual_rec_type; -- 2164190 sashaik
361: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
362: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
363: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
364: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
365:
366: l_Dim_Level_Value_Rec_oltp BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
367: l_dimension_level_number_oltp NUMBER;

Line 443: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;

439: k NUMBER;
440:
441: l_dimension_level_rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
442: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
443: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
444: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
445:
446: ll_message VARCHAR2(500);
447:

Line 520: BIS_TARGET_LEVEL_PUB.Retrieve_target_level

516:
517: l_target_level_rec.measure_id := l_measure_rec.measure_id;
518:
519: l_target_level_rec_p := l_target_level_rec;
520: BIS_TARGET_LEVEL_PUB.Retrieve_target_level
521: (p_api_version => 1.0
522: ,p_target_level_rec => l_target_level_rec_p
523: ,x_target_level_rec => l_target_level_rec
524: ,x_return_status => l_return_status

Line 1594: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

1590: , x_message_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1591: )
1592: IS
1593:
1594: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
1595: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
1596:
1597: l_message_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
1598: l_Message_Banner_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;

Line 2001: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

1997: , x_process OUT NOCOPY VARCHAR2
1998: )
1999: IS
2000:
2001: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
2002:
2003: BEGIN
2004:
2005: BIS_PMF_DATA_SOURCE_PUB.Retrieve_Target_Level