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_ADHOC_PARAM_PVT dependencies on AMS_CTD_ADHOC_PARAM_VALUES

Line 48: SELECT AMS_CTD_ADHOC_PARAM_VALUES_s.NEXTVAL

44: l_ADHOC_PARAM_ID NUMBER;
45: l_dummy NUMBER;
46:
47: CURSOR c_id IS
48: SELECT AMS_CTD_ADHOC_PARAM_VALUES_s.NEXTVAL
49: FROM dual;
50:
51: CURSOR c_id_exists (l_id IN NUMBER) IS
52: SELECT 1

Line 53: FROM AMS_CTD_ADHOC_PARAM_VALUES

49: FROM dual;
50:
51: CURSOR c_id_exists (l_id IN NUMBER) IS
52: SELECT 1
53: FROM AMS_CTD_ADHOC_PARAM_VALUES
54: WHERE ADHOC_PARAM_ID = l_id;
55:
56: BEGIN
57: -- Standard Start of API savepoint

Line 132: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Insert_Row)

128:
129: -- Debug Message
130: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
131:
132: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Insert_Row)
133: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Insert_Row(
134: px_adhoc_param_id => l_adhoc_param_id,
135: p_adhoc_param_code => p_adhoc_param_rec.adhoc_param_code,
136: p_adhoc_param_value => p_adhoc_param_rec.adhoc_param_value,

Line 133: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Insert_Row(

129: -- Debug Message
130: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
131:
132: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Insert_Row)
133: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Insert_Row(
134: px_adhoc_param_id => l_adhoc_param_id,
135: p_adhoc_param_code => p_adhoc_param_rec.adhoc_param_code,
136: p_adhoc_param_value => p_adhoc_param_rec.adhoc_param_value,
137: p_ctd_id => p_adhoc_param_rec.ctd_id,

Line 226: FROM AMS_CTD_ADHOC_PARAM_VALUES;

222:
223: IS
224: CURSOR c_get_adhoc_param(adhoc_param_id NUMBER) IS
225: SELECT *
226: FROM AMS_CTD_ADHOC_PARAM_VALUES;
227: -- Hint: Developer need to provide Where clause
228: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Adhoc_Param';
229: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
230: -- Local Variables

Line 321: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Update_Row)

317:
318: -- Debug Message
319: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
320:
321: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Update_Row)
322: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Update_Row(
323: p_adhoc_param_id => p_adhoc_param_rec.adhoc_param_id,
324: p_adhoc_param_code => p_adhoc_param_rec.adhoc_param_code,
325: p_adhoc_param_value => p_adhoc_param_rec.adhoc_param_value,

Line 322: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Update_Row(

318: -- Debug Message
319: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
320:
321: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Update_Row)
322: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Update_Row(
323: p_adhoc_param_id => p_adhoc_param_rec.adhoc_param_id,
324: p_adhoc_param_code => p_adhoc_param_rec.adhoc_param_code,
325: p_adhoc_param_value => p_adhoc_param_rec.adhoc_param_value,
326: p_ctd_id => p_adhoc_param_rec.ctd_id,

Line 444: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Delete_Row)

440: --
441: -- Debug Message
442: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
443:
444: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Delete_Row)
445: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Delete_Row(
446: p_ADHOC_PARAM_ID => p_ADHOC_PARAM_ID);
447: --
448: -- End of API body

Line 445: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Delete_Row(

441: -- Debug Message
442: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
443:
444: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Delete_Row)
445: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Delete_Row(
446: p_ADHOC_PARAM_ID => p_ADHOC_PARAM_ID);
447: --
448: -- End of API body
449: --

Line 530: FROM AMS_CTD_ADHOC_PARAM_VALUES

526: l_ADHOC_PARAM_ID NUMBER;
527:
528: CURSOR c_Adhoc_Param IS
529: SELECT ADHOC_PARAM_ID
530: FROM AMS_CTD_ADHOC_PARAM_VALUES
531: WHERE ADHOC_PARAM_ID = p_ADHOC_PARAM_ID
532: AND object_version_number = p_object_version
533: FOR UPDATE NOWAIT;
534:

Line 637: 'AMS_CTD_ADHOC_PARAM_VALUES',

633: BEGIN
634: x_return_status := FND_API.g_ret_sts_success;
635: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
636: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
637: 'AMS_CTD_ADHOC_PARAM_VALUES',
638: 'ADHOC_PARAM_ID = ''' || p_adhoc_param_rec.ADHOC_PARAM_ID ||''''
639: );
640: ELSE
641: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 642: 'AMS_CTD_ADHOC_PARAM_VALUES',

638: 'ADHOC_PARAM_ID = ''' || p_adhoc_param_rec.ADHOC_PARAM_ID ||''''
639: );
640: ELSE
641: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
642: 'AMS_CTD_ADHOC_PARAM_VALUES',
643: 'ADHOC_PARAM_ID = ''' || p_adhoc_param_rec.ADHOC_PARAM_ID ||
644: ''' AND ADHOC_PARAM_ID <> ' || p_adhoc_param_rec.ADHOC_PARAM_ID
645: );
646: END IF;

Line 861: FROM ams_ctd_adhoc_param_values

857: l_return_status VARCHAR2(1);
858:
859: CURSOR c_complete IS
860: SELECT *
861: FROM ams_ctd_adhoc_param_values
862: WHERE adhoc_param_id = p_adhoc_param_rec.adhoc_param_id;
863: l_adhoc_param_rec c_complete%ROWTYPE;
864: BEGIN
865: x_complete_rec := p_adhoc_param_rec;