APPS.FEM_STUDSCHL_YR_PKG dependencies on FEM_STUDSCHL_YR_TL

Line 46: insert into FEM_STUDSCHL_YR_TL (

42: X_LAST_UPDATED_BY,
43: X_LAST_UPDATE_LOGIN
44: );
45:
46: insert into FEM_STUDSCHL_YR_TL (
47: STUDENT_YR_IN_SCHOOL_CODE,
48: STUDENT_YR_IN_SCHOOL_NAME,
49: DESCRIPTION,
50: CREATION_DATE,

Line 72: from FEM_STUDSCHL_YR_TL T

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from FEM_STUDSCHL_YR_TL T
73: where T.STUDENT_YR_IN_SCHOOL_CODE = X_STUDENT_YR_IN_SCHOOL_CODE
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75:
76: open c;

Line 109: from FEM_STUDSCHL_YR_TL

105: cursor c1 is select
106: STUDENT_YR_IN_SCHOOL_NAME,
107: DESCRIPTION,
108: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
109: from FEM_STUDSCHL_YR_TL
110: where STUDENT_YR_IN_SCHOOL_CODE = X_STUDENT_YR_IN_SCHOOL_CODE
111: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
112: for update of STUDENT_YR_IN_SCHOOL_CODE nowait;
113: begin

Line 175: update FEM_STUDSCHL_YR_TL set

171: if (sql%notfound) then
172: raise no_data_found;
173: end if;
174:
175: update FEM_STUDSCHL_YR_TL set
176: STUDENT_YR_IN_SCHOOL_NAME = X_STUDENT_YR_IN_SCHOOL_NAME,
177: DESCRIPTION = X_DESCRIPTION,
178: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
179: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 194: delete from FEM_STUDSCHL_YR_TL

190: procedure DELETE_ROW (
191: X_STUDENT_YR_IN_SCHOOL_CODE in VARCHAR2
192: ) is
193: begin
194: delete from FEM_STUDSCHL_YR_TL
195: where STUDENT_YR_IN_SCHOOL_CODE = X_STUDENT_YR_IN_SCHOOL_CODE;
196:
197: if (sql%notfound) then
198: raise no_data_found;

Line 212: delete from FEM_STUDSCHL_YR_TL T

208:
209: procedure ADD_LANGUAGE
210: is
211: begin
212: delete from FEM_STUDSCHL_YR_TL T
213: where not exists
214: (select NULL
215: from FEM_STUDSCHL_YR_B B
216: where B.STUDENT_YR_IN_SCHOOL_CODE = T.STUDENT_YR_IN_SCHOOL_CODE

Line 219: update FEM_STUDSCHL_YR_TL T set (

215: from FEM_STUDSCHL_YR_B B
216: where B.STUDENT_YR_IN_SCHOOL_CODE = T.STUDENT_YR_IN_SCHOOL_CODE
217: );
218:
219: update FEM_STUDSCHL_YR_TL T set (
220: STUDENT_YR_IN_SCHOOL_NAME,
221: DESCRIPTION
222: ) = (select
223: B.STUDENT_YR_IN_SCHOOL_NAME,

Line 225: from FEM_STUDSCHL_YR_TL B

221: DESCRIPTION
222: ) = (select
223: B.STUDENT_YR_IN_SCHOOL_NAME,
224: B.DESCRIPTION
225: from FEM_STUDSCHL_YR_TL B
226: where B.STUDENT_YR_IN_SCHOOL_CODE = T.STUDENT_YR_IN_SCHOOL_CODE
227: and B.LANGUAGE = T.SOURCE_LANG)
228: where (
229: T.STUDENT_YR_IN_SCHOOL_CODE,

Line 234: from FEM_STUDSCHL_YR_TL SUBB, FEM_STUDSCHL_YR_TL SUBT

230: T.LANGUAGE
231: ) in (select
232: SUBT.STUDENT_YR_IN_SCHOOL_CODE,
233: SUBT.LANGUAGE
234: from FEM_STUDSCHL_YR_TL SUBB, FEM_STUDSCHL_YR_TL SUBT
235: where SUBB.STUDENT_YR_IN_SCHOOL_CODE = SUBT.STUDENT_YR_IN_SCHOOL_CODE
236: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
237: and (SUBB.STUDENT_YR_IN_SCHOOL_NAME <> SUBT.STUDENT_YR_IN_SCHOOL_NAME
238: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 241: insert into FEM_STUDSCHL_YR_TL (

237: and (SUBB.STUDENT_YR_IN_SCHOOL_NAME <> SUBT.STUDENT_YR_IN_SCHOOL_NAME
238: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
239: ));
240:
241: insert into FEM_STUDSCHL_YR_TL (
242: STUDENT_YR_IN_SCHOOL_CODE,
243: STUDENT_YR_IN_SCHOOL_NAME,
244: DESCRIPTION,
245: CREATION_DATE,

Line 263: from FEM_STUDSCHL_YR_TL B, FND_LANGUAGES L

259: B.LAST_UPDATE_DATE,
260: B.LAST_UPDATE_LOGIN,
261: L.LANGUAGE_CODE,
262: B.SOURCE_LANG
263: from FEM_STUDSCHL_YR_TL B, FND_LANGUAGES L
264: where L.INSTALLED_FLAG in ('I', 'B')
265: and B.LANGUAGE = userenv('LANG')
266: and not exists
267: (select NULL

Line 268: from FEM_STUDSCHL_YR_TL T

264: where L.INSTALLED_FLAG in ('I', 'B')
265: and B.LANGUAGE = userenv('LANG')
266: and not exists
267: (select NULL
268: from FEM_STUDSCHL_YR_TL T
269: where T.STUDENT_YR_IN_SCHOOL_CODE = B.STUDENT_YR_IN_SCHOOL_CODE
270: and T.LANGUAGE = L.LANGUAGE_CODE);
271: end ADD_LANGUAGE;
272: PROCEDURE TRANSLATE_ROW(

Line 298: from FEM_STUDSCHL_YR_TL

294: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
295: begin
296: select LAST_UPDATED_BY, LAST_UPDATE_DATE
297: into db_luby, db_ludate
298: from FEM_STUDSCHL_YR_TL
299: where STUDENT_YR_IN_SCHOOL_CODE = x_STUDENT_YR_IN_SCHOOL_CODE
300: and LANGUAGE = userenv('LANG');
301:
302: -- Test for customization and version

Line 306: update FEM_STUDSCHL_YR_TL set

302: -- Test for customization and version
303: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
304: db_ludate, x_custom_mode)) then
305: -- Update translations for this language
306: update FEM_STUDSCHL_YR_TL set
307: STUDENT_YR_IN_SCHOOL_NAME = decode(x_STUDENT_YR_IN_SCHOOL_NAME,
308: fnd_load_util.null_value, null, -- Real null
309: null, x_STUDENT_YR_IN_SCHOOL_NAME, -- No change
310: x_STUDENT_YR_IN_SCHOOL_NAME),