APPS.QP_MODIFIER_LIST_PVT dependencies on QP_LIST_HEADERS_TL

Line 140: insert into QP_LIST_HEADERS_TL

136: , X_ATTRIBUTE14
137: , X_ATTRIBUTE15
138: );
139:
140: insert into QP_LIST_HEADERS_TL
141: ( LIST_HEADER_ID
142: , NAME
143: , DESCRIPTION
144: , CREATION_DATE

Line 165: (select NULL from QP_LIST_HEADERS_TL T

161: , userenv('LANG')
162: from FND_LANGUAGES L
163: where L.INSTALLED_FLAG in ('I','B')
164: and not exists
165: (select NULL from QP_LIST_HEADERS_TL T
166: where T.LIST_HEADER_ID = X_LIST_HEADER_ID
167: and T.LANGUAGE = L.LANGUAGE_CODE);
168:
169: open C;

Line 235: FROM QP_LIST_HEADERS_TL

231:
232: cursor C1 is select NAME
233: , DESCRIPTION
234: , decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
235: FROM QP_LIST_HEADERS_TL
236: where LIST_HEADER_ID = X_LIST_HEADER_ID
237: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
238: for update of LIST_HEADER_ID nowait;
239:

Line 534: update QP_LIST_HEADERS_TL set

530: Raise NO_DATA_FOUND;
531:
532: end if;
533:
534: update QP_LIST_HEADERS_TL set
535: NAME = X_NAME
536: , DESCRIPTION = X_DESCRIPTION
537: , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
538: , LAST_UPDATED_BY = X_LAST_UPDATED_BY

Line 561: delete from QP_LIST_HEADERS_TL

557: ) IS
558:
559: begin
560:
561: delete from QP_LIST_HEADERS_TL
562: where LIST_HEADER_ID = X_LIST_HEADER_ID;
563:
564: if (SQL%NOTFOUND) then
565: Raise NO_DATA_FOUND;

Line 582: delete from QP_LIST_HEADERS_TL T

578: Procedure Add_Language is
579:
580: BEGIN
581:
582: delete from QP_LIST_HEADERS_TL T
583: where not exists
584: (select NULL from QP_LIST_HEADERS_B B
585: where B.LIST_HEADER_ID = T.LIST_HEADER_ID);
586:

Line 587: update QP_LIST_HEADERS_TL T set

583: where not exists
584: (select NULL from QP_LIST_HEADERS_B B
585: where B.LIST_HEADER_ID = T.LIST_HEADER_ID);
586:
587: update QP_LIST_HEADERS_TL T set
588: ( NAME
589: , DESCRIPTION)
590: = (select B.NAME , B.DESCRIPTION from QP_LIST_HEADERS_TL B
591: where B.LANGUAGE = T.SOURCE_LANG)

Line 590: = (select B.NAME , B.DESCRIPTION from QP_LIST_HEADERS_TL B

586:
587: update QP_LIST_HEADERS_TL T set
588: ( NAME
589: , DESCRIPTION)
590: = (select B.NAME , B.DESCRIPTION from QP_LIST_HEADERS_TL B
591: where B.LANGUAGE = T.SOURCE_LANG)
592: where ( T.LIST_HEADER_ID , T.LANGUAGE) in
593: (select SUBT.LIST_HEADER_ID , SUBT.LANGUAGE
594: from QP_LIST_HEADERS_TL SUBB, QP_LIST_HEADERS_TL SUBT

Line 594: from QP_LIST_HEADERS_TL SUBB, QP_LIST_HEADERS_TL SUBT

590: = (select B.NAME , B.DESCRIPTION from QP_LIST_HEADERS_TL B
591: where B.LANGUAGE = T.SOURCE_LANG)
592: where ( T.LIST_HEADER_ID , T.LANGUAGE) in
593: (select SUBT.LIST_HEADER_ID , SUBT.LANGUAGE
594: from QP_LIST_HEADERS_TL SUBB, QP_LIST_HEADERS_TL SUBT
595: where SUBB.LIST_HEADER_ID = SUBT.LIST_HEADER_ID
596: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
597: and (SUBB.NAME <> SUBT.DESCRIPTION
598: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 603: insert into QP_LIST_HEADERS_TL

599: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
600: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
601: ));
602:
603: insert into QP_LIST_HEADERS_TL
604: ( LIST_HEADER_ID
605: , NAME
606: , DESCRIPTION
607: , CREATION_DATE

Line 625: from QP_LIST_HEADERS_TL B, FND_LANGUAGES L

621: , B.LAST_UPDATED_BY
622: , B.LAST_UPDATE_LOGIN
623: , L.LANGUAGE_CODE
624: , B.SOURCE_LANG
625: from QP_LIST_HEADERS_TL B, FND_LANGUAGES L
626: where L.INSTALLED_FLAG in ('I','B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL from QP_LIST_HEADERS_TL T

Line 629: (select NULL from QP_LIST_HEADERS_TL T

625: from QP_LIST_HEADERS_TL B, FND_LANGUAGES L
626: where L.INSTALLED_FLAG in ('I','B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL from QP_LIST_HEADERS_TL T
630: where T.LIST_HEADER_ID = B.LIST_HEADER_ID
631: and T.LANGUAGE = L.LANGUAGE_CODE);
632:
633: