33: period_Varray Start_End_Period_Varray;
34:
35: TYPE Period_Record IS record
36: (
37: Periodicity_Id bsc_sys_periods.periodicity_id%TYPE
38: , Base_Periodicity_Id bsc_sys_periods.periodicity_id%TYPE
39: , Calendar_Id bsc_sys_calendars_b.calendar_id%TYPE
40: , Year bsc_sys_periods.year%TYPE
41: , Periodicity_Type bsc_sys_periodicities.periodicity_type%TYPE
34:
35: TYPE Period_Record IS record
36: (
37: Periodicity_Id bsc_sys_periods.periodicity_id%TYPE
38: , Base_Periodicity_Id bsc_sys_periods.periodicity_id%TYPE
39: , Calendar_Id bsc_sys_calendars_b.calendar_id%TYPE
40: , Year bsc_sys_periods.year%TYPE
41: , Periodicity_Type bsc_sys_periodicities.periodicity_type%TYPE
42: , Periods VARCHAR2(32000)
36: (
37: Periodicity_Id bsc_sys_periods.periodicity_id%TYPE
38: , Base_Periodicity_Id bsc_sys_periods.periodicity_id%TYPE
39: , Calendar_Id bsc_sys_calendars_b.calendar_id%TYPE
40: , Year bsc_sys_periods.year%TYPE
41: , Periodicity_Type bsc_sys_periodicities.periodicity_type%TYPE
42: , Periods VARCHAR2(32000)
43: , period_Varry Start_End_Period_Varray
44: , No_Of_Periods bsc_sys_periodicities.num_of_periods%TYPE
41: , Periodicity_Type bsc_sys_periodicities.periodicity_type%TYPE
42: , Periods VARCHAR2(32000)
43: , period_Varry Start_End_Period_Varray
44: , No_Of_Periods bsc_sys_periodicities.num_of_periods%TYPE
45: , Created_By bsc_sys_periods.created_by%TYPE
46: , Creation_Date bsc_sys_periods.creation_date%TYPE
47: , Last_Updated_By bsc_sys_periods.last_updated_by%TYPE
48: , Last_Update_Date bsc_sys_periods.last_update_date%TYPE
49: , Last_Update_Login bsc_sys_periods.last_update_login%TYPE
42: , Periods VARCHAR2(32000)
43: , period_Varry Start_End_Period_Varray
44: , No_Of_Periods bsc_sys_periodicities.num_of_periods%TYPE
45: , Created_By bsc_sys_periods.created_by%TYPE
46: , Creation_Date bsc_sys_periods.creation_date%TYPE
47: , Last_Updated_By bsc_sys_periods.last_updated_by%TYPE
48: , Last_Update_Date bsc_sys_periods.last_update_date%TYPE
49: , Last_Update_Login bsc_sys_periods.last_update_login%TYPE
50: , Time_Fk bsc_sys_periods.time_fk%TYPE
43: , period_Varry Start_End_Period_Varray
44: , No_Of_Periods bsc_sys_periodicities.num_of_periods%TYPE
45: , Created_By bsc_sys_periods.created_by%TYPE
46: , Creation_Date bsc_sys_periods.creation_date%TYPE
47: , Last_Updated_By bsc_sys_periods.last_updated_by%TYPE
48: , Last_Update_Date bsc_sys_periods.last_update_date%TYPE
49: , Last_Update_Login bsc_sys_periods.last_update_login%TYPE
50: , Time_Fk bsc_sys_periods.time_fk%TYPE
51: );
44: , No_Of_Periods bsc_sys_periodicities.num_of_periods%TYPE
45: , Created_By bsc_sys_periods.created_by%TYPE
46: , Creation_Date bsc_sys_periods.creation_date%TYPE
47: , Last_Updated_By bsc_sys_periods.last_updated_by%TYPE
48: , Last_Update_Date bsc_sys_periods.last_update_date%TYPE
49: , Last_Update_Login bsc_sys_periods.last_update_login%TYPE
50: , Time_Fk bsc_sys_periods.time_fk%TYPE
51: );
52:
45: , Created_By bsc_sys_periods.created_by%TYPE
46: , Creation_Date bsc_sys_periods.creation_date%TYPE
47: , Last_Updated_By bsc_sys_periods.last_updated_by%TYPE
48: , Last_Update_Date bsc_sys_periods.last_update_date%TYPE
49: , Last_Update_Login bsc_sys_periods.last_update_login%TYPE
50: , Time_Fk bsc_sys_periods.time_fk%TYPE
51: );
52:
53: PROCEDURE Create_Periods
46: , Creation_Date bsc_sys_periods.creation_date%TYPE
47: , Last_Updated_By bsc_sys_periods.last_updated_by%TYPE
48: , Last_Update_Date bsc_sys_periods.last_update_date%TYPE
49: , Last_Update_Login bsc_sys_periods.last_update_login%TYPE
50: , Time_Fk bsc_sys_periods.time_fk%TYPE
51: );
52:
53: PROCEDURE Create_Periods
54: ( p_Api_Version IN NUMBER