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_LISTSOURCETYPE_PVT dependencies on AMS_LIST_SRC_TYPES

Line 81: -- p_listsrctype_rec: the record representing AMS_LIST_SRC_TYPES.

77: -- PURPOSE
78: -- Create a list source type entry.
79: --
80: -- PARAMETERS
81: -- p_listsrctype_rec: the record representing AMS_LIST_SRC_TYPES.
82: -- x_list_source_type_id: the list_source_type_id.
83: --
84: -- NOTES
85: -- 1. object_version_number will be set to 1.

Line 119: SELECT ams_list_src_types_s.NEXTVAL

115: l_listsrctype_rec ListSourceType_Rec_Type := p_listsrctype_rec;
116: l_dummy NUMBER; -- Capture the exit condition for ID existence loop.
117:
118: CURSOR c_seq IS
119: SELECT ams_list_src_types_s.NEXTVAL
120: FROM dual;
121:
122: CURSOR c_id_exists (x_id IN NUMBER) IS
123: SELECT 1

Line 124: FROM ams_list_src_types

120: FROM dual;
121:
122: CURSOR c_id_exists (x_id IN NUMBER) IS
123: SELECT 1
124: FROM ams_list_src_types
125: WHERE list_source_type_id = x_id;
126: BEGIN
127: --------------------- initialize -----------------------
128: SAVEPOINT Create_ListSourceType;

