216:
217: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
218: END IF;
219:
220: -- Invoke table handler(Pv_Ge_Chklst_Resp_Pkg.Insert_Row)
221: Pv_Ge_Chklst_Resp_Pkg.Insert_Row(
222: --px_chklst_response_id => l_chklst_response_id,
223: px_chklst_response_id => l_ge_chklst_resp_rec.chklst_response_id,
224: p_checklist_item_id => p_ge_chklst_resp_rec.checklist_item_id,
217: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
218: END IF;
219:
220: -- Invoke table handler(Pv_Ge_Chklst_Resp_Pkg.Insert_Row)
221: Pv_Ge_Chklst_Resp_Pkg.Insert_Row(
222: --px_chklst_response_id => l_chklst_response_id,
223: px_chklst_response_id => l_ge_chklst_resp_rec.chklst_response_id,
224: p_checklist_item_id => p_ge_chklst_resp_rec.checklist_item_id,
225: px_object_version_number => l_object_version_number,
467:
468: -- Debug Message
469: --IF (PV_DEBUG_HIGH_ON) THENPVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
470:
471: -- Invoke table handler(Pv_Ge_Chklst_Resp_Pkg.Update_Row)
472: Pv_Ge_Chklst_Resp_Pkg.Update_Row(
473: p_chklst_response_id => p_ge_chklst_resp_rec.chklst_response_id,
474: p_checklist_item_id => p_ge_chklst_resp_rec.checklist_item_id,
475: p_object_version_number => p_ge_chklst_resp_rec.object_version_number,
468: -- Debug Message
469: --IF (PV_DEBUG_HIGH_ON) THENPVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
470:
471: -- Invoke table handler(Pv_Ge_Chklst_Resp_Pkg.Update_Row)
472: Pv_Ge_Chklst_Resp_Pkg.Update_Row(
473: p_chklst_response_id => p_ge_chklst_resp_rec.chklst_response_id,
474: p_checklist_item_id => p_ge_chklst_resp_rec.checklist_item_id,
475: p_object_version_number => p_ge_chklst_resp_rec.object_version_number,
476: p_arc_response_for_entity_code => p_ge_chklst_resp_rec.arc_response_for_entity_code,
637:
638: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
639: END IF;
640:
641: -- Invoke table handler(Pv_Ge_Chklst_Resp_Pkg.Delete_Row)
642: Pv_Ge_Chklst_Resp_Pkg.Delete_Row(
643: p_chklst_response_id => p_chklst_response_id,
644: p_object_version_number => p_object_version_number );
645: --
638: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
639: END IF;
640:
641: -- Invoke table handler(Pv_Ge_Chklst_Resp_Pkg.Delete_Row)
642: Pv_Ge_Chklst_Resp_Pkg.Delete_Row(
643: p_chklst_response_id => p_chklst_response_id,
644: p_object_version_number => p_object_version_number );
645: --
646: -- End of API body
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793:
794:
795: ------------------------ lock -------------------------
796: Pv_Ge_Chklst_Resp_Pkg.Lock_Row(l_chklst_response_id,p_object_version);
797:
798:
799: -------------------- finish --------------------------
800: FND_MSG_PUB.count_and_get(