1 PACKAGE BSC_COLOR_PKG AS
2 /* $Header: BSCCPKGS.pls 120.1.12000000.1 2007/07/17 07:43:36 appldev noship $ */
3 /*
4 +======================================================================================+
5 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +======================================================================================+
8 | FILENAME |
9 | BSCCPKGS.pls |
10 | |
11 | Creation Date: |
12 | October 26, 2006 |
13 | |
14 | Creator: |
15 | Pradeep Pandey |
16 | |
17 | Description: Package Body version. |
18 | This package is CRUD for System level Color properties |
19 | provide CRUD APIs for BSC_SYS_COLORS_B and related table |
20 | |
21 +======================================================================================+
22 */
23
24 G_PKG_NAME CONSTANT varchar2(30) := 'BSC_COLOR_PKG';
25
26
27 /************************************************************************************
28 ************************************************************************************/
29 PROCEDURE INSERT_ROW(
30 p_Color_Id IN NUMBER
31 ,p_Short_Name IN VARCHAR2
32 ,p_System_Color_Name IN VARCHAR2
33 ,p_System_Color_Desc IN VARCHAR2
34 ,p_prototype_label IN VARCHAR2
35 ,p_Perf_Sequence_Id IN NUMBER
36 ,p_System_Color IN NUMBER
37 ,p_User_Color IN NUMBER
38 ,p_Forecast_Color IN NUMBER
39 ,p_User_Forecast_Color IN NUMBER
40 ,p_Numeric_Equivalent IN NUMBER
41 ,p_User_Numeric_Equivalent IN NUMBER
42 ,p_Image IN NUMBER
43 ,p_Created_By IN NUMBER
44 ,p_Last_Updated_By IN NUMBER
45 ,p_Last_Update_Login IN NUMBER
46 );
47
48 /************************************************************************************
49 ************************************************************************************/
50 PROCEDURE UPDATE_ROW (
51 p_Color_Id IN NUMBER
52 ,p_System_Color_Name IN VARCHAR2
53 ,p_System_Color_Desc IN VARCHAR2
54 ,p_prototype_label IN VARCHAR2
55 ,p_Perf_Sequence_Id IN NUMBER
56 ,p_System_Color IN NUMBER
57 ,p_User_Color IN NUMBER
58 ,p_User_Forecast_Color IN NUMBER
59 ,p_Numeric_Equivalent IN NUMBER
60 ,p_User_Numeric_Equivalent IN NUMBER
61 ,p_Image IN NUMBER
62 ,p_Last_Updated_By IN NUMBER
63 ,p_Last_Update_Login IN NUMBER
64 );
65
66 /************************************************************************************
67 ************************************************************************************/
68 PROCEDURE UPDATE_ROW (
69 p_Color_Id IN NUMBER
70 ,p_Perf_Sequence_Id IN NUMBER
71 ,p_System_Color IN NUMBER
72 ,p_User_Color IN NUMBER
73 ,p_User_Forecast_Color IN NUMBER
74 ,p_Numeric_Equivalent IN NUMBER
75 ,p_User_Numeric_Equivalent IN NUMBER
76 ,p_Image IN NUMBER
77 ,p_Last_Updated_By IN NUMBER
78 ,p_Last_Update_Login IN NUMBER
79 );
80
81 /************************************************************************************
82 ************************************************************************************/
83 PROCEDURE DELETE_ROW(
84 p_Bsc_Color_Id IN NUMBER
85 ,p_Bsc_Color_SN IN NUMBER
86 );
87
88 /************************************************************************************
89 ************************************************************************************/
90 PROCEDURE ADD_LANGUAGE;
91
92 END BSC_COLOR_PKG;