23:
24:
25: TYPE Periodicities_Rec_Type IS RECORD
26: (
27: Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
28: , Num_Of_Periods BSC_SYS_PERIODICITIES.NUM_OF_PERIODS%TYPE
29: , Source BSC_SYS_PERIODICITIES.SOURCE%TYPE
30: , Base_Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
31: , Num_Of_Subperiods BSC_SYS_PERIODICITIES.NUM_OF_SUBPERIODS%TYPE
24:
25: TYPE Periodicities_Rec_Type IS RECORD
26: (
27: Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
28: , Num_Of_Periods BSC_SYS_PERIODICITIES.NUM_OF_PERIODS%TYPE
29: , Source BSC_SYS_PERIODICITIES.SOURCE%TYPE
30: , Base_Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
31: , Num_Of_Subperiods BSC_SYS_PERIODICITIES.NUM_OF_SUBPERIODS%TYPE
32: , Period_Col_Name BSC_SYS_PERIODICITIES.PERIOD_COL_NAME%TYPE
25: TYPE Periodicities_Rec_Type IS RECORD
26: (
27: Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
28: , Num_Of_Periods BSC_SYS_PERIODICITIES.NUM_OF_PERIODS%TYPE
29: , Source BSC_SYS_PERIODICITIES.SOURCE%TYPE
30: , Base_Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
31: , Num_Of_Subperiods BSC_SYS_PERIODICITIES.NUM_OF_SUBPERIODS%TYPE
32: , Period_Col_Name BSC_SYS_PERIODICITIES.PERIOD_COL_NAME%TYPE
33: , Subperiod_Col_Name BSC_SYS_PERIODICITIES.SUBPERIOD_COL_NAME%TYPE
26: (
27: Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
28: , Num_Of_Periods BSC_SYS_PERIODICITIES.NUM_OF_PERIODS%TYPE
29: , Source BSC_SYS_PERIODICITIES.SOURCE%TYPE
30: , Base_Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
31: , Num_Of_Subperiods BSC_SYS_PERIODICITIES.NUM_OF_SUBPERIODS%TYPE
32: , Period_Col_Name BSC_SYS_PERIODICITIES.PERIOD_COL_NAME%TYPE
33: , Subperiod_Col_Name BSC_SYS_PERIODICITIES.SUBPERIOD_COL_NAME%TYPE
34: , Yearly_Flag BSC_SYS_PERIODICITIES.YEARLY_FLAG%TYPE
27: Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
28: , Num_Of_Periods BSC_SYS_PERIODICITIES.NUM_OF_PERIODS%TYPE
29: , Source BSC_SYS_PERIODICITIES.SOURCE%TYPE
30: , Base_Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
31: , Num_Of_Subperiods BSC_SYS_PERIODICITIES.NUM_OF_SUBPERIODS%TYPE
32: , Period_Col_Name BSC_SYS_PERIODICITIES.PERIOD_COL_NAME%TYPE
33: , Subperiod_Col_Name BSC_SYS_PERIODICITIES.SUBPERIOD_COL_NAME%TYPE
34: , Yearly_Flag BSC_SYS_PERIODICITIES.YEARLY_FLAG%TYPE
35: , Edw_Flag BSC_SYS_PERIODICITIES.EDW_FLAG%TYPE
28: , Num_Of_Periods BSC_SYS_PERIODICITIES.NUM_OF_PERIODS%TYPE
29: , Source BSC_SYS_PERIODICITIES.SOURCE%TYPE
30: , Base_Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
31: , Num_Of_Subperiods BSC_SYS_PERIODICITIES.NUM_OF_SUBPERIODS%TYPE
32: , Period_Col_Name BSC_SYS_PERIODICITIES.PERIOD_COL_NAME%TYPE
33: , Subperiod_Col_Name BSC_SYS_PERIODICITIES.SUBPERIOD_COL_NAME%TYPE
34: , Yearly_Flag BSC_SYS_PERIODICITIES.YEARLY_FLAG%TYPE
35: , Edw_Flag BSC_SYS_PERIODICITIES.EDW_FLAG%TYPE
36: , Calendar_Id BSC_SYS_PERIODICITIES.CALENDAR_ID%TYPE
29: , Source BSC_SYS_PERIODICITIES.SOURCE%TYPE
30: , Base_Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
31: , Num_Of_Subperiods BSC_SYS_PERIODICITIES.NUM_OF_SUBPERIODS%TYPE
32: , Period_Col_Name BSC_SYS_PERIODICITIES.PERIOD_COL_NAME%TYPE
33: , Subperiod_Col_Name BSC_SYS_PERIODICITIES.SUBPERIOD_COL_NAME%TYPE
34: , Yearly_Flag BSC_SYS_PERIODICITIES.YEARLY_FLAG%TYPE
35: , Edw_Flag BSC_SYS_PERIODICITIES.EDW_FLAG%TYPE
36: , Calendar_Id BSC_SYS_PERIODICITIES.CALENDAR_ID%TYPE
37: , Edw_Periodicity_Id BSC_SYS_PERIODICITIES.EDW_PERIODICITY_ID%TYPE
30: , Base_Periodicity_Id BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE
31: , Num_Of_Subperiods BSC_SYS_PERIODICITIES.NUM_OF_SUBPERIODS%TYPE
32: , Period_Col_Name BSC_SYS_PERIODICITIES.PERIOD_COL_NAME%TYPE
33: , Subperiod_Col_Name BSC_SYS_PERIODICITIES.SUBPERIOD_COL_NAME%TYPE
34: , Yearly_Flag BSC_SYS_PERIODICITIES.YEARLY_FLAG%TYPE
35: , Edw_Flag BSC_SYS_PERIODICITIES.EDW_FLAG%TYPE
36: , Calendar_Id BSC_SYS_PERIODICITIES.CALENDAR_ID%TYPE
37: , Edw_Periodicity_Id BSC_SYS_PERIODICITIES.EDW_PERIODICITY_ID%TYPE
38: , Custom_Code BSC_SYS_PERIODICITIES.CUSTOM_CODE%TYPE
31: , Num_Of_Subperiods BSC_SYS_PERIODICITIES.NUM_OF_SUBPERIODS%TYPE
32: , Period_Col_Name BSC_SYS_PERIODICITIES.PERIOD_COL_NAME%TYPE
33: , Subperiod_Col_Name BSC_SYS_PERIODICITIES.SUBPERIOD_COL_NAME%TYPE
34: , Yearly_Flag BSC_SYS_PERIODICITIES.YEARLY_FLAG%TYPE
35: , Edw_Flag BSC_SYS_PERIODICITIES.EDW_FLAG%TYPE
36: , Calendar_Id BSC_SYS_PERIODICITIES.CALENDAR_ID%TYPE
37: , Edw_Periodicity_Id BSC_SYS_PERIODICITIES.EDW_PERIODICITY_ID%TYPE
38: , Custom_Code BSC_SYS_PERIODICITIES.CUSTOM_CODE%TYPE
39: , Db_Column_Name BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE
32: , Period_Col_Name BSC_SYS_PERIODICITIES.PERIOD_COL_NAME%TYPE
33: , Subperiod_Col_Name BSC_SYS_PERIODICITIES.SUBPERIOD_COL_NAME%TYPE
34: , Yearly_Flag BSC_SYS_PERIODICITIES.YEARLY_FLAG%TYPE
35: , Edw_Flag BSC_SYS_PERIODICITIES.EDW_FLAG%TYPE
36: , Calendar_Id BSC_SYS_PERIODICITIES.CALENDAR_ID%TYPE
37: , Edw_Periodicity_Id BSC_SYS_PERIODICITIES.EDW_PERIODICITY_ID%TYPE
38: , Custom_Code BSC_SYS_PERIODICITIES.CUSTOM_CODE%TYPE
39: , Db_Column_Name BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE
40: , Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_TYPE%TYPE
33: , Subperiod_Col_Name BSC_SYS_PERIODICITIES.SUBPERIOD_COL_NAME%TYPE
34: , Yearly_Flag BSC_SYS_PERIODICITIES.YEARLY_FLAG%TYPE
35: , Edw_Flag BSC_SYS_PERIODICITIES.EDW_FLAG%TYPE
36: , Calendar_Id BSC_SYS_PERIODICITIES.CALENDAR_ID%TYPE
37: , Edw_Periodicity_Id BSC_SYS_PERIODICITIES.EDW_PERIODICITY_ID%TYPE
38: , Custom_Code BSC_SYS_PERIODICITIES.CUSTOM_CODE%TYPE
39: , Db_Column_Name BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE
40: , Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_TYPE%TYPE
41: , Period_Type_Id BSC_SYS_PERIODICITIES.PERIOD_TYPE_ID%TYPE
34: , Yearly_Flag BSC_SYS_PERIODICITIES.YEARLY_FLAG%TYPE
35: , Edw_Flag BSC_SYS_PERIODICITIES.EDW_FLAG%TYPE
36: , Calendar_Id BSC_SYS_PERIODICITIES.CALENDAR_ID%TYPE
37: , Edw_Periodicity_Id BSC_SYS_PERIODICITIES.EDW_PERIODICITY_ID%TYPE
38: , Custom_Code BSC_SYS_PERIODICITIES.CUSTOM_CODE%TYPE
39: , Db_Column_Name BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE
40: , Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_TYPE%TYPE
41: , Period_Type_Id BSC_SYS_PERIODICITIES.PERIOD_TYPE_ID%TYPE
42: , Record_Type_Id BSC_SYS_PERIODICITIES.RECORD_TYPE_ID%TYPE
35: , Edw_Flag BSC_SYS_PERIODICITIES.EDW_FLAG%TYPE
36: , Calendar_Id BSC_SYS_PERIODICITIES.CALENDAR_ID%TYPE
37: , Edw_Periodicity_Id BSC_SYS_PERIODICITIES.EDW_PERIODICITY_ID%TYPE
38: , Custom_Code BSC_SYS_PERIODICITIES.CUSTOM_CODE%TYPE
39: , Db_Column_Name BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE
40: , Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_TYPE%TYPE
41: , Period_Type_Id BSC_SYS_PERIODICITIES.PERIOD_TYPE_ID%TYPE
42: , Record_Type_Id BSC_SYS_PERIODICITIES.RECORD_TYPE_ID%TYPE
43: , Xtd_Pattern BSC_SYS_PERIODICITIES.XTD_PATTERN%TYPE
36: , Calendar_Id BSC_SYS_PERIODICITIES.CALENDAR_ID%TYPE
37: , Edw_Periodicity_Id BSC_SYS_PERIODICITIES.EDW_PERIODICITY_ID%TYPE
38: , Custom_Code BSC_SYS_PERIODICITIES.CUSTOM_CODE%TYPE
39: , Db_Column_Name BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE
40: , Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_TYPE%TYPE
41: , Period_Type_Id BSC_SYS_PERIODICITIES.PERIOD_TYPE_ID%TYPE
42: , Record_Type_Id BSC_SYS_PERIODICITIES.RECORD_TYPE_ID%TYPE
43: , Xtd_Pattern BSC_SYS_PERIODICITIES.XTD_PATTERN%TYPE
44: , Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE
37: , Edw_Periodicity_Id BSC_SYS_PERIODICITIES.EDW_PERIODICITY_ID%TYPE
38: , Custom_Code BSC_SYS_PERIODICITIES.CUSTOM_CODE%TYPE
39: , Db_Column_Name BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE
40: , Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_TYPE%TYPE
41: , Period_Type_Id BSC_SYS_PERIODICITIES.PERIOD_TYPE_ID%TYPE
42: , Record_Type_Id BSC_SYS_PERIODICITIES.RECORD_TYPE_ID%TYPE
43: , Xtd_Pattern BSC_SYS_PERIODICITIES.XTD_PATTERN%TYPE
44: , Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE
45: , Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE
38: , Custom_Code BSC_SYS_PERIODICITIES.CUSTOM_CODE%TYPE
39: , Db_Column_Name BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE
40: , Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_TYPE%TYPE
41: , Period_Type_Id BSC_SYS_PERIODICITIES.PERIOD_TYPE_ID%TYPE
42: , Record_Type_Id BSC_SYS_PERIODICITIES.RECORD_TYPE_ID%TYPE
43: , Xtd_Pattern BSC_SYS_PERIODICITIES.XTD_PATTERN%TYPE
44: , Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE
45: , Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE
46: , Description BIS_LEVELS_TL.DESCRIPTION%TYPE
39: , Db_Column_Name BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE
40: , Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_TYPE%TYPE
41: , Period_Type_Id BSC_SYS_PERIODICITIES.PERIOD_TYPE_ID%TYPE
42: , Record_Type_Id BSC_SYS_PERIODICITIES.RECORD_TYPE_ID%TYPE
43: , Xtd_Pattern BSC_SYS_PERIODICITIES.XTD_PATTERN%TYPE
44: , Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE
45: , Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE
46: , Description BIS_LEVELS_TL.DESCRIPTION%TYPE
47: , Created_By BSC_SYS_PERIODICITIES_TL.CREATED_BY%TYPE
40: , Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_TYPE%TYPE
41: , Period_Type_Id BSC_SYS_PERIODICITIES.PERIOD_TYPE_ID%TYPE
42: , Record_Type_Id BSC_SYS_PERIODICITIES.RECORD_TYPE_ID%TYPE
43: , Xtd_Pattern BSC_SYS_PERIODICITIES.XTD_PATTERN%TYPE
44: , Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE
45: , Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE
46: , Description BIS_LEVELS_TL.DESCRIPTION%TYPE
47: , Created_By BSC_SYS_PERIODICITIES_TL.CREATED_BY%TYPE
48: , Creation_Date BSC_SYS_PERIODICITIES_TL.CREATION_DATE%TYPE
41: , Period_Type_Id BSC_SYS_PERIODICITIES.PERIOD_TYPE_ID%TYPE
42: , Record_Type_Id BSC_SYS_PERIODICITIES.RECORD_TYPE_ID%TYPE
43: , Xtd_Pattern BSC_SYS_PERIODICITIES.XTD_PATTERN%TYPE
44: , Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE
45: , Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE
46: , Description BIS_LEVELS_TL.DESCRIPTION%TYPE
47: , Created_By BSC_SYS_PERIODICITIES_TL.CREATED_BY%TYPE
48: , Creation_Date BSC_SYS_PERIODICITIES_TL.CREATION_DATE%TYPE
49: , Last_Updated_By BSC_SYS_PERIODICITIES_TL.LAST_UPDATED_BY%TYPE
43: , Xtd_Pattern BSC_SYS_PERIODICITIES.XTD_PATTERN%TYPE
44: , Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE
45: , Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE
46: , Description BIS_LEVELS_TL.DESCRIPTION%TYPE
47: , Created_By BSC_SYS_PERIODICITIES_TL.CREATED_BY%TYPE
48: , Creation_Date BSC_SYS_PERIODICITIES_TL.CREATION_DATE%TYPE
49: , Last_Updated_By BSC_SYS_PERIODICITIES_TL.LAST_UPDATED_BY%TYPE
50: , Last_Update_Date BSC_SYS_PERIODICITIES_TL.LAST_UPDATE_DATE%TYPE
51: , Last_Update_Login BSC_SYS_PERIODICITIES_TL.LAST_UPDATE_LOGIN%TYPE
44: , Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE
45: , Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE
46: , Description BIS_LEVELS_TL.DESCRIPTION%TYPE
47: , Created_By BSC_SYS_PERIODICITIES_TL.CREATED_BY%TYPE
48: , Creation_Date BSC_SYS_PERIODICITIES_TL.CREATION_DATE%TYPE
49: , Last_Updated_By BSC_SYS_PERIODICITIES_TL.LAST_UPDATED_BY%TYPE
50: , Last_Update_Date BSC_SYS_PERIODICITIES_TL.LAST_UPDATE_DATE%TYPE
51: , Last_Update_Login BSC_SYS_PERIODICITIES_TL.LAST_UPDATE_LOGIN%TYPE
52: , Application_id BIS_LEVELS.APPLICATION_ID%TYPE
45: , Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE
46: , Description BIS_LEVELS_TL.DESCRIPTION%TYPE
47: , Created_By BSC_SYS_PERIODICITIES_TL.CREATED_BY%TYPE
48: , Creation_Date BSC_SYS_PERIODICITIES_TL.CREATION_DATE%TYPE
49: , Last_Updated_By BSC_SYS_PERIODICITIES_TL.LAST_UPDATED_BY%TYPE
50: , Last_Update_Date BSC_SYS_PERIODICITIES_TL.LAST_UPDATE_DATE%TYPE
51: , Last_Update_Login BSC_SYS_PERIODICITIES_TL.LAST_UPDATE_LOGIN%TYPE
52: , Application_id BIS_LEVELS.APPLICATION_ID%TYPE
53: , Period_Year BSC_SYS_PERIODS.YEAR%TYPE
46: , Description BIS_LEVELS_TL.DESCRIPTION%TYPE
47: , Created_By BSC_SYS_PERIODICITIES_TL.CREATED_BY%TYPE
48: , Creation_Date BSC_SYS_PERIODICITIES_TL.CREATION_DATE%TYPE
49: , Last_Updated_By BSC_SYS_PERIODICITIES_TL.LAST_UPDATED_BY%TYPE
50: , Last_Update_Date BSC_SYS_PERIODICITIES_TL.LAST_UPDATE_DATE%TYPE
51: , Last_Update_Login BSC_SYS_PERIODICITIES_TL.LAST_UPDATE_LOGIN%TYPE
52: , Application_id BIS_LEVELS.APPLICATION_ID%TYPE
53: , Period_Year BSC_SYS_PERIODS.YEAR%TYPE
54: , Start_Period BSC_SYS_PERIODS.START_PERIOD%TYPE
47: , Created_By BSC_SYS_PERIODICITIES_TL.CREATED_BY%TYPE
48: , Creation_Date BSC_SYS_PERIODICITIES_TL.CREATION_DATE%TYPE
49: , Last_Updated_By BSC_SYS_PERIODICITIES_TL.LAST_UPDATED_BY%TYPE
50: , Last_Update_Date BSC_SYS_PERIODICITIES_TL.LAST_UPDATE_DATE%TYPE
51: , Last_Update_Login BSC_SYS_PERIODICITIES_TL.LAST_UPDATE_LOGIN%TYPE
52: , Application_id BIS_LEVELS.APPLICATION_ID%TYPE
53: , Period_Year BSC_SYS_PERIODS.YEAR%TYPE
54: , Start_Period BSC_SYS_PERIODS.START_PERIOD%TYPE
55: , End_Period BSC_SYS_PERIODS.END_PERIOD%TYPE