APPS.OE_PC_CONDITIONS_PKG dependencies on OE_PC_CONDITIONS_TL

Line 116: insert into OE_PC_CONDITIONS_TL (

112: X_LAST_UPDATED_BY,
113: X_LAST_UPDATE_LOGIN
114: );
115:
116: insert into OE_PC_CONDITIONS_TL (
117: CONDITION_ID,
118: USER_MESSAGE,
119: CREATED_BY,
120: CREATION_DATE,

Line 140: from OE_PC_CONDITIONS_TL T

136: from FND_LANGUAGES L
137: where L.INSTALLED_FLAG in ('I', 'B')
138: and not exists
139: (select NULL
140: from OE_PC_CONDITIONS_TL T
141: where T.CONDITION_ID = X_CONDITION_ID
142: and T.LANGUAGE = L.LANGUAGE_CODE);
143:
144: open c;

Line 223: from OE_PC_CONDITIONS_TL

219:
220: cursor c1 is select
221: USER_MESSAGE,
222: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
223: from OE_PC_CONDITIONS_TL
224: where CONDITION_ID = X_CONDITION_ID
225: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
226: for update of CONDITION_ID nowait;
227: begin

Line 373: update OE_PC_CONDITIONS_TL set

369: if (sql%notfound) then
370: raise no_data_found;
371: end if;
372:
373: update OE_PC_CONDITIONS_TL set
374: USER_MESSAGE = X_USER_MESSAGE,
375: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
376: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
377: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 394: delete from OE_PC_CONDITIONS_TL

390: X_CONDITION_ID in NUMBER
391: ) is
392: begin
393:
394: delete from OE_PC_CONDITIONS_TL
395: where CONDITION_ID = X_CONDITION_ID;
396:
397: if (sql%notfound) then
398: raise no_data_found;

Line 413: delete from OE_PC_CONDITIONS_TL T

409:
410: procedure ADD_LANGUAGE
411: is
412: begin
413: delete from OE_PC_CONDITIONS_TL T
414: where not exists
415: (select NULL
416: from OE_PC_CONDITIONS B
417: where B.CONDITION_ID = T.CONDITION_ID

Line 420: update OE_PC_CONDITIONS_TL T set (

416: from OE_PC_CONDITIONS B
417: where B.CONDITION_ID = T.CONDITION_ID
418: );
419:
420: update OE_PC_CONDITIONS_TL T set (
421: USER_MESSAGE
422: ) = (select
423: B.USER_MESSAGE
424: from OE_PC_CONDITIONS_TL B

Line 424: from OE_PC_CONDITIONS_TL B

420: update OE_PC_CONDITIONS_TL T set (
421: USER_MESSAGE
422: ) = (select
423: B.USER_MESSAGE
424: from OE_PC_CONDITIONS_TL B
425: where B.CONDITION_ID = T.CONDITION_ID
426: and B.LANGUAGE = T.SOURCE_LANG)
427: where (
428: T.CONDITION_ID,

Line 433: from OE_PC_CONDITIONS_TL SUBB, OE_PC_CONDITIONS_TL SUBT

429: T.LANGUAGE
430: ) in (select
431: SUBT.CONDITION_ID,
432: SUBT.LANGUAGE
433: from OE_PC_CONDITIONS_TL SUBB, OE_PC_CONDITIONS_TL SUBT
434: where SUBB.CONDITION_ID = SUBT.CONDITION_ID
435: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
436: and (SUBB.USER_MESSAGE <> SUBT.USER_MESSAGE
437: ));

Line 439: insert into OE_PC_CONDITIONS_TL (

435: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
436: and (SUBB.USER_MESSAGE <> SUBT.USER_MESSAGE
437: ));
438:
439: insert into OE_PC_CONDITIONS_TL (
440: CONDITION_ID,
441: USER_MESSAGE,
442: CREATED_BY,
443: CREATION_DATE,

Line 459: from OE_PC_CONDITIONS_TL B, FND_LANGUAGES L

455: B.LAST_UPDATE_DATE,
456: B.LAST_UPDATE_LOGIN,
457: L.LANGUAGE_CODE,
458: B.SOURCE_LANG
459: from OE_PC_CONDITIONS_TL B, FND_LANGUAGES L
460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL

Line 464: from OE_PC_CONDITIONS_TL T

460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL
464: from OE_PC_CONDITIONS_TL T
465: where T.CONDITION_ID = B.CONDITION_ID
466: and T.LANGUAGE = L.LANGUAGE_CODE);
467: end ADD_LANGUAGE;
468:

Line 478: update OE_PC_CONDITIONS_TL set

474: is
475: l_user_id number:=0;
476: begin
477: l_user_id :=fnd_load_util.owner_id(x_owner); --seed data versioning changes
478: update OE_PC_CONDITIONS_TL set
479: USER_MESSAGE = X_USER_MESSAGE,
480: LAST_UPDATE_DATE = sysdate,
481: --LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
482: LAST_UPDATED_BY =l_user_id ,