99: );
100:
101: -- BUG# 1913745 - implementing arrays to recuce db hits
102:
103: TYPE fazcbc_type_tab is table of FA_BOOK_CONTROLS%RowType
104: index by binary_integer;
105: TYPE fazcct_type_tab is table of FA_CALENDAR_TYPES%RowType
106: index by binary_integer;
107: TYPE fazcff_type_tab is table of fazcff_type
147: TYPE fazcsgr_type_tab is table of fazcsgr_rec_type
148: index by binary_integer;
149:
150: -- fazcbc variables
151: fazcbc_record FA_BOOK_CONTROLS%RowType;
152: fazcbc_table fazcbc_type_tab;
153: fazcbc_index number; -- used to store the index of last
154: -- book's position in array. will
155: -- be used to delete a member when
155: -- be used to delete a member when
156: -- transaction approval finds it stale
157:
158: -- fazcbcs variables
159: fazcbcs_record FA_BOOK_CONTROLS%RowType;
160: fazcbcs_table fazcbc_type_tab;
161: fazcbcs_index number; -- used to store the index of last
162: -- book's position in array. will
163: -- be used to delete a member when
318: * Name
319: * fazcbc
320: *
321: * Description
322: * Cache FA_BOOK_CONTROLS information
323: *
324: * Parameters
325: * X_book - book type code to get information about
326: *
352: * Name
353: * fazcbcs
354: *
355: * Description
356: * Cache FA_BOOK_CONTROLS by SOB information
357: *
358: * Parameters
359: * X_book - book type code to get information about
360: *
395: * Name
396: * fazcbc_clr
397: *
398: * Description
399: * Cache FA_BOOK_CONTROLS clear row function
400: *
401: * Parameters
402: * X_book - book type code to get information about
403: * not currently used (always deletes lat used row)