128: gl_code_combinations gc,
129: fa_additions ad,
130: fa_books bk,
131: fa_book_controls bc,
132: fa_maint_schedule_hdr msh
133: where msh.schedule_id = h_schedule_id
134: and bc.book_type_code = msh.book_type_code
135: and bc.book_class = 'CORPORATE'
136: and bk.book_type_code = msh.book_type_code
158:
159: cursor date_cursor is
160: SELECT start_date,end_date,book_type_code
161:
162: FROM fa_maint_schedule_hdr
163: WHERE schedule_id = h_schedule_id;
164:
165: BEGIN
166:
273: END LOOP;
274:
275: close assets_to_schedule;
276:
277: update fa_maint_schedule_hdr
278: set status = 'COMPLETED'
279: where schedule_id = h_schedule_id;
280: commit;
281:
345: fa_rx_conc_mesg_pkg.out(h_mesg_str);
346:
347: rollback to savepoint asset_maint;
348: if (p_sch_id is not NULL) then
349: update fa_maint_schedule_hdr
350: set status = 'FAILED_RUN'
351: where schedule_id = p_sch_id;
352: commit;
353: end if;