DBA Data[Home] [Help]

APPS.FA_DISTRIBUTION_PVT dependencies on FA_API_TYPES

Line 5: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

1: PACKAGE BODY FA_DISTRIBUTION_PVT AS
2: /* $Header: FAVDISTB.pls 120.24.12010000.3 2009/01/22 13:10:07 bridgway ship $ */
3:
4: FUNCTION do_distribution(
5: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
8: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

2: /* $Header: FAVDISTB.pls 120.24.12010000.3 2009/01/22 13:10:07 bridgway ship $ */
3:
4: FUNCTION do_distribution(
5: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
8: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

Line 7: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

3:
4: FUNCTION do_distribution(
5: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
8: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
11:

Line 8: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,

4: FUNCTION do_distribution(
5: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
8: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
11:
12: l_trans_rec FA_API_TYPES.trans_rec_type;

Line 10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
8: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
11:
12: l_trans_rec FA_API_TYPES.trans_rec_type;
13: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
14:

Line 12: l_trans_rec FA_API_TYPES.trans_rec_type;

8: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
11:
12: l_trans_rec FA_API_TYPES.trans_rec_type;
13: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
14:
15: l_asset_type_rec_old FA_API_TYPES.asset_type_rec_type;
16: l_asset_cat_rec_old FA_API_TYPES.asset_cat_rec_type;

Line 13: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
11:
12: l_trans_rec FA_API_TYPES.trans_rec_type;
13: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
14:
15: l_asset_type_rec_old FA_API_TYPES.asset_type_rec_type;
16: l_asset_cat_rec_old FA_API_TYPES.asset_cat_rec_type;
17: l_asset_desc_rec_new FA_API_TYPES.asset_desc_rec_type;

Line 15: l_asset_type_rec_old FA_API_TYPES.asset_type_rec_type;

11:
12: l_trans_rec FA_API_TYPES.trans_rec_type;
13: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
14:
15: l_asset_type_rec_old FA_API_TYPES.asset_type_rec_type;
16: l_asset_cat_rec_old FA_API_TYPES.asset_cat_rec_type;
17: l_asset_desc_rec_new FA_API_TYPES.asset_desc_rec_type;
18: l_period_rec FA_API_TYPES.period_rec_type;
19: l_src_trans_rec FA_API_TYPES.trans_rec_type;

Line 16: l_asset_cat_rec_old FA_API_TYPES.asset_cat_rec_type;

12: l_trans_rec FA_API_TYPES.trans_rec_type;
13: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
14:
15: l_asset_type_rec_old FA_API_TYPES.asset_type_rec_type;
16: l_asset_cat_rec_old FA_API_TYPES.asset_cat_rec_type;
17: l_asset_desc_rec_new FA_API_TYPES.asset_desc_rec_type;
18: l_period_rec FA_API_TYPES.period_rec_type;
19: l_src_trans_rec FA_API_TYPES.trans_rec_type;
20: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 17: l_asset_desc_rec_new FA_API_TYPES.asset_desc_rec_type;

13: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
14:
15: l_asset_type_rec_old FA_API_TYPES.asset_type_rec_type;
16: l_asset_cat_rec_old FA_API_TYPES.asset_cat_rec_type;
17: l_asset_desc_rec_new FA_API_TYPES.asset_desc_rec_type;
18: l_period_rec FA_API_TYPES.period_rec_type;
19: l_src_trans_rec FA_API_TYPES.trans_rec_type;
20: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
21: l_dest_trans_rec FA_API_TYPES.trans_rec_type;

Line 18: l_period_rec FA_API_TYPES.period_rec_type;

14:
15: l_asset_type_rec_old FA_API_TYPES.asset_type_rec_type;
16: l_asset_cat_rec_old FA_API_TYPES.asset_cat_rec_type;
17: l_asset_desc_rec_new FA_API_TYPES.asset_desc_rec_type;
18: l_period_rec FA_API_TYPES.period_rec_type;
19: l_src_trans_rec FA_API_TYPES.trans_rec_type;
20: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
21: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
22: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 19: l_src_trans_rec FA_API_TYPES.trans_rec_type;

15: l_asset_type_rec_old FA_API_TYPES.asset_type_rec_type;
16: l_asset_cat_rec_old FA_API_TYPES.asset_cat_rec_type;
17: l_asset_desc_rec_new FA_API_TYPES.asset_desc_rec_type;
18: l_period_rec FA_API_TYPES.period_rec_type;
19: l_src_trans_rec FA_API_TYPES.trans_rec_type;
20: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
21: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
22: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
23:

Line 20: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

16: l_asset_cat_rec_old FA_API_TYPES.asset_cat_rec_type;
17: l_asset_desc_rec_new FA_API_TYPES.asset_desc_rec_type;
18: l_period_rec FA_API_TYPES.period_rec_type;
19: l_src_trans_rec FA_API_TYPES.trans_rec_type;
20: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
21: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
22: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
23:
24: l_txn_date_entered date;

Line 21: l_dest_trans_rec FA_API_TYPES.trans_rec_type;

17: l_asset_desc_rec_new FA_API_TYPES.asset_desc_rec_type;
18: l_period_rec FA_API_TYPES.period_rec_type;
19: l_src_trans_rec FA_API_TYPES.trans_rec_type;
20: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
21: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
22: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
23:
24: l_txn_date_entered date;
25: l_cal_period_close_date date;

Line 22: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

18: l_period_rec FA_API_TYPES.period_rec_type;
19: l_src_trans_rec FA_API_TYPES.trans_rec_type;
20: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
21: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
22: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
23:
24: l_txn_date_entered date;
25: l_cal_period_close_date date;
26: l_current_pc number;

Line 347: FUNCTION do_validation(p_trans_rec IN FA_API_TYPES.trans_rec_type,

343:
344: END do_distribution;
345:
346:
347: FUNCTION do_validation(p_trans_rec IN FA_API_TYPES.trans_rec_type,
348: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
349: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
350: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
351: p_old_units IN NUMBER,

Line 348: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

344: END do_distribution;
345:
346:
347: FUNCTION do_validation(p_trans_rec IN FA_API_TYPES.trans_rec_type,
348: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
349: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
350: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
351: p_old_units IN NUMBER,
352: x_total_txn_units OUT NOCOPY NUMBER,

Line 349: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,

345:
346:
347: FUNCTION do_validation(p_trans_rec IN FA_API_TYPES.trans_rec_type,
348: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
349: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
350: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
351: p_old_units IN NUMBER,
352: x_total_txn_units OUT NOCOPY NUMBER,
353: p_validation_level IN NUMBER,

Line 350: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,

346:
347: FUNCTION do_validation(p_trans_rec IN FA_API_TYPES.trans_rec_type,
348: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
349: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
350: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
351: p_old_units IN NUMBER,
352: x_total_txn_units OUT NOCOPY NUMBER,
353: p_validation_level IN NUMBER,
354: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is

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

350: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
351: p_old_units IN NUMBER,
352: x_total_txn_units OUT NOCOPY NUMBER,
353: p_validation_level IN NUMBER,
354: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is
355:
356: l_tot_txn number := 0; --total txn units
357: l_prev_txn number := 0;
358: l_count number;

Line 373: l_asset_type_rec_old fa_api_types.asset_type_rec_type;

369: -- l_match_units is used to make sure source and destination units
370: -- match, for transfer and reclass txn
371: l_match_unit number := 0;
372:
373: l_asset_type_rec_old fa_api_types.asset_type_rec_type;
374: l_group_asset_id number;
375:
376: cursor DH_C1 is
377: select distribution_id,

Line 672: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,

668:
669: END do_validation;
670:
671:
672: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
673: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
674: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
675: p_curr_index IN NUMBER,
676: p_validation_level IN NUMBER,

Line 673: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

669: END do_validation;
670:
671:
672: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
673: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
674: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
675: p_curr_index IN NUMBER,
676: p_validation_level IN NUMBER,
677: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

Line 674: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,

670:
671:
672: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
673: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
674: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
675: p_curr_index IN NUMBER,
676: p_validation_level IN NUMBER,
677: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
678:

Line 677: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

673: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
674: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
675: p_curr_index IN NUMBER,
676: p_validation_level IN NUMBER,
677: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
678:
679: RETURN BOOLEAN IS
680:
681:

Line 772: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

768:
769: END valid_dist_data;
770:
771:
772: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
773: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
774:
775: RETURN BOOLEAN IS
776:

Line 773: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

769: END valid_dist_data;
770:
771:
772: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
773: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
774:
775: RETURN BOOLEAN IS
776:
777: l_ad_units number;

Line 823: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

819: END units_in_sync;
820:
821:
822:
823: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
824: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
825: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
826: RETURN BOOLEAN IS
827:

Line 824: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

820:
821:
822:
823: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
824: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
825: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
826: RETURN BOOLEAN IS
827:
828: l_transaction_type_code px_trans_rec.transaction_type_code%TYPE;

Line 825: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

821:
822:
823: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
824: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
825: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
826: RETURN BOOLEAN IS
827:
828: l_transaction_type_code px_trans_rec.transaction_type_code%TYPE;
829: l_transaction_subtype px_trans_rec.transaction_subtype%TYPE;

Line 901: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,

897: END insert_txn_headers;
898:
899:
900:
901: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
902: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
903: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
904: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
905: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

Line 902: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

898:
899:
900:
901: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
902: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
903: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
904: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
905: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
906:

Line 903: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,

899:
900:
901: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
902: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
903: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
904: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
905: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
906:
907: RETURN BOOLEAN IS

Line 904: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,

900:
901: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
902: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
903: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
904: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
905: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
906:
907: RETURN BOOLEAN IS
908:

Line 905: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

901: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
902: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
903: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
904: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
905: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
906:
907: RETURN BOOLEAN IS
908:
909: CURSOR ah_cur (l_asset_id in NUMBER) IS

Line 1032: FUNCTION update_additions(p_trans_rec IN FA_API_TYPES.trans_rec_type,

1028:
1029: END update_asset_history;
1030:
1031:
1032: FUNCTION update_additions(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1033: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1034: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
1035: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
1036: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

Line 1033: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

1029: END update_asset_history;
1030:
1031:
1032: FUNCTION update_additions(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1033: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1034: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
1035: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
1036: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1037: RETURN BOOLEAN IS

Line 1034: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,

1030:
1031:
1032: FUNCTION update_additions(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1033: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1034: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
1035: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
1036: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1037: RETURN BOOLEAN IS
1038:

Line 1035: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,

1031:
1032: FUNCTION update_additions(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1033: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1034: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
1035: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
1036: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1037: RETURN BOOLEAN IS
1038:
1039: BEGIN

Line 1036: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1032: FUNCTION update_additions(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1033: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1034: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
1035: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
1036: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1037: RETURN BOOLEAN IS
1038:
1039: BEGIN
1040: if (p_trans_rec.transaction_type_code in ('UNIT ADJUSTMENT','TRANSFER OUT')) then

Line 1117: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,

1113:
1114: END update_additions;
1115:
1116:
1117: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1118: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1119: p_period_rec IN FA_API_TYPES.period_rec_type,
1120: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1121: RETURN BOOLEAN IS

Line 1118: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

1114: END update_additions;
1115:
1116:
1117: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1118: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1119: p_period_rec IN FA_API_TYPES.period_rec_type,
1120: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1121: RETURN BOOLEAN IS
1122:

Line 1119: p_period_rec IN FA_API_TYPES.period_rec_type,

1115:
1116:
1117: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1118: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1119: p_period_rec IN FA_API_TYPES.period_rec_type,
1120: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1121: RETURN BOOLEAN IS
1122:
1123: l_cal_period_close_date DATE;

Line 1120: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1116:
1117: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1118: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1119: p_period_rec IN FA_API_TYPES.period_rec_type,
1120: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1121: RETURN BOOLEAN IS
1122:
1123: l_cal_period_close_date DATE;
1124: l_tax_cal_period_close_date DATE;

Line 1173: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,

1169: return FALSE;
1170:
1171: END update_books;
1172:
1173: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1174: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1175: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
1176: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1177: RETURN BOOLEAN IS

Line 1174: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

1170:
1171: END update_books;
1172:
1173: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1174: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1175: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
1176: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1177: RETURN BOOLEAN IS
1178:

Line 1175: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,

1171: END update_books;
1172:
1173: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1174: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1175: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
1176: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1177: RETURN BOOLEAN IS
1178:
1179: CURSOR dh_cur (l_asset_id IN NUMBER, l_distribution_id IN NUMBER) IS

Line 1176: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1172:
1173: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
1174: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1175: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
1176: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1177: RETURN BOOLEAN IS
1178:
1179: CURSOR dh_cur (l_asset_id IN NUMBER, l_distribution_id IN NUMBER) IS
1180: select dh.rowid row_id, dh.*