[Home] [Help]
21: TYPE varchar2_tabletype IS TABLE OF VARCHAR2(32000) INDEX BY binary_integer;
22:
23: TYPE Calendar_Type_Record IS record
24: (
25: Calendar_Id bsc_sys_calendars_b.calendar_id%TYPE
26: , Edw_Flag bsc_sys_calendars_b.edw_flag%TYPE
27: , Edw_Calendar_Id bsc_sys_calendars_b.edw_calendar_id%TYPE
28: , Edw_Calendar_Type_Id bsc_sys_calendars_b.edw_calendar_type_id%TYPE
29: , Fiscal_Year bsc_sys_calendars_b.fiscal_year%TYPE
22:
23: TYPE Calendar_Type_Record IS record
24: (
25: Calendar_Id bsc_sys_calendars_b.calendar_id%TYPE
26: , Edw_Flag bsc_sys_calendars_b.edw_flag%TYPE
27: , Edw_Calendar_Id bsc_sys_calendars_b.edw_calendar_id%TYPE
28: , Edw_Calendar_Type_Id bsc_sys_calendars_b.edw_calendar_type_id%TYPE
29: , Fiscal_Year bsc_sys_calendars_b.fiscal_year%TYPE
30: , Fiscal_Change bsc_sys_calendars_b.fiscal_change%TYPE
23: TYPE Calendar_Type_Record IS record
24: (
25: Calendar_Id bsc_sys_calendars_b.calendar_id%TYPE
26: , Edw_Flag bsc_sys_calendars_b.edw_flag%TYPE
27: , Edw_Calendar_Id bsc_sys_calendars_b.edw_calendar_id%TYPE
28: , Edw_Calendar_Type_Id bsc_sys_calendars_b.edw_calendar_type_id%TYPE
29: , Fiscal_Year bsc_sys_calendars_b.fiscal_year%TYPE
30: , Fiscal_Change bsc_sys_calendars_b.fiscal_change%TYPE
31: , Range_Yr_Mod bsc_sys_calendars_b.range_yr_mod%TYPE
24: (
25: Calendar_Id bsc_sys_calendars_b.calendar_id%TYPE
26: , Edw_Flag bsc_sys_calendars_b.edw_flag%TYPE
27: , Edw_Calendar_Id bsc_sys_calendars_b.edw_calendar_id%TYPE
28: , Edw_Calendar_Type_Id bsc_sys_calendars_b.edw_calendar_type_id%TYPE
29: , Fiscal_Year bsc_sys_calendars_b.fiscal_year%TYPE
30: , Fiscal_Change bsc_sys_calendars_b.fiscal_change%TYPE
31: , Range_Yr_Mod bsc_sys_calendars_b.range_yr_mod%TYPE
32: , Current_Year bsc_sys_calendars_b.current_year%TYPE
25: Calendar_Id bsc_sys_calendars_b.calendar_id%TYPE
26: , Edw_Flag bsc_sys_calendars_b.edw_flag%TYPE
27: , Edw_Calendar_Id bsc_sys_calendars_b.edw_calendar_id%TYPE
28: , Edw_Calendar_Type_Id bsc_sys_calendars_b.edw_calendar_type_id%TYPE
29: , Fiscal_Year bsc_sys_calendars_b.fiscal_year%TYPE
30: , Fiscal_Change bsc_sys_calendars_b.fiscal_change%TYPE
31: , Range_Yr_Mod bsc_sys_calendars_b.range_yr_mod%TYPE
32: , Current_Year bsc_sys_calendars_b.current_year%TYPE
33: , Start_Month bsc_sys_calendars_b.start_month%TYPE
26: , Edw_Flag bsc_sys_calendars_b.edw_flag%TYPE
27: , Edw_Calendar_Id bsc_sys_calendars_b.edw_calendar_id%TYPE
28: , Edw_Calendar_Type_Id bsc_sys_calendars_b.edw_calendar_type_id%TYPE
29: , Fiscal_Year bsc_sys_calendars_b.fiscal_year%TYPE
30: , Fiscal_Change bsc_sys_calendars_b.fiscal_change%TYPE
31: , Range_Yr_Mod bsc_sys_calendars_b.range_yr_mod%TYPE
32: , Current_Year bsc_sys_calendars_b.current_year%TYPE
33: , Start_Month bsc_sys_calendars_b.start_month%TYPE
34: , Start_Day bsc_sys_calendars_b.start_day%TYPE
27: , Edw_Calendar_Id bsc_sys_calendars_b.edw_calendar_id%TYPE
28: , Edw_Calendar_Type_Id bsc_sys_calendars_b.edw_calendar_type_id%TYPE
29: , Fiscal_Year bsc_sys_calendars_b.fiscal_year%TYPE
30: , Fiscal_Change bsc_sys_calendars_b.fiscal_change%TYPE
31: , Range_Yr_Mod bsc_sys_calendars_b.range_yr_mod%TYPE
32: , Current_Year bsc_sys_calendars_b.current_year%TYPE
33: , Start_Month bsc_sys_calendars_b.start_month%TYPE
34: , Start_Day bsc_sys_calendars_b.start_day%TYPE
35: , Created_By bsc_sys_calendars_b.created_by%TYPE
28: , Edw_Calendar_Type_Id bsc_sys_calendars_b.edw_calendar_type_id%TYPE
29: , Fiscal_Year bsc_sys_calendars_b.fiscal_year%TYPE
30: , Fiscal_Change bsc_sys_calendars_b.fiscal_change%TYPE
31: , Range_Yr_Mod bsc_sys_calendars_b.range_yr_mod%TYPE
32: , Current_Year bsc_sys_calendars_b.current_year%TYPE
33: , Start_Month bsc_sys_calendars_b.start_month%TYPE
34: , Start_Day bsc_sys_calendars_b.start_day%TYPE
35: , Created_By bsc_sys_calendars_b.created_by%TYPE
36: , Creation_Date bsc_sys_calendars_b.creation_date%TYPE
29: , Fiscal_Year bsc_sys_calendars_b.fiscal_year%TYPE
30: , Fiscal_Change bsc_sys_calendars_b.fiscal_change%TYPE
31: , Range_Yr_Mod bsc_sys_calendars_b.range_yr_mod%TYPE
32: , Current_Year bsc_sys_calendars_b.current_year%TYPE
33: , Start_Month bsc_sys_calendars_b.start_month%TYPE
34: , Start_Day bsc_sys_calendars_b.start_day%TYPE
35: , Created_By bsc_sys_calendars_b.created_by%TYPE
36: , Creation_Date bsc_sys_calendars_b.creation_date%TYPE
37: , Last_Updated_By bsc_sys_calendars_b.last_updated_by%TYPE
30: , Fiscal_Change bsc_sys_calendars_b.fiscal_change%TYPE
31: , Range_Yr_Mod bsc_sys_calendars_b.range_yr_mod%TYPE
32: , Current_Year bsc_sys_calendars_b.current_year%TYPE
33: , Start_Month bsc_sys_calendars_b.start_month%TYPE
34: , Start_Day bsc_sys_calendars_b.start_day%TYPE
35: , Created_By bsc_sys_calendars_b.created_by%TYPE
36: , Creation_Date bsc_sys_calendars_b.creation_date%TYPE
37: , Last_Updated_By bsc_sys_calendars_b.last_updated_by%TYPE
38: , Last_Update_Date bsc_sys_calendars_b.last_update_date%TYPE
31: , Range_Yr_Mod bsc_sys_calendars_b.range_yr_mod%TYPE
32: , Current_Year bsc_sys_calendars_b.current_year%TYPE
33: , Start_Month bsc_sys_calendars_b.start_month%TYPE
34: , Start_Day bsc_sys_calendars_b.start_day%TYPE
35: , Created_By bsc_sys_calendars_b.created_by%TYPE
36: , Creation_Date bsc_sys_calendars_b.creation_date%TYPE
37: , Last_Updated_By bsc_sys_calendars_b.last_updated_by%TYPE
38: , Last_Update_Date bsc_sys_calendars_b.last_update_date%TYPE
39: , Last_Update_Login bsc_sys_calendars_b.last_update_login%TYPE
32: , Current_Year bsc_sys_calendars_b.current_year%TYPE
33: , Start_Month bsc_sys_calendars_b.start_month%TYPE
34: , Start_Day bsc_sys_calendars_b.start_day%TYPE
35: , Created_By bsc_sys_calendars_b.created_by%TYPE
36: , Creation_Date bsc_sys_calendars_b.creation_date%TYPE
37: , Last_Updated_By bsc_sys_calendars_b.last_updated_by%TYPE
38: , Last_Update_Date bsc_sys_calendars_b.last_update_date%TYPE
39: , Last_Update_Login bsc_sys_calendars_b.last_update_login%TYPE
40: , Name bsc_sys_calendars_tl.name%TYPE
33: , Start_Month bsc_sys_calendars_b.start_month%TYPE
34: , Start_Day bsc_sys_calendars_b.start_day%TYPE
35: , Created_By bsc_sys_calendars_b.created_by%TYPE
36: , Creation_Date bsc_sys_calendars_b.creation_date%TYPE
37: , Last_Updated_By bsc_sys_calendars_b.last_updated_by%TYPE
38: , Last_Update_Date bsc_sys_calendars_b.last_update_date%TYPE
39: , Last_Update_Login bsc_sys_calendars_b.last_update_login%TYPE
40: , Name bsc_sys_calendars_tl.name%TYPE
41: , Help bsc_sys_calendars_tl.help%TYPE
34: , Start_Day bsc_sys_calendars_b.start_day%TYPE
35: , Created_By bsc_sys_calendars_b.created_by%TYPE
36: , Creation_Date bsc_sys_calendars_b.creation_date%TYPE
37: , Last_Updated_By bsc_sys_calendars_b.last_updated_by%TYPE
38: , Last_Update_Date bsc_sys_calendars_b.last_update_date%TYPE
39: , Last_Update_Login bsc_sys_calendars_b.last_update_login%TYPE
40: , Name bsc_sys_calendars_tl.name%TYPE
41: , Help bsc_sys_calendars_tl.help%TYPE
42: , Dim_Short_Name bsc_sys_dim_groups_tl.short_name%TYPE
35: , Created_By bsc_sys_calendars_b.created_by%TYPE
36: , Creation_Date bsc_sys_calendars_b.creation_date%TYPE
37: , Last_Updated_By bsc_sys_calendars_b.last_updated_by%TYPE
38: , Last_Update_Date bsc_sys_calendars_b.last_update_date%TYPE
39: , Last_Update_Login bsc_sys_calendars_b.last_update_login%TYPE
40: , Name bsc_sys_calendars_tl.name%TYPE
41: , Help bsc_sys_calendars_tl.help%TYPE
42: , Dim_Short_Name bsc_sys_dim_groups_tl.short_name%TYPE
43: , Application_Id bis_dimensions.application_id%TYPE