APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UNIT_EFFECTIVITIES_PKG

Line 339: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (

335: END IF; -- is_grp_mr_check%FOUND
336:
337: SELECT AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL INTO l_unit_effectivity_id FROM DUAL;
338:
339: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (
340: X_ROWID => l_rowid,
341: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
342: X_EARLIEST_DUE_DATE => NULL ,
343: X_LATEST_DUE_DATE => NULL ,

Line 435: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' BEFORE Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );

431:
432: -- create Unit Effectivities from Related MRs also
433:
434: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
435: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' BEFORE Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );
436: END IF;
437:
438: FOR l_appl_mrs_relns IN Get_Appl_Mr_Relns
439: LOOP

Line 443: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (

439: LOOP
440:
441: SELECT AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL INTO l_unit_effectivity_id FROM DUAL;
442:
443: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (
444: X_ROWID => l_rowid,
445: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
446: X_EARLIEST_DUE_DATE => NULL ,
447: X_LATEST_DUE_DATE => NULL ,

Line 520: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );

516:
517: END LOOP;
518:
519: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
520: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );
521: END IF;
522:
523: -- to update the AHL_UE_RELATIONSHIPS table with the Unit Effectivity Relationships
524:

Line 830: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW( l_all_ue_ids.RELATED_UE_ID);

826: THEN
827: -- delete the corresponding relationships records too.
828: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW( l_all_ue_ids.UE_RELATIONSHIP_ID);
829: -- deletes all related ue ids of the originator ue id of the ue id passed for deletion.
830: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW( l_all_ue_ids.RELATED_UE_ID);
831:
832: ELSE
833: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');
834: FND_MSG_PUB.ADD;

Line 856: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(l_originator_ue_id);

852:
853:
854: -- deletes the top node UE id
855:
856: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(l_originator_ue_id);
857:
858: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
859: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER deleting the originator UE ');
860: END IF;