[Home] [Help]
PACKAGE: APPS.BIS_CORRECTIVE_ACTION_PVT
Source
1 PACKAGE BIS_CORRECTIVE_ACTION_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVCACS.pls 115.26 2004/01/15 22:36:46 jxyu ship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BISVCACS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Private API for the Data Source Connector
13 REM |
14 REM | NOTES |
15 REM | |
16 REM | HISTORY |
17 REM | APR-2000 irchen Creation
18 REM | NOV-15 sashaik Unsubscribe alerts 1898436
19 REM | 09-APR-2003 smuruges Bug# 2871017. |
20 REM | Created a new procedure GenerateAlerts |
21 REM | This API would be invoked by the workflow |
22 REM | NOTIFICATION engine to generate html/text |
23 REM | documents for sending alerts. |
24 REM | 05-JUL-2003 rchandra removed proc isTargetOwner for bug 2929282 |
25 REM | 14-NOV-2003 ankgoel Modified for bug# 3153918 |
26 REM | 14-Jan-2004 jxyu Modified for bug#3374352 |
27 REM +=======================================================================+
28 */
29
30 --
31 -- Procedures
32 --
33
34 -- Starts the corrective action workflow
35 --
36 Procedure Start_Corrective_Action
37 ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
38 , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
39 , p_comparison_result IN VARCHAR2
40 );
41
42 Procedure Send_Alert
43 ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
44 , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
45 , p_comparison_result IN VARCHAR2
46 );
47
48
49 -- Used by generate the notification text
50 --
51 Procedure Generate_Alert_Message
52 ( document_id IN VARCHAR2
53 , display_type IN VARCHAR2
54 , document IN OUT NOCOPY VARCHAR2
55 , document_type IN OUT NOCOPY VARCHAR2
56 );
57
58 -- Retrieves the alert request information for this notification
59 --
60 Procedure Get_Request_Info
61 ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
62 , x_schedule_date OUT NOCOPY VARCHAR2
63 , x_schedule_time OUT NOCOPY VARCHAR2
64 , x_schedule_unit OUT NOCOPY VARCHAR2
65 , x_schedule_freq OUT NOCOPY VARCHAR2
66 , x_next_run_date OUT NOCOPY VARCHAR2
67 , x_next_run_time OUT NOCOPY VARCHAR2
68 , x_description OUT NOCOPY VARCHAR2
69 , x_return_status OUT NOCOPY VARCHAR2
70 );
71
72
73 PROCEDURE unsub_launch_jsp -- 1898436
74 ( pMeasureId IN VARCHAR2 := NULL
75 , pTargetLevelId IN VARCHAR2 := NULL
76 , pTargetId IN VARCHAR2 := NULL
77 , pTimeDimensionLevelId IN VARCHAR2 := NULL
78 , pPlanId IN VARCHAR2 := NULL
79 , pNotifiersCode IN VARCHAR2 := NULL
80 , pParameter1Value IN VARCHAR2 := NULL
81 , pParameter2Value IN VARCHAR2 := NULL
82 , pParameter3Value IN VARCHAR2 := NULL
83 , pParameter4Value IN VARCHAR2 := NULL
84 , pParameter5Value IN VARCHAR2 := NULL
85 , pParameter6Value IN VARCHAR2 := NULL
86 , pParameter7Value IN VARCHAR2 := NULL
87 );
88
89
90 PROCEDURE unSubscribeFromAlerts -- 1898436
91 (p_measure_Id IN VARCHAR2 := NULL
92 ,p_target_Level_Id IN VARCHAR2 := NULL
93 ,p_time_Dimension_Level_Id IN VARCHAR2 := NULL
94 ,p_plan_Id IN VARCHAR2 := NULL
95 ,p_notifiers_Code IN VARCHAR2 := NULL
96 ,p_parameter1_Value IN VARCHAR2 := NULL
97 ,p_parameter2_Value IN VARCHAR2 := NULL
98 ,p_parameter3_Value IN VARCHAR2 := NULL
99 ,p_parameter4_Value IN VARCHAR2 := NULL
100 ,p_parameter5_Value IN VARCHAR2 := NULL
101 ,p_parameter6_Value IN VARCHAR2 := NULL
102 ,p_parameter7_Value IN VARCHAR2 := NULL
103 ,x_return_status OUT NOCOPY VARCHAR2
104 ,x_msg_count OUT NOCOPY NUMBER
105 ,x_msg_data OUT NOCOPY VARCHAR2
106 );
107
108 PROCEDURE GenerateAlerts
109 ( document_id IN VARCHAR2,
110 content_type IN VARCHAR2,
111 document IN OUT NOCOPY CLOB,
112 document_type IN OUT NOCOPY VARCHAR2);
113
114 PROCEDURE Generate_Report
115 ( document_id IN VARCHAR2,
116 content_type IN VARCHAR2,
117 document IN OUT NOCOPY CLOB,
118 document_type IN OUT NOCOPY VARCHAR2);
119
120 FUNCTION Adjust_Datetime
121 ( p_date_time IN DATE
122 , p_from_tz IN VARCHAR2
123 , p_to_tz IN VARCHAR2
124 ) RETURN DATE;
125
126 END BIS_CORRECTIVE_ACTION_PVT;