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.

[Home] [Help]

APPS.AMS_LIST_SRC_FIELD_PVT dependencies on AMS_LIST_SRC_FIELDS

Line 57: SELECT AMS_LIST_SRC_FIELDS_s.NEXTVAL

53: l_table_name VARCHAR2(30);
54: l_column_name VARCHAR2(30);
55:
56: CURSOR c_id IS
57: SELECT AMS_LIST_SRC_FIELDS_s.NEXTVAL
58: FROM dual;
59:
60: CURSOR c_id_exists (l_id IN NUMBER) IS
61: SELECT 1

Line 62: FROM AMS_LIST_SRC_FIELDS

58: FROM dual;
59:
60: CURSOR c_id_exists (l_id IN NUMBER) IS
61: SELECT 1
62: FROM AMS_LIST_SRC_FIELDS
63: WHERE LIST_SOURCE_FIELD_ID = l_id;
64:
65: CURSOR c_get_column_name(p_table_name VARCHAR2, p_column_name VARCHAR2) IS
66: /* SELECT COLUMN_NAME -- Fix for bug 15876260

Line 196: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Insert_Row)

192:
193: -- Debug Message
194: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
195:
196: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Insert_Row)
197: AMS_LIST_SRC_FIELDS_PKG.Insert_Row(
198: px_list_source_field_id => l_list_source_field_id,
199: p_last_update_date => SYSDATE,
200: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 197: AMS_LIST_SRC_FIELDS_PKG.Insert_Row(

193: -- Debug Message
194: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
195:
196: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Insert_Row)
197: AMS_LIST_SRC_FIELDS_PKG.Insert_Row(
198: px_list_source_field_id => l_list_source_field_id,
199: p_last_update_date => SYSDATE,
200: p_last_updated_by => FND_GLOBAL.USER_ID,
201: p_creation_date => SYSDATE,

Line 312: FROM AMS_LIST_SRC_FIELDS

308: IS
309:
310: CURSOR c_get_list_src_field(list_source_field_id NUMBER) IS
311: SELECT *
312: FROM AMS_LIST_SRC_FIELDS
313: WHERE list_source_field_id =p_list_src_field_rec.list_source_field_id;
314:
315: CURSOR c_get_analytics_flag(p_list_source_field_id NUMBER) IS
316: SELECT analytics_flag

Line 317: FROM AMS_LIST_SRC_FIELDS

313: WHERE list_source_field_id =p_list_src_field_rec.list_source_field_id;
314:
315: CURSOR c_get_analytics_flag(p_list_source_field_id NUMBER) IS
316: SELECT analytics_flag
317: FROM AMS_LIST_SRC_FIELDS
318: WHERE list_source_field_id = p_list_source_field_id;
319:
320: CURSOR c_get_column_name(p_table_name VARCHAR2, p_column_name VARCHAR2) IS
321: /* SELECT COLUMN_NAME -- Fix for bug 15876260

Line 478: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Update_Row)

474:
475: -- Debug Message
476: -- AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
477:
478: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Update_Row)
479: AMS_LIST_SRC_FIELDS_PKG.Update_Row(
480: p_list_source_field_id => p_list_src_field_rec.list_source_field_id,
481: p_last_update_date => SYSDATE,
482: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 479: AMS_LIST_SRC_FIELDS_PKG.Update_Row(

475: -- Debug Message
476: -- AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
477:
478: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Update_Row)
479: AMS_LIST_SRC_FIELDS_PKG.Update_Row(
480: p_list_source_field_id => p_list_src_field_rec.list_source_field_id,
481: p_last_update_date => SYSDATE,
482: p_last_updated_by => FND_GLOBAL.USER_ID,
483: p_creation_date => SYSDATE,

Line 646: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Delete_Row)

642: --
643: -- Debug Message
644: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
645:
646: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Delete_Row)
647: AMS_LIST_SRC_FIELDS_PKG.Delete_Row(
648: p_LIST_SOURCE_FIELD_ID => p_LIST_SOURCE_FIELD_ID);
649:
650:

Line 647: AMS_LIST_SRC_FIELDS_PKG.Delete_Row(

643: -- Debug Message
644: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
645:
646: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Delete_Row)
647: AMS_LIST_SRC_FIELDS_PKG.Delete_Row(
648: p_LIST_SOURCE_FIELD_ID => p_LIST_SOURCE_FIELD_ID);
649:
650:
651: -- Beginning of Code for Analytics Data Source Fields

Line 743: FROM AMS_LIST_SRC_FIELDS

739: l_LIST_SOURCE_FIELD_ID NUMBER;
740:
741: CURSOR c_List_Src_Field IS
742: SELECT LIST_SOURCE_FIELD_ID
743: FROM AMS_LIST_SRC_FIELDS
744: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID
745: AND object_version_number = p_object_version
746: FOR UPDATE NOWAIT;
747:

Line 850: 'AMS_LIST_SRC_FIELDS',

846: BEGIN
847: x_return_status := FND_API.g_ret_sts_success;
848: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
849: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
850: 'AMS_LIST_SRC_FIELDS',
851: 'LIST_SOURCE_FIELD_ID = ''' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID ||''''
852: );
853: ELSE
854: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 855: 'AMS_LIST_SRC_FIELDS',

851: 'LIST_SOURCE_FIELD_ID = ''' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID ||''''
852: );
853: ELSE
854: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
855: 'AMS_LIST_SRC_FIELDS',
856: 'LIST_SOURCE_FIELD_ID = ''' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID ||
857: ''' AND LIST_SOURCE_FIELD_ID <> ' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID
858: );
859: END IF;

Line 875: 'ams_list_src_fields',

871: AND p_list_src_field_rec.list_source_type_id IS NOT NULL
872:
873: THEN
874: IF AMS_Utility_PVT.check_uniqueness(
875: 'ams_list_src_fields',
876: 'source_column_name = ' || p_list_src_field_rec.source_column_name||
877: ' and field_table_name = '||p_list_src_field_rec.field_table_name
878: ||' and field_column_name = '||p_list_src_field_rec.field_column_name
879: ||' and list_source_type_id = '||p_list_src_field_rec.list_source_type_id

Line 984: FROM ams_list_src_fields_vl

980: IS
981:
982: CURSOR c_lstsrcfld_crt IS
983: SELECT *
984: FROM ams_list_src_fields_vl
985: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
986: and source_column_name = p_list_src_field_rec.source_column_name;
987:
988: CURSOR c_lstsrcfld_upd IS

Line 990: FROM ams_list_src_fields_vl

986: and source_column_name = p_list_src_field_rec.source_column_name;
987:
988: CURSOR c_lstsrcfld_upd IS
989: SELECT *
990: FROM ams_list_src_fields_vl
991: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
992: and source_column_name = p_list_src_field_rec.source_column_name
993: and list_source_field_id <> p_list_src_field_rec.list_source_field_id;
994:

Line 998: -- FROM ams_list_src_fields_vl

994:
995: CURSOR c_fldcolname_crt IS
996: -- Bug 3664542, SOLIN SQL Repository, tuning
997: -- SELECT *
998: -- FROM ams_list_src_fields_vl
999: -- WHERE
1000: -- (list_source_type_id=p_list_src_field_rec.list_source_type_id
1001: -- OR list_source_type_id IN
1002: -- ( SELECT sub_source_type_id

Line 1011: FROM ams_list_src_fields_vl

1007: -- )
1008: -- )
1009: -- AND field_column_name = p_list_src_field_rec.field_column_name;
1010: SELECT *
1011: FROM ams_list_src_fields_vl
1012: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
1013: AND field_column_name = p_list_src_field_rec.field_column_name
1014: UNION ALL
1015: SELECT *

Line 1016: FROM ams_list_src_fields_vl

1012: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
1013: AND field_column_name = p_list_src_field_rec.field_column_name
1014: UNION ALL
1015: SELECT *
1016: FROM ams_list_src_fields_vl
1017: WHERE list_source_type_id IN
1018: ( SELECT sub_source_type_id
1019: FROM ams_list_src_type_assocs
1020: WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id

Line 1029: -- FROM ams_list_src_fields_vl

1025:
1026: CURSOR c_fldcolname_upd IS
1027: -- Bug 3664542, SOLIN SQL Repository, tuning
1028: -- SELECT *
1029: -- FROM ams_list_src_fields_vl
1030: -- WHERE
1031: -- (list_source_type_id=p_list_src_field_rec.list_source_type_id
1032: -- OR list_source_type_id IN
1033: -- ( SELECT sub_source_type_id

Line 1043: FROM ams_list_src_fields_vl

1039: -- )
1040: -- AND field_column_name = p_list_src_field_rec.field_column_name
1041: -- AND list_source_field_id <> p_list_src_field_rec.list_source_field_id;
1042: SELECT *
1043: FROM ams_list_src_fields_vl
1044: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
1045: AND field_column_name = p_list_src_field_rec.field_column_name
1046: AND list_source_field_id <> p_list_src_field_rec.list_source_field_id
1047: UNION ALL

Line 1049: FROM ams_list_src_fields_vl

1045: AND field_column_name = p_list_src_field_rec.field_column_name
1046: AND list_source_field_id <> p_list_src_field_rec.list_source_field_id
1047: UNION ALL
1048: SELECT *
1049: FROM ams_list_src_fields_vl
1050: WHERE list_source_type_id IN
1051: ( SELECT sub_source_type_id
1052: FROM ams_list_src_type_assocs
1053: WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id

Line 1208: FROM ams_list_src_fields_vl

1204: l_return_status VARCHAR2(1);
1205:
1206: CURSOR c_complete IS
1207: SELECT *
1208: FROM ams_list_src_fields_vl
1209: WHERE list_source_field_id = p_list_src_field_rec.list_source_field_id;
1210: l_list_src_field_rec c_complete%ROWTYPE;
1211: BEGIN
1212: x_complete_rec := p_list_src_field_rec;