APPS.QP_LIST_HEADERS_PKG dependencies on QP_LIST_HEADERS_TL

Line 189: insert into QP_LIST_HEADERS_TL (

185: X_PROGRAM_ID,
186: X_PROGRAM_UPDATE_DATE
187: );
188:
189: insert into QP_LIST_HEADERS_TL (
190: LIST_HEADER_ID,
191: CREATION_DATE,
192: CREATED_BY,
193: LAST_UPDATE_DATE,

Line 217: from QP_LIST_HEADERS_TL T

213: from FND_LANGUAGES L
214: where L.INSTALLED_FLAG in ('I', 'B')
215: and not exists
216: (select NULL
217: from QP_LIST_HEADERS_TL T
218: where T.LIST_HEADER_ID = X_LIST_HEADER_ID
219: and T.LANGUAGE = L.LANGUAGE_CODE);
220:
221: open c;

Line 348: from QP_LIST_HEADERS_TL

344: NAME,
345: DESCRIPTION,
346: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG,
347: VERSION_NO
348: from QP_LIST_HEADERS_TL
349: where LIST_HEADER_ID = X_LIST_HEADER_ID
350: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
351: for update of LIST_HEADER_ID nowait;
352: begin

Line 598: update QP_LIST_HEADERS_TL set

594: if (sql%notfound) then
595: raise no_data_found;
596: end if;
597:
598: update QP_LIST_HEADERS_TL set
599: NAME = X_NAME,
600: DESCRIPTION = X_DESCRIPTION,
601: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
602: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 618: delete from QP_LIST_HEADERS_TL

614: procedure DELETE_ROW (
615: X_LIST_HEADER_ID in NUMBER
616: ) is
617: begin
618: delete from QP_LIST_HEADERS_TL
619: where LIST_HEADER_ID = X_LIST_HEADER_ID;
620:
621: if (sql%notfound) then
622: raise no_data_found;

Line 636: delete from QP_LIST_HEADERS_TL T

632:
633: procedure ADD_LANGUAGE
634: is
635: begin
636: delete from QP_LIST_HEADERS_TL T
637: where not exists
638: (select NULL
639: from QP_LIST_HEADERS_B B
640: where B.LIST_HEADER_ID = T.LIST_HEADER_ID

Line 643: update QP_LIST_HEADERS_TL T set (

639: from QP_LIST_HEADERS_B B
640: where B.LIST_HEADER_ID = T.LIST_HEADER_ID
641: );
642:
643: update QP_LIST_HEADERS_TL T set (
644: NAME,
645: DESCRIPTION
646: ) = (select
647: B.NAME,

Line 649: from QP_LIST_HEADERS_TL B

645: DESCRIPTION
646: ) = (select
647: B.NAME,
648: B.DESCRIPTION
649: from QP_LIST_HEADERS_TL B
650: where B.LIST_HEADER_ID = T.LIST_HEADER_ID
651: and B.LANGUAGE = T.SOURCE_LANG)
652: where (
653: T.LIST_HEADER_ID,

Line 658: from QP_LIST_HEADERS_TL SUBB, QP_LIST_HEADERS_TL SUBT

654: T.LANGUAGE
655: ) in (select
656: SUBT.LIST_HEADER_ID,
657: SUBT.LANGUAGE
658: from QP_LIST_HEADERS_TL SUBB, QP_LIST_HEADERS_TL SUBT
659: where SUBB.LIST_HEADER_ID = SUBT.LIST_HEADER_ID
660: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
661: and (SUBB.NAME <> SUBT.NAME
662: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 667: insert into QP_LIST_HEADERS_TL (

663: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
664: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
665: ));
666:
667: insert into QP_LIST_HEADERS_TL (
668: LIST_HEADER_ID,
669: CREATION_DATE,
670: CREATED_BY,
671: LAST_UPDATE_DATE,

Line 691: from QP_LIST_HEADERS_TL B, FND_LANGUAGES L

687: B.DESCRIPTION,
688: B.VERSION_NO,
689: L.LANGUAGE_CODE,
690: B.SOURCE_LANG
691: from QP_LIST_HEADERS_TL B, FND_LANGUAGES L
692: where L.INSTALLED_FLAG in ('I', 'B')
693: and B.LANGUAGE = userenv('LANG')
694: and not exists
695: (select NULL

Line 696: from QP_LIST_HEADERS_TL T

692: where L.INSTALLED_FLAG in ('I', 'B')
693: and B.LANGUAGE = userenv('LANG')
694: and not exists
695: (select NULL
696: from QP_LIST_HEADERS_TL T
697: where T.LIST_HEADER_ID = B.LIST_HEADER_ID
698: and T.LANGUAGE = L.LANGUAGE_CODE);
699: end ADD_LANGUAGE;
700: