[Home] [Help]
7:
8: --Define global cursor
9: CURSOR get_csi_ii_ovn(c_subject_id number) IS
10: SELECT object_version_number
11: FROM csi_ii_relationships
12: WHERE subject_id = c_subject_id
13: AND relationship_type_code = 'COMPONENT-OF'
14: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
15: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
209: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: --Get the object_version_number of the record in csi_ii_relationships which has p_instance_id
214: --as the subject_id. This public API doesn't contain the validation to check whether
215: --p_instance_id is installed in p_uc_header_id which is done in the private API.
216: OPEN get_csi_ii_ovn(l_instance_id);
217: FETCH get_csi_ii_ovn INTO l_csi_ii_ovn;
371: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374:
375: --Get the object_version_number of the record in csi_ii_relationships which has p_instance_id
376: --as the subject_id. This public API doesn't contain the validation to check whether
377: --p_instance_id is installed in p_uc_header_id which is done in the private API.
378: OPEN get_csi_ii_ovn(l_instance_id);
379: FETCH get_csi_ii_ovn INTO l_csi_ii_ovn;
832: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END IF;
835:
836: --Get the object_version_number of the record in csi_ii_relationships which has p_instance_id
837: --as the subject_id and p_parent_instance_id as the object_id and also position_reference is
838: --NULL(extra). This public API doesn't contain the validation to check whether
839: --p_relationship_id is valid which is done in the private API.
840: OPEN get_csi_ii_ovn(l_instance_id);
1019: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1021: END IF;
1022:
1023: --Get the object_version_number of the record in csi_ii_relationships which has p_instance_id
1024: --as the subject_id and p_parent_instance_id as the object_id and also position_reference is
1025: --NULL(extra). This public API doesn't contain the validation to check whether
1026: --p_relationship_id is valid which is done in the private API.
1027: OPEN get_csi_ii_ovn(l_old_instance_id);