[Home] [Help]
266: L_CATEGORY_REC.BUDGET_CODE_SUFFIX,
267: L_CATEGORY_REC.LEDGER_ID
268: );
269:
270: INSERT INTO AMS_CATEGORIES_TL (
271: CATEGORY_NAME,
272: DESCRIPTION,
273: LAST_UPDATE_DATE,
274: LAST_UPDATED_BY,
292: FROM FND_LANGUAGES L
293: WHERE L.INSTALLED_FLAG in ('I', 'B')
294: AND NOT EXISTS
295: (SELECT NULL
296: FROM AMS_CATEGORIES_TL T
297: WHERE T.CATEGORY_ID = l_category_rec.category_id
298: AND T.LANGUAGE = L.LANGUAGE_CODE);
299:
300: -- set OUT value
505: END IF;
506: RAISE FND_API.g_exc_error;
507: END IF;
508:
509: UPDATE AMS_CATEGORIES_TL
510: SET
511: LAST_UPDATE_DATE = sysdate,
512: LAST_UPDATED_BY = FND_GLOBAL.User_Id,
513: LAST_UPDATE_LOGIN = FND_GLOBAL.Conc_Login_Id,
565: END IF;
566: RAISE FND_API.g_exc_error;
567: END IF;
568:
569: UPDATE AMS_CATEGORIES_TL
570: SET
571: CATEGORY_NAME = l_category_rec.CATEGORY_NAME,
572: DESCRIPTION = l_category_rec.DESCRIPTION,
573: LAST_UPDATE_DATE = sysdate,
764: RAISE FND_API.g_exc_error;
765: END IF;
766:
767:
768: delete from AMS_CATEGORIES_TL
769: where category_id = l_category_id
770: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
771:
772: IF (SQL%NOTFOUND) THEN
883: and object_version_number = p_object_version
884: FOR UPDATE of category_id NOWAIT;
885: Recinfo C_ams_categories_b%ROWTYPE;
886:
887: CURSOR C_ams_categories_tl IS
888: SELECT CATEGORY_NAME,
889: DESCRIPTION,
890: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
891: FROM AMS_CATEGORIES_TL
887: CURSOR C_ams_categories_tl IS
888: SELECT CATEGORY_NAME,
889: DESCRIPTION,
890: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
891: FROM AMS_CATEGORIES_TL
892: WHERE CATEGORY_ID = p_CATEGORY_ID
893: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG)
894: FOR UPDATE OF CATEGORY_ID NOWAIT;
895: Tlinfo C_ams_categories_tl%ROWTYPE;
891: FROM AMS_CATEGORIES_TL
892: WHERE CATEGORY_ID = p_CATEGORY_ID
893: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG)
894: FOR UPDATE OF CATEGORY_ID NOWAIT;
895: Tlinfo C_ams_categories_tl%ROWTYPE;
896:
897: BEGIN
898: IF (AMS_DEBUG_HIGH_ON) THEN
899:
937: END IF;
938:
939: CLOSE C_ams_categories_b;
940:
941: open C_ams_categories_tl ;
942: close C_ams_categories_tl;
943:
944: -- Standard call to get message count AND IF count is 1, get message info.
945: FND_MSG_PUB.Count_AND_Get
938:
939: CLOSE C_ams_categories_b;
940:
941: open C_ams_categories_tl ;
942: close C_ams_categories_tl;
943:
944: -- Standard call to get message count AND IF count is 1, get message info.
945: FND_MSG_PUB.Count_AND_Get
946: ( p_count => x_msg_count,
1555: l_return_status VARCHAR2(1); -- Return value from procedures
1556: l_item_name VARCHAR2(30); -- Return value from procedures
1557: l_dummy NUMBER;
1558: cursor c_ctg_name_crt(ctg_name_in IN VARCHAR2, ctg_id_in IN NUMBER,ctg_arc_in IN VARCHAR2) IS
1559: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_CATEGORIES_TL t,
1560: AMS_CATEGORIES_B b
1561: where t.category_name = ctg_name_in
1562: and b.arc_category_created_for = ctg_arc_in
1563: and language = userenv('LANG')
1565: --and t.category_id = ctg_id_in
1566: --and b.category_id = ctg_id_in
1567: );
1568: cursor c_ctg_name_updt(ctg_name_in IN VARCHAR2, ctg_id_in IN NUMBER,ctg_arc_in IN VARCHAR2) IS
1569: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_CATEGORIES_TL t,
1570: AMS_CATEGORIES_B b
1571: where t.category_name = ctg_name_in
1572: and b.arc_category_created_for = ctg_arc_in
1573: and language = userenv('LANG')
1589: THEN
1590:
1591: /* bug 1490374
1592: if AMS_Utility_PVT.Check_Uniqueness
1593: (p_table_name => 'AMS_CATEGORIES_TL',
1594: p_where_clause => 'category_name = '
1595: || ''''
1596: || p_category_rec.category_name
1597: || ''''
1621: -- Update mode
1622: ELSE
1623: /* bug # 1490374
1624: if AMS_Utility_PVT.Check_Uniqueness
1625: (p_table_name => 'AMS_CATEGORIES_TL',
1626: p_where_clause => 'category_name = '
1627: || ''''
1628: || p_category_rec.category_name
1629: || ''''