[Home] [Help]
Skip to content
PACKAGE: APPS.BIS_PMF_REG_SERVICE_PVT
Source
1 PACKAGE BIS_PMF_REG_SERVICE_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVARSS.pls 115.27 2003/12/15 14:15:34 arhegde ship $ */
3
4 G_TARGET_LEVEL VARCHAR2(80) := 'FROMTARGETLEVEL';
5 G_ALL_TARGET VARCHAR2(80) := 'ALLTARGET';
6 G_REPORT_GEN VARCHAR2(80) := 'GENERATED_REPORT';
7 G_REPORT_BATCH VARCHAR2(80) := 'REPORT_BATCH';
8 G_ALERT_CONC_REQ_NAME CONSTANT VARCHAR2(1000) := 'BIS_PMF_ALERT';
9
10 G_NOTSUBMIT VARCHAR2(10000) := fnd_message.get_string('BIS','BIS_NO_CONC');
11 G_FAILED_MSG CONSTANT VARCHAR2(10000) := 'BIS_CONC_FAILED';
12 G_SUCCESS_MSG CONSTANT VARCHAR2(10000) := 'BIS_CONC_SUCCESS';
13 G_REQUEST_ID_TOK CONSTANT VARCHAR2(10000) := 'REQUEST_ID';
14 G_USER_EXIST VARCHAR2(10000) := fnd_message.get_string('BIS','BIS_USER_EXIST');
15 G_REQUEST_EXIST VARCHAR2(10000)
16 := fnd_message.get_string('BIS','BIS_REQUEST_EXIST');
17
18 --
19 -- Procedure Which accepts all the parameters from the Alert
20 -- Registration screen, processes the information and submits the request
21 --
22
23 PROCEDURE process_parameter_full_set
24 (p_request_id OUT NOCOPY varchar2
25 ,p_StartTime IN varchar2 default null
26 ,p_EndTime IN varchar2 default null
27 ,p_frequencyInterval IN varchar2 default null
28 ,p_frequencyUnits IN varchar2 default null
29 ,p_perf_measure_id IN varchar2 default null
30 ,p_target_level_id IN varchar2 default null
31 ,p_time_dim_level_id IN varchar2 default null
32 ,p_notifiers IN varchar2 default null
33 ,p_plan_id IN varchar2 default null
34 ,p_parameter1_level IN varchar2 default null
35 ,p_parameter1_value IN varchar2 default null
36 ,p_parameter2_level IN varchar2 default null
37 ,p_parameter2_value IN varchar2 default null
38 ,p_parameter3_level IN varchar2 default null
39 ,p_parameter3_value IN varchar2 default null
40 ,p_parameter4_level IN varchar2 default null
41 ,p_parameter4_value IN varchar2 default null
42 ,p_parameter5_level IN varchar2 default null
43 ,p_parameter5_value IN varchar2 default null
44 ,p_parameter6_level IN varchar2 default null
45 ,p_parameter6_value IN varchar2 default null
46 ,p_parameter7_level IN varchar2 default null
47 ,p_parameter7_value IN varchar2 default null
48 ,p_view_by_level_id IN varchar2 default null
49 ,p_alert_type IN varchar2 default null
50 ,p_session_id IN varchar2 default null
51 ,p_notify_owners_flag IN varchar2 default null
52 , p_current_row IN VARCHAR2 := 'N'
53 ,p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
54 );
55
56 --
57 -- Procedure Which Accepts the parameters Performance measure
58 -- and time dimension level id from the Alert
59 -- Registration screen and processes the request
60 --
61
62 PROCEDURE process_parameter_set
63 (p_request_id OUT NOCOPY varchar2
64 ,p_perf_measure_id IN varchar2 default null
65 ,p_time_dim_level_id IN varchar2 default null
66 ,p_session_id IN varchar2 default null
67 ,p_alert_type IN varchar2 default null
68 ,p_notify_owners_flag IN varchar2 default null
69 , p_current_row IN VARCHAR2 := 'N'
70 );
71
72 --
73 -- Retrieve all Target information for the given performance measure
74 -- and time dimension level id.
75 --
76 PROCEDURE Retrieve_target_info
77 ( p_api_version IN NUMBER
78 , p_measure_id IN NUMBER
79 , p_time_dimension_level_id IN NUMBER
80 , p_current_row IN VARCHAR2 := NULL
81 , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
82 , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
83 , x_return_status OUT NOCOPY VARCHAR2
84 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
85 );
86
87 --
88 -- Retrieve a All Target information for the given target level
89 --
90 PROCEDURE Retrieve_target_info
91 ( p_api_version IN NUMBER
92 , p_target_level_id IN NUMBER
93 , p_time_dimension_level_id IN NUMBER := NULL
94 , p_current_row IN VARCHAR2 := NULL
95 --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
96 , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
97 , x_return_status OUT NOCOPY VARCHAR2
98 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
99 );
100
101 PROCEDURE Form_Parameter_Set
102 ( p_measure_id IN NUMBER
103 , p_time_level_id IN NUMBER := NULL
104 , p_target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
105 , p_Notifiers_Code IN VARCHAR2 := NULL
106 , x_parameter_set_tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
107 );
108
109 --
110 -- Procedure which insert the needed parameters to the alert
111 -- registration repository
112 --
113 PROCEDURE Register_Parameter_Set
114 ( p_api_version IN NUMBER
115 , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
116 , p_session_id IN varchar2 default null
117 , p_alert_type IN varchar2 default null
118 , p_request_id OUT NOCOPY varchar2
119 , x_return_status OUT NOCOPY VARCHAR2
120 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
121 );
122
123 FUNCTION IS_TOTAL_DIM_LEVEL
124 (p_DimLevelId IN NUMBER := NULL
125 )
126 RETURN BOOLEAN;
127
128
129 END BIS_PMF_REG_SERVICE_PVT;