APPS.BSC_CALENDAR_PVT dependencies on BSC_SYS_CALENDARS_TL

Line 73: INSERT INTO bsc_sys_calendars_tl

69: , NVL(p_Calendar_Record.Last_Update_Login,FND_GLOBAL.LOGIN_ID)
70: , p_Calendar_Record.Dim_Short_Name
71: );
72:
73: INSERT INTO bsc_sys_calendars_tl
74: ( calendar_id
75: , language
76: , source_lang
77: , name

Line 101: FROM bsc_sys_calendars_tl T

97: WHERE L.INSTALLED_FLAG IN ('I', 'B')
98: AND NOT EXISTS
99: (
100: SELECT NULL
101: FROM bsc_sys_calendars_tl T
102: WHERE T.calendar_id = p_Calendar_Record.Calendar_Id
103: AND T.LANGUAGE = L.LANGUAGE_CODE
104: );
105:

Line 156: UPDATE bsc_sys_calendars_tl

152: , last_update_date = p_Calendar_Record.Last_Update_Date
153: , last_update_login = p_Calendar_Record.Last_Update_Login
154: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
155:
156: UPDATE bsc_sys_calendars_tl
157: SET name = p_Calendar_Record.Name
158: , help = p_Calendar_Record.Help
159: , last_updated_by = p_Calendar_Record.Last_Updated_By
160: , last_update_date = p_Calendar_Record.Last_Update_Date

Line 245: DELETE bsc_sys_calendars_tl

241:
242: DELETE bsc_sys_periodicities
243: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
244:
245: DELETE bsc_sys_calendars_tl
246: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
247: --dbms_output.put_line(' deleting from bsc_sys_calendars_b with calendar id as :- ' || p_Calendar_Record.Calendar_Id);
248:
249: DELETE bsc_sys_calendars_b