APPS.PA_PROJECT_ROLE_TYPES_PKG dependencies on PA_PROJECT_ROLE_TYPES_TL

Line 128: insert into PA_PROJECT_ROLE_TYPES_TL (

124: X_LAST_UPDATED_BY,
125: X_LAST_UPDATE_LOGIN
126: );
127:
128: insert into PA_PROJECT_ROLE_TYPES_TL (
129: PROJECT_ROLE_ID,
130: MEANING,
131: DESCRIPTION,
132: CREATION_DATE,

Line 154: from PA_PROJECT_ROLE_TYPES_TL T

150: from FND_LANGUAGES L
151: where L.INSTALLED_FLAG in ('I', 'B')
152: and not exists
153: (select NULL
154: from PA_PROJECT_ROLE_TYPES_TL T
155: where T.PROJECT_ROLE_ID = X_PROJECT_ROLE_ID
156: and T.LANGUAGE = L.LANGUAGE_CODE);
157:
158:

Line 300: update PA_PROJECT_ROLE_TYPES_TL set

296: THEN
297: RAISE NO_DATA_FOUND;
298: END IF;
299: --dbms_output.put_line('check 102');
300: update PA_PROJECT_ROLE_TYPES_TL set
301: MEANING = X_MEANING,
302: DESCRIPTION = X_DESCRIPTION,
303: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
304: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 330: delete from PA_PROJECT_ROLE_TYPES_TL

326: FROM pa_project_role_types_b
327: WHERE ROWID = x_rowid;
328:
329:
330: delete from PA_PROJECT_ROLE_TYPES_TL
331: where PROJECT_ROLE_ID = X_PROJECT_ROLE_ID;
332:
333: if (sql%notfound) then
334: raise no_data_found;

Line 351: delete from PA_PROJECT_ROLE_TYPES_TL T

347:
348: procedure ADD_LANGUAGE
349: is
350: begin
351: delete from PA_PROJECT_ROLE_TYPES_TL T
352: where not exists
353: (select NULL
354: from PA_PROJECT_ROLE_TYPES_B B
355: where B.PROJECT_ROLE_ID = T.PROJECT_ROLE_ID

Line 358: update PA_PROJECT_ROLE_TYPES_TL T set (

354: from PA_PROJECT_ROLE_TYPES_B B
355: where B.PROJECT_ROLE_ID = T.PROJECT_ROLE_ID
356: );
357:
358: update PA_PROJECT_ROLE_TYPES_TL T set (
359: MEANING,
360: DESCRIPTION
361: ) = (select
362: B.MEANING,

Line 364: from PA_PROJECT_ROLE_TYPES_TL B

360: DESCRIPTION
361: ) = (select
362: B.MEANING,
363: B.DESCRIPTION
364: from PA_PROJECT_ROLE_TYPES_TL B
365: where B.PROJECT_ROLE_ID = T.PROJECT_ROLE_ID
366: and B.LANGUAGE = T.SOURCE_LANG)
367: where (
368: T.PROJECT_ROLE_ID,

Line 373: from PA_PROJECT_ROLE_TYPES_TL SUBB, PA_PROJECT_ROLE_TYPES_TL SUBT

369: T.LANGUAGE
370: ) in (select
371: SUBT.PROJECT_ROLE_ID,
372: SUBT.LANGUAGE
373: from PA_PROJECT_ROLE_TYPES_TL SUBB, PA_PROJECT_ROLE_TYPES_TL SUBT
374: where SUBB.PROJECT_ROLE_ID = SUBT.PROJECT_ROLE_ID
375: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
376: and (SUBB.MEANING <> SUBT.MEANING
377: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 382: insert into PA_PROJECT_ROLE_TYPES_TL (

378: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
379: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
380: ));
381:
382: insert into PA_PROJECT_ROLE_TYPES_TL (
383: PROJECT_ROLE_ID,
384: MEANING,
385: DESCRIPTION,
386: CREATION_DATE,

Line 404: from PA_PROJECT_ROLE_TYPES_TL B, FND_LANGUAGES L

400: B.LAST_UPDATED_BY,
401: B.LAST_UPDATE_LOGIN,
402: L.LANGUAGE_CODE,
403: B.SOURCE_LANG
404: from PA_PROJECT_ROLE_TYPES_TL B, FND_LANGUAGES L
405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL

Line 409: from PA_PROJECT_ROLE_TYPES_TL T

405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL
409: from PA_PROJECT_ROLE_TYPES_TL T
410: where T.PROJECT_ROLE_ID = B.PROJECT_ROLE_ID
411: and T.LANGUAGE = L.LANGUAGE_CODE);
412: end ADD_LANGUAGE;
413: