77:
78: --* logic starts here *--
79:
80:
81: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Insert_Row)
82: CSD_RO_BULLETINS_PKG.INSERT_ROW(
83: px_ro_bulletin_id => x_ro_bulletin_id
84: ,p_repair_line_id => p_ro_bulletin_rec.repair_line_id
85: ,p_bulletin_id => p_ro_bulletin_rec.bulletin_id
78: --* logic starts here *--
79:
80:
81: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Insert_Row)
82: CSD_RO_BULLETINS_PKG.INSERT_ROW(
83: px_ro_bulletin_id => x_ro_bulletin_id
84: ,p_repair_line_id => p_ro_bulletin_rec.repair_line_id
85: ,p_bulletin_id => p_ro_bulletin_rec.bulletin_id
86: ,p_last_viewed_date => p_ro_bulletin_rec.last_viewed_date
261:
262: --* NOTE: add validation logic here if needed
263:
264:
265: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Update_Row)
266: CSD_RO_BULLETINS_PKG.UPDATE_ROW(
267: p_ro_bulletin_id => p_ro_bulletin_rec.ro_bulletin_id
268: ,p_repair_line_id => p_ro_bulletin_rec.repair_line_id
269: ,p_bulletin_id => p_ro_bulletin_rec.bulletin_id
262: --* NOTE: add validation logic here if needed
263:
264:
265: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Update_Row)
266: CSD_RO_BULLETINS_PKG.UPDATE_ROW(
267: p_ro_bulletin_id => p_ro_bulletin_rec.ro_bulletin_id
268: ,p_repair_line_id => p_ro_bulletin_rec.repair_line_id
269: ,p_bulletin_id => p_ro_bulletin_rec.bulletin_id
270: ,p_last_viewed_date => p_ro_bulletin_rec.last_viewed_date
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: --* logic starts here *--
392:
393: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Delete_Row)
394: CSD_RO_BULLETINS_PKG.DELETE_ROW(p_ro_bulletin_id => p_ro_bulletin_id);
395:
396:
397: -- logic ends here *--
390:
391: --* logic starts here *--
392:
393: --* Invoke table handler(CSD_RO_BULLETINS_PKG.Delete_Row)
394: CSD_RO_BULLETINS_PKG.DELETE_ROW(p_ro_bulletin_id => p_ro_bulletin_id);
395:
396:
397: -- logic ends here *--
398:
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: --* logic starts here *--
506:
507: -- Invoke table handler(CSD_RO_BULLETINS_PKG.Lock_Row)
508: CSD_RO_BULLETINS_PKG.LOCK_ROW(
509: p_ro_bulletin_id => p_ro_bulletin_rec.ro_bulletin_id
510: ,p_object_version_number => p_ro_bulletin_rec.object_version_number);
511:
504:
505: --* logic starts here *--
506:
507: -- Invoke table handler(CSD_RO_BULLETINS_PKG.Lock_Row)
508: CSD_RO_BULLETINS_PKG.LOCK_ROW(
509: p_ro_bulletin_id => p_ro_bulletin_rec.ro_bulletin_id
510: ,p_object_version_number => p_ro_bulletin_rec.object_version_number);
511:
512: --* logic ends here *--