99:
100: cursor c_id is
101: SELECT instance_status_id
102: FROM csi_instance_statuses
103: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
104:
105: r_id c_id%rowtype;
106:
107: CURSOR c_obj_version (pc_instance_id IN NUMBER) is
1228:
1229: cursor c_id is
1230: SELECT instance_status_id
1231: FROM csi_instance_statuses
1232: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
1233:
1234: r_id c_id%rowtype;
1235:
1236: CURSOR c_obj_version (pc_instance_id IN NUMBER) is
2184:
2185: cursor c_id is
2186: SELECT instance_status_id
2187: FROM csi_instance_statuses
2188: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
2189:
2190: r_id c_id%rowtype;
2191:
2192: CURSOR c_phys_inv_info (pc_physical_adjustment_id IN NUMBER) is