APPS.AMS_IBA_PL_SITES_PVT dependencies on AMS_IBA_PL_SITES_B_PKG

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 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