DBA Data[Home] [Help]

APPS.FA_RECLASS_PVT dependencies on FA_API_TYPES

Line 18: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

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

Line 19: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,

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

Line 20: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

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

Line 21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,

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

Line 22: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

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

Line 23: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

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

Line 24: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

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

Line 29: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

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

Line 30: l_trans_rec FA_API_TYPES.trans_rec_type;

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

Line 213: p_trans_rec IN FA_API_TYPES.trans_rec_type,

209: -- ------------------------------------------------------
210:
211: -- ------------------------------------------------------
212: FUNCTION validate_reclass (
213: p_trans_rec IN FA_API_TYPES.trans_rec_type,
214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,

Line 214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

210:
211: -- ------------------------------------------------------
212: FUNCTION validate_reclass (
213: p_trans_rec IN FA_API_TYPES.trans_rec_type,
214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
218: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is

Line 215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

211: -- ------------------------------------------------------
212: FUNCTION validate_reclass (
213: p_trans_rec IN FA_API_TYPES.trans_rec_type,
214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
218: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
219:

Line 216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

212: FUNCTION validate_reclass (
213: p_trans_rec IN FA_API_TYPES.trans_rec_type,
214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
218: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
219:
220: l_err_stage varchar2(100);

Line 217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,

213: p_trans_rec IN FA_API_TYPES.trans_rec_type,
214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
218: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
219:
220: l_err_stage varchar2(100);
221: l_calling_fn varchar2(40) := 'fa_reclass_pvt.validate_reclass';

Line 218: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is

214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
218: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
219:
220: l_err_stage varchar2(100);
221: l_calling_fn varchar2(40) := 'fa_reclass_pvt.validate_reclass';
222: call_err EXCEPTION;

Line 317: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

313:
314: -- ----------------------------------------------------
315:
316: FUNCTION validate_redefault(
317: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,

314: -- ----------------------------------------------------
315:
316: FUNCTION validate_redefault(
317: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

315:
316: FUNCTION validate_redefault(
317: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
323: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

Line 320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,

316: FUNCTION validate_redefault(
317: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
323: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
324:

Line 321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

317: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
323: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
324:
325:

Line 322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
323: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
324:
325:
326: BEGIN

Line 323: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
323: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
324:
325:
326: BEGIN
327: null;

Line 340: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

336: *
337: *
338: * ---------------------------------------------------------------------- */
339: FUNCTION do_redefault(
340: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
341: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 341: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,

337: *
338: * ---------------------------------------------------------------------- */
339: FUNCTION do_redefault(
340: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
341: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
345: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

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

Line 343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,

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

Line 344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

340: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
341: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
345: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
346: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
347:
348: CURSOR book_cr( p_asset_id number ) IS

Line 345: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

341: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
345: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
346: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
347:
348: CURSOR book_cr( p_asset_id number ) IS
349: SELECT TH.book_type_code

Line 346: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
345: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
346: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
347:
348: CURSOR book_cr( p_asset_id number ) IS
349: SELECT TH.book_type_code
350: FROM FA_BOOK_CONTROLS BC,

Line 388: l_trans_rec FA_API_TYPES.trans_rec_type;

384: l_rate_source_rules VARCHAR2(10);
385: l_deprn_basis_rule VARCHAR2(10);
386: l_prorate_date date;
387:
388: l_trans_rec FA_API_TYPES.trans_rec_type;
389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

385: l_deprn_basis_rule VARCHAR2(10);
386: l_prorate_date date;
387:
388: l_trans_rec FA_API_TYPES.trans_rec_type;
389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

386: l_prorate_date date;
387:
388: l_trans_rec FA_API_TYPES.trans_rec_type;
389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

Line 391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

387:
388: l_trans_rec FA_API_TYPES.trans_rec_type;
389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

Line 392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

388: l_trans_rec FA_API_TYPES.trans_rec_type;
389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:

Line 397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

Line 398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;

Line 401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
404: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
405: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
404: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
405: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
406:

Line 403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;

399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
404: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
405: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
406:
407: l_return_status VARCHAR2(1);

Line 404: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;

400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
404: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
405: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
406:
407: l_return_status VARCHAR2(1);
408: l_mesg_count NUMBER;

Line 405: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;

401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
404: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
405: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
406:
407: l_return_status VARCHAR2(1);
408: l_mesg_count NUMBER;
409: l_mesg_data VARCHAR2(2000);

Line 704: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

700: END do_redefault;
701:
702:
703: FUNCTION populate_adjust_info (
704: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

Line 705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

701:
702:
703: FUNCTION populate_adjust_info (
704: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,

702:
703: FUNCTION populate_adjust_info (
704: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,

703: FUNCTION populate_adjust_info (
704: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

Line 708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

704: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

Line 709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
713: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,

Line 710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
713: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
714: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info

Line 711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
713: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
714: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info
715: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

Line 712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
713: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
714: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info
715: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
716:

Line 715: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
713: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
714: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info
715: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
716:
717: CURSOR get_prorate_date(p_dpis date) IS
718: SELECT conv.prorate_date
719: FROM FA_CONVENTIONS conv

Line 727: l_period_rec FA_API_TYPES.period_rec_type;

723: l_use_deprn_limits_flag VARCHAR2(3) := 'NO';
724: l_prorate_date date;
725: l_status boolean;
726: l_fiscal_year_name varchar2(30);
727: l_period_rec FA_API_TYPES.period_rec_type;
728:
729: l_calling_fn varchar2(40) := 'fa_reclass_pvt.populate_adjust_info';
730: call_err EXCEPTION;
731: BEGIN