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_PAGES_PVT dependencies on AMS_IBA_PL_PAGES_B

Line 65: FROM AMS_IBA_PL_PAGES_B

61: l_page_ref_count NUMBER;
62:
63: CURSOR c_page_ref(c_page_id IN NUMBER, c_page_ref_code IN VARCHAR2) IS
64: SELECT COUNT(*)
65: FROM AMS_IBA_PL_PAGES_B
66: where page_id = c_page_id
67: and page_ref_code = c_page_ref_code;
68: BEGIN
69: x_return_status := FND_API.g_ret_sts_success;

Line 114: SELECT ams_iba_pl_pages_b_s.NEXTVAL

110: l_site_ref_code VARCHAR2(30);
111: l_site_id NUMBER;
112:
113: CURSOR c_id IS
114: SELECT ams_iba_pl_pages_b_s.NEXTVAL
115: FROM dual;
116:
117: CURSOR c_id_exists (l_id IN NUMBER) IS
118: SELECT 1

Line 119: FROM AMS_IBA_PL_PAGES_B

115: FROM dual;
116:
117: CURSOR c_id_exists (l_id IN NUMBER) IS
118: SELECT 1
119: FROM AMS_IBA_PL_PAGES_B
120: WHERE PAGE_ID = l_id;
121:
122: CURSOR c_site_id (l_site_ref_code IN VARCHAR2) IS
123: SELECT site_id

Line 219: -- Invoke table handler(AMS_IBA_PL_PAGES_B_PKG.Insert_Row)

215:
216: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
217: END IF;
218:
219: -- Invoke table handler(AMS_IBA_PL_PAGES_B_PKG.Insert_Row)
220: AMS_IBA_PL_PAGES_B_PKG.Insert_Row(
221: px_page_id => l_page_id,
222: p_site_id => l_site_id,
223: p_site_ref_code => p_iba_pl_pages_rec.site_ref_code,

Line 220: AMS_IBA_PL_PAGES_B_PKG.Insert_Row(

216: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
217: END IF;
218:
219: -- Invoke table handler(AMS_IBA_PL_PAGES_B_PKG.Insert_Row)
220: AMS_IBA_PL_PAGES_B_PKG.Insert_Row(
221: px_page_id => l_page_id,
222: p_site_id => l_site_id,
223: p_site_ref_code => p_iba_pl_pages_rec.site_ref_code,
224: p_page_ref_code => p_iba_pl_pages_rec.page_ref_code,

Line 319: FROM AMS_IBA_PL_PAGES_B;

315: IS
316: --/*
317: CURSOR c_get_iba_pl_pages(page_id NUMBER) IS
318: SELECT *
319: FROM AMS_IBA_PL_PAGES_B;
320: -- Hint: Developer need to provide Where clause
321: --*/
322: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Iba_Pl_Pages';
323: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 461: -- Invoke table handler(AMS_IBA_PL_PAGES_B_PKG.Update_Row)

457:
458: -- Debug Message
459: -- 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;
460:
461: -- Invoke table handler(AMS_IBA_PL_PAGES_B_PKG.Update_Row)
462: AMS_IBA_PL_PAGES_B_PKG.Update_Row(
463: p_page_id => p_iba_pl_pages_rec.page_id,
464: p_site_id => p_iba_pl_pages_rec.site_id,
465: p_site_ref_code => p_iba_pl_pages_rec.site_ref_code,

Line 462: AMS_IBA_PL_PAGES_B_PKG.Update_Row(

458: -- Debug Message
459: -- 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;
460:
461: -- Invoke table handler(AMS_IBA_PL_PAGES_B_PKG.Update_Row)
462: AMS_IBA_PL_PAGES_B_PKG.Update_Row(
463: p_page_id => p_iba_pl_pages_rec.page_id,
464: p_site_id => p_iba_pl_pages_rec.site_id,
465: p_site_ref_code => p_iba_pl_pages_rec.site_ref_code,
466: p_page_ref_code => p_iba_pl_pages_rec.page_ref_code,

Line 612: -- Invoke table handler(AMS_IBA_PL_PAGES_B_PKG.Delete_Row)

608: FND_MSG_PUB.add;
609: END IF;
610: RAISE FND_API.g_exc_error;
611: ELSE
612: -- Invoke table handler(AMS_IBA_PL_PAGES_B_PKG.Delete_Row)
613: AMS_IBA_PL_PAGES_B_PKG.Delete_Row(
614: p_PAGE_ID => p_PAGE_ID);
615: --
616: -- End of API body

Line 613: AMS_IBA_PL_PAGES_B_PKG.Delete_Row(

609: END IF;
610: RAISE FND_API.g_exc_error;
611: ELSE
612: -- Invoke table handler(AMS_IBA_PL_PAGES_B_PKG.Delete_Row)
613: AMS_IBA_PL_PAGES_B_PKG.Delete_Row(
614: p_PAGE_ID => p_PAGE_ID);
615: --
616: -- End of API body
617: --

Line 703: FROM AMS_IBA_PL_PAGES_B

699: l_PAGE_ID NUMBER;
700:
701: CURSOR c_Iba_Pl_Pages IS
702: SELECT PAGE_ID
703: FROM AMS_IBA_PL_PAGES_B
704: WHERE PAGE_ID = p_PAGE_ID
705: AND object_version_number = p_object_version
706: FOR UPDATE NOWAIT;
707: BEGIN

Line 877: -- 'AMS_IBA_PL_PAGES_B',

873: end if;
874:
875: -- IF p_validation_mode = JTF_PLSQL_API.g_create THEN
876: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
877: -- 'AMS_IBA_PL_PAGES_B',
878: -- 'PAGE_ID = ''' || p_iba_pl_pages_rec.PAGE_ID ||''''
879: -- );
880: -- ELSE
881: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 882: -- 'AMS_IBA_PL_PAGES_B',

878: -- 'PAGE_ID = ''' || p_iba_pl_pages_rec.PAGE_ID ||''''
879: -- );
880: -- ELSE
881: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
882: -- 'AMS_IBA_PL_PAGES_B',
883: -- 'PAGE_ID = ''' || p_iba_pl_pages_rec.PAGE_ID ||
884: -- ''' AND PAGE_ID <> ' || p_iba_pl_pages_rec.PAGE_ID
885: -- );
886: -- END IF;

Line 1120: FROM ams_iba_pl_pages_b

1116: l_return_status VARCHAR2(1);
1117:
1118: CURSOR c_complete IS
1119: SELECT *
1120: FROM ams_iba_pl_pages_b
1121: WHERE page_id = p_iba_pl_pages_rec.page_id;
1122: l_iba_pl_pages_rec c_complete%ROWTYPE;
1123: BEGIN
1124: x_complete_rec := p_iba_pl_pages_rec;