166: FORALL j IN NVL(selected_contract_ids.FIRST,0)..NVL(selected_contract_ids.LAST,-1)
167: UPDATE okc_rep_contracts_all
168: SET contract_status_code = p_status,
169: last_update_date = sysdate,
170: last_updated_by = Fnd_Global.User_Id,
171: last_update_login = Fnd_Global.Login_Id
172: WHERE contract_id = selected_contract_ids(j);
173:
174: END LOOP;
167: UPDATE okc_rep_contracts_all
168: SET contract_status_code = p_status,
169: last_update_date = sysdate,
170: last_updated_by = Fnd_Global.User_Id,
171: last_update_login = Fnd_Global.Login_Id
172: WHERE contract_id = selected_contract_ids(j);
173:
174: END LOOP;
175:
233: FORALL j IN NVL(selected_vers_contract_ids.FIRST,0)..NVL(selected_vers_contract_ids.LAST,-1)
234: UPDATE okc_rep_contract_vers
235: SET contract_status_code = p_status,
236: last_update_date = sysdate,
237: last_updated_by = Fnd_Global.User_Id,
238: last_update_login = Fnd_Global.Login_Id
239: WHERE contract_id = selected_vers_contract_ids(j)
240: AND contract_version_num = selected_vers_contract_ver(j);
241:
234: UPDATE okc_rep_contract_vers
235: SET contract_status_code = p_status,
236: last_update_date = sysdate,
237: last_updated_by = Fnd_Global.User_Id,
238: last_update_login = Fnd_Global.Login_Id
239: WHERE contract_id = selected_vers_contract_ids(j)
240: AND contract_version_num = selected_vers_contract_ver(j);
241:
242: END LOOP;