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_SRC_FIELD_PVT dependencies on AMS_LIST_SRC_FIELDS

Line 55: SELECT AMS_LIST_SRC_FIELDS_s.NEXTVAL

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

Line 60: FROM AMS_LIST_SRC_FIELDS

56: FROM dual;
57:
58: CURSOR c_id_exists (l_id IN NUMBER) IS
59: SELECT 1
60: FROM AMS_LIST_SRC_FIELDS
61: WHERE LIST_SOURCE_FIELD_ID = l_id;
62:
63: CURSOR c_get_column_name(p_table_name VARCHAR2, p_column_name VARCHAR2) IS
64: SELECT COLUMN_NAME

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

182:
183: -- Debug Message
184: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
185:
186: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Insert_Row)
187: AMS_LIST_SRC_FIELDS_PKG.Insert_Row(
188: px_list_source_field_id => l_list_source_field_id,
189: p_last_update_date => SYSDATE,
190: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 187: AMS_LIST_SRC_FIELDS_PKG.Insert_Row(

183: -- Debug Message
184: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
185:
186: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Insert_Row)
187: AMS_LIST_SRC_FIELDS_PKG.Insert_Row(
188: px_list_source_field_id => l_list_source_field_id,
189: p_last_update_date => SYSDATE,
190: p_last_updated_by => FND_GLOBAL.USER_ID,
191: p_creation_date => SYSDATE,

Line 302: FROM AMS_LIST_SRC_FIELDS

298: IS
299:
300: CURSOR c_get_list_src_field(list_source_field_id NUMBER) IS
301: SELECT *
302: FROM AMS_LIST_SRC_FIELDS
303: WHERE list_source_field_id =p_list_src_field_rec.list_source_field_id;
304:
305: CURSOR c_get_analytics_flag(p_list_source_field_id NUMBER) IS
306: SELECT analytics_flag

Line 307: FROM AMS_LIST_SRC_FIELDS

303: WHERE list_source_field_id =p_list_src_field_rec.list_source_field_id;
304:
305: CURSOR c_get_analytics_flag(p_list_source_field_id NUMBER) IS
306: SELECT analytics_flag
307: FROM AMS_LIST_SRC_FIELDS
308: WHERE list_source_field_id = p_list_source_field_id;
309:
310: CURSOR c_get_column_name(p_table_name VARCHAR2, p_column_name VARCHAR2) IS
311: SELECT COLUMN_NAME

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

443:
444: -- Debug Message
445: -- AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
446:
447: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Update_Row)
448: AMS_LIST_SRC_FIELDS_PKG.Update_Row(
449: p_list_source_field_id => p_list_src_field_rec.list_source_field_id,
450: p_last_update_date => SYSDATE,
451: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 448: AMS_LIST_SRC_FIELDS_PKG.Update_Row(

444: -- Debug Message
445: -- AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
446:
447: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Update_Row)
448: AMS_LIST_SRC_FIELDS_PKG.Update_Row(
449: p_list_source_field_id => p_list_src_field_rec.list_source_field_id,
450: p_last_update_date => SYSDATE,
451: p_last_updated_by => FND_GLOBAL.USER_ID,
452: p_creation_date => SYSDATE,

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

611: --
612: -- Debug Message
613: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
614:
615: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Delete_Row)
616: AMS_LIST_SRC_FIELDS_PKG.Delete_Row(
617: p_LIST_SOURCE_FIELD_ID => p_LIST_SOURCE_FIELD_ID);
618:
619:

Line 616: AMS_LIST_SRC_FIELDS_PKG.Delete_Row(

612: -- Debug Message
613: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
614:
615: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Delete_Row)
616: AMS_LIST_SRC_FIELDS_PKG.Delete_Row(
617: p_LIST_SOURCE_FIELD_ID => p_LIST_SOURCE_FIELD_ID);
618:
619:
620: -- Beginning of Code for Analytics Data Source Fields

Line 712: FROM AMS_LIST_SRC_FIELDS

708: l_LIST_SOURCE_FIELD_ID NUMBER;
709:
710: CURSOR c_List_Src_Field IS
711: SELECT LIST_SOURCE_FIELD_ID
712: FROM AMS_LIST_SRC_FIELDS
713: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID
714: AND object_version_number = p_object_version
715: FOR UPDATE NOWAIT;
716:

Line 819: 'AMS_LIST_SRC_FIELDS',

815: BEGIN
816: x_return_status := FND_API.g_ret_sts_success;
817: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
818: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
819: 'AMS_LIST_SRC_FIELDS',
820: 'LIST_SOURCE_FIELD_ID = ''' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID ||''''
821: );
822: ELSE
823: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 824: 'AMS_LIST_SRC_FIELDS',

820: 'LIST_SOURCE_FIELD_ID = ''' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID ||''''
821: );
822: ELSE
823: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
824: 'AMS_LIST_SRC_FIELDS',
825: 'LIST_SOURCE_FIELD_ID = ''' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID ||
826: ''' AND LIST_SOURCE_FIELD_ID <> ' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID
827: );
828: END IF;

Line 844: 'ams_list_src_fields',

840: AND p_list_src_field_rec.list_source_type_id IS NOT NULL
841:
842: THEN
843: IF AMS_Utility_PVT.check_uniqueness(
844: 'ams_list_src_fields',
845: 'source_column_name = ' || p_list_src_field_rec.source_column_name||
846: ' and field_table_name = '||p_list_src_field_rec.field_table_name
847: ||' and field_column_name = '||p_list_src_field_rec.field_column_name
848: ||' and list_source_type_id = '||p_list_src_field_rec.list_source_type_id

Line 953: FROM ams_list_src_fields_vl

949: IS
950:
951: CURSOR c_lstsrcfld_crt IS
952: SELECT *
953: FROM ams_list_src_fields_vl
954: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
955: and source_column_name = p_list_src_field_rec.source_column_name;
956:
957: CURSOR c_lstsrcfld_upd IS

Line 959: FROM ams_list_src_fields_vl

955: and source_column_name = p_list_src_field_rec.source_column_name;
956:
957: CURSOR c_lstsrcfld_upd IS
958: SELECT *
959: FROM ams_list_src_fields_vl
960: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
961: and source_column_name = p_list_src_field_rec.source_column_name
962: and list_source_field_id <> p_list_src_field_rec.list_source_field_id;
963:

Line 967: -- FROM ams_list_src_fields_vl

963:
964: CURSOR c_fldcolname_crt IS
965: -- Bug 3664542, SOLIN SQL Repository, tuning
966: -- SELECT *
967: -- FROM ams_list_src_fields_vl
968: -- WHERE
969: -- (list_source_type_id=p_list_src_field_rec.list_source_type_id
970: -- OR list_source_type_id IN
971: -- ( SELECT sub_source_type_id

Line 980: FROM ams_list_src_fields_vl

976: -- )
977: -- )
978: -- AND field_column_name = p_list_src_field_rec.field_column_name;
979: SELECT *
980: FROM ams_list_src_fields_vl
981: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
982: AND field_column_name = p_list_src_field_rec.field_column_name
983: UNION ALL
984: SELECT *

Line 985: FROM ams_list_src_fields_vl

981: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
982: AND field_column_name = p_list_src_field_rec.field_column_name
983: UNION ALL
984: SELECT *
985: FROM ams_list_src_fields_vl
986: WHERE list_source_type_id IN
987: ( SELECT sub_source_type_id
988: FROM ams_list_src_type_assocs
989: WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id

Line 998: -- FROM ams_list_src_fields_vl

994:
995: CURSOR c_fldcolname_upd 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 1012: FROM ams_list_src_fields_vl

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

Line 1018: FROM ams_list_src_fields_vl

1014: AND field_column_name = p_list_src_field_rec.field_column_name
1015: AND list_source_field_id <> p_list_src_field_rec.list_source_field_id
1016: UNION ALL
1017: SELECT *
1018: FROM ams_list_src_fields_vl
1019: WHERE list_source_type_id IN
1020: ( SELECT sub_source_type_id
1021: FROM ams_list_src_type_assocs
1022: WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id

Line 1177: FROM ams_list_src_fields_vl

1173: l_return_status VARCHAR2(1);
1174:
1175: CURSOR c_complete IS
1176: SELECT *
1177: FROM ams_list_src_fields_vl
1178: WHERE list_source_field_id = p_list_src_field_rec.list_source_field_id;
1179: l_list_src_field_rec c_complete%ROWTYPE;
1180: BEGIN
1181: x_complete_rec := p_list_src_field_rec;