[Home] [Help]
PACKAGE: APPS.BSC_COLOR_PUB
Source
1 PACKAGE BSC_COLOR_PUB AS
2 /* $Header: BSCPCOLS.pls 120.1.12000000.1 2007/07/17 07:43:50 appldev noship $ */
3 /*
4 +======================================================================================+
5 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +======================================================================================+
8 | FILENAME |
9 | BSCPCOLS.pls |
10 | |
11 | Creation Date: |
12 | October 26, 2006 |
13 | |
14 | Creator: |
15 | Pradeep Pandey |
16 | |
17 | Description: Public Spec version. |
18 | This package is to manage System level Color properties |
19 | and provide CRUD APIs for BSC_SYS_COLORS_B and related table |
20 | |
21 +======================================================================================+
22 */
23
24 G_PKG_NAME CONSTANT varchar2(30) := 'BSC_COLOR_PUB';
25
26 TYPE BSC_COLOR_REC IS RECORD (
27 color_id bsc_sys_colors_b.color_id%TYPE
28 ,short_name bsc_sys_colors_b.short_name%TYPE
29 ,name bsc_sys_colors_tl.name%TYPE
30 ,prototype_label bsc_sys_colors_tl.prototype_label%TYPE
31 ,description bsc_sys_colors_tl.description%TYPE
32 ,perf_sequence bsc_sys_colors_b.perf_sequence%TYPE
33 ,color bsc_sys_colors_b.color%TYPE
34 ,user_color bsc_sys_colors_b.user_color%TYPE
35 ,forecast_color bsc_sys_colors_b.forecast_color%TYPE
36 ,user_forecast_color bsc_sys_colors_b.user_forecast_color%TYPE
37 ,numeric_equivalent bsc_sys_colors_b.numeric_equivalent%TYPE
38 ,user_numeric_equivalent bsc_sys_colors_b.user_numeric_equivalent%TYPE
39 ,image bsc_sys_colors_b.user_image_id%TYPE
40 ,created_by bsc_sys_colors_b.created_by%TYPE
41 ,last_updated_by bsc_sys_colors_b.last_updated_by%TYPE
42 ,last_update_login bsc_sys_colors_b.last_update_login%TYPE
43 ,last_update_date bsc_sys_colors_b.last_update_date%TYPE
44 );
45
46 /************************************************************************************
47 ************************************************************************************/
48 PROCEDURE Create_Color(
49 p_commit IN VARCHAR2 := FND_API.G_FALSE
50 ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54 ) ;
55
56 /************************************************************************************
57 ************************************************************************************/
58 PROCEDURE Update_Color(
59 p_commit IN VARCHAR2 := FND_API.G_FALSE
60 ,p_Bsc_Color_Tbl IN COLOR_ARRAY
61 ,x_return_status OUT NOCOPY VARCHAR2
62 ,x_msg_count OUT NOCOPY NUMBER
63 ,x_msg_data OUT NOCOPY VARCHAR2
64 );
65
66 /************************************************************************************
67 ************************************************************************************/
68 PROCEDURE Delete_Color(
69 p_commit IN VARCHAR2:= FND_API.G_FALSE
70 ,p_Bsc_Color_Id IN NUMBER
71 ,p_Bsc_Color_SN IN NUMBER
72 ,x_return_status OUT NOCOPY VARCHAR2
73 ,x_msg_count OUT NOCOPY NUMBER
74 ,x_msg_data OUT NOCOPY VARCHAR2
75 ) ;
76
77 /************************************************************************************
78 ************************************************************************************/
79 PROCEDURE Update_Default_Color_Count(
80 p_commit IN VARCHAR2:= FND_API.G_FALSE
81 ,p_color_count IN NUMBER
82 ,x_return_status OUT NOCOPY VARCHAR2
83 ,x_msg_count OUT NOCOPY NUMBER
84 ,x_msg_data OUT NOCOPY VARCHAR2
85 );
86
87 END BSC_COLOR_PUB;