eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_WORD_FIELDS_PVT dependencies on AMS_LIST_WORD_FIELDS

Line 1: PACKAGE BODY AMS_List_Word_Fields_PVT AS

1: PACKAGE BODY AMS_List_Word_Fields_PVT AS
2: /* $Header: amsvwdfb.pls 115.8 2002/11/22 08:56:31 jieli ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_List_Word_Fields_PVT';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_List_Word_Fields_PVT';

1: PACKAGE BODY AMS_List_Word_Fields_PVT AS
2: /* $Header: amsvwdfb.pls 115.8 2002/11/22 08:56:31 jieli ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_List_Word_Fields_PVT';
5:
6: /*****************************************************************************/
7: -- Procedure: create_list_word_field
8: --

Line 40: SELECT AMS_LIST_WORD_FIELDS_S.NEXTVAL

36: l_wrd_fld_rec wrd_fld_rec_type := p_wrd_fld_rec;
37: l_wrd_fld_count NUMBER;
38:
39: CURSOR c_list_word_field_seq IS
40: SELECT AMS_LIST_WORD_FIELDS_S.NEXTVAL
41: FROM DUAL;
42:
43: CURSOR c_list_word_field_count(wrd_fld_id IN NUMBER) IS
44: SELECT COUNT(*)

Line 45: FROM AMS_LIST_WORD_FIELDS

41: FROM DUAL;
42:
43: CURSOR c_list_word_field_count(wrd_fld_id IN NUMBER) IS
44: SELECT COUNT(*)
45: FROM AMS_LIST_WORD_FIELDS
46: WHERE list_word_field_id = wrd_fld_id;
47:
48: BEGIN
49: -- initialize

Line 123: INSERT INTO AMS_LIST_WORD_FIELDS

119: EXIT WHEN l_wrd_fld_count = 0;
120: END LOOP;
121: END IF;
122:
123: INSERT INTO AMS_LIST_WORD_FIELDS
124: (
125: list_word_field_id,
126: last_update_date,
127: last_updated_by,

Line 311: UPDATE AMS_LIST_WORD_FIELDS SET

307:
308: AMS_Utility_PVT.debug_message(l_full_name||': update');
309: END IF;
310:
311: UPDATE AMS_LIST_WORD_FIELDS SET
312: last_update_date = SYSDATE,
313: last_updated_by = FND_GLOBAL.user_id,
314: last_update_login = FND_GLOBAL.conc_login_id,
315: object_version_number = l_wrd_fld_rec.object_version_number + 1,

Line 452: DELETE FROM AMS_LIST_WORD_FIELDS

448:
449: AMS_Utility_PVT.debug_message(l_full_name || ': delete');
450: END IF;
451:
452: DELETE FROM AMS_LIST_WORD_FIELDS
453: WHERE list_word_field_id = p_wrd_fld_id
454: AND object_version_number = p_object_version;
455:
456: IF (SQL%NOTFOUND) THEN

Line 549: FROM AMS_LIST_WORD_FIELDS

545: l_wrd_fld_id NUMBER;
546:
547: CURSOR c_list_word_field IS
548: SELECT list_word_field_id
549: FROM AMS_LIST_WORD_FIELDS
550: WHERE list_word_field_id = p_wrd_fld_id
551: AND object_version_number = p_object_version
552: FOR UPDATE OF list_word_field_id NOWAIT;
553:

Line 879: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');

875: -- check list_word_field_id
876: IF p_wrd_fld_rec.list_word_field_id IS NULL
877: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
879: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');
880: FND_MSG_PUB.add;
881: END IF;
882:
883: x_return_status := FND_API.g_ret_sts_error;

Line 1070: 'AMS_LIST_WORD_FIELDS',

1066: AND p_wrd_fld_rec.list_word_field_id IS NOT NULL
1067: THEN
1068: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1069: (
1070: 'AMS_LIST_WORD_FIELDS',
1071: 'list_word_field_id = ' || p_wrd_fld_rec.list_word_field_id
1072: );
1073: END IF;
1074:

Line 1077: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');

1073: END IF;
1074:
1075: IF l_uk_flag = FND_API.g_false THEN
1076: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1077: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');
1078: FND_MSG_PUB.add;
1079: END IF;
1080:
1081: x_return_status := FND_API.g_ret_sts_error;

Line 1089: 'AMS_LIST_WORD_FIELDS',

1085: -- check list_word_replaces_id, field_table_name, field_column_name
1086: IF p_wrd_fld_rec.list_word_field_id IS NOT NULL THEN
1087: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1088: (
1089: 'AMS_LIST_WORD_FIELDS',
1090: 'list_word_field_id <> ' || p_wrd_fld_rec.list_word_field_id
1091: || ' AND list_word_replaces_id = ' || p_wrd_fld_rec.list_word_replaces_id
1092: || ' AND field_table_name = ''' || p_wrd_fld_rec.field_table_name
1093: || ''' AND field_column_name = ''' || p_wrd_fld_rec.field_column_name || ''''

Line 1098: 'AMS_LIST_WORD_FIELDS',

1094: );
1095: ELSE
1096: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1097: (
1098: 'AMS_LIST_WORD_FIELDS',
1099: 'list_word_replaces_id = ' || p_wrd_fld_rec.list_word_replaces_id
1100: || ' AND field_table_name = ''' || p_wrd_fld_rec.field_table_name
1101: || ''' AND field_column_name = ''' || p_wrd_fld_rec.field_column_name || ''''
1102: );

Line 1132: SELECT * FROM AMS_LIST_WORD_FIELDS

1128: )
1129: IS
1130:
1131: CURSOR c_list_word_field IS
1132: SELECT * FROM AMS_LIST_WORD_FIELDS
1133: WHERE list_word_field_id = p_wrd_fld_rec.list_word_field_id;
1134:
1135: l_wrd_fld_rec c_list_word_field%ROWTYPE;
1136:

Line 1216: END AMS_List_Word_Fields_PVT;

1212: x_wrd_fld_rec.description := FND_API.g_miss_char;
1213:
1214: END init_rec;
1215:
1216: END AMS_List_Word_Fields_PVT;