eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 76: -- by AHL_UMP_PROCESSUNIT_PVT.Process_Unit into ahl_unit_effectivities and ahl_ue_relationships.

72: -- Define Procedures --
73: ------------------------------
74:
75: -- To flush the unit effectivities created in the temporary table (ahl_temp_unit_effectivities)
76: -- by AHL_UMP_PROCESSUNIT_PVT.Process_Unit into ahl_unit_effectivities and ahl_ue_relationships.
77: -- JKJain, NR Analysis and Forecasting
78: PROCEDURE Flush_From_Temp_table (p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type,
79: p_uc_header_id IN NUMBER)
80:

Line 296: FROM ahl_ue_relationships

292: AND date_run < p_date_run
293: --AND defer_from_ue_id IS NULL
294: AND nvl(manually_planned_flag,'N') = 'N'
295: AND NOT EXISTS (SELECT 'x'
296: FROM ahl_ue_relationships
297: WHERE related_ue_id = ue.unit_effectivity_id);
298: -- FOR UPDATE OF message_code NOWAIT;
299: -- UMP rows are already locked by ahl_ump_processunit_pvt.lock_effectivity
300: -- proc.

Line 305: FROM ahl_ue_relationships

301:
302: -- Cursor to get all decendents for a UE.
303: CURSOR decendent_csr (p_unit_effectivity_id IN NUMBER) IS
304: SELECT ue_relationship_id, related_ue_id
305: FROM ahl_ue_relationships
306: WHERE relationship_code = 'PARENT' AND
307: originator_ue_id = p_unit_effectivity_id;
308:
309: -- Cursor to check if init-due excepion still valid.

Line 320: FROM ahl_ue_relationships

316:
317: -- to check if ue has child ue records.
318: CURSOR chk_child_ue_csr (p_unit_effectivity_id IN NUMBER) IS
319: SELECT 'x'
320: FROM ahl_ue_relationships
321: WHERE ue_id = p_unit_effectivity_id;
322:
323: l_visit_status_code VARCHAR2(40);
324:

Line 572: AND NOT EXISTS (select 'x' from ahl_ue_relationships

568: AND ue.defer_from_ue_id IS NULL -- do not pick deferrals
569: AND ue.unit_effectivity_id = vts.unit_effectivity_id
570: AND vts.status_code IN ('RELEASED', 'CLOSED')
571: AND vts.task_type_code = 'SUMMARY'
572: AND NOT EXISTS (select 'x' from ahl_ue_relationships
573: where related_ue_id = ue.unit_effectivity_id)
574: ORDER BY due_date asc )
575: WHERE ROWNUM < 2;
576:

Line 1272: AHL_UE_RELATIONSHIPS_PKG.Delete_Row (ue_reln_rec.ue_relationship_id);

1268:
1269: FOR ue_reln_rec IN decendent_csr(exception_rec.unit_effectivity_id) LOOP
1270:
1271: -- delete relationship.
1272: AHL_UE_RELATIONSHIPS_PKG.Delete_Row (ue_reln_rec.ue_relationship_id);
1273: -- delete unit effectivity record.
1274: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(ue_reln_rec.related_ue_id);
1275:
1276: -- Delete the corresponding rows in ahl_schedule materials for this ue.

Line 1684: -- Insert into ahl_ue_relationships.

1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: END IF;
1682: CLOSE ahl_temp_parent_csr;
1683:
1684: -- Insert into ahl_ue_relationships.
1685: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
1686: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
1687: X_UE_ID => l_parent_ue_id,
1688: X_RELATED_UE_ID => l_temp_grp_rec.unit_effectivity_id,

Line 1685: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

1681: END IF;
1682: CLOSE ahl_temp_parent_csr;
1683:
1684: -- Insert into ahl_ue_relationships.
1685: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
1686: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
1687: X_UE_ID => l_parent_ue_id,
1688: X_RELATED_UE_ID => l_temp_grp_rec.unit_effectivity_id,
1689: X_RELATIONSHIP_CODE => 'PARENT',

Line 1768: FROM ahl_ue_relationships

1764: CURSOR ahl_ue_reln_csr(p_unit_effectivity_id IN NUMBER,
1765: p_level IN NUMBER) IS
1766: SELECT UE_ID parent_ue_id,
1767: RELATED_UE_ID ue_id
1768: FROM ahl_ue_relationships
1769: WHERE level = p_level
1770: START WITH ue_id = p_unit_effectivity_id AND
1771: relationship_code = 'PARENT'
1772: CONNECT BY PRIOR related_ue_id = ue_id AND

Line 1922: FROM ahl_ue_relationships

1918: LAST_UPDATE_LOGIN = fnd_global.login_id,
1919: -- JKJain, NR Analysis and Forecasting
1920: FLEET_HEADER_ID = p_temp_mr_rec.fleet_header_id
1921: WHERE unit_effectivity_id IN (SELECT related_ue_id
1922: FROM ahl_ue_relationships
1923: WHERE originator_ue_id = p_temp_mr_rec.unit_effectivity_id
1924: AND relationship_code = 'PARENT');
1925:
1926: ELSE

Line 2167: -- Read group from ahl_ue_relationships.

2163: WHERE orig_unit_effectivity_id IS NULL
2164: ORDER BY csi_item_instance_id, mr_header_id
2165: FOR UPDATE OF unit_effectivity_id;
2166:
2167: -- Read group from ahl_ue_relationships.
2168: CURSOR ahl_ue_csr (p_orig_ue_id IN NUMBER) IS
2169: SELECT related_ue_id
2170: FROM ahl_ue_relationships
2171: WHERE originator_ue_id = p_orig_ue_id

