DBA Data[Home] [Help]

APPS.OKC_REP_STATUS_UPDATE_PVT dependencies on FND_GLOBAL

Line 182: last_updated_by = Fnd_Global.User_Id,

178: FORALL j IN NVL(selected_contract_ids.FIRST,0)..NVL(selected_contract_ids.LAST,-1)
179: UPDATE okc_rep_contracts_all
180: SET contract_status_code = p_status,
181: last_update_date = sysdate,
182: last_updated_by = Fnd_Global.User_Id,
183: last_update_login = Fnd_Global.Login_Id
184: WHERE contract_id = selected_contract_ids(j);
185:
186: END LOOP;

Line 183: last_update_login = Fnd_Global.Login_Id

179: UPDATE okc_rep_contracts_all
180: SET contract_status_code = p_status,
181: last_update_date = sysdate,
182: last_updated_by = Fnd_Global.User_Id,
183: last_update_login = Fnd_Global.Login_Id
184: WHERE contract_id = selected_contract_ids(j);
185:
186: END LOOP;
187:

Line 253: last_updated_by = Fnd_Global.User_Id,

249: FORALL j IN NVL(selected_vers_contract_ids.FIRST,0)..NVL(selected_vers_contract_ids.LAST,-1)
250: UPDATE okc_rep_contract_vers
251: SET contract_status_code = p_status,
252: last_update_date = sysdate,
253: last_updated_by = Fnd_Global.User_Id,
254: last_update_login = Fnd_Global.Login_Id
255: WHERE contract_id = selected_vers_contract_ids(j)
256: AND contract_version_num = selected_vers_contract_ver(j);
257:

Line 254: last_update_login = Fnd_Global.Login_Id

250: UPDATE okc_rep_contract_vers
251: SET contract_status_code = p_status,
252: last_update_date = sysdate,
253: last_updated_by = Fnd_Global.User_Id,
254: last_update_login = Fnd_Global.Login_Id
255: WHERE contract_id = selected_vers_contract_ids(j)
256: AND contract_version_num = selected_vers_contract_ver(j);
257:
258: END LOOP;