APPS.AHL_PRD_DF_PVT dependencies on AHL_UE_RELATIONSHIPS_PKG

Line 4671: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

4667: -- create tree here
4668: IF (l_ue_relns_tbl.count > 0 AND p_new_status = 'DEFERRED')THEN
4669: FOR k IN l_ue_relns_tbl.FIRST..l_ue_relns_tbl.LAST LOOP
4670: -- Insert into ahl_ue_relationships.
4671: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
4672: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
4673: X_UE_ID => l_ue_relns_tbl(k).ue_id,
4674: X_RELATED_UE_ID => l_ue_relns_tbl(k).related_ue_id,
4675: X_RELATIONSHIP_CODE => 'PARENT',

Line 4887: AHL_UE_RELATIONSHIPS_PKG.delete_row(l_ue_relationship_id);

4883: AHL_UNIT_EFFECTIVITIES_PKG.delete_row(ue_id_rec.unit_effectivity_id);
4884: OPEN ue_rel_id_csr(ue_id_rec.unit_effectivity_id);
4885: FETCH ue_rel_id_csr INTO l_ue_relationship_id;
4886: IF(ue_rel_id_csr%FOUND) THEN
4887: AHL_UE_RELATIONSHIPS_PKG.delete_row(l_ue_relationship_id);
4888: END IF;
4889: CLOSE ue_rel_id_csr;
4890: ELSE -- assigned to visit -- mark as exception
4891: FOR ue_rec IN unit_effectivity_csr(ue_id_rec.unit_effectivity_id) LOOP