[Home] [Help]
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_TIMEZONE_ID in NUMBER,
6: X_GLOBAL_TIMEZONE_NAME in VARCHAR2,
7: X_STANDARD_TIME_SHORT_CODE in VARCHAR2,
8: X_DAYLIGHT_SAVINGS_SHORT_CODE in VARCHAR2,
9: X_GMT_DEVIATION_HOURS in NUMBER,
10: X_DAYLIGHT_SAVINGS_TIME_FLAG in VARCHAR2,
11: X_BEGIN_DST_MONTH in VARCHAR2,
33: begin
34: insert into HZ_TIMEZONES (
35: TIMEZONE_ID,
36: GLOBAL_TIMEZONE_NAME,
37: STANDARD_TIME_SHORT_CODE,
38: DAYLIGHT_SAVINGS_SHORT_CODE,
39: GMT_DEVIATION_HOURS,
40: DAYLIGHT_SAVINGS_TIME_FLAG,
41: BEGIN_DST_MONTH,
56: LAST_UPDATE_LOGIN
57: ) values (
58: X_TIMEZONE_ID,
59: X_GLOBAL_TIMEZONE_NAME,
60: X_STANDARD_TIME_SHORT_CODE,
61: X_DAYLIGHT_SAVINGS_SHORT_CODE,
62: X_GMT_DEVIATION_HOURS,
63: X_DAYLIGHT_SAVINGS_TIME_FLAG,
64: X_BEGIN_DST_MONTH,
121:
122: procedure LOCK_ROW (
123: X_TIMEZONE_ID in NUMBER,
124: X_GLOBAL_TIMEZONE_NAME in VARCHAR2,
125: X_STANDARD_TIME_SHORT_CODE in VARCHAR2,
126: X_DAYLIGHT_SAVINGS_SHORT_CODE in VARCHAR2,
127: X_GMT_DEVIATION_HOURS in NUMBER,
128: X_DAYLIGHT_SAVINGS_TIME_FLAG in VARCHAR2,
129: X_BEGIN_DST_MONTH in VARCHAR2,
141: X_DESCRIPTION in VARCHAR2
142: ) is
143: cursor c is select
144: GLOBAL_TIMEZONE_NAME,
145: STANDARD_TIME_SHORT_CODE,
146: DAYLIGHT_SAVINGS_SHORT_CODE,
147: GMT_DEVIATION_HOURS,
148: DAYLIGHT_SAVINGS_TIME_FLAG,
149: BEGIN_DST_MONTH,
179: app_exception.raise_exception;
180: end if;
181: close c;
182: if ( (recinfo.GLOBAL_TIMEZONE_NAME = X_GLOBAL_TIMEZONE_NAME)
183: AND (recinfo.STANDARD_TIME_SHORT_CODE = X_STANDARD_TIME_SHORT_CODE)
184: AND ((recinfo.DAYLIGHT_SAVINGS_SHORT_CODE = X_DAYLIGHT_SAVINGS_SHORT_CODE)
185: OR ((recinfo.DAYLIGHT_SAVINGS_SHORT_CODE is null) AND (X_DAYLIGHT_SAVINGS_SHORT_CODE is null)))
186: AND (recinfo.DAYLIGHT_SAVINGS_TIME_FLAG = X_DAYLIGHT_SAVINGS_TIME_FLAG)
187: AND ((recinfo.BEGIN_DST_MONTH = X_BEGIN_DST_MONTH)
231:
232: procedure UPDATE_ROW (
233: X_TIMEZONE_ID in NUMBER,
234: X_GLOBAL_TIMEZONE_NAME in VARCHAR2,
235: X_STANDARD_TIME_SHORT_CODE in VARCHAR2,
236: X_DAYLIGHT_SAVINGS_SHORT_CODE in VARCHAR2,
237: X_GMT_DEVIATION_HOURS in NUMBER,
238: X_DAYLIGHT_SAVINGS_TIME_FLAG in VARCHAR2,
239: X_BEGIN_DST_MONTH in VARCHAR2,
255: ) is
256: begin
257: update HZ_TIMEZONES set
258: GLOBAL_TIMEZONE_NAME = X_GLOBAL_TIMEZONE_NAME,
259: STANDARD_TIME_SHORT_CODE = X_STANDARD_TIME_SHORT_CODE,
260: DAYLIGHT_SAVINGS_SHORT_CODE = X_DAYLIGHT_SAVINGS_SHORT_CODE,
261: GMT_DEVIATION_HOURS = X_GMT_DEVIATION_HOURS,
262: DAYLIGHT_SAVINGS_TIME_FLAG = X_DAYLIGHT_SAVINGS_TIME_FLAG,
263: BEGIN_DST_MONTH = X_BEGIN_DST_MONTH,