APPS.FND_TIMEZONES_PKG dependencies on FND_TIMEZONES_B

Line 18: cursor C is select ROWID from FND_TIMEZONES_B

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from FND_TIMEZONES_B
19: where TIMEZONE_CODE = X_TIMEZONE_CODE
20: ;
21: begin
22: insert into FND_TIMEZONES_B (

Line 22: insert into FND_TIMEZONES_B (

18: cursor C is select ROWID from FND_TIMEZONES_B
19: where TIMEZONE_CODE = X_TIMEZONE_CODE
20: ;
21: begin
22: insert into FND_TIMEZONES_B (
23: TIMEZONE_CODE,
24: ENABLED_FLAG,
25: GMT_OFFSET,
26: DAYLIGHT_SAVINGS_FLAG,

Line 101: from FND_TIMEZONES_B

97: GMT_OFFSET,
98: DAYLIGHT_SAVINGS_FLAG,
99: ACTIVE_TIMEZONE_CODE,
100: UPGRADE_TZ_ID
101: from FND_TIMEZONES_B
102: where TIMEZONE_CODE = X_TIMEZONE_CODE
103: for update of TIMEZONE_CODE nowait;
104: recinfo c%rowtype;
105:

Line 163: update FND_TIMEZONES_B set

159: X_LAST_UPDATED_BY in NUMBER,
160: X_LAST_UPDATE_LOGIN in NUMBER
161: ) is
162: begin
163: update FND_TIMEZONES_B set
164: ENABLED_FLAG = X_ENABLED_FLAG,
165: GMT_OFFSET = X_GMT_OFFSET,
166: DAYLIGHT_SAVINGS_FLAG = X_DAYLIGHT_SAVINGS_FLAG,
167: ACTIVE_TIMEZONE_CODE = X_ACTIVE_TIMEZONE_CODE,

Line 203: delete from FND_TIMEZONES_B

199: if (sql%notfound) then
200: raise no_data_found;
201: end if;
202:
203: delete from FND_TIMEZONES_B
204: where TIMEZONE_CODE = X_TIMEZONE_CODE;
205:
206: if (sql%notfound) then
207: raise no_data_found;

Line 223: from FND_TIMEZONES_B B

219:
220: delete from FND_TIMEZONES_TL T
221: where not exists
222: (select NULL
223: from FND_TIMEZONES_B B
224: where B.TIMEZONE_CODE = T.TIMEZONE_CODE
225: );
226:
227: update FND_TIMEZONES_TL T set (

Line 353: from FND_TIMEZONES_B

349: begin
350:
351: select LAST_UPDATED_BY, LAST_UPDATE_DATE
352: into db_luby, db_ludate
353: from FND_TIMEZONES_B
354: where TIMEZONE_CODE = X_TIMEZONE_CODE;
355:
356: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
357: db_ludate, X_CUSTOM_MODE)) then