40: --pdoki added for ER 9583373
41: Cursor Chk_UE_Init_Due (c_mr_header_id NUMBER, c_instance_id NUMBER)
42: IS
43: SELECT 'x'
44: FROM AHL_UNIT_EFFECTIVITIES_B UE,
45: AHL_MR_HEADERS_B MRH
46: WHERE UE.mr_header_id = c_mr_header_id
47: AND MRH.mr_header_id = UE.mr_header_id
48: AND MRH.IMPLEMENT_STATUS_CODE IN ('MANDATORY','OPTIONAL_IMPLEMENT')
377: END IF;
378:
379: -- BACHANDR - NR project end
380:
381: SELECT AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL INTO l_unit_effectivity_id FROM DUAL;
382:
383: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (
384: X_ROWID => l_rowid,
385: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
507: l_uc_header_id := AHL_UTIL_UC_PKG.get_uc_header_id(p_instance_id => l_appl_mrs_relns.RELATED_CSI_ITEM_INSTANCE_ID);
508: -- BACHANDR - NR project end
509: */
510:
511: SELECT AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL INTO l_unit_effectivity_id FROM DUAL;
512:
513: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (
514: X_ROWID => l_rowid,
515: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
926:
927: -- added for SB Enh for 'Chain' case
928: BEGIN
929: delete from ahl_unit_effectivities_tl
930: where unit_effectivity_id in (select unit_effectivity_id from ahl_unit_effectivities_b where start_lc_ue_id = l_originator_ue_id);
931:
932: delete from ahl_unit_effectivities_b
933: where start_lc_ue_id = l_originator_ue_id
934: and unit_effectivity_id <> start_lc_ue_id;
928: BEGIN
929: delete from ahl_unit_effectivities_tl
930: where unit_effectivity_id in (select unit_effectivity_id from ahl_unit_effectivities_b where start_lc_ue_id = l_originator_ue_id);
931:
932: delete from ahl_unit_effectivities_b
933: where start_lc_ue_id = l_originator_ue_id
934: and unit_effectivity_id <> start_lc_ue_id;
935: EXCEPTION
936: WHEN OTHERS THEN