APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 597: -- to update the AHL_UE_RELATIONSHIPS table with the Unit Effectivity Relationships

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:
599: FOR l_appl_mrs_relns IN Get_Appl_Mr_Relns
600: LOOP
601:

Line 615: SELECT AHL_UE_RELATIONSHIPS_S.NEXTVAL INTO l_ue_relationship_id FROM DUAL;

611: FETCH get_rel_mr_ue_id into l_unit_effectivity_id;
612: CLOSE get_rel_mr_ue_id;
613: END IF;
614:
615: SELECT AHL_UE_RELATIONSHIPS_S.NEXTVAL INTO l_ue_relationship_id FROM DUAL;
616:
617: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW
618: (
619: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,

Line 617: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW

613: END IF;
614:
615: SELECT AHL_UE_RELATIONSHIPS_S.NEXTVAL INTO l_ue_relationship_id FROM DUAL;
616:
617: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW
618: (
619: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
620: X_UE_ID => l_unit_effectivity_id,
621: X_RELATED_UE_ID => l_appl_mrs_relns.ue_id,

Line 650: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW for Related MRs from AHL_APPLICABLE_MR_RELNS' );

646: );
647: END LOOP;
648:
649: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
650: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW for Related MRs from AHL_APPLICABLE_MR_RELNS' );
651: END IF;
652: END IF;
653:
654:

Line 763: AHL_UE_RELATIONSHIPS

759: Cursor GetOrigUeId ( c_ue_id NUMBER)
760: IS
761: SELECT ORIGINATOR_UE_ID
762: FROM
763: AHL_UE_RELATIONSHIPS
764: WHERE
765: RELATED_UE_ID = c_ue_id ;
766:
767: --given the Top Ue Id, get the whole tree

Line 773: AHL_UE_RELATIONSHIPS

769: Cursor GetAllUeIds ( c_ue_id NUMBER)
770: IS
771: SELECT UE_RELATIONSHIP_ID , UE_ID , RELATED_UE_ID , ORIGINATOR_UE_ID
772: FROM
773: AHL_UE_RELATIONSHIPS
774: START WITH UE_ID = c_ue_id
775: CONNECT BY UE_ID = PRIOR RELATED_UE_ID order by RELATED_UE_ID;
776:
777: -- get the status code of the UE before deleting it.

Line 902: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW( l_all_ue_ids.UE_RELATIONSHIP_ID);

898: CLOSE GetStatusCode;
899: IF ( l_get_status_code IS NULL OR l_get_status_code IN ('EXCEPTION') )
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