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_PS_STRATS_PVT dependencies on AMS_IBA_PS_STRATS_B

Line 47: SELECT AMS_IBA_PS_STRATS_B_s.NEXTVAL

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

Line 52: FROM AMS_IBA_PS_STRATS_B

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

Line 140: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Insert_Row)

136:
137: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
138: END IF;
139:
140: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Insert_Row)
141: AMS_IBA_PS_STRATS_B_PKG.Insert_Row(
142: p_created_by => FND_GLOBAL.USER_ID,
143: p_creation_date => SYSDATE,
144: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 141: AMS_IBA_PS_STRATS_B_PKG.Insert_Row(

137: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
138: END IF;
139:
140: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Insert_Row)
141: AMS_IBA_PS_STRATS_B_PKG.Insert_Row(
142: p_created_by => FND_GLOBAL.USER_ID,
143: p_creation_date => SYSDATE,
144: p_last_updated_by => FND_GLOBAL.USER_ID,
145: p_last_update_date => SYSDATE,

Line 244: FROM AMS_IBA_PS_STRATS_B

240: --/*
241: --CURSOR c_get_ps_strats(created_by NUMBER) IS
242: CURSOR c_get_ps_strats(p_strategy_id NUMBER) IS
243: SELECT object_version_number
244: FROM AMS_IBA_PS_STRATS_B
245: WHERE strategy_id = p_strategy_id;
246: -- Hint: Developer need to provide Where clause
247: --*/
248: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Ps_Strats';

Line 366: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Update_Row)

362:
363: -- Debug Message
364: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
365:
366: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Update_Row)
367: AMS_IBA_PS_STRATS_B_PKG.Update_Row(
368: p_created_by => FND_GLOBAL.USER_ID,
369: p_creation_date => SYSDATE,
370: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 367: AMS_IBA_PS_STRATS_B_PKG.Update_Row(

363: -- Debug Message
364: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
365:
366: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Update_Row)
367: AMS_IBA_PS_STRATS_B_PKG.Update_Row(
368: p_created_by => FND_GLOBAL.USER_ID,
369: p_creation_date => SYSDATE,
370: p_last_updated_by => FND_GLOBAL.USER_ID,
371: p_last_update_date => SYSDATE,

Line 469: UPDATE ams_iba_ps_strats_b

465:
466: -- PREDEFINED is same as PRODUCT_RELATIONSHIP
467: IF p_strat_type = 'PREDEFINED' THEN
468:
469: UPDATE ams_iba_ps_strats_b
470: SET
471: max_returned = p_ps_strats_rec.max_returned
472: WHERE strategy_type = 'PRODUCT_RELATIONSHIP';
473:

Line 476: UPDATE ams_iba_ps_strats_b

472: WHERE strategy_type = 'PRODUCT_RELATIONSHIP';
473:
474: ELSE
475:
476: UPDATE ams_iba_ps_strats_b
477: SET
478: max_returned = p_ps_strats_rec.max_returned
479: WHERE strategy_type = 'INFERRED_OP';
480:

Line 540: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Delete_Row)

536:
537: AMS_UTILITY_PVT.debug_message('Private API: Calling delete table handler');
538: END IF;
539:
540: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Delete_Row)
541: AMS_IBA_PS_STRATS_B_PKG.Delete_Row(
542: p_STRATEGY_ID => p_STRATEGY_ID);
543: --
544: -- End of API body

Line 541: AMS_IBA_PS_STRATS_B_PKG.Delete_Row(

537: AMS_UTILITY_PVT.debug_message('Private API: Calling delete table handler');
538: END IF;
539:
540: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Delete_Row)
541: AMS_IBA_PS_STRATS_B_PKG.Delete_Row(
542: p_STRATEGY_ID => p_STRATEGY_ID);
543: --
544: -- End of API body
545: --

Line 627: FROM AMS_IBA_PS_STRATS_B

623: l_STRATEGY_ID NUMBER;
624:
625: CURSOR c_Ps_Strats IS
626: SELECT STRATEGY_ID
627: FROM AMS_IBA_PS_STRATS_B
628: WHERE STRATEGY_ID = p_STRATEGY_ID
629: AND object_version_number = p_object_version
630: FOR UPDATE NOWAIT;
631:

Line 745: 'AMS_IBA_PS_STRATS_B',

741: BEGIN
742: x_return_status := FND_API.g_ret_sts_success;
743: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
744: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
745: 'AMS_IBA_PS_STRATS_B',
746: 'STRATEGY_ID = ''' || p_ps_strats_rec.STRATEGY_ID ||''''
747: );
748: ELSE
749: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 750: 'AMS_IBA_PS_STRATS_B',

746: 'STRATEGY_ID = ''' || p_ps_strats_rec.STRATEGY_ID ||''''
747: );
748: ELSE
749: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
750: 'AMS_IBA_PS_STRATS_B',
751: 'STRATEGY_ID = ''' || p_ps_strats_rec.STRATEGY_ID ||
752: ''' AND STRATEGY_ID <> ' || p_ps_strats_rec.STRATEGY_ID
753: );
754: END IF;

Line 948: FROM ams_iba_ps_strats_b

944: l_return_status VARCHAR2(1);
945:
946: CURSOR c_complete IS
947: SELECT *
948: FROM ams_iba_ps_strats_b
949: WHERE strategy_id = p_ps_strats_rec.strategy_id;
950: l_ps_strats_rec c_complete%ROWTYPE;
951: BEGIN
952: x_complete_rec := p_ps_strats_rec;