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_SITES_PVT dependencies on AMS_IBA_PL_SITES_B

Line 95: FROM AMS_IBA_PL_SITES_B

91: l_site_ref_count NUMBER;
92:
93: CURSOR c_site_ref(c_site_id IN NUMBER, c_site_ref_code IN VARCHAR2) IS
94: SELECT COUNT(*)
95: FROM AMS_IBA_PL_SITES_B
96: where site_id = c_site_id
97: and site_ref_code = c_site_ref_code;
98: BEGIN
99: x_return_status := FND_API.g_ret_sts_success;

Line 141: SELECT ams_iba_pl_sites_b_s.NEXTVAL

137: l_site_id NUMBER;
138: l_dummy NUMBER;
139:
140: CURSOR c_id IS
141: SELECT ams_iba_pl_sites_b_s.NEXTVAL
142: FROM dual;
143:
144: CURSOR c_id_exists (l_id IN NUMBER) IS
145: (SELECT 1 FROM ams_iba_pl_sites_b

Line 145: (SELECT 1 FROM ams_iba_pl_sites_b

141: SELECT ams_iba_pl_sites_b_s.NEXTVAL
142: FROM dual;
143:
144: CURSOR c_id_exists (l_id IN NUMBER) IS
145: (SELECT 1 FROM ams_iba_pl_sites_b
146: WHERE site_id = l_id);
147:
148: BEGIN
149: -- Standard Start of API savepoint

Line 236: -- Invoke table handler(AMS_IBA_PL_SITES_B_PKG.Insert_Row)

232:
233: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
234: END IF;
235:
236: -- Invoke table handler(AMS_IBA_PL_SITES_B_PKG.Insert_Row)
237: AMS_IBA_PL_SITES_B_PKG.Insert_Row(
238: px_site_id => l_site_id,
239: p_site_ref_code => p_iba_pl_sites_rec.site_ref_code,
240: p_site_category_type => p_iba_pl_sites_rec.site_category_type,

Line 237: AMS_IBA_PL_SITES_B_PKG.Insert_Row(

233: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
234: END IF;
235:
236: -- Invoke table handler(AMS_IBA_PL_SITES_B_PKG.Insert_Row)
237: AMS_IBA_PL_SITES_B_PKG.Insert_Row(
238: px_site_id => l_site_id,
239: p_site_ref_code => p_iba_pl_sites_rec.site_ref_code,
240: p_site_category_type => p_iba_pl_sites_rec.site_category_type,
241: p_site_category_object_id => p_iba_pl_sites_rec.site_category_object_id,

Line 337: FROM AMS_IBA_PL_SITES_B

333: IS
334: --/*
335: CURSOR c_get_iba_pl_sites(site_id NUMBER) IS
336: SELECT *
337: FROM AMS_IBA_PL_SITES_B
338: WHERE site_id = site_id;
339: -- Hint: Developer need to provide Where clause
340: --*/
341: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Iba_Pl_Sites';

Line 520: -- Invoke table handler(AMS_IBA_PL_SITES_B_PKG.Update_Row)

516:
517: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler - mymessage - site_id='||p_iba_pl_sites_rec.site_id);
518: END IF;
519:
520: -- Invoke table handler(AMS_IBA_PL_SITES_B_PKG.Update_Row)
521: AMS_IBA_PL_SITES_B_PKG.Update_Row(
522: p_site_id => p_iba_pl_sites_rec.site_id,
523: p_site_ref_code => p_iba_pl_sites_rec.site_ref_code,
524: p_site_category_type => p_iba_pl_sites_rec.site_category_type,

Line 521: AMS_IBA_PL_SITES_B_PKG.Update_Row(

517: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler - mymessage - site_id='||p_iba_pl_sites_rec.site_id);
518: END IF;
519:
520: -- Invoke table handler(AMS_IBA_PL_SITES_B_PKG.Update_Row)
521: AMS_IBA_PL_SITES_B_PKG.Update_Row(
522: p_site_id => p_iba_pl_sites_rec.site_id,
523: p_site_ref_code => p_iba_pl_sites_rec.site_ref_code,
524: p_site_category_type => p_iba_pl_sites_rec.site_category_type,
525: p_site_category_object_id => p_iba_pl_sites_rec.site_category_object_id,

Line 680: -- Invoke table handler(AMS_IBA_PL_SITES_B_PKG.Delete_Row)

676:
677: AMS_UTILITY_PVT.debug_message('Private API: Page Count = ' || l_site_page_count );
678:
679: END IF;
680: -- Invoke table handler(AMS_IBA_PL_SITES_B_PKG.Delete_Row)
681: IF l_site_page_count = 0 --MEANING NO PAGES ARE AVAILABLE FOR THIS SITE
682: THEN
683: -- IF l_object_version_number = p_object_version_number -- VERSIONS MATCH
684: -- THEN

Line 690: AMS_IBA_PL_SITES_B_PKG.Delete_Row

686:
687: AMS_UTILITY_PVT.debug_message('Private API: Just before calling Delete site_id = ' || p_site_id || 'obj_ver_no = ' || p_object_version_number);
688: END IF;
689:
690: AMS_IBA_PL_SITES_B_PKG.Delete_Row
691: (p_site_id => p_site_id,
692: p_object_version_number => p_object_version_number
693: );
694: IF (AMS_DEBUG_HIGH_ON) THEN

Line 811: FROM AMS_IBA_PL_SITES_B

807: l_SITE_ID NUMBER;
808:
809: CURSOR c_Iba_Pl_Sites IS
810: SELECT SITE_ID
811: FROM AMS_IBA_PL_SITES_B
812: WHERE SITE_ID = p_SITE_ID
813: AND object_version_number = p_object_version
814: FOR UPDATE NOWAIT;
815:

Line 936: 'ams_iba_pl_sites_b'

932: --If Validation_mode is create, check uniqueness of site_id, name, site_ref_code
933: if p_validation_mode = JTF_PLSQL_API.g_create then
934: -- Checking if the site id passed is unique
935: l_site_id_flag := ams_uTILITY_pvt.check_uniqueness(
936: 'ams_iba_pl_sites_b'
937: , 'site_id = ''' || p_iba_pl_sites_rec.site_id ||''''
938: );
939:
940: if l_site_id_flag = fnd_api.g_false then

Line 1243: FROM ams_iba_pl_sites_b

1239: l_return_status VARCHAR2(1);
1240:
1241: CURSOR c_complete IS
1242: SELECT *
1243: FROM ams_iba_pl_sites_b
1244: WHERE site_id = p_iba_pl_sites_rec.site_id;
1245: l_iba_pl_sites_rec c_complete%ROWTYPE;
1246: BEGIN
1247: x_complete_rec := p_iba_pl_sites_rec;