1 PACKAGE BIS_PMF_ALERT_REG_PUB AUTHID CURRENT_USER AS
2 /* $Header: BISPARTS.pls 115.18 2002/12/20 11:26:01 mahrao ship $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISPMEAS.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Public API for managing Alert Registration Repository
14 REM |
15 REM | NOTES |
16 REM | |
17 REM | HISTORY |
18 REM | 17-May-2000 jradhakr Creation
19 REM |
20 REM +=======================================================================+
21 */
22
23
24 -- Data Types: Records
25
26 TYPE parameter_set_rec_type IS RECORD
27 ( REGISTRATION_ID NUMBER
28 , PERFORMANCE_MEASURE_ID NUMBER
29 , TARGET_LEVEL_ID NUMBER
30 , TIME_DIMENSION_LEVEL_ID NUMBER
31 , PLAN_ID NUMBER
32 , NOTIFIERS_CODE VARCHAR2(250)
33 , PARAMETER1_VALUE VARCHAR2(80)
34 , PARAMETER2_VALUE VARCHAR2(80)
35 , PARAMETER3_VALUE VARCHAR2(80)
36 , PARAMETER4_VALUE VARCHAR2(80)
37 , PARAMETER5_VALUE VARCHAR2(80)
38 , PARAMETER6_VALUE VARCHAR2(80)
39 , PARAMETER7_VALUE VARCHAR2(80)
40 , NOTIFY_OWNER_FLAG VARCHAR2(1)
41 );
42
43 -- Data Types: Tables
44 --
45 TYPE parameter_set_tbl_type IS TABLE of parameter_set_rec_type
46 INDEX BY BINARY_INTEGER;
47 --
48 -- Global Missing Composite Types
49 --
50 --
51 -- PROCEDUREs
52 --
53 -- creates one parameter set
54
55
56 PROCEDURE Create_Parameter_set
57 ( p_api_version IN NUMBER
58 , p_commit IN VARCHAR2 := FND_API.G_FALSE
59 , p_Param_Set_Rec IN OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
60 , x_return_status OUT NOCOPY VARCHAR2
61 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
62 );
63
64 --
65 -- Delete one parameter set.
66 --
67 PROCEDURE Delete_Parameter_set
68 ( p_api_version IN NUMBER
69 , p_commit IN VARCHAR2 := FND_API.G_FALSE
70 , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
71 , x_return_status OUT NOCOPY VARCHAR2
72 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
73 );
74
75 --
76 -- Retrieve a Table of parmeter set.
77 --
78 PROCEDURE Retrieve_Parameter_set
79 ( p_api_version IN NUMBER
80 , p_measure_id IN NUMBER
81 , p_time_dimension_level_id IN NUMBER
82 , p_current_row IN VARCHAR2 := NULL
83 , x_Param_Set_Tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
84 , x_return_status OUT NOCOPY VARCHAR2
85 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
86 );
87
88 --
89 -- Checks if request is scheduled to run again. If not, the request
90 -- is deleted from the Registration table and the ad hoc workflow role
91 -- is removed.
92 --
93 PROCEDURE Manage_Alert_Registrations
94 ( p_Param_Set_Tbl IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
95 , x_request_scheduled OUT NOCOPY VARCHAR2
96 , x_return_status OUT NOCOPY VARCHAR2
97 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
98 );
99
100 PROCEDURE Manage_Alert_Registrations
101 ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
102 , x_request_scheduled OUT NOCOPY VARCHAR2
103 , x_return_status OUT NOCOPY VARCHAR2
104 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
105 );
106
107 --
108 -- Function which will return a boolean varible, if parameter set exist
109 -- and will also return the notifiers_code
110 --
111
112 FUNCTION Parameter_set_exist
113 ( p_api_version IN NUMBER
114 , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
115 , x_notifiers_code OUT NOCOPY VARCHAR2
116 , x_return_status OUT NOCOPY VARCHAR2
117 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
118 ) return boolean;
119
120 END BIS_PMF_ALERT_REG_PUB;