APPS.AMS_CUST_SETUP_PVT dependencies on AMS_CUSTOM_SETUPS_TL

Line 158: INSERT INTO AMS_CUSTOM_SETUPS_TL

154: l_cust_setup_rec.source_code_suffix,
155: l_cust_setup_rec.application_id
156: );
157:
158: INSERT INTO AMS_CUSTOM_SETUPS_TL
159: (
160: custom_setup_id,
161: language,
162: last_update_date,

Line 187: FROM AMS_CUSTOM_SETUPS_TL t

183: WHERE l.installed_flag in ('I', 'B')
184: AND NOT EXISTS
185: (
186: SELECT NULL
187: FROM AMS_CUSTOM_SETUPS_TL t
188: WHERE t.custom_setup_id = l_cust_setup_rec.custom_setup_id
189: AND t.language = l.language_code
190: );
191:

Line 716: UPDATE AMS_CUSTOM_SETUPS_TL SET

712: END IF;
713: RAISE FND_API.g_exc_error;
714: END IF;
715:
716: UPDATE AMS_CUSTOM_SETUPS_TL SET
717: last_update_date = SYSDATE,
718: last_updated_by = FND_GLOBAL.user_id,
719: last_update_login = FND_GLOBAL.conc_login_id,
720: source_lang = USERENV('LANG'),

Line 886: DELETE FROM AMS_CUSTOM_SETUPS_TL

882: IF l_object_version = p_object_version THEN -- VERSIONS MATCH
883: DELETE FROM AMS_CUSTOM_SETUP_ATTR
884: WHERE custom_setup_id = p_cust_setup_id;
885:
886: DELETE FROM AMS_CUSTOM_SETUPS_TL
887: WHERE custom_setup_id = p_cust_setup_id;
888:
889: IF (SQL%NOTFOUND) THEN
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1022: FROM AMS_CUSTOM_SETUPS_TL

1018: FOR UPDATE OF custom_setup_id NOWAIT;
1019:
1020: CURSOR c_cust_setup_tl IS
1021: SELECT custom_setup_id
1022: FROM AMS_CUSTOM_SETUPS_TL
1023: WHERE custom_setup_id = p_cust_setup_id
1024: AND USERENV('LANG') IN (language, source_lang)
1025: FOR UPDATE OF custom_setup_id NOWAIT;
1026:

Line 1482: FROM AMS_CUSTOM_SETUPS_TL

1478: l_uk_flag VARCHAR2(1);
1479:
1480: CURSOR c_name_unique_cr (p_setup_name IN VARCHAR2) IS
1481: SELECT ''
1482: FROM AMS_CUSTOM_SETUPS_TL
1483: WHERE UPPER(setup_name) = UPPER(p_setup_name)
1484: AND language = USERENV('LANG') ;
1485:
1486: CURSOR c_name_unique_up (p_setup_name IN VARCHAR2, p_setup_id IN NUMBER) IS

Line 1488: FROM AMS_CUSTOM_SETUPS_TL

1484: AND language = USERENV('LANG') ;
1485:
1486: CURSOR c_name_unique_up (p_setup_name IN VARCHAR2, p_setup_id IN NUMBER) IS
1487: SELECT ''
1488: FROM AMS_CUSTOM_SETUPS_TL
1489: WHERE UPPER(setup_name) = UPPER(p_setup_name)
1490: AND custom_setup_id <> p_setup_id
1491: AND language = USERENV('LANG');
1492:

Line 1526: 'AMS_CUSTOM_SETUPS_TL',

1522: /*************** commented by abhola
1523: IF p_cust_setup_rec.custom_setup_id IS NOT NULL THEN -- UPDATE RECORD
1524: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1525: (
1526: 'AMS_CUSTOM_SETUPS_TL',
1527: 'custom_setup_id <> ' || p_cust_setup_rec.custom_setup_id
1528: || ' AND setup_name = ''' || p_cust_setup_rec.setup_name
1529: || ''' AND language = ''' || USERENV('LANG') ||''''
1530: );

Line 1534: 'AMS_CUSTOM_SETUPS_TL',

1530: );
1531: ELSE -- NEW RECORD
1532: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1533: (
1534: 'AMS_CUSTOM_SETUPS_TL',
1535: 'setup_name = ''' || p_cust_setup_rec.setup_name
1536: || ''' AND language = ''' || USERENV('LANG') ||''''
1537: );
1538: END IF;