APPS.QP_SEGMENTS_PKG dependencies on QP_SEGMENTS_TL

Line 123: insert into QP_SEGMENTS_TL (

119: X_LAST_UPDATED_BY,
120: X_LAST_UPDATE_LOGIN
121: );
122:
123: insert into QP_SEGMENTS_TL (
124: SEGMENT_ID,
125: SEEDED_SEGMENT_NAME,
126: USER_SEGMENT_NAME,
127: SEEDED_DESCRIPTION,

Line 153: from QP_SEGMENTS_TL T

149: from FND_LANGUAGES L
150: where L.INSTALLED_FLAG in ('I', 'B')
151: and not exists
152: (select NULL
153: from QP_SEGMENTS_TL T
154: where T.SEGMENT_ID = X_SEGMENT_ID
155: and T.LANGUAGE = L.LANGUAGE_CODE);
156:
157: open c;

Line 244: from QP_SEGMENTS_TL

240: USER_SEGMENT_NAME,
241: SEEDED_DESCRIPTION,
242: USER_DESCRIPTION,
243: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
244: from QP_SEGMENTS_TL
245: where SEGMENT_ID = X_SEGMENT_ID
246: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
247: for update of SEGMENT_ID nowait;
248: begin

Line 413: update QP_SEGMENTS_TL set

409: if (sql%notfound) then
410: raise no_data_found;
411: end if;
412:
413: update QP_SEGMENTS_TL set
414: SEEDED_SEGMENT_NAME = X_SEEDED_SEGMENT_NAME,
415: USER_SEGMENT_NAME = X_USER_SEGMENT_NAME,
416: SEEDED_DESCRIPTION = X_SEEDED_DESCRIPTION,
417: USER_DESCRIPTION = X_USER_DESCRIPTION,

Line 434: delete from QP_SEGMENTS_TL

430: procedure DELETE_ROW (
431: X_SEGMENT_ID in NUMBER
432: ) is
433: begin
434: delete from QP_SEGMENTS_TL
435: where SEGMENT_ID = X_SEGMENT_ID;
436:
437: if (sql%notfound) then
438: raise no_data_found;

Line 452: delete from QP_SEGMENTS_TL T

448:
449: procedure ADD_LANGUAGE
450: is
451: begin
452: delete from QP_SEGMENTS_TL T
453: where not exists
454: (select NULL
455: from QP_SEGMENTS_B B
456: where B.SEGMENT_ID = T.SEGMENT_ID

Line 459: update QP_SEGMENTS_TL T set (

455: from QP_SEGMENTS_B B
456: where B.SEGMENT_ID = T.SEGMENT_ID
457: );
458:
459: update QP_SEGMENTS_TL T set (
460: SEEDED_SEGMENT_NAME,
461: USER_SEGMENT_NAME,
462: SEEDED_DESCRIPTION,
463: USER_DESCRIPTION

Line 469: from QP_SEGMENTS_TL B

465: B.SEEDED_SEGMENT_NAME,
466: B.USER_SEGMENT_NAME,
467: B.SEEDED_DESCRIPTION,
468: B.USER_DESCRIPTION
469: from QP_SEGMENTS_TL B
470: where B.SEGMENT_ID = T.SEGMENT_ID
471: and B.LANGUAGE = T.SOURCE_LANG)
472: where (
473: T.SEGMENT_ID,

Line 478: from QP_SEGMENTS_TL SUBB, QP_SEGMENTS_TL SUBT

474: T.LANGUAGE
475: ) in (select
476: SUBT.SEGMENT_ID,
477: SUBT.LANGUAGE
478: from QP_SEGMENTS_TL SUBB, QP_SEGMENTS_TL SUBT
479: where SUBB.SEGMENT_ID = SUBT.SEGMENT_ID
480: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
481: and (SUBB.SEEDED_SEGMENT_NAME <> SUBT.SEEDED_SEGMENT_NAME
482: or (SUBB.SEEDED_SEGMENT_NAME is null and SUBT.SEEDED_SEGMENT_NAME is not null)

Line 487: insert into QP_SEGMENTS_TL (

483: or (SUBB.SEEDED_SEGMENT_NAME is not null and SUBT.SEEDED_SEGMENT_NAME is null)
484: or SUBB.USER_SEGMENT_NAME <> SUBT.USER_SEGMENT_NAME
485: ));
486:
487: insert into QP_SEGMENTS_TL (
488: SEGMENT_ID,
489: SEEDED_SEGMENT_NAME,
490: USER_SEGMENT_NAME,
491: SEEDED_DESCRIPTION,

Line 513: from QP_SEGMENTS_TL B, FND_LANGUAGES L

509: B.LAST_UPDATE_DATE,
510: B.LAST_UPDATE_LOGIN,
511: L.LANGUAGE_CODE,
512: B.SOURCE_LANG
513: from QP_SEGMENTS_TL B, FND_LANGUAGES L
514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL

Line 518: from QP_SEGMENTS_TL T

514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL
518: from QP_SEGMENTS_TL T
519: where T.SEGMENT_ID = B.SEGMENT_ID
520: and T.LANGUAGE = L.LANGUAGE_CODE);
521: end ADD_LANGUAGE;
522: