1032:
1033: END IF;
1034: END IF;
1035: -- store the details to the temp tables.
1036: DELETE FROM ahl_mr_instances_temp;
1037: IF x_mr_item_instances IS NOT NULL AND x_mr_item_instances.COUNT > 0
1038: THEN
1039: FOR i IN x_mr_item_instances.FIRST..x_mr_item_instances.LAST
1040: LOOP
1038: THEN
1039: FOR i IN x_mr_item_instances.FIRST..x_mr_item_instances.LAST
1040: LOOP
1041: IF(x_mr_item_instances.EXISTS(i)) THEN
1042: INSERT INTO ahl_mr_instances_temp
1043: (
1044: MR_INSTANCE_TEMP_ID,
1045: MR_EFFECTIVITY_ID,
1046: ITEM_INSTANCE_ID,