DBA Data[Home] [Help]

APPS.BIS_ALERT_SERVICE_PVT dependencies on BIS_ALERT_SERVICE_PVT

Line 1: PACKAGE BODY BIS_ALERT_SERVICE_PVT AS

1: PACKAGE BODY BIS_ALERT_SERVICE_PVT AS
2: /* $Header: BISVALRB.pls 120.1 2005/11/18 05:51:18 ankgoel noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |

Line 47: G_PKG_NAME CONSTANT VARCHAR2(30):= 'BIS_ALERT_SERVICE_PVT';

43: -- Constants
44: --
45:
46: l_debug_text VARCHAR2(32000);
47: G_PKG_NAME CONSTANT VARCHAR2(30):= 'BIS_ALERT_SERVICE_PVT';
48:
49: -----------------------------------------------------
50: -- Procedures Forward declarations
51: -----------------------------------------------------

Line 178: ,x_Alert_request_Tbl OUT NOCOPY BIS_ALERT_SERVICE_PVT.Alert_request_Tbl_type

174: ,p_current_row IN VARCHAR2 := NULL
175: ,p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
176: , p_alert_type IN VARCHAR2 := NULL
177: , p_alert_level IN VARCHAR2 := NULL
178: ,x_Alert_request_Tbl OUT NOCOPY BIS_ALERT_SERVICE_PVT.Alert_request_Tbl_type
179: ,x_return_status OUT NOCOPY VARCHAR2
180: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
181: );
182:

Line 230: l_alert_request_tbl BIS_ALERT_SERVICE_PVT.Alert_Request_Tbl_Type;

226: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
227: )
228: IS
229:
230: l_alert_request_tbl BIS_ALERT_SERVICE_PVT.Alert_Request_Tbl_Type;
231: l_Concurrent_Request_Tbl BIS_CONCURRENT_MANAGER_PVT.PMF_Request_Tbl_Type;
232: l_request_id_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
233:
234: l_return_status VARCHAR2(1000);

Line 350: l_alert_request_tbl BIS_ALERT_SERVICE_PVT.Alert_Request_Tbl_Type;

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);
354:

Line 351: l_alert_request_rec BIS_ALERT_SERVICE_PVT.Alert_Request_Rec_Type;

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);
354:
355: BEGIN

Line 886: l_Alert_Request_rec BIS_ALERT_SERVICE_PVT.Alert_Request_rec_Type;

882: , x_Alert_Request_rec OUT NOCOPY Alert_Request_rec_Type
883: )
884: IS
885:
886: l_Alert_Request_rec BIS_ALERT_SERVICE_PVT.Alert_Request_rec_Type;
887:
888: BEGIN
889: --BIS_UTILITIES_PUB.put_line(p_text =>'in form alert request: target id: '||p_target_rec.target_id);
890:

Line 1000: ,x_Alert_request_Tbl OUT NOCOPY BIS_ALERT_SERVICE_PVT.Alert_request_Tbl_type

996: ,p_current_row IN VARCHAR2 := NULL
997: ,p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
998: , p_alert_type IN VARCHAR2 := NULL
999: , p_alert_level IN VARCHAR2 := NULL
1000: ,x_Alert_request_Tbl OUT NOCOPY BIS_ALERT_SERVICE_PVT.Alert_request_Tbl_type
1001: ,x_return_status OUT NOCOPY VARCHAR2
1002: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1003: )
1004: IS

Line 1186: END BIS_ALERT_SERVICE_PVT;

1182: );
1183: End Retrieve_All_Request_Rows;
1184:
1185:
1186: END BIS_ALERT_SERVICE_PVT;