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_IBA_PL_STYLESHEETS_PVT dependencies on AMS_IBA_PL_STYLESHTS_B

Line 78: SELECT AMS_IBA_PL_STYLESHTS_B_s.NEXTVAL

74: l_STYLESHEET_ID NUMBER;
75: l_dummy NUMBER;
76:
77: CURSOR c_id IS
78: SELECT AMS_IBA_PL_STYLESHTS_B_s.NEXTVAL
79: FROM dual;
80:
81: CURSOR c_id_exists (l_id IN NUMBER) IS
82: SELECT 1

Line 83: FROM AMS_IBA_PL_STYLESHTS_B

79: FROM dual;
80:
81: CURSOR c_id_exists (l_id IN NUMBER) IS
82: SELECT 1
83: FROM AMS_IBA_PL_STYLESHTS_B
84: WHERE STYLESHEET_ID = l_id;
85:
86: BEGIN
87: -- Standard Start of API savepoint

Line 174: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row)

170:
171: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
172: END IF;
173:
174: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row)
175: AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row(
176: px_stylesheet_id => l_stylesheet_id,
177: p_content_type => p_iba_pl_stylesheets_rec.content_type,
178: p_stylesheet_filename => p_iba_pl_stylesheets_rec.stylesheet_filename,

Line 175: AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row(

171: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
172: END IF;
173:
174: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row)
175: AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row(
176: px_stylesheet_id => l_stylesheet_id,
177: p_content_type => p_iba_pl_stylesheets_rec.content_type,
178: p_stylesheet_filename => p_iba_pl_stylesheets_rec.stylesheet_filename,
179: p_status_code => 'Active',

Line 284: FROM AMS_IBA_PL_STYLESHTS_B;

280: IS
281: --/*
282: CURSOR c_get_iba_pl_stylesheets(stylesheet_id NUMBER) IS
283: SELECT *
284: FROM AMS_IBA_PL_STYLESHTS_B;
285: -- Hint: Developer need to provide Where clause
286: --*/
287: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Iba_Pl_Stylesheets';
288: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 395: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Update_Row)

391:
392: -- Debug Message
393: -- 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;
394:
395: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Update_Row)
396: AMS_IBA_PL_STYLESHTS_B_PKG.Update_Row(
397: p_stylesheet_id => p_iba_pl_stylesheets_rec.stylesheet_id,
398: p_content_type => p_iba_pl_stylesheets_rec.content_type,
399: p_stylesheet_filename => p_iba_pl_stylesheets_rec.stylesheet_filename,

Line 396: AMS_IBA_PL_STYLESHTS_B_PKG.Update_Row(

392: -- Debug Message
393: -- 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;
394:
395: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Update_Row)
396: AMS_IBA_PL_STYLESHTS_B_PKG.Update_Row(
397: p_stylesheet_id => p_iba_pl_stylesheets_rec.stylesheet_id,
398: p_content_type => p_iba_pl_stylesheets_rec.content_type,
399: p_stylesheet_filename => p_iba_pl_stylesheets_rec.stylesheet_filename,
400: p_status_code => p_iba_pl_stylesheets_rec.status_code,

Line 548: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Delete_Row)

544: FND_MSG_PUB.add;
545: END IF;
546: RAISE FND_API.g_exc_error;
547: ELSE
548: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Delete_Row)
549: AMS_IBA_PL_STYLESHTS_B_PKG.Delete_Row(
550: p_STYLESHEET_ID => p_STYLESHEET_ID);
551: --
552: -- End of API body

Line 549: AMS_IBA_PL_STYLESHTS_B_PKG.Delete_Row(

545: END IF;
546: RAISE FND_API.g_exc_error;
547: ELSE
548: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Delete_Row)
549: AMS_IBA_PL_STYLESHTS_B_PKG.Delete_Row(
550: p_STYLESHEET_ID => p_STYLESHEET_ID);
551: --
552: -- End of API body
553: --

Line 638: FROM AMS_IBA_PL_STYLESHTS_B

634: l_STYLESHEET_ID NUMBER;
635:
636: CURSOR c_Iba_Pl_Stylesheets IS
637: SELECT STYLESHEET_ID
638: FROM AMS_IBA_PL_STYLESHTS_B
639: WHERE STYLESHEET_ID = p_STYLESHEET_ID
640: AND object_version_number = p_object_version
641: FOR UPDATE NOWAIT;
642:

Line 815: -- 'AMS_IBA_PL_STYLESHTS_B',

811:
812:
813: -- IF p_validation_mode = JTF_PLSQL_API.g_create THEN
814: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
815: -- 'AMS_IBA_PL_STYLESHTS_B',
816: -- 'STYLESHEET_ID = ''' || p_iba_pl_stylesheets_rec.STYLESHEET_ID ||''''
817: -- );
818: -- ELSE
819: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 820: -- 'AMS_IBA_PL_STYLESHTS_B',

816: -- 'STYLESHEET_ID = ''' || p_iba_pl_stylesheets_rec.STYLESHEET_ID ||''''
817: -- );
818: -- ELSE
819: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
820: -- 'AMS_IBA_PL_STYLESHTS_B',
821: -- 'STYLESHEET_ID = ''' || p_iba_pl_stylesheets_rec.STYLESHEET_ID ||
822: -- ''' AND STYLESHEET_ID <> ' || p_iba_pl_stylesheets_rec.STYLESHEET_ID
823: -- );
824: -- END IF;

Line 1026: FROM ams_iba_pl_styleshts_b

1022: l_return_status VARCHAR2(1);
1023:
1024: CURSOR c_complete IS
1025: SELECT *
1026: FROM ams_iba_pl_styleshts_b
1027: WHERE stylesheet_id = p_iba_pl_stylesheets_rec.stylesheet_id;
1028: l_iba_pl_stylesheets_rec c_complete%ROWTYPE;
1029: BEGIN
1030: x_complete_rec := p_iba_pl_stylesheets_rec;