APPS.PRP_GROUPS_PKG dependencies on PRP_GROUPS_TL

Line 85: insert into PRP_GROUPS_TL (

81: X_LAST_UPDATED_BY,
82: X_LAST_UPDATE_LOGIN
83: );
84:
85: insert into PRP_GROUPS_TL (
86: LAST_UPDATE_DATE,
87: LAST_UPDATE_LOGIN,
88: GROUP_ID,
89: GROUP_NAME,

Line 111: from PRP_GROUPS_TL T

107: from FND_LANGUAGES L
108: where L.INSTALLED_FLAG in ('I', 'B')
109: and not exists
110: (select NULL
111: from PRP_GROUPS_TL T
112: where T.GROUP_ID = X_GROUP_ID
113: and T.LANGUAGE = L.LANGUAGE_CODE);
114:
115: open c;

Line 174: from PRP_GROUPS_TL

170: cursor c1 is select
171: GROUP_NAME,
172: GROUP_DESC,
173: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
174: from PRP_GROUPS_TL
175: where GROUP_ID = X_GROUP_ID
176: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
177: for update of GROUP_ID nowait;
178: begin

Line 296: update PRP_GROUPS_TL set

292: if (sql%notfound) then
293: raise no_data_found;
294: end if;
295:
296: update PRP_GROUPS_TL set
297: GROUP_NAME = X_GROUP_NAME,
298: GROUP_DESC = X_GROUP_DESC,
299: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
300: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 315: delete from PRP_GROUPS_TL

311: procedure DELETE_ROW (
312: X_GROUP_ID in NUMBER
313: ) is
314: begin
315: delete from PRP_GROUPS_TL
316: where GROUP_ID = X_GROUP_ID;
317:
318: if (sql%notfound) then
319: raise no_data_found;

Line 333: delete from PRP_GROUPS_TL T

329:
330: procedure ADD_LANGUAGE
331: is
332: begin
333: delete from PRP_GROUPS_TL T
334: where not exists
335: (select NULL
336: from PRP_GROUPS_B B
337: where B.GROUP_ID = T.GROUP_ID

Line 340: update PRP_GROUPS_TL T set (

336: from PRP_GROUPS_B B
337: where B.GROUP_ID = T.GROUP_ID
338: );
339:
340: update PRP_GROUPS_TL T set (
341: GROUP_NAME,
342: GROUP_DESC
343: ) = (select
344: B.GROUP_NAME,

Line 346: from PRP_GROUPS_TL B

342: GROUP_DESC
343: ) = (select
344: B.GROUP_NAME,
345: B.GROUP_DESC
346: from PRP_GROUPS_TL B
347: where B.GROUP_ID = T.GROUP_ID
348: and B.LANGUAGE = T.SOURCE_LANG)
349: where (
350: T.GROUP_ID,

Line 355: from PRP_GROUPS_TL SUBB, PRP_GROUPS_TL SUBT

351: T.LANGUAGE
352: ) in (select
353: SUBT.GROUP_ID,
354: SUBT.LANGUAGE
355: from PRP_GROUPS_TL SUBB, PRP_GROUPS_TL SUBT
356: where SUBB.GROUP_ID = SUBT.GROUP_ID
357: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
358: and (SUBB.GROUP_NAME <> SUBT.GROUP_NAME
359: or SUBB.GROUP_DESC <> SUBT.GROUP_DESC

Line 364: insert into PRP_GROUPS_TL (

360: or (SUBB.GROUP_DESC is null and SUBT.GROUP_DESC is not null)
361: or (SUBB.GROUP_DESC is not null and SUBT.GROUP_DESC is null)
362: ));
363:
364: insert into PRP_GROUPS_TL (
365: LAST_UPDATE_DATE,
366: LAST_UPDATE_LOGIN,
367: GROUP_ID,
368: GROUP_NAME,

Line 386: from PRP_GROUPS_TL B, FND_LANGUAGES L

382: B.CREATION_DATE,
383: B.LAST_UPDATED_BY,
384: L.LANGUAGE_CODE,
385: B.SOURCE_LANG
386: from PRP_GROUPS_TL B, FND_LANGUAGES L
387: where L.INSTALLED_FLAG in ('I', 'B')
388: and B.LANGUAGE = userenv('LANG')
389: and not exists
390: (select NULL

Line 391: from PRP_GROUPS_TL T

387: where L.INSTALLED_FLAG in ('I', 'B')
388: and B.LANGUAGE = userenv('LANG')
389: and not exists
390: (select NULL
391: from PRP_GROUPS_TL T
392: where T.GROUP_ID = B.GROUP_ID
393: and T.LANGUAGE = L.LANGUAGE_CODE);
394: end ADD_LANGUAGE;
395:

Line 509: UPDATE prp_groups_tl

505: IS
506: l_login_id NUMBER := 0;
507: BEGIN
508:
509: UPDATE prp_groups_tl
510: SET group_name = p_group_name,
511: group_desc = p_group_desc,
512: last_update_date = sysdate,
513: last_updated_by = decode(p_owner, 'SEED', 1, 0),