Line 2170: FROM ahl_ue_relationships

2166:
2167: -- Read group from ahl_ue_relationships.
2168: CURSOR ahl_ue_csr (p_orig_ue_id IN NUMBER) IS
2169: SELECT related_ue_id
2170: FROM ahl_ue_relationships
2171: WHERE originator_ue_id = p_orig_ue_id
2172: AND relationship_code = 'PARENT';
2173:
2174: -- Read group elements.

Line 2288: FROM ahl_unit_effectivities_b UE, ahl_ue_relationships UER

2284:
2285: -- Get all mr-terminated children under the SR-UE.
2286: CURSOR ahl_term_mr_csr (p_sr_ue_id IN NUMBER) IS
2287: SELECT unit_effectivity_id
2288: FROM ahl_unit_effectivities_b UE, ahl_ue_relationships UER
2289: WHERE UE.unit_effectivity_id = UER.related_ue_id
2290: AND UER.ue_id = p_sr_ue_id
2291: AND UE.status_code = 'MR-TERMINATE';
2292:

Line 2741: -- Insert into ahl_ue_relationships.

2737: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2738: END IF;
2739: CLOSE ahl_temp_parent_csr;
2740:
2741: -- Insert into ahl_ue_relationships.
2742: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
2743: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
2744: X_UE_ID => l_parent_ue_id,
2745: X_RELATED_UE_ID => ahl_temp_rec.unit_effectivity_id,

Line 2742: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

2738: END IF;
2739: CLOSE ahl_temp_parent_csr;
2740:
2741: -- Insert into ahl_ue_relationships.
2742: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
2743: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
2744: X_UE_ID => l_parent_ue_id,
2745: X_RELATED_UE_ID => ahl_temp_rec.unit_effectivity_id,
2746: X_RELATIONSHIP_CODE => 'PARENT',

Line 2853: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

2849:
2850: CLOSE ahl_unit_effectivity_csr;
2851:
2852: -- Now create the relationship record.
2853: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
2854: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
2855: X_UE_ID => l_parent_ue_id,
2856: X_RELATED_UE_ID => l_unit_effectivity_id,
2857: X_RELATIONSHIP_CODE => 'PARENT',

Line 2916: FROM ahl_ue_relationships

2912: LAST_UPDATE_DATE = sysdate,
2913: LAST_UPDATED_BY = fnd_global.user_id,
2914: LAST_UPDATE_LOGIN = fnd_global.login_id
2915: WHERE unit_effectivity_id IN (SELECT related_ue_id
2916: FROM ahl_ue_relationships
2917: WHERE originator_ue_id = l_delete_ue_id_tbl(i)
2918: AND relationship_code = 'PARENT');
2919:
2920: -- Update originator UE ID.

Line 2932: -- delete ahl_ue_relationships

2928: LAST_UPDATE_LOGIN = fnd_global.login_id
2929: WHERE unit_effectivity_id = l_delete_ue_id_tbl(i);
2930:
2931: ELSIF (l_visit_status IS NULL) THEN
2932: -- delete ahl_ue_relationships
2933: FOR l_ue_rec IN ahl_ue_csr(l_delete_ue_id_tbl(i)) LOOP
2934:
2935: -- delete unit effectivity record.
2936: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_ue_rec.related_ue_id);

Line 2942: DELETE FROM ahl_ue_relationships

2938: -- Delete the corresponding rows in ahl_schedule materials for this ue.
2939: Delete_Sch_Materials(l_ue_rec.related_ue_id);
2940:
2941: END LOOP;
2942: DELETE FROM ahl_ue_relationships
2943: WHERE originator_ue_id = l_delete_ue_id_tbl(i);
2944:
2945: -- delete top UE
2946: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_delete_ue_id_tbl(i));

Line 3858: FROM ahl_ue_relationships

3854: WHERE csi_item_instance_id = c_csi_item_instance_id and
3855: defer_from_ue_id is null and
3856: ((status_code is null and manually_planned_flag = 'Y') OR status_code = 'INIT-DUE') and
3857: NOT EXISTS ( SELECT 'X'
3858: FROM ahl_ue_relationships
3859: where related_ue_id = unit_effectivity_id )
3860: ;
3861:
3862:

Line 3880: FROM ahl_ue_relationships

3876:
3877: -- Get all child UE's for a given unit effectivity.
3878: CURSOR ahl_ue_relns_csr (c_unit_effectivity_id IN NUMBER) IS
3879: SELECT related_ue_id child_ue_id, ue_id parent_ue_id
3880: FROM ahl_ue_relationships
3881: START WITH ue_id = c_unit_effectivity_id
3882: AND relationship_code = 'PARENT'
3883: CONNECT BY PRIOR related_ue_id = ue_id
3884: AND relationship_code = 'PARENT'

Line 3889: FROM ahl_ue_relationships

3885: ORDER BY level;
3886: -- Get all child UE's for a given unit effectivity.
3887: CURSOR ahl_all_child_ue_csr (c_unit_effectivity_id IN NUMBER) IS
3888: SELECT related_ue_id
3889: FROM ahl_ue_relationships
3890: WHERE ORIGINATOR_UE_ID = c_unit_effectivity_id
3891: AND relationship_code = 'PARENT';
3892:
3893: