APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UNIT_EFFECTIVITIES_PKG

Line 383: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (

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,
386: X_EARLIEST_DUE_DATE => NULL ,
387: X_LATEST_DUE_DATE => NULL ,

Line 483: 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' );

479:
480: -- create Unit Effectivities from Related MRs also
481:
482: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
483: 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' );
484: END IF;
485:
486: FOR l_appl_mrs_relns IN Get_Appl_Mr_Relns
487: LOOP

Line 513: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (

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,
516: X_EARLIEST_DUE_DATE => NULL ,
517: X_LATEST_DUE_DATE => NULL ,

Line 594: 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' );

590:
591: END LOOP;
592:
593: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
594: 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' );
595: END IF;
596:
597: -- to update the AHL_UE_RELATIONSHIPS table with the Unit Effectivity Relationships
598:

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

900: THEN
901: -- delete the corresponding relationships records too.
902: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW( l_all_ue_ids.UE_RELATIONSHIP_ID);
903: -- deletes all related ue ids of the originator ue id of the ue id passed for deletion.
904: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW( l_all_ue_ids.RELATED_UE_ID);
905:
906: ELSE
907: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');
908: FND_MSG_PUB.ADD;

Line 941: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(l_originator_ue_id);

937: null;
938: END;
939: -- deletes the top node UE id
940:
941: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(l_originator_ue_id);
942:
943: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
944: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER deleting the originator UE ');
945: END IF;