APPS.BSC_COLOR_RANGES_PUB dependencies on BSC_COLOR_RANGES

Line 1: PACKAGE BSC_COLOR_RANGES_PUB AS

1: PACKAGE BSC_COLOR_RANGES_PUB AS
2: /* $Header: BSCPCRNS.pls 120.2.12000000.1 2007/07/17 07:43:53 appldev noship $ */
3: /*
4: +======================================================================================+
5: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |

Line 19: | and provide CRUD APIs for BSC_COLOR_RANGES_B related table |

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_COLOR_RANGES_B related table |
20: | |
21: | 26-JUN-2007 ankgoel Bug#6132361 - Handled PL objectives |
22: +======================================================================================+
23: */

Line 25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'BSC_COLOR_RANGES_PUB';

21: | 26-JUN-2007 ankgoel Bug#6132361 - Handled PL objectives |
22: +======================================================================================+
23: */
24:
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'BSC_COLOR_RANGES_PUB';
26:
27: TYPE BSC_COLOR_RANGE_OBJ IS RECORD (
28: color_range_id bsc_color_ranges.color_range_id%TYPE
29: ,color_range_sequence bsc_color_ranges.color_range_sequence%TYPE

Line 28: color_range_id bsc_color_ranges.color_range_id%TYPE

24:
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'BSC_COLOR_RANGES_PUB';
26:
27: TYPE BSC_COLOR_RANGE_OBJ IS RECORD (
28: color_range_id bsc_color_ranges.color_range_id%TYPE
29: ,color_range_sequence bsc_color_ranges.color_range_sequence%TYPE
30: ,low bsc_color_ranges.low%TYPE
31: ,high bsc_color_ranges.high%TYPE
32: ,color_id bsc_color_ranges.color_id%TYPE

Line 29: ,color_range_sequence bsc_color_ranges.color_range_sequence%TYPE

25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'BSC_COLOR_RANGES_PUB';
26:
27: TYPE BSC_COLOR_RANGE_OBJ IS RECORD (
28: color_range_id bsc_color_ranges.color_range_id%TYPE
29: ,color_range_sequence bsc_color_ranges.color_range_sequence%TYPE
30: ,low bsc_color_ranges.low%TYPE
31: ,high bsc_color_ranges.high%TYPE
32: ,color_id bsc_color_ranges.color_id%TYPE
33: ,user_id NUMBER

Line 30: ,low bsc_color_ranges.low%TYPE

26:
27: TYPE BSC_COLOR_RANGE_OBJ IS RECORD (
28: color_range_id bsc_color_ranges.color_range_id%TYPE
29: ,color_range_sequence bsc_color_ranges.color_range_sequence%TYPE
30: ,low bsc_color_ranges.low%TYPE
31: ,high bsc_color_ranges.high%TYPE
32: ,color_id bsc_color_ranges.color_id%TYPE
33: ,user_id NUMBER
34: );

Line 31: ,high bsc_color_ranges.high%TYPE

27: TYPE BSC_COLOR_RANGE_OBJ IS RECORD (
28: color_range_id bsc_color_ranges.color_range_id%TYPE
29: ,color_range_sequence bsc_color_ranges.color_range_sequence%TYPE
30: ,low bsc_color_ranges.low%TYPE
31: ,high bsc_color_ranges.high%TYPE
32: ,color_id bsc_color_ranges.color_id%TYPE
33: ,user_id NUMBER
34: );
35:

Line 32: ,color_id bsc_color_ranges.color_id%TYPE

28: color_range_id bsc_color_ranges.color_range_id%TYPE
29: ,color_range_sequence bsc_color_ranges.color_range_sequence%TYPE
30: ,low bsc_color_ranges.low%TYPE
31: ,high bsc_color_ranges.high%TYPE
32: ,color_id bsc_color_ranges.color_id%TYPE
33: ,user_id NUMBER
34: );
35:
36: TYPE BSC_COLOR_RANGE_REC IS TABLE OF BSC_COLOR_RANGE_OBJ

Line 181: END BSC_COLOR_RANGES_PUB;

177: p_objective_id IN NUMBER
178: ,p_kpi_measure_id IN NUMBER
179: ) RETURN NUMBER;
180:
181: END BSC_COLOR_RANGES_PUB;