APPS.QP_PB_INPUT_HEADERS_PKG dependencies on QP_PB_INPUT_HEADERS_TL

Line 151: insert into QP_PB_INPUT_HEADERS_TL (

147: X_VALIDATION_ERROR_FLAG,
148: X_CUST_ACCOUNT_ID
149: );
150:
151: insert into QP_PB_INPUT_HEADERS_TL (
152: PRICE_BOOK_NAME,
153: PB_INPUT_HEADER_ID,
154: PL_AGR_BSA_NAME,
155: PUB_TEMPLATE_NAME,

Line 179: from QP_PB_INPUT_HEADERS_TL T

175: from FND_LANGUAGES L
176: where L.INSTALLED_FLAG in ('I', 'B')
177: and not exists
178: (select NULL
179: from QP_PB_INPUT_HEADERS_TL T
180: where T.PB_INPUT_HEADER_ID = X_PB_INPUT_HEADER_ID
181: and T.LANGUAGE = L.LANGUAGE_CODE);
182:
183: open c;

Line 291: from QP_PB_INPUT_HEADERS_TL

287: PRICE_BOOK_NAME,
288: PL_AGR_BSA_NAME,
289: PUB_TEMPLATE_NAME,
290: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
291: from QP_PB_INPUT_HEADERS_TL
292: where PB_INPUT_HEADER_ID = X_PB_INPUT_HEADER_ID
293: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
294: for update of PB_INPUT_HEADER_ID nowait;
295: begin

Line 484: update QP_PB_INPUT_HEADERS_TL set

480: if (sql%notfound) then
481: raise no_data_found;
482: end if;
483:
484: update QP_PB_INPUT_HEADERS_TL set
485: PRICE_BOOK_NAME = X_PRICE_BOOK_NAME,
486: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
487: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
488: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 504: delete from QP_PB_INPUT_HEADERS_TL

500: procedure DELETE_ROW (
501: X_PB_INPUT_HEADER_ID in NUMBER
502: ) is
503: begin
504: delete from QP_PB_INPUT_HEADERS_TL
505: where PB_INPUT_HEADER_ID = X_PB_INPUT_HEADER_ID;
506:
507: if (sql%notfound) then
508: raise no_data_found;

Line 522: delete from QP_PB_INPUT_HEADERS_TL T

518:
519: procedure ADD_LANGUAGE
520: is
521: begin
522: delete from QP_PB_INPUT_HEADERS_TL T
523: where not exists
524: (select NULL
525: from QP_PB_INPUT_HEADERS_B B
526: where B.PB_INPUT_HEADER_ID = T.PB_INPUT_HEADER_ID

Line 529: update QP_PB_INPUT_HEADERS_TL T set (

525: from QP_PB_INPUT_HEADERS_B B
526: where B.PB_INPUT_HEADER_ID = T.PB_INPUT_HEADER_ID
527: );
528:
529: update QP_PB_INPUT_HEADERS_TL T set (
530: PRICE_BOOK_NAME,
531: PL_AGR_BSA_NAME,
532: PUB_TEMPLATE_NAME
533: ) = (select

Line 537: from QP_PB_INPUT_HEADERS_TL B

533: ) = (select
534: B.PRICE_BOOK_NAME,
535: B.PL_AGR_BSA_NAME,
536: B.PUB_TEMPLATE_NAME
537: from QP_PB_INPUT_HEADERS_TL B
538: where B.PB_INPUT_HEADER_ID = T.PB_INPUT_HEADER_ID
539: and B.LANGUAGE = T.SOURCE_LANG)
540: where (
541: T.PB_INPUT_HEADER_ID,

Line 546: from QP_PB_INPUT_HEADERS_TL SUBB, QP_PB_INPUT_HEADERS_TL SUBT

542: T.LANGUAGE
543: ) in (select
544: SUBT.PB_INPUT_HEADER_ID,
545: SUBT.LANGUAGE
546: from QP_PB_INPUT_HEADERS_TL SUBB, QP_PB_INPUT_HEADERS_TL SUBT
547: where SUBB.PB_INPUT_HEADER_ID = SUBT.PB_INPUT_HEADER_ID
548: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
549: and (SUBB.PRICE_BOOK_NAME <> SUBT.PRICE_BOOK_NAME
550: or SUBB.PL_AGR_BSA_NAME <> SUBT.PL_AGR_BSA_NAME

Line 555: insert into QP_PB_INPUT_HEADERS_TL (

551: or (SUBB.PL_AGR_BSA_NAME is null and SUBT.PL_AGR_BSA_NAME is not null)
552: or (SUBB.PL_AGR_BSA_NAME is not null and SUBT.PL_AGR_BSA_NAME is null)
553: ));
554:
555: insert into QP_PB_INPUT_HEADERS_TL (
556: PRICE_BOOK_NAME,
557: PB_INPUT_HEADER_ID,
558: LAST_UPDATE_LOGIN,
559: LAST_UPDATED_BY,

Line 579: from QP_PB_INPUT_HEADERS_TL B, FND_LANGUAGES L

575: B.CREATED_BY,
576: B.LAST_UPDATE_DATE,
577: L.LANGUAGE_CODE,
578: B.SOURCE_LANG
579: from QP_PB_INPUT_HEADERS_TL B, FND_LANGUAGES L
580: where L.INSTALLED_FLAG in ('I', 'B')
581: and B.LANGUAGE = userenv('LANG')
582: and not exists
583: (select NULL

Line 584: from QP_PB_INPUT_HEADERS_TL T

580: where L.INSTALLED_FLAG in ('I', 'B')
581: and B.LANGUAGE = userenv('LANG')
582: and not exists
583: (select NULL
584: from QP_PB_INPUT_HEADERS_TL T
585: where T.PB_INPUT_HEADER_ID = B.PB_INPUT_HEADER_ID
586: and T.LANGUAGE = L.LANGUAGE_CODE);
587: end ADD_LANGUAGE;
588: