APPS.AMS_COMPETITOR_PRODUCTS_B_PKG dependencies on AMS_COMPETITOR_PRODUCTS_TL

Line 166: INSERT INTO AMS_COMPETITOR_PRODUCTS_TL(

162: , DECODE(p_attribute14 , FND_API.G_MISS_CHAR, NULL , p_attribute14)
163: , DECODE(p_attribute15 , FND_API.G_MISS_CHAR, NULL , p_attribute15)
164: );
165:
166: INSERT INTO AMS_COMPETITOR_PRODUCTS_TL(
167: competitor_product_id,
168: language,
169: source_lang,
170: last_update_date,

Line 195: FROM ams_competitor_products_tl t

191: FROM fnd_languages l
192: WHERE l.installed_flag IN ('I','B')
193: AND NOT EXISTS(
194: SELECT NULL
195: FROM ams_competitor_products_tl t
196: WHERE t.competitor_product_id = DECODE( px_competitor_product_id, FND_API.g_miss_num, NULL, px_competitor_product_id)
197: AND t.language = l.language_code ) ;
198:
199:

Line 303: UPDATE AMS_COMPETITOR_PRODUCTS_TL

299: IF (SQL%NOTFOUND) THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302:
303: UPDATE AMS_COMPETITOR_PRODUCTS_TL
304: SET
305: competitor_product_name = DECODE( p_competitor_product_name, FND_API.g_miss_char, competitor_product_name, p_competitor_product_name),
306: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
307: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 347: DELETE FROM AMS_COMPETITOR_PRODUCTS_TL

343: If (SQL%NOTFOUND) then
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: End If;
346:
347: DELETE FROM AMS_COMPETITOR_PRODUCTS_TL
348: WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID;
349: If (SQL%NOTFOUND) then
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: End If;

Line 482: delete from AMS_COMPETITOR_PRODUCTS_TL T

478: --=============================================
479: procedure ADD_LANGUAGE
480: is
481: begin
482: delete from AMS_COMPETITOR_PRODUCTS_TL T
483: where not exists
484: (select NULL
485: from AMS_COMPETITOR_PRODUCTS_B B
486: where B.competitor_product_id = T.competitor_product_id

Line 489: update AMS_COMPETITOR_PRODUCTS_TL T set (

485: from AMS_COMPETITOR_PRODUCTS_B B
486: where B.competitor_product_id = T.competitor_product_id
487: );
488:
489: update AMS_COMPETITOR_PRODUCTS_TL T set (
490: competitor_product_id
491: ) = (select
492: B.competitor_product_id
493: from AMS_COMPETITOR_PRODUCTS_TL B

Line 493: from AMS_COMPETITOR_PRODUCTS_TL B

489: update AMS_COMPETITOR_PRODUCTS_TL T set (
490: competitor_product_id
491: ) = (select
492: B.competitor_product_id
493: from AMS_COMPETITOR_PRODUCTS_TL B
494: where B.competitor_product_id = T.competitor_product_id
495: and B.LANGUAGE = T.SOURCE_LANG)
496: where (
497: T.competitor_product_id,

Line 502: from AMS_COMPETITOR_PRODUCTS_TL SUBB, AMS_COMPETITOR_PRODUCTS_TL SUBT

498: T.LANGUAGE
499: ) in (select
500: SUBT.competitor_product_id,
501: SUBT.LANGUAGE
502: from AMS_COMPETITOR_PRODUCTS_TL SUBB, AMS_COMPETITOR_PRODUCTS_TL SUBT
503: where SUBB.competitor_product_id = SUBT.competitor_product_id
504: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
505: and (SUBB.competitor_product_id <> SUBT.competitor_product_id
506: ));

Line 508: INSERT INTO AMS_COMPETITOR_PRODUCTS_TL(

504: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
505: and (SUBB.competitor_product_id <> SUBT.competitor_product_id
506: ));
507:
508: INSERT INTO AMS_COMPETITOR_PRODUCTS_TL(
509: competitor_product_id,
510: language,
511: source_lang,
512: last_update_date,

Line 532: from AMS_COMPETITOR_PRODUCTS_TL B, FND_LANGUAGES L

528: B.CREATION_DATE,
529: B.CREATED_BY,
530: B.competitor_product_name,
531: B.DESCRIPTION
532: from AMS_COMPETITOR_PRODUCTS_TL B, FND_LANGUAGES L
533: where L.INSTALLED_FLAG in ('I', 'B')
534: and B.LANGUAGE = userenv('LANG')
535: and not exists
536: (select NULL

Line 537: from AMS_COMPETITOR_PRODUCTS_TL T

533: where L.INSTALLED_FLAG in ('I', 'B')
534: and B.LANGUAGE = userenv('LANG')
535: and not exists
536: (select NULL
537: from AMS_COMPETITOR_PRODUCTS_TL T
538: where T.competitor_product_id = B.competitor_product_id
539: and T.LANGUAGE = L.LANGUAGE_CODE);
540:
541: end ADD_LANGUAGE;