APPS.FA_BOOK_CONTROLS_PKG dependencies on FA_BOOK_CONTROLS_HISTORY

Line 485: insert into fa_book_controls_history (

481: Raise NO_DATA_FOUND;
482: end if;
483: CLOSE C_bc;
484:
485: insert into fa_book_controls_history (
486: book_type_code,
487: date_active,
488: date_inactive,
489: book_type_name,

Line 1134: UPDATE fa_book_controls_history

1130: end if;
1131:
1132: select sysdate into l_sysdate from dual;
1133:
1134: UPDATE fa_book_controls_history
1135: SET date_inactive = l_sysdate
1136: WHERE book_type_code = X_Book_Type_Code
1137: AND date_inactive is null;
1138:

Line 1139: insert into fa_book_controls_history (

1135: SET date_inactive = l_sysdate
1136: WHERE book_type_code = X_Book_Type_Code
1137: AND date_inactive is null;
1138:
1139: insert into fa_book_controls_history (
1140: book_type_code,
1141: date_active,
1142: date_inactive,
1143: book_type_name,

Line 1536: DELETE FROM fa_book_controls_history

1532:
1533: DELETE FROM fa_book_controls
1534: WHERE book_type_code = l_book_type_code;
1535:
1536: DELETE FROM fa_book_controls_history
1537: WHERE book_type_code = l_book_type_code;
1538:
1539: end if;
1540: