1: PACKAGE FA_DISTRIBUTION_PVT AUTHID CURRENT_USER as
2: /* $Header: FAVDISTS.pls 120.4 2009/03/26 23:51:18 bridgway ship $ */
3:
4:
5: FUNCTION do_distribution(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 :=
2: /* $Header: FAVDISTS.pls 120.4 2009/03/26 23:51:18 bridgway ship $ */
3:
4:
5: FUNCTION do_distribution(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 :=
10: FND_API.G_VALID_LEVEL_FULL, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
3:
4:
5: FUNCTION do_distribution(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 :=
10: FND_API.G_VALID_LEVEL_FULL, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
11: RETURN BOOLEAN;
4:
5: FUNCTION do_distribution(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 :=
10: FND_API.G_VALID_LEVEL_FULL, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
11: RETURN BOOLEAN;
12:
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 :=
10: FND_API.G_VALID_LEVEL_FULL, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
11: RETURN BOOLEAN;
12:
13:
14: FUNCTION do_validation(p_trans_rec IN FA_API_TYPES.trans_rec_type,
10: FND_API.G_VALID_LEVEL_FULL, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
11: RETURN BOOLEAN;
12:
13:
14: FUNCTION do_validation(p_trans_rec IN FA_API_TYPES.trans_rec_type,
15: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
16: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
17: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
18: p_old_units IN NUMBER,
11: RETURN BOOLEAN;
12:
13:
14: FUNCTION do_validation(p_trans_rec IN FA_API_TYPES.trans_rec_type,
15: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
16: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
17: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
18: p_old_units IN NUMBER,
19: x_total_txn_units OUT NOCOPY NUMBER,
12:
13:
14: FUNCTION do_validation(p_trans_rec IN FA_API_TYPES.trans_rec_type,
15: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
16: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
17: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
18: p_old_units IN NUMBER,
19: x_total_txn_units OUT NOCOPY NUMBER,
20: p_validation_level IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
13:
14: FUNCTION do_validation(p_trans_rec IN FA_API_TYPES.trans_rec_type,
15: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
16: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
17: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
18: p_old_units IN NUMBER,
19: x_total_txn_units OUT NOCOPY NUMBER,
20: p_validation_level IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
21: RETURN BOOLEAN;
16: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
17: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
18: p_old_units IN NUMBER,
19: x_total_txn_units OUT NOCOPY NUMBER,
20: p_validation_level IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
21: RETURN BOOLEAN;
22:
23:
24: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
20: p_validation_level IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
21: RETURN BOOLEAN;
22:
23:
24: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
25: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
26: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
27: p_curr_index IN NUMBER,
28: p_validation_level IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
21: RETURN BOOLEAN;
22:
23:
24: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
25: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
26: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
27: p_curr_index IN NUMBER,
28: p_validation_level IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
29: RETURN BOOLEAN;
22:
23:
24: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
25: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
26: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
27: p_curr_index IN NUMBER,
28: p_validation_level IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
29: RETURN BOOLEAN;
30:
24: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
25: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
26: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
27: p_curr_index IN NUMBER,
28: p_validation_level IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
29: RETURN BOOLEAN;
30:
31: /*
32: FUNCTION get_total_txn_units(p_trans_rec IN FA_API_TYPES.trans_rec_type,
28: p_validation_level IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
29: RETURN BOOLEAN;
30:
31: /*
32: FUNCTION get_total_txn_units(p_trans_rec IN FA_API_TYPES.trans_rec_type,
33: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
34: x_total_units IN OUT NOCOPY number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
35: RETURN BOOLEAN; */
36:
29: RETURN BOOLEAN;
30:
31: /*
32: FUNCTION get_total_txn_units(p_trans_rec IN FA_API_TYPES.trans_rec_type,
33: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
34: x_total_units IN OUT NOCOPY number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
35: RETURN BOOLEAN; */
36:
37: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
30:
31: /*
32: FUNCTION get_total_txn_units(p_trans_rec IN FA_API_TYPES.trans_rec_type,
33: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
34: x_total_units IN OUT NOCOPY number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
35: RETURN BOOLEAN; */
36:
37: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
38: RETURN BOOLEAN;
33: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
34: x_total_units IN OUT NOCOPY number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
35: RETURN BOOLEAN; */
36:
37: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
38: RETURN BOOLEAN;
39:
40: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
41: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
36:
37: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
38: RETURN BOOLEAN;
39:
40: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
41: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
42: RETURN BOOLEAN;
43:
44: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
37: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
38: RETURN BOOLEAN;
39:
40: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
41: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
42: RETURN BOOLEAN;
43:
44: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
45: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
40: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
41: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
42: RETURN BOOLEAN;
43:
44: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
45: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
46: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
47: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
48: RETURN BOOLEAN;
41: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
42: RETURN BOOLEAN;
43:
44: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
45: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
46: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
47: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
48: RETURN BOOLEAN;
49:
42: RETURN BOOLEAN;
43:
44: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
45: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
46: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
47: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
48: RETURN BOOLEAN;
49:
50: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
43:
44: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
45: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
46: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
47: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
48: RETURN BOOLEAN;
49:
50: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
51: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
46: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
47: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
48: RETURN BOOLEAN;
49:
50: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
51: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
52: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
53: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
54: RETURN BOOLEAN;
47: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
48: RETURN BOOLEAN;
49:
50: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
51: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
52: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
53: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
54: RETURN BOOLEAN;
55:
48: RETURN BOOLEAN;
49:
50: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
51: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
52: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
53: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
54: RETURN BOOLEAN;
55:
56: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
49:
50: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
51: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
52: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
53: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
54: RETURN BOOLEAN;
55:
56: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
57: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
52: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
53: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
54: RETURN BOOLEAN;
55:
56: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
57: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
58: p_period_rec IN FA_API_TYPES.period_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
59: RETURN BOOLEAN;
60:
53: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
54: RETURN BOOLEAN;
55:
56: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
57: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
58: p_period_rec IN FA_API_TYPES.period_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
59: RETURN BOOLEAN;
60:
61: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
54: RETURN BOOLEAN;
55:
56: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
57: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
58: p_period_rec IN FA_API_TYPES.period_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
59: RETURN BOOLEAN;
60:
61: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
62: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
57: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
58: p_period_rec IN FA_API_TYPES.period_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
59: RETURN BOOLEAN;
60:
61: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
62: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
63: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
64: RETURN BOOLEAN;
65:
58: p_period_rec IN FA_API_TYPES.period_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
59: RETURN BOOLEAN;
60:
61: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
62: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
63: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
64: RETURN BOOLEAN;
65:
66:
59: RETURN BOOLEAN;
60:
61: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
62: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
63: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
64: RETURN BOOLEAN;
65:
66:
67: END FA_DISTRIBUTION_PVT;