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_DM_TARGET_SOURCES_PVT dependencies on AMS_DM_TARGET_SOURCES

Line 1: PACKAGE BODY AMS_Dm_Target_Sources_PVT as

1: PACKAGE BODY AMS_Dm_Target_Sources_PVT as
2: /* $Header: amsvdtsb.pls 115.6 2004/06/16 12:27:36 rosharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_Dm_Target_Sources_PVT

2: /* $Header: amsvdtsb.pls 115.6 2004/06/16 12:27:36 rosharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_Dm_Target_Sources_PVT
7: -- Purpose
8: --
9: -- History
10: --

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Dm_Target_Sources_PVT';

16: -- End of Comments
17: -- ===============================================================
18:
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Dm_Target_Sources_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvdtsb.pls';
22:
23: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 97: SELECT ams_dm_target_sources_s.NEXTVAL

93: l_org_id NUMBER := FND_API.G_MISS_NUM;
94: l_target_source_rec target_source_rec_type := p_target_source_rec_type_rec;
95: l_dummy NUMBER;
96: CURSOR c_id IS
97: SELECT ams_dm_target_sources_s.NEXTVAL
98: FROM dual;
99:
100: CURSOR c_id_exists (l_id IN NUMBER) IS
101: SELECT 1

Line 102: FROM AMS_DM_TARGET_SOURCES

98: FROM dual;
99:
100: CURSOR c_id_exists (l_id IN NUMBER) IS
101: SELECT 1
102: FROM AMS_DM_TARGET_SOURCES
103: WHERE target_source_id = l_id;
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_dm_target_sources_pvt;

Line 186: -- Invoke table handler(Ams_Dm_Target_Sources_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_Dm_Target_Sources_Pkg.Insert_Row)
187: Ams_Dm_Target_Sources_Pkg.Insert_Row(
188: px_target_source_id => l_target_source_rec.target_source_id,
189: p_last_update_date => SYSDATE,
190: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 187: Ams_Dm_Target_Sources_Pkg.Insert_Row(

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

Line 318: FROM AMS_DM_TARGET_SOURCES

314:
315:
316: CURSOR c_get_dm_target_sources(p_target_source_id NUMBER) IS
317: SELECT *
318: FROM AMS_DM_TARGET_SOURCES
319: WHERE target_source_id = p_target_source_id;
320:
321:
322: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Dm_Target_Sources';

Line 420: -- Invoke table handler(Ams_Dm_Target_Sources_Pkg.Update_Row)

416:
417: -- Debug Message
418: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
419:
420: -- Invoke table handler(Ams_Dm_Target_Sources_Pkg.Update_Row)
421: Ams_Dm_Target_Sources_Pkg.Update_Row(
422: p_target_source_id => p_target_source_rec_type_rec.target_source_id,
423: p_last_update_date => SYSDATE,
424: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 421: Ams_Dm_Target_Sources_Pkg.Update_Row(

417: -- Debug Message
418: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
419:
420: -- Invoke table handler(Ams_Dm_Target_Sources_Pkg.Update_Row)
421: Ams_Dm_Target_Sources_Pkg.Update_Row(
422: p_target_source_id => p_target_source_rec_type_rec.target_source_id,
423: p_last_update_date => SYSDATE,
424: p_last_updated_by => FND_GLOBAL.USER_ID,
425: p_last_update_login => FND_GLOBAL.conc_login_id,

Line 544: IS SELECT 1 FROM AMS_DM_TARGETS_B t, AMS_DM_TARGET_SOURCES s

540: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
541: l_object_version_number NUMBER;
542:
543: CURSOR c_target_source (p_target_source_id IN NUMBER)
544: IS SELECT 1 FROM AMS_DM_TARGETS_B t, AMS_DM_TARGET_SOURCES s
545: WHERE s.target_source_id = p_target_source_id
546: AND s.target_id = t.target_id
547: AND s.data_source_id = t.target_source_id;
548:

Line 595: -- Invoke table handler(Ams_Dm_Target_Sources_Pkg.Delete_Row)

591: --
592: -- Debug Message
593: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
594:
595: -- Invoke table handler(Ams_Dm_Target_Sources_Pkg.Delete_Row)
596: Ams_Dm_Target_Sources_Pkg.Delete_Row(
597: p_target_source_id => p_target_source_id,
598: p_object_version_number => p_object_version_number );
599: --

Line 596: Ams_Dm_Target_Sources_Pkg.Delete_Row(

592: -- Debug Message
593: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
594:
595: -- Invoke table handler(Ams_Dm_Target_Sources_Pkg.Delete_Row)
596: Ams_Dm_Target_Sources_Pkg.Delete_Row(
597: p_target_source_id => p_target_source_id,
598: p_object_version_number => p_object_version_number );
599: --
600: -- End of API body

Line 744: Ams_Dm_Target_Sources_Pkg.Lock_Row(l_target_source_id,p_object_version);

740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741:
742:
743: ------------------------ lock -------------------------
744: Ams_Dm_Target_Sources_Pkg.Lock_Row(l_target_source_id,p_object_version);
745:
746:
747: -------------------- finish --------------------------
748: FND_MSG_PUB.count_and_get(

Line 810: 'ams_dm_target_sources',

806: IF p_validation_mode = JTF_PLSQL_API.g_create
807: AND p_target_source_rec_type_rec.target_source_id IS NOT NULL
808: THEN
809: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
810: 'ams_dm_target_sources',
811: 'target_source_id = ''' || p_target_source_rec_type_rec.target_source_id ||''''
812: );
813: END IF;
814:

Line 997: FROM ams_dm_target_sources

993: l_return_status VARCHAR2(1);
994:
995: CURSOR c_complete IS
996: SELECT *
997: FROM ams_dm_target_sources
998: WHERE target_source_id = p_target_source_rec_type_rec.target_source_id;
999: l_target_source_rec_type_rec c_complete%ROWTYPE;
1000: BEGIN
1001: x_complete_rec := p_target_source_rec_type_rec;

Line 1228: FROM ams_dm_target_sources dts, ams_list_src_types lst1, ams_list_src_types lst2

1224: )
1225: IS
1226: CURSOR c_check_underlying_obj(p_ds_id IN NUMBER, p_target_id IN NUMBER) IS
1227: SELECT 1
1228: FROM ams_dm_target_sources dts, ams_list_src_types lst1, ams_list_src_types lst2
1229: WHERE dts.target_id = p_target_id
1230: AND lst1.list_source_type_id = p_ds_id
1231: AND lst2.list_source_type_id = dts.data_source_id
1232: AND lst2.list_source_type_id <> p_ds_id

Line 1295: DELETE FROM ams_dm_target_sources

1291:
1292: --
1293: -- Api body
1294: --
1295: DELETE FROM ams_dm_target_sources
1296: WHERE TARGET_SOURCE_ID in (SELECT TARGET_SOURCE_ID FROM ams_dm_target_sources WHERE TARGET_ID = p_TARGET_ID);
1297:
1298: --
1299: -- End of API body

Line 1296: WHERE TARGET_SOURCE_ID in (SELECT TARGET_SOURCE_ID FROM ams_dm_target_sources WHERE TARGET_ID = p_TARGET_ID);

1292: --
1293: -- Api body
1294: --
1295: DELETE FROM ams_dm_target_sources
1296: WHERE TARGET_SOURCE_ID in (SELECT TARGET_SOURCE_ID FROM ams_dm_target_sources WHERE TARGET_ID = p_TARGET_ID);
1297:
1298: --
1299: -- End of API body
1300: --

Line 1324: END AMS_Dm_Target_Sources_PVT;

1320: ROLLBACK TO delete_tgtsources_for_target;
1321:
1322: End delete_tgtsources_for_target;
1323:
1324: END AMS_Dm_Target_Sources_PVT;