APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UE_RELATIONSHIPS

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

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:
525: FOR l_appl_mrs_relns IN Get_Appl_Mr_Relns
526: LOOP
527:

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

537: FETCH get_rel_mr_ue_id into l_unit_effectivity_id;
538: CLOSE get_rel_mr_ue_id;
539: END IF;
540:
541: SELECT AHL_UE_RELATIONSHIPS_S.NEXTVAL INTO l_ue_relationship_id FROM DUAL;
542:
543: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW
544: (
545: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,

Line 543: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW

539: END IF;
540:
541: SELECT AHL_UE_RELATIONSHIPS_S.NEXTVAL INTO l_ue_relationship_id FROM DUAL;
542:
543: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW
544: (
545: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
546: X_UE_ID => l_unit_effectivity_id,
547: X_RELATED_UE_ID => l_appl_mrs_relns.ue_id,

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

572: );
573: END LOOP;
574:
575: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
576: 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' );
577: END IF;
578: END IF;
579:
580:

Line 689: AHL_UE_RELATIONSHIPS

685: Cursor GetOrigUeId ( c_ue_id NUMBER)
686: IS
687: SELECT ORIGINATOR_UE_ID
688: FROM
689: AHL_UE_RELATIONSHIPS
690: WHERE
691: RELATED_UE_ID = c_ue_id ;
692:
693: --given the Top Ue Id, get the whole tree

Line 699: AHL_UE_RELATIONSHIPS

695: Cursor GetAllUeIds ( c_ue_id NUMBER)
696: IS
697: SELECT UE_RELATIONSHIP_ID , UE_ID , RELATED_UE_ID , ORIGINATOR_UE_ID
698: FROM
699: AHL_UE_RELATIONSHIPS
700: START WITH UE_ID = c_ue_id
701: CONNECT BY UE_ID = PRIOR RELATED_UE_ID order by RELATED_UE_ID;
702:
703: -- get the status code of the UE before deleting it.

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

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