3320: IS
3321: l_csi_item_instance_h_id NUMBER;
3322:
3323: BEGIN
3324: SELECT csi_item_instances_h_s.NEXTVAL
3325: INTO l_csi_item_instance_h_id
3326: FROM dual;
3327: RETURN l_csi_item_instance_h_id;
3328: EXCEPTION
5233: l_min_txn_id := NULL;
5234: l_src_txn_date := NULL;
5235: select min(transaction_id)
5236: into l_min_txn_id
5237: from csi_item_instances_h
5238: where instance_id = p_instance_rec.instance_id
5239: and creation_date = (select min(creation_date) from csi_item_instances_h
5240: where instance_id = p_instance_rec.instance_id
5241: );
5235: select min(transaction_id)
5236: into l_min_txn_id
5237: from csi_item_instances_h
5238: where instance_id = p_instance_rec.instance_id
5239: and creation_date = (select min(creation_date) from csi_item_instances_h
5240: where instance_id = p_instance_rec.instance_id
5241: );
5242: --
5243: IF l_min_txn_id IS NOT NULL THEN