170:
171: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
172: END IF;
173:
174: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Insert_Row)
175: AMS_ACT_CONTACT_POINTS_PKG.Insert_Row(
176: px_contact_point_id => l_contact_point_id,
177: p_last_update_date => SYSDATE,
178: p_last_updated_by => FND_GLOBAL.user_id,
171: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
172: END IF;
173:
174: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Insert_Row)
175: AMS_ACT_CONTACT_POINTS_PKG.Insert_Row(
176: px_contact_point_id => l_contact_point_id,
177: p_last_update_date => SYSDATE,
178: p_last_updated_by => FND_GLOBAL.user_id,
179: p_creation_date => SYSDATE,
409:
410: AMS_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');
411: END IF;
412:
413: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Update_Row)
414: AMS_ACT_CONTACT_POINTS_PKG.Update_Row(
415: p_contact_point_id => p_cnt_point_rec.contact_point_id,
416: p_last_update_date => SYSDATE,
417: p_last_updated_by => FND_GLOBAL.user_id,
410: AMS_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');
411: END IF;
412:
413: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Update_Row)
414: AMS_ACT_CONTACT_POINTS_PKG.Update_Row(
415: p_contact_point_id => p_cnt_point_rec.contact_point_id,
416: p_last_update_date => SYSDATE,
417: p_last_updated_by => FND_GLOBAL.user_id,
418: p_last_update_login => FND_GLOBAL.conc_login_id,
584:
585: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
586: END IF;
587:
588: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Delete_Row)
589: AMS_ACT_CONTACT_POINTS_PKG.Delete_Row(
590: p_CONTACT_POINT_ID => p_CONTACT_POINT_ID);
591: --
592: -- End of API body
585: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
586: END IF;
587:
588: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Delete_Row)
589: AMS_ACT_CONTACT_POINTS_PKG.Delete_Row(
590: p_CONTACT_POINT_ID => p_CONTACT_POINT_ID);
591: --
592: -- End of API body
593: --