DBA Data[Home] [Help]

APPS.IA_WF_REQUEST_PKG dependencies on IA_REQUEST_DETAILS

Line 337: update ia_request_details

333: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
334: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
335: where request_id = p_request_id;
336:
337: update ia_request_details
338: set status = IA_WF_UTIL_PKG.LineStatusPending
339: ,last_update_date = SYSDATE
340: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
341: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)

Line 1590: update ia_request_details

1586: * since Super user can intervene the process by changing the line-level detail status.
1587: * As per a discussion with project team on Feb 19, 2004, we will have Super user see
1588: * the requests with status PENDING, POST, ON_REVIEW, or ON_HOLD on the SuperUser page.
1589: */
1590: update ia_request_details
1591: set status = p_status
1592: ,last_update_date = SYSDATE
1593: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1594: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)