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 41: -- by AHL_UMP_PROCESSUNIT_PVT.Process_Unit into ahl_unit_effectivities and ahl_ue_relationships.

37: -- Define Procedures --
38: ------------------------------
39:
40: -- To flush the unit effectivities created in the temporary table (ahl_temp_unit_effectivities)
41: -- by AHL_UMP_PROCESSUNIT_PVT.Process_Unit into ahl_unit_effectivities and ahl_ue_relationships.
42:
43: PROCEDURE Flush_From_Temp_table (p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type)
44:
45: IS

Line 231: FROM ahl_ue_relationships

227: AND date_run < p_date_run
228: --AND defer_from_ue_id IS NULL
229: AND nvl(manually_planned_flag,'N') = 'N'
230: AND NOT EXISTS (SELECT 'x'
231: FROM ahl_ue_relationships
232: WHERE related_ue_id = ue.unit_effectivity_id);
233: -- FOR UPDATE OF message_code NOWAIT;
234: -- UMP rows are already locked by ahl_ump_processunit_pvt.lock_effectivity
235: -- proc.

Line 240: FROM ahl_ue_relationships

236:
237: -- Cursor to get all decendents for a UE.
238: CURSOR decendent_csr (p_unit_effectivity_id IN NUMBER) IS
239: SELECT ue_relationship_id, related_ue_id
240: FROM ahl_ue_relationships
241: WHERE relationship_code = 'PARENT' AND
242: originator_ue_id = p_unit_effectivity_id;
243:
244: -- Cursor to check if init-due excepion still valid.

Line 255: FROM ahl_ue_relationships

251:
252: -- to check if ue has child ue records.
253: CURSOR chk_child_ue_csr (p_unit_effectivity_id IN NUMBER) IS
254: SELECT 'x'
255: FROM ahl_ue_relationships
256: WHERE ue_id = p_unit_effectivity_id;
257:
258: l_visit_status_code VARCHAR2(40);
259:

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

897:
898: FOR ue_reln_rec IN decendent_csr(exception_rec.unit_effectivity_id) LOOP
899:
900: -- delete relationship.
901: AHL_UE_RELATIONSHIPS_PKG.Delete_Row (ue_reln_rec.ue_relationship_id);
902: -- delete unit effectivity record.
903: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(ue_reln_rec.related_ue_id);
904:
905: -- Delete the corresponding rows in ahl_schedule materials for this ue.

Line 1284: -- Insert into ahl_ue_relationships.

1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;
1282: CLOSE ahl_temp_parent_csr;
1283:
1284: -- Insert into ahl_ue_relationships.
1285: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
1286: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
1287: X_UE_ID => l_parent_ue_id,
1288: X_RELATED_UE_ID => l_temp_grp_rec.unit_effectivity_id,

Line 1285: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

1281: END IF;
1282: CLOSE ahl_temp_parent_csr;
1283:
1284: -- Insert into ahl_ue_relationships.
1285: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
1286: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
1287: X_UE_ID => l_parent_ue_id,
1288: X_RELATED_UE_ID => l_temp_grp_rec.unit_effectivity_id,
1289: X_RELATIONSHIP_CODE => 'PARENT',

Line 1368: FROM ahl_ue_relationships

1364: CURSOR ahl_ue_reln_csr(p_unit_effectivity_id IN NUMBER,
1365: p_level IN NUMBER) IS
1366: SELECT UE_ID parent_ue_id,
1367: RELATED_UE_ID ue_id
1368: FROM ahl_ue_relationships
1369: WHERE level = p_level
1370: START WITH ue_id = p_unit_effectivity_id AND
1371: relationship_code = 'PARENT'
1372: CONNECT BY PRIOR related_ue_id = ue_id AND

Line 1520: FROM ahl_ue_relationships

1516: LAST_UPDATE_DATE = sysdate,
1517: LAST_UPDATED_BY = fnd_global.user_id,
1518: LAST_UPDATE_LOGIN = fnd_global.login_id
1519: WHERE unit_effectivity_id IN (SELECT related_ue_id
1520: FROM ahl_ue_relationships
1521: WHERE originator_ue_id = p_temp_mr_rec.unit_effectivity_id
1522: AND relationship_code = 'PARENT');
1523:
1524: ELSE

