DBA Data[Home] [Help]

APPS.OKC_REP_STATUS_UPDATE_PVT dependencies on FND_GLOBAL

Line 170: last_updated_by = Fnd_Global.User_Id,

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;

Line 171: last_update_login = Fnd_Global.Login_Id

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:

Line 237: last_updated_by = Fnd_Global.User_Id,

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:

Line 238: last_update_login = Fnd_Global.Login_Id

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;