APPS.PRP_COMPONENTS_PKG dependencies on PRP_COMPONENTS_TL

Line 88: insert into PRP_COMPONENTS_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into PRP_COMPONENTS_TL (
89: COMPONENT_ID,
90: COMPONENT_NAME,
91: COMPONENT_DESC,
92: CREATED_BY,

Line 114: from PRP_COMPONENTS_TL T

110: from FND_LANGUAGES L
111: where L.INSTALLED_FLAG in ('I', 'B')
112: and not exists
113: (select NULL
114: from PRP_COMPONENTS_TL T
115: where T.COMPONENT_ID = X_COMPONENT_ID
116: and T.LANGUAGE = L.LANGUAGE_CODE);
117:
118: open c;

Line 179: from PRP_COMPONENTS_TL

175: cursor c1 is select
176: COMPONENT_NAME,
177: COMPONENT_DESC,
178: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
179: from PRP_COMPONENTS_TL
180: where COMPONENT_ID = X_COMPONENT_ID
181: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
182: for update of COMPONENT_ID nowait;
183: begin

Line 304: update PRP_COMPONENTS_TL set

300: if (sql%notfound) then
301: raise no_data_found;
302: end if;
303:
304: update PRP_COMPONENTS_TL set
305: COMPONENT_NAME = X_COMPONENT_NAME,
306: COMPONENT_DESC = X_COMPONENT_DESC,
307: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
308: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 323: delete from PRP_COMPONENTS_TL

319: procedure DELETE_ROW (
320: X_COMPONENT_ID in NUMBER
321: ) is
322: begin
323: delete from PRP_COMPONENTS_TL
324: where COMPONENT_ID = X_COMPONENT_ID;
325:
326: if (sql%notfound) then
327: raise no_data_found;

Line 341: delete from PRP_COMPONENTS_TL T

337:
338: procedure ADD_LANGUAGE
339: is
340: begin
341: delete from PRP_COMPONENTS_TL T
342: where not exists
343: (select NULL
344: from PRP_COMPONENTS_B B
345: where B.COMPONENT_ID = T.COMPONENT_ID

Line 348: update PRP_COMPONENTS_TL T set (

344: from PRP_COMPONENTS_B B
345: where B.COMPONENT_ID = T.COMPONENT_ID
346: );
347:
348: update PRP_COMPONENTS_TL T set (
349: COMPONENT_NAME,
350: COMPONENT_DESC
351: ) = (select
352: B.COMPONENT_NAME,

Line 354: from PRP_COMPONENTS_TL B

350: COMPONENT_DESC
351: ) = (select
352: B.COMPONENT_NAME,
353: B.COMPONENT_DESC
354: from PRP_COMPONENTS_TL B
355: where B.COMPONENT_ID = T.COMPONENT_ID
356: and B.LANGUAGE = T.SOURCE_LANG)
357: where (
358: T.COMPONENT_ID,

Line 363: from PRP_COMPONENTS_TL SUBB, PRP_COMPONENTS_TL SUBT

359: T.LANGUAGE
360: ) in (select
361: SUBT.COMPONENT_ID,
362: SUBT.LANGUAGE
363: from PRP_COMPONENTS_TL SUBB, PRP_COMPONENTS_TL SUBT
364: where SUBB.COMPONENT_ID = SUBT.COMPONENT_ID
365: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
366: and (SUBB.COMPONENT_NAME <> SUBT.COMPONENT_NAME
367: or SUBB.COMPONENT_DESC <> SUBT.COMPONENT_DESC

Line 372: insert into PRP_COMPONENTS_TL (

368: or (SUBB.COMPONENT_DESC is null and SUBT.COMPONENT_DESC is not null)
369: or (SUBB.COMPONENT_DESC is not null and SUBT.COMPONENT_DESC is null)
370: ));
371:
372: insert into PRP_COMPONENTS_TL (
373: COMPONENT_ID,
374: COMPONENT_NAME,
375: COMPONENT_DESC,
376: CREATED_BY,

Line 394: from PRP_COMPONENTS_TL B, FND_LANGUAGES L

390: B.LAST_UPDATE_DATE,
391: B.LAST_UPDATE_LOGIN,
392: L.LANGUAGE_CODE,
393: B.SOURCE_LANG
394: from PRP_COMPONENTS_TL B, FND_LANGUAGES L
395: where L.INSTALLED_FLAG in ('I', 'B')
396: and B.LANGUAGE = userenv('LANG')
397: and not exists
398: (select NULL

Line 399: from PRP_COMPONENTS_TL T

395: where L.INSTALLED_FLAG in ('I', 'B')
396: and B.LANGUAGE = userenv('LANG')
397: and not exists
398: (select NULL
399: from PRP_COMPONENTS_TL T
400: where T.COMPONENT_ID = B.COMPONENT_ID
401: and T.LANGUAGE = L.LANGUAGE_CODE);
402: end ADD_LANGUAGE;
403: