PACKAGE: APPS.BSC_COLOR_REPOSITORY

Source

1 PACKAGE BSC_COLOR_REPOSITORY AS
2 /* $Header: BSCRCOLS.pls 120.0.12000000.1 2007/07/17 07:44:24 appldev noship $ */
3 
4 NO_COLOR         CONSTANT NUMBER := 8421504;
5 EXCELLENT_COLOR  CONSTANT NUMBER := 24865;
6 GOOD_COLOR       CONSTANT NUMBER := 1;
7 AVERAGE_COLOR    CONSTANT NUMBER := 49919;
8 LOW_COLOR        CONSTANT NUMBER := 2;
9 POOR_COLOR       CONSTANT NUMBER := 192;
10 
11 TYPE t_color_rec IS RECORD (
12   color_id    bsc_sys_colors_b.color_id%TYPE
13 , short_name  bsc_sys_colors_b.short_name%TYPE
14 , perf_seq    bsc_sys_colors_b.perf_sequence%TYPE
15 , numeric_eq  bsc_sys_colors_b.user_numeric_equivalent%TYPE
16 );
17 
18 TYPE t_array_colors IS TABLE OF t_color_rec
19     INDEX BY BINARY_INTEGER;
20 
21 g_array_colors  t_array_colors;
22 
23 G_COLOR_SET     BOOLEAN := FALSE;
24 
25 FUNCTION get_color_props
26 RETURN t_array_colors;
27 
28 END BSC_COLOR_REPOSITORY;