Line 197: INSERT INTO ams_list_src_types (

193:
194: -------------------------- insert --------------------------
195: AMS_Utility_PVT.debug_message (l_full_name || ': Insert');
196:
197: INSERT INTO ams_list_src_types (
198: list_source_type_id,
199: last_update_date,
200: last_updated_by,
201: creation_date,

Line 240: insert into AMS_LIST_SRC_TYPES_TL (

236: l_listsrctype_rec.arc_act_src_used_by,
237: l_listsrctype_rec.source_category
238: );
239:
240: insert into AMS_LIST_SRC_TYPES_TL (
241: LANGUAGE,
242: SOURCE_LANG,
243: LIST_SOURCE_NAME,
244: DESCRIPTION,

Line 266: from AMS_LIST_SRC_TYPES_TL T

262: from FND_LANGUAGES L
263: where L.INSTALLED_FLAG in ('I', 'B')
264: and not exists
265: (select NULL
266: from AMS_LIST_SRC_TYPES_TL T
267: where T.LIST_SOURCE_TYPE_ID = l_listsrctype_rec.LIST_SOURCE_TYPE_ID
268: and T.LANGUAGE = L.LANGUAGE_CODE);
269:
270: IF l_listsrctype_rec.list_source_type = L_DATA_SOURCE_ANALYTICS THEN

Line 370: from ams_list_src_types a

366: l_api_name CONSTANT VARCHAR2(30) := 'Delete_ListSourceType';
367: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
368: cursor c_delete_sources is
369: select 'x'
370: from ams_list_src_types a
371: WHERE a.list_source_type_id = p_list_source_type_id
372: and exists (select 'x'
373: from ams_list_headers_all b
374: where b.list_source_type = a.source_type_code) ;

Line 386: FROM ams_list_src_types t

382:
383: -- Cursor to get the type of the data source
384: CURSOR c_get_ds_type (l_id IN NUMBER) IS
385: SELECT list_source_type
386: FROM ams_list_src_types t
387: WHERE t.list_source_type_id = l_id;
388:
389: -- Cursor to check if ANALYTICS data source is used in any models
390: CURSOR c_analytics_ds_used (l_id IN NUMBER) IS

Line 466: DELETE FROM ams_list_src_types

462: END IF;
463: END IF;
464: -------------------- finish --------------------------
465:
466: DELETE FROM ams_list_src_types
467: WHERE list_source_type_id = p_list_source_type_id
468: AND object_version_number = p_object_version
469: ;
470:

Line 471: DELETE FROM ams_list_src_types_tl

467: WHERE list_source_type_id = p_list_source_type_id
468: AND object_version_number = p_object_version
469: ;
470:
471: DELETE FROM ams_list_src_types_tl
472: WHERE list_source_type_id = p_list_source_type_id
473: ;
474:
475:

Line 610: FROM ams_list_src_types

606: -- and perform comparison in the body and raise the
607: -- exception there.
608: CURSOR c_lock_req IS
609: SELECT object_version_number
610: FROM ams_list_src_types
611: WHERE list_source_type_id = p_list_source_type_id
612: AND object_version_number = p_object_version
613: FOR UPDATE NOWAIT;
614: BEGIN

Line 705: -- p_listsrctype_rec: the record representing AMS_LIST_SRC_TYPES.

701: -- PURPOSE
702: -- Update a list source type entry.
703: --
704: -- PARAMETERS
705: -- p_listsrctype_rec: the record representing AMS_LIST_SRC_TYPES.
706: --
707: -- NOTES
708: -- 1. Raise exception if the object_version_number doesn't match.
709: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

Line 801: UPDATE ams_list_src_types

797: END IF;
798: END IF;
799:
800: -------------------------- update --------------------
801: UPDATE ams_list_src_types
802: SET
803: last_update_date = SYSDATE,
804: last_updated_by = FND_GLOBAL.user_id,
805: last_update_login = FND_GLOBAL.conc_login_id,

Line 830: update AMS_LIST_SRC_TYPES_TL set

826: END IF;
827: RAISE FND_API.g_exc_error;
828: END IF;
829:
830: update AMS_LIST_SRC_TYPES_TL set
831: LIST_SOURCE_NAME = l_listsrctype_rec.LIST_SOURCE_NAME,
832: DESCRIPTION = l_listsrctype_rec.DESCRIPTION,
833: LAST_UPDATE_DATE = sysdate,
834: LAST_UPDATE_BY = FND_GLOBAL.user_id,

Line 847: FND_MESSAGE.Set_Token('ROW', 'AMS_ListSourceType_PVT.Upd_AMS_LIST_SRC_TYPES_TL', TRUE);

843: -- API message list. --
844: ------------------------------------------------------------------
845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
846: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
847: FND_MESSAGE.Set_Token('ROW', 'AMS_ListSourceType_PVT.Upd_AMS_LIST_SRC_TYPES_TL', TRUE);
848: FND_MSG_PUB.Add;
849: END IF;
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;

Line 908: -- p_listsrctype_rec: the record representing AMS_LIST_SRC_TYPES.

904: -- PURPOSE
905: -- Validate a list source type entry.
906: --
907: -- PARAMETERS
908: -- p_listsrctype_rec: the record representing AMS_LIST_SRC_TYPES.
909: --
910: -- NOTES
911: -- 1. p_listsrctype_rec should be the complete list source type record. There
912: -- should not be any FND_API.g_miss_char/num/date in it.

Line 1190: FROM AMS_LIST_SRC_TYPES_VL

1186: , java_class_name
1187: , arc_act_src_used_by
1188: , source_category
1189: , import_type
1190: FROM AMS_LIST_SRC_TYPES_VL
1191: WHERE list_source_type_id = p_list_source_type_id
1192: ;
1193: l_reference_rec c_reference%ROWTYPE;
1194:

Line 1286: FROM ams_list_src_types_vl

1282: )
1283: IS
1284: CURSOR c_fields IS
1285: SELECT *
1286: FROM ams_list_src_types_vl
1287: WHERE list_source_type_id = p_listsrctype_rec.list_source_type_id
1288: ;
1289: l_listsrctype_rec c_fields%ROWTYPE;
1290: BEGIN

Line 1444: l_list_src_types_table CONSTANT VARCHAR2(30) := 'ams_list_src_types';

1440: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1441: x_return_status OUT NOCOPY VARCHAR2
1442: )
1443: IS
1444: l_list_src_types_table CONSTANT VARCHAR2(30) := 'ams_list_src_types';
1445: l_valid_flag VARCHAR2(1);
1446: l_where_clause VARCHAR2(4000);
1447:
1448: CURSOR c_name_create (p_name IN VARCHAR2) IS

Line 1450: FROM ams_list_src_types_vl

1446: l_where_clause VARCHAR2(4000);
1447:
1448: CURSOR c_name_create (p_name IN VARCHAR2) IS
1449: SELECT 1
1450: FROM ams_list_src_types_vl
1451: WHERE list_source_name = p_name;
1452:
1453: CURSOR c_name_update (p_name IN VARCHAR2, p_id IN NUMBER) IS
1454: SELECT 'Y'

Line 1455: FROM ams_list_src_types_vl

1451: WHERE list_source_name = p_name;
1452:
1453: CURSOR c_name_update (p_name IN VARCHAR2, p_id IN NUMBER) IS
1454: SELECT 'Y'
1455: FROM ams_list_src_types_vl
1456: WHERE list_source_name = p_name
1457: AND list_source_type_id <> p_id;
1458:
1459: BEGIN