APPS.QP_PRICE_BOOK_HEADERS_PKG dependencies on QP_PRICE_BOOK_HEADERS_TL

Line 74: insert into QP_PRICE_BOOK_HEADERS_TL (

70: X_LAST_UPDATED_BY,
71: X_LAST_UPDATE_LOGIN
72: );
73:
74: insert into QP_PRICE_BOOK_HEADERS_TL (
75: PRICE_BOOK_HEADER_ID,
76: PRICE_BOOK_NAME,
77: PL_AGR_BSA_NAME,
78: CREATION_DATE,

Line 100: from QP_PRICE_BOOK_HEADERS_TL T

96: from FND_LANGUAGES L
97: where L.INSTALLED_FLAG in ('I', 'B')
98: and not exists
99: (select NULL
100: from QP_PRICE_BOOK_HEADERS_TL T
101: where T.PRICE_BOOK_HEADER_ID = X_PRICE_BOOK_HEADER_ID
102: and T.LANGUAGE = L.LANGUAGE_CODE);
103:
104: open c;

Line 158: from QP_PRICE_BOOK_HEADERS_TL

154: PL_AGR_BSA_NAME,
155: -- PRICE_BOOK_HEADER_ID,
156: LANGUAGE,
157: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
158: from QP_PRICE_BOOK_HEADERS_TL
159: where PRICE_BOOK_HEADER_ID = X_PRICE_BOOK_HEADER_ID
160: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
161: for update of PRICE_BOOK_HEADER_ID nowait;
162: begin

Line 257: update QP_PRICE_BOOK_HEADERS_TL set

253: if (sql%notfound) then
254: raise no_data_found;
255: end if;
256:
257: update QP_PRICE_BOOK_HEADERS_TL set
258: PRICE_BOOK_NAME = X_PRICE_BOOK_NAME,
259: PL_AGR_BSA_NAME = X_PL_AGR_BSA_NAME,
260: PRICE_BOOK_HEADER_ID = X_PRICE_BOOK_HEADER_ID,
261: LANGUAGE = X_LANGUAGE,

Line 278: delete from QP_PRICE_BOOK_HEADERS_TL

274: procedure DELETE_ROW (
275: X_PRICE_BOOK_HEADER_ID in NUMBER
276: ) is
277: begin
278: delete from QP_PRICE_BOOK_HEADERS_TL
279: where PRICE_BOOK_HEADER_ID = X_PRICE_BOOK_HEADER_ID;
280:
281: if (sql%notfound) then
282: raise no_data_found;

Line 296: delete from QP_PRICE_BOOK_HEADERS_TL T

292:
293: procedure ADD_LANGUAGE
294: is
295: begin
296: delete from QP_PRICE_BOOK_HEADERS_TL T
297: where not exists
298: (select NULL
299: from QP_PRICE_BOOK_HEADERS_ALL_B B
300: where B.PRICE_BOOK_HEADER_ID = T.PRICE_BOOK_HEADER_ID

Line 303: update QP_PRICE_BOOK_HEADERS_TL T set (

299: from QP_PRICE_BOOK_HEADERS_ALL_B B
300: where B.PRICE_BOOK_HEADER_ID = T.PRICE_BOOK_HEADER_ID
301: );
302:
303: update QP_PRICE_BOOK_HEADERS_TL T set (
304: PRICE_BOOK_NAME,
305: PL_AGR_BSA_NAME
306: ) = (select
307: B.PRICE_BOOK_NAME,

Line 309: from QP_PRICE_BOOK_HEADERS_TL B

305: PL_AGR_BSA_NAME
306: ) = (select
307: B.PRICE_BOOK_NAME,
308: B.PL_AGR_BSA_NAME
309: from QP_PRICE_BOOK_HEADERS_TL B
310: where B.PRICE_BOOK_HEADER_ID = T.PRICE_BOOK_HEADER_ID
311: and B.LANGUAGE = T.SOURCE_LANG)
312: where (
313: T.PRICE_BOOK_HEADER_ID,

Line 318: from QP_PRICE_BOOK_HEADERS_TL SUBB, QP_PRICE_BOOK_HEADERS_TL SUBT

314: T.LANGUAGE
315: ) in (select
316: SUBT.PRICE_BOOK_HEADER_ID,
317: SUBT.LANGUAGE
318: from QP_PRICE_BOOK_HEADERS_TL SUBB, QP_PRICE_BOOK_HEADERS_TL SUBT
319: where SUBB.PRICE_BOOK_HEADER_ID = SUBT.PRICE_BOOK_HEADER_ID
320: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
321: and (SUBB.PRICE_BOOK_NAME <> SUBT.PRICE_BOOK_NAME
322: or SUBB.PL_AGR_BSA_NAME <> SUBT.PL_AGR_BSA_NAME

Line 327: insert into QP_PRICE_BOOK_HEADERS_TL (

323: or (SUBB.PL_AGR_BSA_NAME is null and SUBT.PL_AGR_BSA_NAME is not null)
324: or (SUBB.PL_AGR_BSA_NAME is not null and SUBT.PL_AGR_BSA_NAME is null)
325: ));
326:
327: insert into QP_PRICE_BOOK_HEADERS_TL (
328: PRICE_BOOK_HEADER_ID,
329: PRICE_BOOK_NAME,
330: PL_AGR_BSA_NAME,
331: CREATION_DATE,

Line 349: from QP_PRICE_BOOK_HEADERS_TL B, FND_LANGUAGES L

345: B.LAST_UPDATED_BY,
346: B.LAST_UPDATE_LOGIN,
347: L.LANGUAGE_CODE,
348: B.SOURCE_LANG
349: from QP_PRICE_BOOK_HEADERS_TL B, FND_LANGUAGES L
350: where L.INSTALLED_FLAG in ('I', 'B')
351: and B.LANGUAGE = userenv('LANG')
352: and not exists
353: (select NULL

Line 354: from QP_PRICE_BOOK_HEADERS_TL T

350: where L.INSTALLED_FLAG in ('I', 'B')
351: and B.LANGUAGE = userenv('LANG')
352: and not exists
353: (select NULL
354: from QP_PRICE_BOOK_HEADERS_TL T
355: where T.PRICE_BOOK_HEADER_ID = B.PRICE_BOOK_HEADER_ID
356: and T.LANGUAGE = L.LANGUAGE_CODE);
357: end ADD_LANGUAGE;
358: