APPS.IGR_I_PKG_ITEM_CRM_PKG dependencies on AMS_DELIVERABLES_ALL_B

Line 155: CURSOR c_get_obj_num IS SELECT object_version_number from AMS_DELIVERABLES_ALL_B

151: */
152: l_tmp_var VARCHAR2(2000);
153: l_tmp_var1 VARCHAR2(2000);
154:
155: CURSOR c_get_obj_num IS SELECT object_version_number from AMS_DELIVERABLES_ALL_B
156: WHERE DELIVERABLE_ID = x_package_item_id;
157: l_object_version_number AMS_DELIVERABLES_ALL_B.object_version_number%TYPE;
158:
159: BEGIN

Line 157: l_object_version_number AMS_DELIVERABLES_ALL_B.object_version_number%TYPE;

153: l_tmp_var1 VARCHAR2(2000);
154:
155: CURSOR c_get_obj_num IS SELECT object_version_number from AMS_DELIVERABLES_ALL_B
156: WHERE DELIVERABLE_ID = x_package_item_id;
157: l_object_version_number AMS_DELIVERABLES_ALL_B.object_version_number%TYPE;
158:
159: BEGIN
160: OPEN c_get_obj_num; FETCH c_get_obj_num INTO l_object_version_number; CLOSE c_get_obj_num;
161: AMS_DELIVERABLE_PUB.lock_DELIVERABLE(

Line 219: CURSOR c_get_obj_num IS SELECT object_version_number from AMS_DELIVERABLES_ALL_B

215:
216: x_last_updated_by NUMBER;
217: x_last_update_login NUMBER;
218:
219: CURSOR c_get_obj_num IS SELECT object_version_number from AMS_DELIVERABLES_ALL_B
220: WHERE DELIVERABLE_ID = x_package_item_id;
221: l_object_version_number AMS_DELIVERABLES_ALL_B.object_version_number%TYPE;
222:
223: BEGIN

Line 221: l_object_version_number AMS_DELIVERABLES_ALL_B.object_version_number%TYPE;

217: x_last_update_login NUMBER;
218:
219: CURSOR c_get_obj_num IS SELECT object_version_number from AMS_DELIVERABLES_ALL_B
220: WHERE DELIVERABLE_ID = x_package_item_id;
221: l_object_version_number AMS_DELIVERABLES_ALL_B.object_version_number%TYPE;
222:
223: BEGIN
224: IF (X_MODE = 'I') THEN
225: x_last_updated_by := 1;