APPS.IA_WF_REQUEST_PKG dependencies on IA_REQUEST_HEADERS

Line 115: debugInfo := 'Retrieve book type code from IA_REQUEST_HEADERS';

111: IA_WF_UTIL_PKG.InitializeDebugMessage;
112:
113:
114: -----------------------------------------------------
115: debugInfo := 'Retrieve book type code from IA_REQUEST_HEADERS';
116: -----------------------------------------------------
117: begin
118:
119: select book_type_code

Line 137: from ia_request_headers

133: ,l_purpose
134: ,l_status
135: ,l_releasing_approver_id
136: ,l_receiving_approver_id
137: from ia_request_headers
138: where request_id=p_request_id;
139:
140: exception
141: when others then

Line 330: update ia_request_headers

326:
327: -----------------------------------------------------
328: debugInfo := 'Set the current request status to Pending';
329: -----------------------------------------------------
330: update ia_request_headers
331: set status = IA_WF_UTIL_PKG.HeaderStatusPendingApproval
332: ,last_update_date = SYSDATE
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)

Line 1021: from ia_request_headers

1017: begin
1018:
1019: select 1
1020: into l_dummy
1021: from ia_request_headers
1022: where request_id=p_request_id;
1023:
1024: select max(approval_id)
1025: into l_approval_id

Line 1557: update ia_request_headers

1553: -- PRAGMA AUTONOMOUS_TRANSACTION;
1554:
1555: BEGIN
1556:
1557: update ia_request_headers
1558: set status = p_status
1559: ,last_update_date = SYSDATE
1560: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1561: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)