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_CTD_PRM_VAL_PVT dependencies on AMS_CTD_PARAM_VALUES

Line 48: SELECT AMS_CTD_PARAM_VALUES_s.NEXTVAL

44: l_ACTION_PARAM_VALUE_ID NUMBER;
45: l_dummy NUMBER;
46:
47: CURSOR c_id IS
48: SELECT AMS_CTD_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_PARAM_VALUES

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

Line 132: -- Invoke table handler(AMS_CTD_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_PARAM_VALUES_PKG.Insert_Row)
133: AMS_CTD_PARAM_VALUES_PKG.Insert_Row(
134: px_action_param_value_id => l_action_param_value_id,
135: p_action_param_value => p_ctd_prm_val_rec.action_param_value,
136: p_ctd_id => p_ctd_prm_val_rec.ctd_id,

Line 133: AMS_CTD_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_PARAM_VALUES_PKG.Insert_Row)
133: AMS_CTD_PARAM_VALUES_PKG.Insert_Row(
134: px_action_param_value_id => l_action_param_value_id,
135: p_action_param_value => p_ctd_prm_val_rec.action_param_value,
136: p_ctd_id => p_ctd_prm_val_rec.ctd_id,
137: p_action_param_id => p_ctd_prm_val_rec.action_param_id,

Line 226: FROM AMS_CTD_PARAM_VALUES;

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

Line 321: -- Invoke table handler(AMS_CTD_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_PARAM_VALUES_PKG.Update_Row)
322: AMS_CTD_PARAM_VALUES_PKG.Update_Row(
323: p_action_param_value_id => p_ctd_prm_val_rec.action_param_value_id,
324: p_action_param_value => p_ctd_prm_val_rec.action_param_value,
325: p_ctd_id => p_ctd_prm_val_rec.ctd_id,

Line 322: AMS_CTD_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_PARAM_VALUES_PKG.Update_Row)
322: AMS_CTD_PARAM_VALUES_PKG.Update_Row(
323: p_action_param_value_id => p_ctd_prm_val_rec.action_param_value_id,
324: p_action_param_value => p_ctd_prm_val_rec.action_param_value,
325: p_ctd_id => p_ctd_prm_val_rec.ctd_id,
326: p_action_param_id => p_ctd_prm_val_rec.action_param_id,

Line 444: -- Invoke table handler(AMS_CTD_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_PARAM_VALUES_PKG.Delete_Row)
445: AMS_CTD_PARAM_VALUES_PKG.Delete_Row(
446: p_ACTION_PARAM_VALUE_ID => p_ACTION_PARAM_VALUE_ID);
447: --
448: -- End of API body

Line 445: AMS_CTD_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_PARAM_VALUES_PKG.Delete_Row)
445: AMS_CTD_PARAM_VALUES_PKG.Delete_Row(
446: p_ACTION_PARAM_VALUE_ID => p_ACTION_PARAM_VALUE_ID);
447: --
448: -- End of API body
449: --

Line 530: FROM AMS_CTD_PARAM_VALUES

526: l_ACTION_PARAM_VALUE_ID NUMBER;
527:
528: CURSOR c_Ctd_Prm_Val IS
529: SELECT ACTION_PARAM_VALUE_ID
530: FROM AMS_CTD_PARAM_VALUES
531: WHERE ACTION_PARAM_VALUE_ID = p_ACTION_PARAM_VALUE_ID
532: AND object_version_number = p_object_version
533: FOR UPDATE NOWAIT;
534:

Line 637: 'AMS_CTD_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_PARAM_VALUES',
638: 'ACTION_PARAM_VALUE_ID = ''' || p_ctd_prm_val_rec.ACTION_PARAM_VALUE_ID ||''''
639: );
640: ELSE
641: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 642: 'AMS_CTD_PARAM_VALUES',

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

Line 876: FROM ams_ctd_param_values

872: l_return_status VARCHAR2(1);
873:
874: CURSOR c_complete IS
875: SELECT *
876: FROM ams_ctd_param_values
877: WHERE action_param_value_id = p_ctd_prm_val_rec.action_param_value_id;
878: l_ctd_prm_val_rec c_complete%ROWTYPE;
879: BEGIN
880: x_complete_rec := p_ctd_prm_val_rec;