APPS.SO_PRICE_LISTS_PKG dependencies on SO_PRICE_LISTS_TL

Line 112: insert into SO_PRICE_LISTS_TL (

108: X_LAST_UPDATED_BY,
109: X_LAST_UPDATE_LOGIN
110: );
111:
112: insert into SO_PRICE_LISTS_TL (
113: PRICE_LIST_ID,
114: NAME,
115: DESCRIPTION,
116: CREATION_DATE,

Line 138: from SO_PRICE_LISTS_TL T

134: from FND_LANGUAGES L
135: where L.INSTALLED_FLAG in ('I', 'B')
136: and not exists
137: (select NULL
138: from SO_PRICE_LISTS_TL T
139: where T.PRICE_LIST_ID = X_PRICE_LIST_ID
140: and T.LANGUAGE = L.LANGUAGE_CODE);
141:
142: open c;

Line 219: from SO_PRICE_LISTS_TL

215: cursor c1 is select
216: NAME,
217: DESCRIPTION,
218: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
219: from SO_PRICE_LISTS_TL
220: where PRICE_LIST_ID = X_PRICE_LIST_ID
221: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
222: for update of PRICE_LIST_ID nowait;
223: begin

Line 375: update SO_PRICE_LISTS_TL set

371: if (sql%notfound) then
372: raise no_data_found;
373: end if;
374:
375: update SO_PRICE_LISTS_TL set
376: NAME = X_NAME,
377: DESCRIPTION = X_DESCRIPTION,
378: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
379: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 394: delete from SO_PRICE_LISTS_TL

390: procedure DELETE_ROW (
391: X_PRICE_LIST_ID in NUMBER
392: ) is
393: begin
394: delete from SO_PRICE_LISTS_TL
395: where PRICE_LIST_ID = X_PRICE_LIST_ID;
396:
397: if (sql%notfound) then
398: raise no_data_found;

Line 412: delete from SO_PRICE_LISTS_TL T

408:
409: procedure ADD_LANGUAGE
410: is
411: begin
412: delete from SO_PRICE_LISTS_TL T
413: where not exists
414: (select NULL
415: from SO_PRICE_LISTS_B B
416: where B.PRICE_LIST_ID = T.PRICE_LIST_ID

Line 419: update SO_PRICE_LISTS_TL T set (

415: from SO_PRICE_LISTS_B B
416: where B.PRICE_LIST_ID = T.PRICE_LIST_ID
417: );
418:
419: update SO_PRICE_LISTS_TL T set (
420: NAME,
421: DESCRIPTION
422: ) = (select
423: B.NAME,

Line 425: from SO_PRICE_LISTS_TL B

421: DESCRIPTION
422: ) = (select
423: B.NAME,
424: B.DESCRIPTION
425: from SO_PRICE_LISTS_TL B
426: where B.PRICE_LIST_ID = T.PRICE_LIST_ID
427: and B.LANGUAGE = T.SOURCE_LANG)
428: where (
429: T.PRICE_LIST_ID,

Line 434: from SO_PRICE_LISTS_TL SUBB, SO_PRICE_LISTS_TL SUBT

430: T.LANGUAGE
431: ) in (select
432: SUBT.PRICE_LIST_ID,
433: SUBT.LANGUAGE
434: from SO_PRICE_LISTS_TL SUBB, SO_PRICE_LISTS_TL SUBT
435: where SUBB.PRICE_LIST_ID = SUBT.PRICE_LIST_ID
436: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
437: and (SUBB.NAME <> SUBT.NAME
438: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 441: insert into SO_PRICE_LISTS_TL (

437: and (SUBB.NAME <> SUBT.NAME
438: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
439: ));
440:
441: insert into SO_PRICE_LISTS_TL (
442: PRICE_LIST_ID,
443: NAME,
444: DESCRIPTION,
445: CREATION_DATE,

Line 463: from SO_PRICE_LISTS_TL B, FND_LANGUAGES L

459: B.LAST_UPDATED_BY,
460: B.LAST_UPDATE_LOGIN,
461: L.LANGUAGE_CODE,
462: B.SOURCE_LANG
463: from SO_PRICE_LISTS_TL B, FND_LANGUAGES L
464: where L.INSTALLED_FLAG in ('I', 'B')
465: and B.LANGUAGE = userenv('LANG')
466: and not exists
467: (select NULL

Line 468: from SO_PRICE_LISTS_TL T

464: where L.INSTALLED_FLAG in ('I', 'B')
465: and B.LANGUAGE = userenv('LANG')
466: and not exists
467: (select NULL
468: from SO_PRICE_LISTS_TL T
469: where T.PRICE_LIST_ID = B.PRICE_LIST_ID
470: and T.LANGUAGE = L.LANGUAGE_CODE);
471: end ADD_LANGUAGE;
472: