APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 248: FROM ahl_unit_deferrals_b

244: -- Cursor to check if init-due excepion still valid.
245: CURSOR exception_init_due_csr (p_unit_effectivity_id IN NUMBER) IS
246: SELECT unit_deferral_id
247: --FROM ahl_unit_thresholds
248: FROM ahl_unit_deferrals_b
249: WHERE unit_effectivity_id = p_unit_effectivity_id
250: AND unit_deferral_type = 'INIT-DUE';
251:
252: -- to check if ue has child ue records.

Line 1480: FROM ahl_unit_deferrals_b

1476:
1477: -- added for bug# 7586838
1478: CURSOR unit_deferral_csr(p_ue_id IN NUMBER) IS
1479: SELECT unit_deferral_id
1480: FROM ahl_unit_deferrals_b
1481: WHERE UNIT_EFFECTIVITY_ID = p_ue_id
1482: AND UNIT_DEFERRAL_TYPE = 'INIT-DUE';
1483:
1484: l_unit_deferral_id NUMBER;

Line 1697: -- update ahl_unit_deferrals_b.

1693:
1694: create_group (p_x_temp_grp_rec => l_temp_mr_rec);
1695: -- fix for bug# 7586838.
1696: IF (p_mr_rec.status_code = 'INIT-DUE') THEN
1697: -- update ahl_unit_deferrals_b.
1698: OPEN unit_deferral_csr(p_mr_rec.unit_effectivity_id);
1699: FETCH unit_deferral_csr INTO l_unit_deferral_id;
1700: IF (unit_deferral_csr%FOUND) THEN
1701: UPDATE ahl_unit_deferrals_b

Line 1701: UPDATE ahl_unit_deferrals_b

1697: -- update ahl_unit_deferrals_b.
1698: OPEN unit_deferral_csr(p_mr_rec.unit_effectivity_id);
1699: FETCH unit_deferral_csr INTO l_unit_deferral_id;
1700: IF (unit_deferral_csr%FOUND) THEN
1701: UPDATE ahl_unit_deferrals_b
1702: SET UNIT_EFFECTIVITY_ID = l_temp_mr_rec.unit_effectivity_id,
1703: last_update_date = sysdate,
1704: object_version_number = object_version_number + 1,
1705: LAST_UPDATED_BY = fnd_global.user_id,

Line 2202: UPDATE AHL_UNIT_DEFERRALS_B

2198:
2199: CLOSE ahl_unit_effectivity_csr;
2200:
2201: -- Associate deferral threshold to new UE if exists (deferral from UMP).
2202: UPDATE AHL_UNIT_DEFERRALS_B
2203: SET unit_effectivity_id = l_new_top_ue_id,
2204: last_update_date = sysdate,
2205: object_version_number = object_version_number + 1,
2206: LAST_UPDATED_BY = fnd_global.user_id,