Line 1764: -- Read group from ahl_ue_relationships.

1760: FROM ahl_temp_unit_SR_deferrals
1761: WHERE orig_unit_effectivity_id IS NULL
1762: FOR UPDATE OF unit_effectivity_id;
1763:
1764: -- Read group from ahl_ue_relationships.
1765: CURSOR ahl_ue_csr (p_orig_ue_id IN NUMBER) IS
1766: SELECT related_ue_id
1767: FROM ahl_ue_relationships
1768: WHERE originator_ue_id = p_orig_ue_id

Line 1767: FROM ahl_ue_relationships

1763:
1764: -- Read group from ahl_ue_relationships.
1765: CURSOR ahl_ue_csr (p_orig_ue_id IN NUMBER) IS
1766: SELECT related_ue_id
1767: FROM ahl_ue_relationships
1768: WHERE originator_ue_id = p_orig_ue_id
1769: AND relationship_code = 'PARENT';
1770:
1771: -- Read group elements.

Line 1879: FROM ahl_unit_effectivities_b UE, ahl_ue_relationships UER

1875:
1876: -- Get all mr-terminated children under the SR-UE.
1877: CURSOR ahl_term_mr_csr (p_sr_ue_id IN NUMBER) IS
1878: SELECT unit_effectivity_id
1879: FROM ahl_unit_effectivities_b UE, ahl_ue_relationships UER
1880: WHERE UE.unit_effectivity_id = UER.related_ue_id
1881: AND UER.ue_id = p_sr_ue_id
1882: AND UE.status_code = 'MR-TERMINATE';
1883:

Line 2313: -- Insert into ahl_ue_relationships.

2309: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2310: END IF;
2311: CLOSE ahl_temp_parent_csr;
2312:
2313: -- Insert into ahl_ue_relationships.
2314: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
2315: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
2316: X_UE_ID => l_parent_ue_id,
2317: X_RELATED_UE_ID => ahl_temp_rec.unit_effectivity_id,

Line 2314: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

2310: END IF;
2311: CLOSE ahl_temp_parent_csr;
2312:
2313: -- Insert into ahl_ue_relationships.
2314: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
2315: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
2316: X_UE_ID => l_parent_ue_id,
2317: X_RELATED_UE_ID => ahl_temp_rec.unit_effectivity_id,
2318: X_RELATIONSHIP_CODE => 'PARENT',

Line 2426: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

2422:
2423: CLOSE ahl_unit_effectivity_csr;
2424:
2425: -- Now create the relationship record.
2426: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
2427: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
2428: X_UE_ID => l_parent_ue_id,
2429: X_RELATED_UE_ID => l_unit_effectivity_id,
2430: X_RELATIONSHIP_CODE => 'PARENT',

Line 2489: FROM ahl_ue_relationships

2485: LAST_UPDATE_DATE = sysdate,
2486: LAST_UPDATED_BY = fnd_global.user_id,
2487: LAST_UPDATE_LOGIN = fnd_global.login_id
2488: WHERE unit_effectivity_id IN (SELECT related_ue_id
2489: FROM ahl_ue_relationships
2490: WHERE originator_ue_id = l_delete_ue_id_tbl(i)
2491: AND relationship_code = 'PARENT');
2492:
2493: -- Update originator UE ID.

Line 2505: -- delete ahl_ue_relationships

2501: LAST_UPDATE_LOGIN = fnd_global.login_id
2502: WHERE unit_effectivity_id = l_delete_ue_id_tbl(i);
2503:
2504: ELSIF (l_visit_status IS NULL) THEN
2505: -- delete ahl_ue_relationships
2506: FOR l_ue_rec IN ahl_ue_csr(l_delete_ue_id_tbl(i)) LOOP
2507:
2508: -- delete unit effectivity record.
2509: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_ue_rec.related_ue_id);

Line 2515: DELETE FROM ahl_ue_relationships

2511: -- Delete the corresponding rows in ahl_schedule materials for this ue.
2512: Delete_Sch_Materials(l_ue_rec.related_ue_id);
2513:
2514: END LOOP;
2515: DELETE FROM ahl_ue_relationships
2516: WHERE originator_ue_id = l_delete_ue_id_tbl(i);
2517:
2518: -- delete top UE
2519: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_delete_ue_id_tbl(i));