DBA Data[Home] [Help]

APPS.BIS_ALERT_SERVICE_PVT dependencies on BIS_DIM_LEVEL_VALUE_PUB

Line 55: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

51: -----------------------------------------------------
52:
53: Procedure Submit_Planning_Request
54: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
55: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
56: , p_alert_type IN VARCHAR2 := NULL
57: , p_alert_level IN VARCHAR2 := NULL
58: );
59:

Line 62: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

58: );
59:
60: Procedure Submit_Planning_Request
61: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
62: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
63: , p_primary_dim_level_rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
64: , p_notify_set IN VARCHAR2
65: , p_alert_type IN VARCHAR2
66: , p_alert_level IN VARCHAR2

Line 112: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

108: , P_notify_set IN VARCHAR2 := NULL
109: , p_alert_type IN VARCHAR2 := NULL
110: , p_alert_level IN VARCHAR2 := NULL
111: , x_measure_instance OUT NOCOPY BIS_MEASURE_PUB.Measure_Instance_type
112: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
113: );
114:
115: -- For future enhencements
116: --

Line 160: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

156: , P_notify_set IN VARCHAR2 := NULL
157: , p_alert_type IN VARCHAR2 := NULL
158: , p_alert_level IN VARCHAR2 := NULL
159: , x_measure_instance OUT NOCOPY BIS_MEASURE_PUB.Measure_Instance_type
160: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
161: , x_primary_dim_level_rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
162: , x_notify_set OUT NOCOPY VARCHAR2
163: , x_alert_type OUT NOCOPY VARCHAR2
164: , x_alert_level OUT NOCOPY VARCHAR2

Line 349: l_Dim_Level_Value_Tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;

345: )
346: IS
347:
348: l_Measure_Instance BIS_MEASURE_PUB.Measure_Instance_type;
349: l_Dim_Level_Value_Tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
350: l_alert_request_tbl BIS_ALERT_SERVICE_PVT.Alert_Request_Tbl_Type;
351: l_alert_request_rec BIS_ALERT_SERVICE_PVT.Alert_Request_Rec_Type;
352: l_return_status VARCHAR2(1000);
353: l_return_msg VARCHAR2(32000);

Line 452: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

448: END Service_Alert_Request_Pvt;
449:
450: Procedure Submit_Planning_Request
451: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
452: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
453: , p_alert_type IN VARCHAR2 := NULL
454: , p_alert_level IN VARCHAR2 := NULL
455: )
456: IS

Line 486: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

482: -- for future enhencements
483: --
484: Procedure Submit_Planning_Request
485: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
486: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
487: , p_primary_dim_level_rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
488: , P_notify_set IN VARCHAR2
489: , p_alert_type IN VARCHAR2
490: , p_alert_level IN VARCHAR2

Line 704: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

700: , P_notify_set IN VARCHAR2 := NULL
701: , p_alert_type IN VARCHAR2 := NULL
702: , p_alert_level IN VARCHAR2 := NULL
703: , x_measure_instance OUT NOCOPY BIS_MEASURE_PUB.Measure_Instance_type
704: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
705: )
706: IS
707:
708: l_measure_instance BIS_MEASURE_PUB.measure_instance_Type;

Line 709: l_Dim_Level_Value_Tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;

705: )
706: IS
707:
708: l_measure_instance BIS_MEASURE_PUB.measure_instance_Type;
709: l_Dim_Level_Value_Tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
710:
711: BEGIN
712:
713: l_measure_instance := x_measure_instance;

Line 849: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

845: , P_notify_set IN VARCHAR2 := NULL
846: , p_alert_type IN VARCHAR2 := NULL
847: , p_alert_level IN VARCHAR2 := NULL
848: , x_measure_instance OUT NOCOPY BIS_MEASURE_PUB.Measure_Instance_type
849: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
850: , x_primary_dim_level_rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
851: , x_notify_set OUT NOCOPY VARCHAR2
852: , x_alert_type OUT NOCOPY VARCHAR2
853: , x_alert_level OUT NOCOPY VARCHAR2