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 79: -- p_listsrctype_rec: the record representing AMS_LIST_SRC_TYPES.

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

Line 117: SELECT ams_list_src_types_s.NEXTVAL

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

Line 122: FROM ams_list_src_types

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

Line 195: INSERT INTO ams_list_src_types (

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

Line 238: insert into AMS_LIST_SRC_TYPES_TL (

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

Line 264: from AMS_LIST_SRC_TYPES_TL T

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

Line 368: from ams_list_src_types a

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

Line 384: FROM ams_list_src_types t

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

Line 464: DELETE FROM ams_list_src_types

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

Line 469: DELETE FROM ams_list_src_types_tl

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

Line 608: FROM ams_list_src_types

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

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

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

Line 799: UPDATE ams_list_src_types

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

Line 828: update AMS_LIST_SRC_TYPES_TL set

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

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

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

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

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

Line 1188: FROM AMS_LIST_SRC_TYPES_VL

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

Line 1284: FROM ams_list_src_types_vl

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

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

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

Line 1448: FROM ams_list_src_types_vl

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

Line 1453: FROM ams_list_src_types_vl

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