APPS.HR_FORM_DATA_GROUPS_PKG dependencies on HR_FORM_DATA_GROUPS_TL

Line 66: insert into HR_FORM_DATA_GROUPS_TL (

62: X_LAST_UPDATED_BY,
63: X_LAST_UPDATE_LOGIN
64: );
65:
66: insert into HR_FORM_DATA_GROUPS_TL (
67: CREATED_BY,
68: CREATION_DATE,
69: USER_DATA_GROUP_NAME,
70: DESCRIPTION,

Line 92: from HR_FORM_DATA_GROUPS_TL T

88: from FND_LANGUAGES L
89: where L.INSTALLED_FLAG in ('I', 'B')
90: and not exists
91: (select NULL
92: from HR_FORM_DATA_GROUPS_TL T
93: where T.FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID
94: and T.LANGUAGE = L.LANGUAGE_CODE);
95:
96: open c;

Line 129: from HR_FORM_DATA_GROUPS_TL

125: cursor c1 is select
126: USER_DATA_GROUP_NAME,
127: DESCRIPTION,
128: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
129: from HR_FORM_DATA_GROUPS_TL
130: where FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID
131: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
132: for update of FORM_DATA_GROUP_ID nowait;
133: begin

Line 196: update HR_FORM_DATA_GROUPS_TL set

192: if (sql%notfound) then
193: raise no_data_found;
194: end if;
195:
196: update HR_FORM_DATA_GROUPS_TL set
197: USER_DATA_GROUP_NAME = X_USER_DATA_GROUP_NAME,
198: DESCRIPTION = X_DESCRIPTION,
199: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
200: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 215: delete from HR_FORM_DATA_GROUPS_TL

211: procedure DELETE_ROW (
212: X_FORM_DATA_GROUP_ID in NUMBER
213: ) is
214: begin
215: delete from HR_FORM_DATA_GROUPS_TL
216: where FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID;
217:
218: if (sql%notfound) then
219: raise no_data_found;

Line 233: delete from HR_FORM_DATA_GROUPS_TL T

229:
230: procedure ADD_LANGUAGE
231: is
232: begin
233: delete from HR_FORM_DATA_GROUPS_TL T
234: where not exists
235: (select NULL
236: from HR_FORM_DATA_GROUPS_B B
237: where B.FORM_DATA_GROUP_ID = T.FORM_DATA_GROUP_ID

Line 240: update HR_FORM_DATA_GROUPS_TL T set (

236: from HR_FORM_DATA_GROUPS_B B
237: where B.FORM_DATA_GROUP_ID = T.FORM_DATA_GROUP_ID
238: );
239:
240: update HR_FORM_DATA_GROUPS_TL T set (
241: USER_DATA_GROUP_NAME,
242: DESCRIPTION
243: ) = (select
244: B.USER_DATA_GROUP_NAME,

Line 246: from HR_FORM_DATA_GROUPS_TL B

242: DESCRIPTION
243: ) = (select
244: B.USER_DATA_GROUP_NAME,
245: B.DESCRIPTION
246: from HR_FORM_DATA_GROUPS_TL B
247: where B.FORM_DATA_GROUP_ID = T.FORM_DATA_GROUP_ID
248: and B.LANGUAGE = T.SOURCE_LANG)
249: where (
250: T.FORM_DATA_GROUP_ID,

Line 255: from HR_FORM_DATA_GROUPS_TL SUBB, HR_FORM_DATA_GROUPS_TL SUBT

251: T.LANGUAGE
252: ) in (select
253: SUBT.FORM_DATA_GROUP_ID,
254: SUBT.LANGUAGE
255: from HR_FORM_DATA_GROUPS_TL SUBB, HR_FORM_DATA_GROUPS_TL SUBT
256: where SUBB.FORM_DATA_GROUP_ID = SUBT.FORM_DATA_GROUP_ID
257: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
258: and (SUBB.USER_DATA_GROUP_NAME <> SUBT.USER_DATA_GROUP_NAME
259: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 264: insert into HR_FORM_DATA_GROUPS_TL (

260: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
261: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
262: ));
263:
264: insert into HR_FORM_DATA_GROUPS_TL (
265: CREATED_BY,
266: CREATION_DATE,
267: USER_DATA_GROUP_NAME,
268: DESCRIPTION,

Line 286: from HR_FORM_DATA_GROUPS_TL B, FND_LANGUAGES L

282: B.LAST_UPDATE_LOGIN,
283: B.FORM_DATA_GROUP_ID,
284: L.LANGUAGE_CODE,
285: B.SOURCE_LANG
286: from HR_FORM_DATA_GROUPS_TL B, FND_LANGUAGES L
287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL

Line 291: from HR_FORM_DATA_GROUPS_TL T

287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL
291: from HR_FORM_DATA_GROUPS_TL T
292: where T.FORM_DATA_GROUP_ID = B.FORM_DATA_GROUP_ID
293: and T.LANGUAGE = L.LANGUAGE_CODE);
294: end ADD_LANGUAGE;
295:

Line 341: update HR_FORM_DATA_GROUPS_TL set

337: where data_group_name = x_data_group_name
338: and application_id = x_application_id
339: and form_id = x_form_id;
340:
341: update HR_FORM_DATA_GROUPS_TL set
342: DESCRIPTION = X_DESCRIPTION,
343: USER_DATA_GROUP_NAME = X_USER_DATA_GROUP_NAME,
344: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
345: LAST_UPDATED_BY = X_LAST_UPDATED_BY,