[Home] [Help]
252: IF (is_grp_mr_check%FOUND) THEN
253:
254: CLOSE is_grp_mr_check;
255:
256: -- call AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate the AHL_APPLICABLE_MRS temporary table
257: -- call the API with input p_include_doNotImplmt = 'Y', otherwise descendent_count is not populated.
258:
259: AHL_FMP_COMMON_PVT.Populate_Appl_MRs (
260: p_csi_ii_id => p_instance_id,
255:
256: -- call AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate the AHL_APPLICABLE_MRS temporary table
257: -- call the API with input p_include_doNotImplmt = 'Y', otherwise descendent_count is not populated.
258:
259: AHL_FMP_COMMON_PVT.Populate_Appl_MRs (
260: p_csi_ii_id => p_instance_id,
261: p_include_doNotImplmt => 'Y',
262: x_return_status => x_return_status,
263: x_msg_count => x_msg_count,
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:
272: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
273: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'AFTER Calling AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate AHL_APPLICABLE_MRS');
274: END IF;
275:
276: --loop not need as only one record.The Top Group MR is returned.
277: OPEN Get_all_appl_mrs ( p_mr_header_id , p_instance_id );