[Home] [Help]
17: p_location_id number,
18: p_th_id_in number,
19: p_assigned_to number,
20: p_trans_units number,
21: p_record_status varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
22: IS
23: BEGIN
24: if (g_dist_count=0) then /* initialize the table */
25: dist_table.delete;
85: p_attribute12 varchar2 default null,
86: p_attribute13 varchar2 default null,
87: p_attribute14 varchar2 default null,
88: p_attribute15 varchar2 default null,
89: p_attribute_cat_code varchar2 default null, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
90: IS
91: BEGIN
92: if (g_inv_count=0) then /* initialize inv_line_tbl */
93: inv_table.delete;
229: PROCEDURE Load_Deprn_Rules_Tbl(
230: p_corp_book VARCHAR2,
231: p_category_id NUMBER,
232: x_return_status OUT NOCOPY BOOLEAN
233: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
234: CURSOR BOOK_CR IS
235: SELECT bc.book_type_code
236: FROM fa_category_books cb, fa_book_controls bc
237: WHERE p_corp_book =
301: p_book_type_code VARCHAR2,
302: p_date_placed_in_service DATE,
303: x_deprn_rules_rec OUT NOCOPY asset_deprn_info,
304: x_found OUT NOCOPY BOOLEAN
305: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
306: found BOOLEAN := FALSE;
307: BEGIN
308: FOR i IN deprn_table.FIRST .. deprn_table.LAST LOOP
309: if deprn_table.exists(i) then
335: PROCEDURE Find_Position_Deprn_Rules(
336: p_book_type_code VARCHAR2,
337: p_date_placed_in_service DATE,
338: x_pos OUT NOCOPY NUMBER
339: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
340: BEGIN
341: x_pos := NULL;
342: FOR i IN deprn_table.FIRST .. deprn_table.LAST LOOP
343: IF deprn_table.exists(i) THEN