DBA Data[Home] [Help]

PACKAGE: APPS.BSC_COLOR_PVT

Source


1 PACKAGE BSC_COLOR_PVT AS
2 /* $Header: BSCVCOLS.pls 120.0.12000000.1 2007/07/17 07:44:37 appldev noship $ */
3 /*
4  +======================================================================================+
5  |    Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA                    |
6  |                         All rights reserved.                                         |
7  +======================================================================================+
8  | FILENAME                                                                             |
9  |                      BSCVCOLS.pls                                                    |
10  |                                                                                      |
11  | Creation Date:                                                                       |
12  |                      October 26, 2006                                                |
13  |                                                                                      |
14  | Creator:                                                                             |
15  |                      Pradeep Pandey                                                  |
16  |                                                                                      |
17  | Description:         Private 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_PVT';
25 
26 
27 /************************************************************************************
28  ************************************************************************************/
29 PROCEDURE Create_Color(
30   p_commit              IN            VARCHAR2 := FND_API.G_FALSE
31  ,p_Bsc_Color_Rec       IN            BSC_COLOR_PUB.Bsc_Color_Rec
32  ,x_return_status       OUT NOCOPY    VARCHAR2
33  ,x_msg_count           OUT NOCOPY    NUMBER
34  ,x_msg_data            OUT NOCOPY    VARCHAR2
35 ) ;
36 
37 /************************************************************************************
38  ************************************************************************************/
39 PROCEDURE Update_Color(
40   p_commit              IN             VARCHAR2 := FND_API.G_FALSE
41  ,p_Bsc_Color_Rec       IN             BSC_COLOR_PUB.Bsc_Color_Rec
42  ,x_return_status       OUT NOCOPY     VARCHAR2
43  ,x_msg_count           OUT NOCOPY     NUMBER
44  ,x_msg_data            OUT NOCOPY     VARCHAR2
45 );
46 
47 /************************************************************************************
48 ************************************************************************************/
49 PROCEDURE Delete_Color(
50   p_commit              IN             VARCHAR2:= FND_API.G_FALSE
51  ,p_Bsc_Color_Id        IN             NUMBER
52  ,p_Bsc_Color_SN        IN             NUMBER
53  ,x_return_status       OUT NOCOPY     VARCHAR2
54  ,x_msg_count           OUT NOCOPY     NUMBER
55  ,x_msg_data            OUT NOCOPY     VARCHAR2
56 );
57 
58 /************************************************************************************
59  ************************************************************************************/
60 PROCEDURE Translate_Color(
61   p_commit              IN             VARCHAR2:= FND_API.G_FALSE
62  ,p_Bsc_Color_Rec       IN             BSC_COLOR_PUB.Bsc_Color_Rec
63  ,x_return_status       OUT NOCOPY     VARCHAR2
64  ,x_msg_count           OUT NOCOPY     NUMBER
65  ,x_msg_data            OUT NOCOPY     VARCHAR2
66 );
67 
68 /************************************************************************************
69  ************************************************************************************/
70 PROCEDURE Load_Color(
71   p_commit              IN             VARCHAR2:= FND_API.G_FALSE
72  ,p_Bsc_Color_Rec       IN             BSC_COLOR_PUB.Bsc_Color_Rec
73  ,x_return_status       OUT NOCOPY     VARCHAR2
74  ,x_msg_count           OUT NOCOPY     NUMBER
75  ,x_msg_data            OUT NOCOPY     VARCHAR2
76 );
77 
78 
79 END BSC_COLOR_PVT;