APPS.QP_PRICE_FORMULAS_PKG dependencies on QP_PRICE_FORMULAS_TL

Line 91: insert into QP_PRICE_FORMULAS_TL (

87: X_LAST_UPDATE_LOGIN,
88: X_FORMULA
89: );
90:
91: insert into QP_PRICE_FORMULAS_TL (
92: PRICE_FORMULA_ID,
93: NAME,
94: DESCRIPTION,
95: CREATION_DATE,

Line 117: from QP_PRICE_FORMULAS_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from QP_PRICE_FORMULAS_TL T
118: where T.PRICE_FORMULA_ID = X_PRICE_FORMULA_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: open c;

Line 184: from QP_PRICE_FORMULAS_TL

180: cursor c1 is select
181: NAME,
182: DESCRIPTION,
183: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
184: from QP_PRICE_FORMULAS_TL
185: where PRICE_FORMULA_ID = X_PRICE_FORMULA_ID
186: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
187: for update of PRICE_FORMULA_ID nowait;
188: begin

Line 314: update QP_PRICE_FORMULAS_TL set

310: if (sql%notfound) then
311: raise no_data_found;
312: end if;
313:
314: update QP_PRICE_FORMULAS_TL set
315: NAME = X_NAME,
316: DESCRIPTION = X_DESCRIPTION,
317: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
318: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 333: delete from QP_PRICE_FORMULAS_TL

329: procedure DELETE_ROW (
330: X_PRICE_FORMULA_ID in NUMBER
331: ) is
332: begin
333: delete from QP_PRICE_FORMULAS_TL
334: where PRICE_FORMULA_ID = X_PRICE_FORMULA_ID;
335:
336: if (sql%notfound) then
337: raise no_data_found;

Line 351: delete from QP_PRICE_FORMULAS_TL T

347:
348: procedure ADD_LANGUAGE
349: is
350: begin
351: delete from QP_PRICE_FORMULAS_TL T
352: where not exists
353: (select NULL
354: from QP_PRICE_FORMULAS_B B
355: where B.PRICE_FORMULA_ID = T.PRICE_FORMULA_ID

Line 358: update QP_PRICE_FORMULAS_TL T set (

354: from QP_PRICE_FORMULAS_B B
355: where B.PRICE_FORMULA_ID = T.PRICE_FORMULA_ID
356: );
357:
358: update QP_PRICE_FORMULAS_TL T set (
359: NAME,
360: DESCRIPTION
361: ) = (select
362: B.NAME,

Line 364: from QP_PRICE_FORMULAS_TL B

360: DESCRIPTION
361: ) = (select
362: B.NAME,
363: B.DESCRIPTION
364: from QP_PRICE_FORMULAS_TL B
365: where B.PRICE_FORMULA_ID = T.PRICE_FORMULA_ID
366: and B.LANGUAGE = T.SOURCE_LANG)
367: where (
368: T.PRICE_FORMULA_ID,

Line 373: from QP_PRICE_FORMULAS_TL SUBB, QP_PRICE_FORMULAS_TL SUBT

369: T.LANGUAGE
370: ) in (select
371: SUBT.PRICE_FORMULA_ID,
372: SUBT.LANGUAGE
373: from QP_PRICE_FORMULAS_TL SUBB, QP_PRICE_FORMULAS_TL SUBT
374: where SUBB.PRICE_FORMULA_ID = SUBT.PRICE_FORMULA_ID
375: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
376: and (SUBB.NAME <> SUBT.NAME
377: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 382: insert into QP_PRICE_FORMULAS_TL (

378: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
379: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
380: ));
381:
382: insert into QP_PRICE_FORMULAS_TL (
383: PRICE_FORMULA_ID,
384: NAME,
385: DESCRIPTION,
386: CREATION_DATE,

Line 404: from QP_PRICE_FORMULAS_TL B, FND_LANGUAGES L

400: B.LAST_UPDATED_BY,
401: B.LAST_UPDATE_LOGIN,
402: L.LANGUAGE_CODE,
403: B.SOURCE_LANG
404: from QP_PRICE_FORMULAS_TL B, FND_LANGUAGES L
405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL

Line 409: from QP_PRICE_FORMULAS_TL T

405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL
409: from QP_PRICE_FORMULAS_TL T
410: where T.PRICE_FORMULA_ID = B.PRICE_FORMULA_ID
411: and T.LANGUAGE = L.LANGUAGE_CODE);
412: end ADD_LANGUAGE;
413: