DBA Data[Home] [Help]

APPS.FA_RECLASS_PVT dependencies on FA_API_TYPES

Line 19: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

15: * px_asset_desc_rec.asset_number
16: * pxx_asset_cat_rec_new.category_id
17: * ---------------------------------------------------------------- */
18: FUNCTION do_reclass (
19: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
21: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
23: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 20: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,

16: * pxx_asset_cat_rec_new.category_id
17: * ---------------------------------------------------------------- */
18: FUNCTION do_reclass (
19: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
21: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
23: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 21: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

17: * ---------------------------------------------------------------- */
18: FUNCTION do_reclass (
19: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
21: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
23: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
25: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,

Line 22: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,

18: FUNCTION do_reclass (
19: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
21: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
23: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
25: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
26: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

Line 23: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

19: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
21: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
23: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
25: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
26: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
27: return boolean IS

Line 24: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

20: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
21: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
23: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
25: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
26: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
27: return boolean IS
28:

Line 25: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,

21: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
23: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
25: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
26: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
27: return boolean IS
28:
29: l_err_stage varchar2(230);

Line 26: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

22: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
23: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
25: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
26: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
27: return boolean IS
28:
29: l_err_stage varchar2(230);
30: i integer:= 1;

Line 31: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

27: return boolean IS
28:
29: l_err_stage varchar2(230);
30: i integer:= 1;
31: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
32: l_trans_rec FA_API_TYPES.trans_rec_type;
33:
34: l_calling_fn varchar2(40) := 'fa_reclass_pvt.do_reclass';
35: call_err EXCEPTION;

Line 32: l_trans_rec FA_API_TYPES.trans_rec_type;

28:
29: l_err_stage varchar2(230);
30: i integer:= 1;
31: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
32: l_trans_rec FA_API_TYPES.trans_rec_type;
33:
34: l_calling_fn varchar2(40) := 'fa_reclass_pvt.do_reclass';
35: call_err EXCEPTION;
36:

Line 223: p_trans_rec IN FA_API_TYPES.trans_rec_type,

219: -- ------------------------------------------------------
220:
221: -- ------------------------------------------------------
222: FUNCTION validate_reclass (
223: p_trans_rec IN FA_API_TYPES.trans_rec_type,
224: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
225: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
227: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,

Line 224: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

220:
221: -- ------------------------------------------------------
222: FUNCTION validate_reclass (
223: p_trans_rec IN FA_API_TYPES.trans_rec_type,
224: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
225: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
227: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
228: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,

Line 225: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

221: -- ------------------------------------------------------
222: FUNCTION validate_reclass (
223: p_trans_rec IN FA_API_TYPES.trans_rec_type,
224: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
225: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
227: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
228: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
229: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is

Line 226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

222: FUNCTION validate_reclass (
223: p_trans_rec IN FA_API_TYPES.trans_rec_type,
224: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
225: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
227: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
228: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
229: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is
230:

Line 227: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,

223: p_trans_rec IN FA_API_TYPES.trans_rec_type,
224: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
225: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
227: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
228: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
229: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is
230:
231: l_err_stage varchar2(100);

Line 228: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,

224: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
225: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
227: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
228: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
229: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is
230:
231: l_err_stage varchar2(100);
232: l_calling_fn varchar2(40) := 'fa_reclass_pvt.validate_reclass';

Line 229: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is

225: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
227: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
228: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
229: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is
230:
231: l_err_stage varchar2(100);
232: l_calling_fn varchar2(40) := 'fa_reclass_pvt.validate_reclass';
233: call_err EXCEPTION;

Line 337: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

333:
334: -- ----------------------------------------------------
335:
336: FUNCTION validate_redefault(
337: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
338: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
339: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
340: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
341: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 338: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,

334: -- ----------------------------------------------------
335:
336: FUNCTION validate_redefault(
337: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
338: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
339: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
340: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
341: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
342: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 339: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

335:
336: FUNCTION validate_redefault(
337: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
338: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
339: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
340: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
341: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
342: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
343: p_mass_request_id IN NUMBER DEFAULT null,

Line 340: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,

336: FUNCTION validate_redefault(
337: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
338: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
339: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
340: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
341: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
342: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
343: p_mass_request_id IN NUMBER DEFAULT null,
344: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

Line 341: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

337: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
338: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
339: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
340: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
341: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
342: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
343: p_mass_request_id IN NUMBER DEFAULT null,
344: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
345:

Line 342: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

338: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
339: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
340: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
341: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
342: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
343: p_mass_request_id IN NUMBER DEFAULT null,
344: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
345:
346:

Line 344: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

340: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
341: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
342: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
343: p_mass_request_id IN NUMBER DEFAULT null,
344: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
345:
346:
347: BEGIN
348: null;

Line 361: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

357: *
358: *
359: * ---------------------------------------------------------------------- */
360: FUNCTION do_redefault(
361: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
362: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
363: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
364: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
365: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 362: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,

358: *
359: * ---------------------------------------------------------------------- */
360: FUNCTION do_redefault(
361: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
362: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
363: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
364: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
365: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
366: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 363: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

359: * ---------------------------------------------------------------------- */
360: FUNCTION do_redefault(
361: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
362: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
363: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
364: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
365: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
366: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
367: p_mass_request_id IN NUMBER DEFAULT null,

Line 364: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,

360: FUNCTION do_redefault(
361: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
362: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
363: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
364: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
365: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
366: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
367: p_mass_request_id IN NUMBER DEFAULT null,
368: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

Line 365: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

361: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
362: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
363: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
364: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
365: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
366: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
367: p_mass_request_id IN NUMBER DEFAULT null,
368: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
369:

Line 366: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

362: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
363: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
364: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
365: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
366: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
367: p_mass_request_id IN NUMBER DEFAULT null,
368: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
369:
370: CURSOR book_cr( p_asset_id number ) IS

Line 368: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

364: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
365: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
366: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
367: p_mass_request_id IN NUMBER DEFAULT null,
368: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
369:
370: CURSOR book_cr( p_asset_id number ) IS
371: SELECT TH.book_type_code
372: FROM FA_BOOK_CONTROLS BC,

Line 410: l_trans_rec FA_API_TYPES.trans_rec_type;

406: l_rate_source_rules VARCHAR2(10);
407: l_deprn_basis_rule VARCHAR2(10);
408: l_prorate_date date;
409:
410: l_trans_rec FA_API_TYPES.trans_rec_type;
411: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
412: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
413: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
414: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 411: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

407: l_deprn_basis_rule VARCHAR2(10);
408: l_prorate_date date;
409:
410: l_trans_rec FA_API_TYPES.trans_rec_type;
411: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
412: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
413: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
414: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
415: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 412: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

408: l_prorate_date date;
409:
410: l_trans_rec FA_API_TYPES.trans_rec_type;
411: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
412: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
413: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
414: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
415: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
416: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

Line 413: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

409:
410: l_trans_rec FA_API_TYPES.trans_rec_type;
411: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
412: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
413: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
414: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
415: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
416: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
417: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

Line 414: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

410: l_trans_rec FA_API_TYPES.trans_rec_type;
411: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
412: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
413: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
414: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
415: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
416: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
417: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
418: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 415: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

411: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
412: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
413: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
414: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
415: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
416: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
417: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
418: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
419: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 416: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

412: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
413: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
414: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
415: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
416: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
417: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
418: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
419: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
420: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 417: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

413: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
414: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
415: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
416: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
417: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
418: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
419: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
420: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
421: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 418: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

414: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
415: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
416: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
417: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
418: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
419: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
420: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
421: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
422:

Line 419: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

415: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
416: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
417: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
418: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
419: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
420: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
421: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
422:
423: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

Line 420: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

416: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
417: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
418: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
419: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
420: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
421: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
422:
423: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
424: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 421: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

417: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
418: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
419: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
420: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
421: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
422:
423: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
424: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
425: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;

Line 423: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

419: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
420: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
421: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
422:
423: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
424: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
425: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
426: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
427: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 424: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

420: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
421: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
422:
423: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
424: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
425: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
426: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
427: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
428:

Line 425: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;

421: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
422:
423: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
424: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
425: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
426: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
427: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
428:
429: l_return_status VARCHAR2(1);

Line 426: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;

422:
423: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
424: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
425: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
426: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
427: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
428:
429: l_return_status VARCHAR2(1);
430: l_mesg_count NUMBER;

Line 427: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;

423: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
424: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
425: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
426: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
427: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
428:
429: l_return_status VARCHAR2(1);
430: l_mesg_count NUMBER;
431: l_mesg_data VARCHAR2(2000);

Line 763: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

759: END do_redefault;
760:
761:
762: FUNCTION populate_adjust_info (
763: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
764: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
765: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
766: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
767: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 764: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

760:
761:
762: FUNCTION populate_adjust_info (
763: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
764: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
765: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
766: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
767: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
768: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 765: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,

761:
762: FUNCTION populate_adjust_info (
763: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
764: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
765: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
766: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
767: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
768: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
769: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 766: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,

762: FUNCTION populate_adjust_info (
763: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
764: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
765: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
766: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
767: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
768: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
769: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
770: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

Line 767: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

763: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
764: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
765: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
766: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
767: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
768: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
769: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
770: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
771: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

Line 768: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

764: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
765: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
766: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
767: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
768: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
769: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
770: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
771: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
772: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,

Line 769: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

765: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
766: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
767: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
768: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
769: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
770: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
771: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
772: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
773: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,

Line 770: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

766: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
767: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
768: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
769: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
770: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
771: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
772: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
773: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
774: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

Line 771: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

767: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
768: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
769: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
770: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
771: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
772: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
773: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
774: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
775:

Line 774: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

770: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
771: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
772: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
773: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
774: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
775:
776: CURSOR get_prorate_date(p_dpis date) IS
777: SELECT conv.prorate_date
778: FROM FA_CONVENTIONS conv