DBA Data[Home] [Help]

APPS.FA_MAINTENANCE_PKG dependencies on FA_MAINT_SCHEDULE_HDR

Line 132: fa_maint_schedule_hdr msh

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

Line 162: FROM fa_maint_schedule_hdr

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:

Line 277: update fa_maint_schedule_hdr

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:

Line 349: update fa_maint_schedule_hdr

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;