APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 291: SELECT 'x' from okc_k_lines_b OKCL, ahl_unit_effectivities_b UE

287: l_scheduled_date DATE;
288:
289: -- Cursor to check whether contract for exiting UE is valid(bug#4692366)
290: CURSOR valid_contract_csr (p_unit_effectivity_id IN NUMBER) IS
291: SELECT 'x' from okc_k_lines_b OKCL, ahl_unit_effectivities_b UE
292: --WHERE NVL(NVL(DATE_TERMINATED,END_DATE),SYSDATE) >= SYSDATE
293: -- Fix for bug# 5517930
294: WHERE NVL(NVL(DATE_TERMINATED,END_DATE),SYSDATE+1) >= trunc(SYSDATE)
295: AND OKCL.id = UE.service_line_id

Line 303: FROM okc_k_lines_b OKCL, ahl_unit_effectivities_b UE

299: -- delete UMP rows only if due date > termination date/end date.
300: CURSOR valid_due_date_csr (p_unit_effectivity_id IN NUMBER,
301: p_due_date IN DATE) IS
302: SELECT 'x'
303: FROM okc_k_lines_b OKCL, ahl_unit_effectivities_b UE
304: WHERE trunc(p_due_date) <= NVL(DATE_TERMINATED,END_DATE)
305: AND OKCL.id = UE.service_line_id
306: AND UE.unit_effectivity_id = p_unit_effectivity_id;
307:

Line 1382: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2

1378: SELECT ue1.mr_header_id, ue1.csi_item_instance_id, ue1.unit_effectivity_id,
1379: ue2.mr_header_id parent_mr_header_id,
1380: ue2.csi_item_instance_id parent_csi_item_instance_id
1381: --FROM ahl_unit_effectivities_app_v ue1, ahl_unit_effectivities_app_v ue2
1382: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2
1383: WHERE ue1.unit_effectivity_id = p_ue_id AND
1384: ue2.unit_effectivity_id = p_parent_ue_id;
1385:
1386: -- Cursor to get all details of a unit effectivity record.

Line 1502: UPDATE AHL_UNIT_EFFECTIVITIES_B

1498:
1499: IF (l_visit_status IN ('RELEASED','CLOSED')) THEN
1500: l_grp_match_found := TRUE; -- ignore matching group as UE on shop floor.
1501: -- update existing UE children.
1502: UPDATE AHL_UNIT_EFFECTIVITIES_B
1503: SET mr_interval_id = p_temp_mr_rec.mr_interval_id,
1504: mr_effectivity_id = p_temp_mr_rec.mr_effectivity_id,
1505: due_date = p_temp_mr_rec.due_date,
1506: due_counter_value = p_temp_mr_rec.due_counter_value,

Line 1712: UPDATE ahl_unit_effectivities_b

1708: END IF;
1709: CLOSE unit_deferral_csr;
1710:
1711: -- update unit effectivity status on top node.
1712: UPDATE ahl_unit_effectivities_b
1713: SET status_code = 'INIT-DUE'
1714: WHERE unit_effectivity_id = l_temp_mr_rec.unit_effectivity_id;
1715:
1716: END IF;

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 2480: UPDATE AHL_UNIT_EFFECTIVITIES_B

2476: Delete_Sch_Materials(l_ue_rec.related_ue_id);
2477: END LOOP;
2478:
2479: -- update unit effectivity record to exception.
2480: UPDATE AHL_UNIT_EFFECTIVITIES_B
2481: SET status_code = 'EXCEPTION',
2482: message_code = 'VISIT-ASSIGN',
2483: object_version_number = object_version_number + 1,
2484: DATE_RUN = sysdate,

Line 2494: UPDATE AHL_UNIT_EFFECTIVITIES_B

2490: WHERE originator_ue_id = l_delete_ue_id_tbl(i)
2491: AND relationship_code = 'PARENT');
2492:
2493: -- Update originator UE ID.
2494: UPDATE AHL_UNIT_EFFECTIVITIES_B
2495: SET status_code = 'EXCEPTION',
2496: message_code = 'VISIT-ASSIGN',
2497: object_version_number = object_version_number + 1,
2498: DATE_RUN = sysdate,