APPS.FA_CUA_HR_REINSTATEMENTS_PKG dependencies on FA_HR_RETIREMENT_HEADERS

Line 242: UPDATE fa_hr_retirement_headers

238:
239: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
240: rollback;
241:
242: UPDATE fa_hr_retirement_headers
243: set status_code = 'RF' -- Reinstatement Failed
244: where batch_id = x_batch_num;
245: END IF;
246:

Line 250: update fa_hr_retirement_headers

246:
247: END LOOP; -- qualified_assets
248: CLOSE qualified_assets;
249:
250: update fa_hr_retirement_headers
251: set status_code = 'RC' -- reinstatement completed
252: where batch_id = x_batch_num;
253:
254: update fa_hr_retirement_details

Line 263: UPDATE fa_hr_retirement_headers

259: EXCEPTION -- hr_Reinstate
260: WHEN Others THEN
261: rollback;
262:
263: UPDATE fa_hr_retirement_headers
264: set status_code = 'RF' -- Reinstatement Failed
265: where batch_id = x_batch_num;
266: END Reinstate;
267: --

Line 314: FROM fa_hr_retirement_headers ihrh,

310: , ihrh.TH_attribute12
311: , ihrh.TH_attribute13
312: , ihrh.TH_attribute14
313: , ihrh.TH_attribute15
314: FROM fa_hr_retirement_headers ihrh,
315: fa_book_controls fbc,
316: gl_sets_of_books sob,
317: fa_fiscal_year ffy
318: WHERE ihrh.batch_id >= nvl(x_from_batch_num, ihrh.batch_id )

Line 331: update fa_hr_retirement_headers

327: BEGIN
328:
329: FOR hrh_rec IN hr_reinstatement LOOP
330:
331: update fa_hr_retirement_headers
332: set status_code = 'RP'
333: where batch_id = hrh_rec.batch_id;
334:
335: update fa_hr_retirement_details