[Home] [Help]
PACKAGE: APPS.BSC_COLOR_RANGE_PVT
Source
1 package BSC_COLOR_RANGE_PVT as
2 /* $Header: BSCVCRNS.pls 120.2.12000000.1 2007/07/17 07:44:41 appldev noship $ */
3 /*
4 +======================================================================================+
5 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +======================================================================================+
8 | FILENAME |
9 | BSCVCRNS.pls |
10 | |
11 | Creation Date: |
12 | November 02, 2006 |
13 | |
14 | Creator: |
15 | Pradeep Pandey |
16 | |
17 | Description: Private Spec version. |
18 | This package is to manage Range Properties properties |
19 | and provide CRUD APIs for BSC_SYS_COLOR_RANGES_B and related tbl|
20 | |
21 | 26-JUN-2007 ankgoel Bug#6132361 - Handled PL objectives |
22 +======================================================================================+
23 */
24
25 G_PKG_NAME CONSTANT varchar2(30) := 'BSC_COLOR_RANGE_PVT';
26
27
28 /************************************************************************************
29 ************************************************************************************/
30 PROCEDURE Create_Color_Props (
31 p_commit IN VARCHAR2 := FND_API.G_FALSE
32 ,p_objective_id IN NUMBER
33 ,p_kpi_measure_id IN NUMBER
34 ,p_color_type IN VARCHAR2
35 ,p_color_range_id IN NUMBER
36 ,p_property_value IN VARCHAR2 := NULL
37 ,x_return_status OUT NOCOPY VARCHAR2
38 ,x_msg_count OUT NOCOPY NUMBER
39 ,x_msg_data OUT NOCOPY VARCHAR2
40 ) ;
41
42 /************************************************************************************
43 ************************************************************************************/
44 PROCEDURE Create_Color_Range (
45 p_commit IN VARCHAR2 := FND_API.G_FALSE
46 ,p_range_id IN NUMBER
47 ,p_Bsc_Kpi_Color_Range_Rec IN BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec
48 ,p_user_id IN FND_USER.user_id%TYPE
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 /************************************************************************************
55 ************************************************************************************/
56
57 PROCEDURE Delete_Color_Ranges (
58 p_commit IN VARCHAR2 := FND_API.G_FALSE
59 ,p_color_range_id IN NUMBER
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 /************************************************************************************
66 ************************************************************************************/
67 PROCEDURE Delete_Color_Prop_Ranges (
68 p_commit IN VARCHAR2:= FND_API.G_FALSE
69 ,p_color_range_id IN NUMBER
70 ,x_return_status OUT NOCOPY VARCHAR2
71 ,x_msg_count OUT NOCOPY NUMBER
72 ,x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 END BSC_COLOR_RANGE_PVT;