APPS.IA_POST_REQUEST_PKG dependencies on IA_REQUEST_HEADERS

Line 44: from ia_request_headers irh,

40: ird.effective_date,
41: irh.status,
42: ird.status,
43: ad.asset_number
44: from ia_request_headers irh,
45: ia_request_details ird,
46: fa_book_controls bc,
47: fa_additions ad,
48: fa_deprn_periods dp

Line 331: update ia_request_headers

327:
328: if (l_request_id(i) <> prev_req_id) then
329:
330: if (error_occured) then
331: update ia_request_headers
332: set status = 'COMPLETED_ERROR'
333: where request_id = prev_req_id;
334:
335: elsif (prev_status = 'PARTIAL_POST') then

Line 339: update ia_request_headers

335: elsif (prev_status = 'PARTIAL_POST') then
336: null; -- remain the same
337:
338: else
339: update ia_request_headers
340: set status = 'COMPLETED'
341: where request_id = prev_req_id;
342: end if;
343:

Line 357: update ia_request_headers

353:
354: if (prev_req_id <> 0) then
355:
356: if (error_occured) then
357: update ia_request_headers
358: set status = 'COMPLETED_ERROR'
359: where request_id = prev_req_id;
360:
361: elsif (prev_status = 'PARTIAL_POST') then

Line 365: update ia_request_headers

361: elsif (prev_status = 'PARTIAL_POST') then
362: null; -- remain the same
363:
364: else
365: update ia_request_headers
366: set status = 'COMPLETED'
367: where request_id = prev_req_id;
368: end if;
369: end if;