APPS.FA_BOOKS_SUMMARY_PKG dependencies on FA_MC_BOOKS_SUMMARY

Line 118: FROM fa_mc_books_summary

114: AND book_type_code = X_Book_Type_Code
115: AND period_counter = X_Period_Counter;
116:
117: CURSOR C_bs_mc IS SELECT rowid
118: FROM fa_mc_books_summary
119: WHERE asset_id = X_Asset_ID
120: AND book_type_code = X_Book_Type_Code
121: AND period_counter = X_Period_Counter
122: AND set_of_books_id = X_set_of_books_id;

Line 127: INSERT INTO fa_mc_books_summary(

123:
124: BEGIN
125:
126: if (X_mrc_sob_type_code = 'R') then
127: INSERT INTO fa_mc_books_summary(
128: set_of_books_id,
129: book_type_code,
130: asset_id,
131: period_counter,

Line 904: UPDATE fa_mc_books_summary

900: BEGIN
901:
902: if (X_mrc_sob_type_code = 'R') then
903: if X_Rowid is not null then
904: UPDATE fa_mc_books_summary
905: SET
906: book_type_code = decode(X_Book_Type_Code,
907: NULL, book_type_code,
908: FND_API.G_MISS_CHAR, NULL,

Line 1735: DELETE FROM fa_mc_books_summary

1731: BEGIN
1732:
1733: if (X_mrc_sob_type_code = 'R') then
1734: if (X_Rowid is not null) then
1735: DELETE FROM fa_mc_books_summary
1736: WHERE rowid = X_Rowid;
1737: elsif ((X_Asset_ID is not null) AND
1738: (X_Book_Type_Code is not null) AND
1739: (X_Period_Counter is not null)) then

Line 1740: DELETE FROM fa_mc_books_summary

1736: WHERE rowid = X_Rowid;
1737: elsif ((X_Asset_ID is not null) AND
1738: (X_Book_Type_Code is not null) AND
1739: (X_Period_Counter is not null)) then
1740: DELETE FROM fa_mc_books_summary
1741: WHERE asset_id = X_Asset_ID
1742: AND book_type_code = X_Book_Type_Code
1743: AND period_counter = X_Period_Counter
1744: AND set_of_books_id = X_set_of_books_id;

Line 1746: DELETE FROM fa_mc_books_summary

1742: AND book_type_code = X_Book_Type_Code
1743: AND period_counter = X_Period_Counter
1744: AND set_of_books_id = X_set_of_books_id;
1745: elsif (X_Asset_Id is not null) then
1746: DELETE FROM fa_mc_books_summary
1747: WHERE asset_id = X_Asset_Id
1748: AND set_of_books_id = X_set_of_books_id;
1749: else
1750: -- print some error message