APPS.BSC_COLOR_PUB dependencies on BSC_SYS_COLORS_B

Line 19: | and provide CRUD APIs for BSC_SYS_COLORS_B and 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_SYS_COLORS_B and related table |
20: | |
21: +======================================================================================+
22: */
23:

Line 27: color_id bsc_sys_colors_b.color_id%TYPE

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

Line 28: ,short_name bsc_sys_colors_b.short_name%TYPE

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

Line 32: ,perf_sequence bsc_sys_colors_b.perf_sequence%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

Line 33: ,color bsc_sys_colors_b.color%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

Line 34: ,user_color bsc_sys_colors_b.user_color%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

Line 35: ,forecast_color bsc_sys_colors_b.forecast_color%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

Line 36: ,user_forecast_color bsc_sys_colors_b.user_forecast_color%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

Line 37: ,numeric_equivalent bsc_sys_colors_b.numeric_equivalent%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

Line 38: ,user_numeric_equivalent bsc_sys_colors_b.user_numeric_equivalent%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

Line 39: ,image bsc_sys_colors_b.user_image_id%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

Line 40: ,created_by bsc_sys_colors_b.created_by%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: );

Line 41: ,last_updated_by bsc_sys_colors_b.last_updated_by%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:

Line 42: ,last_update_login bsc_sys_colors_b.last_update_login%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: /************************************************************************************

Line 43: ,last_update_date bsc_sys_colors_b.last_update_date%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: ************************************************************************************/