79: l_location_type VARCHAR2(50);
80:
81: cursor c_id is
82: SELECT instance_status_id
83: FROM csi_instance_statuses
84: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
85:
86: r_id c_id%rowtype;
87:
951: l_curr_quantity NUMBER := NULL;
952:
953: cursor c_id is
954: SELECT instance_status_id
955: FROM csi_instance_statuses
956: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
957:
958: r_id c_id%rowtype;
959:
2270: l_location_type VARCHAR2(50);
2271:
2272: cursor c_id is
2273: SELECT instance_status_id
2274: FROM csi_instance_statuses
2275: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
2276:
2277: r_id c_id%rowtype;
2278: