APPS.FA_LOAD_TBL_PKG dependencies on FA_API_TYPES

Line 22: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

18: p_th_id_in number,
19: p_assigned_to number,
20: p_trans_units number,
21: p_record_status varchar2,
22: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
23: IS
24: BEGIN
25: if (g_dist_count=0) then /* initialize the table */
26: dist_table.delete;

Line 91: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

87: p_attribute_cat_code varchar2 default null,
88: p_invoice_distribution_id number default null,
89: p_invoice_line_number number default null,
90: p_po_distribution_id number default null,
91: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
92: IS
93: BEGIN
94: if (g_inv_count=0) then /* initialize inv_line_tbl */
95: inv_table.delete;

Line 196: FUNCTION reset_g_dist_count(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

192: END load_inv_table;
193:
194:
195: -- function to reset g_dist_count
196: FUNCTION reset_g_dist_count(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
197: RETURN BOOLEAN
198: IS
199: BEGIN
200: g_dist_count := 0;

Line 216: PROCEDURE reset_g_inv_count(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

212: END;
213:
214:
215: -- procedure to reset g_inv_count
216: PROCEDURE reset_g_inv_count(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
217: IS
218: BEGIN
219: g_inv_count := 0;
220:

Line 235: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

231: PROCEDURE Load_Deprn_Rules_Tbl(
232: p_corp_book VARCHAR2,
233: p_category_id NUMBER,
234: x_return_status OUT NOCOPY BOOLEAN,
235: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
236: CURSOR BOOK_CR IS
237: SELECT bc.book_type_code
238: FROM fa_category_books cb, fa_book_controls bc
239: WHERE p_corp_book =

Line 308: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

304: p_book_type_code VARCHAR2,
305: p_date_placed_in_service DATE,
306: x_deprn_rules_rec OUT NOCOPY asset_deprn_info,
307: x_found OUT NOCOPY BOOLEAN,
308: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
309: found BOOLEAN := FALSE;
310: BEGIN
311: FOR i IN deprn_table.FIRST .. deprn_table.LAST LOOP
312: if deprn_table.exists(i) then

Line 343: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

339: PROCEDURE Find_Position_Deprn_Rules(
340: p_book_type_code VARCHAR2,
341: p_date_placed_in_service DATE,
342: x_pos OUT NOCOPY NUMBER,
343: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
344: BEGIN
345: x_pos := NULL;
346: FOR i IN deprn_table.FIRST .. deprn_table.LAST LOOP
347: IF deprn_table.exists(i) THEN