[Home] [Help]
14:
15:
16: -- To update ahl_unit_effectivities record.
17: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
18: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE);
19:
20: -- To create decendent records and build relationships if the MR is a group MR.
21: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);
22:
21: PROCEDURE create_group (p_x_temp_grp_rec IN OUT NOCOPY ahl_temp_unit_effectivities%ROWTYPE);
22:
23: -- To update decendent records and update relationships if the MR is a group MR.
24: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
25: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE);
26:
27: -- Process deferral and SR records.
28: -- Added for 11.5.10.
29: PROCEDURE Flush_Unit_SR_Deferrals;
153: LAST_UPDATE_DATE ,
154: LAST_UPDATED_BY ,
155: LAST_UPDATE_LOGIN
156:
157: --FROM ahl_unit_effectivities_app_v
158: FROM ahl_unit_effectivities_vl
159: WHERE unit_effectivity_id = p_unit_effectivity_id;
160: --FOR UPDATE OF preceding_ue_id, status_code NOWAIT; -- not required as these rows were locked before.
161:
217: ATTRIBUTE14 ,
218: ATTRIBUTE15 ,
219: OBJECT_VERSION_NUMBER
220:
221: FROM ahl_unit_effectivities_app_v ue
222: WHERE csi_item_instance_id = p_csi_item_instance_id AND
223: ( status_code IS NULL OR
224: status_code NOT IN ('ACCOMPLISHED','TERMINATED',
225: 'MR-TERMINATE', 'INIT-ACCOMPLISHED',
262:
263: l_temp_individual_mr_rec temp_individual_mrs_csr%ROWTYPE;
264:
265: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE;
266: l_mr_rec ahl_unit_effectivities_app_v%ROWTYPE;
267:
268: l_temp_mr_found BOOLEAN;
269: l_mr_found BOOLEAN;
270:
272: l_ue_rec ahl_unit_effectivity_csr%ROWTYPE;
273:
274: l_last_accomplishment_date DATE;
275: l_acc_unit_effectivity_id NUMBER;
276: l_acc_status_code ahl_unit_effectivities_app_v.status_code%TYPE;
277: l_return_val BOOLEAN;
278:
279: l_exception_upd_flag BOOLEAN;
280: l_delete_flag BOOLEAN;
1044: -----------------------------------------------------------------------------
1045: -- To update ahl_unit_effectivities record.
1046:
1047: PROCEDURE update_record (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
1048: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE)
1049: IS
1050:
1051: BEGIN
1052:
1329: --------------------------------------------------------------------------------
1330: -- To update decendent records and update relationships if the MR is a group MR.
1331:
1332: PROCEDURE update_group (p_temp_mr_rec IN ahl_temp_unit_effectivities%ROWTYPE,
1333: p_mr_rec IN ahl_unit_effectivities_app_v%ROWTYPE)
1334: IS
1335:
1336: -- Read group elements.
1337: CURSOR ahl_temp_grp_csr(p_csi_item_instance_id IN NUMBER,
1377: p_parent_ue_id IN NUMBER ) IS
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:
1429: ATTRIBUTE13 ,
1430: ATTRIBUTE14 ,
1431: ATTRIBUTE15 ,
1432: OBJECT_VERSION_NUMBER
1433: --FROM ahl_unit_effectivities_app_v
1434: FROM ahl_unit_effectivities_vl
1435: WHERE unit_effectivity_id = p_unit_effectivity_id;
1436: --FOR UPDATE OF due_date NOWAIT;
1437:
1471: i NUMBER;
1472: l_grp_match_flag BOOLEAN;
1473:
1474: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE := p_temp_mr_rec;
1475: l_unit_effectivity_rec ahl_unit_effectivities_app_v%ROWTYPE;
1476:
1477: -- added for bug# 7586838
1478: CURSOR unit_deferral_csr(p_ue_id IN NUMBER) IS
1479: SELECT unit_deferral_id