DBA Data[Home] [Help]

APPS.BSC_PERIODS_PUB dependencies on BSC_SYS_PERIODS

Line 37: Periodicity_Id bsc_sys_periods.periodicity_id%TYPE

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

Line 38: , Base_Periodicity_Id bsc_sys_periods.periodicity_id%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)

Line 40: , Year bsc_sys_periods.year%TYPE

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

Line 45: , Created_By bsc_sys_periods.created_by%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

Line 46: , Creation_Date bsc_sys_periods.creation_date%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

Line 47: , Last_Updated_By bsc_sys_periods.last_updated_by%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: );

Line 48: , Last_Update_Date bsc_sys_periods.last_update_date%TYPE

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:

Line 49: , Last_Update_Login bsc_sys_periods.last_update_login%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:
53: PROCEDURE Create_Periods

Line 50: , Time_Fk bsc_sys_periods.time_fk%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
54: ( p_Api_Version IN NUMBER