1: PACKAGE FA_DISTRIBUTION_PVT as
2: /* $Header: FAVDISTS.pls 120.2.12010000.2 2008/07/31 07:29:51 sbhaskar 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 := FND_API.G_VALID_LEVEL_FULL,
2: /* $Header: FAVDISTS.pls 120.2.12010000.2 2008/07/31 07:29:51 sbhaskar 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 := FND_API.G_VALID_LEVEL_FULL,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
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 := FND_API.G_VALID_LEVEL_FULL,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
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 := FND_API.G_VALID_LEVEL_FULL,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
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 := FND_API.G_VALID_LEVEL_FULL,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
11: RETURN BOOLEAN;
12:
13:
14: FUNCTION do_validation(p_trans_rec IN FA_API_TYPES.trans_rec_type,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
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 := FND_API.G_VALID_LEVEL_FULL,
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 := FND_API.G_VALID_LEVEL_FULL,
21: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
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 := FND_API.G_VALID_LEVEL_FULL,
21: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
22: RETURN BOOLEAN;
23:
24:
25: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
21: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
22: RETURN BOOLEAN;
23:
24:
25: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
26: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
27: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
28: p_curr_index IN NUMBER,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: RETURN BOOLEAN;
23:
24:
25: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
26: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
27: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
28: p_curr_index IN NUMBER,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30:
23:
24:
25: FUNCTION valid_dist_data(p_trans_rec IN FA_API_TYPES.trans_rec_type,
26: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
27: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
28: p_curr_index IN NUMBER,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30:
31: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
27: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
28: p_curr_index IN NUMBER,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30:
31: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
32: RETURN BOOLEAN;
33:
34: /*
35: FUNCTION get_total_txn_units(p_trans_rec IN FA_API_TYPES.trans_rec_type,
31: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
32: RETURN BOOLEAN;
33:
34: /*
35: FUNCTION get_total_txn_units(p_trans_rec IN FA_API_TYPES.trans_rec_type,
36: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
37: x_total_units IN OUT NOCOPY number,
38: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
39: RETURN BOOLEAN; */
32: RETURN BOOLEAN;
33:
34: /*
35: FUNCTION get_total_txn_units(p_trans_rec IN FA_API_TYPES.trans_rec_type,
36: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
37: x_total_units IN OUT NOCOPY number,
38: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
39: RETURN BOOLEAN; */
40:
34: /*
35: FUNCTION get_total_txn_units(p_trans_rec IN FA_API_TYPES.trans_rec_type,
36: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
37: x_total_units IN OUT NOCOPY number,
38: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
39: RETURN BOOLEAN; */
40:
41: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
42: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
37: x_total_units IN OUT NOCOPY number,
38: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
39: RETURN BOOLEAN; */
40:
41: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
42: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
43: RETURN BOOLEAN;
44:
45: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
38: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
39: RETURN BOOLEAN; */
40:
41: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
42: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
43: RETURN BOOLEAN;
44:
45: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
46: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
41: FUNCTION units_in_sync(p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
42: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
43: RETURN BOOLEAN;
44:
45: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
46: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
47: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
48: RETURN BOOLEAN;
49:
42: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
43: RETURN BOOLEAN;
44:
45: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
46: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
47: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
48: RETURN BOOLEAN;
49:
50: FUNCTION update_asset_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
43: RETURN BOOLEAN;
44:
45: FUNCTION insert_txn_headers(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
46: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
47: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
48: RETURN BOOLEAN;
49:
50: FUNCTION update_asset_history(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_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
47: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
48: RETURN BOOLEAN;
49:
50: FUNCTION update_asset_history(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,
54: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
47: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
48: RETURN BOOLEAN;
49:
50: FUNCTION update_asset_history(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,
54: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
55: RETURN BOOLEAN;
48: RETURN BOOLEAN;
49:
50: FUNCTION update_asset_history(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,
54: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
55: RETURN BOOLEAN;
56:
49:
50: FUNCTION update_asset_history(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,
54: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
55: RETURN BOOLEAN;
56:
57: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
50: FUNCTION update_asset_history(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,
54: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
55: RETURN BOOLEAN;
56:
57: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
58: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
54: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
55: RETURN BOOLEAN;
56:
57: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
58: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
59: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
60: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
61: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
54: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
55: RETURN BOOLEAN;
56:
57: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
58: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
59: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
60: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
61: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
62: RETURN BOOLEAN;
55: RETURN BOOLEAN;
56:
57: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
58: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
59: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
60: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
61: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
62: RETURN BOOLEAN;
63:
56:
57: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
58: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
59: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
60: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
61: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
62: RETURN BOOLEAN;
63:
64: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
57: FUNCTION update_additions( p_trans_rec IN FA_API_TYPES.trans_rec_type,
58: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
59: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
60: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
61: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
62: RETURN BOOLEAN;
63:
64: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
65: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
60: p_asset_desc_rec_new IN FA_API_TYPES.asset_desc_rec_type,
61: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
62: RETURN BOOLEAN;
63:
64: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
65: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
66: p_period_rec IN FA_API_TYPES.period_rec_type,
67: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
68: RETURN BOOLEAN;
61: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
62: RETURN BOOLEAN;
63:
64: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
65: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
66: p_period_rec IN FA_API_TYPES.period_rec_type,
67: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
68: RETURN BOOLEAN;
69:
62: RETURN BOOLEAN;
63:
64: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
65: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
66: p_period_rec IN FA_API_TYPES.period_rec_type,
67: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
68: RETURN BOOLEAN;
69:
70: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
63:
64: FUNCTION update_books(p_trans_rec IN FA_API_TYPES.trans_rec_type,
65: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
66: p_period_rec IN FA_API_TYPES.period_rec_type,
67: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
68: RETURN BOOLEAN;
69:
70: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
71: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
66: p_period_rec IN FA_API_TYPES.period_rec_type,
67: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
68: RETURN BOOLEAN;
69:
70: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
71: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
72: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
73: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
74: RETURN BOOLEAN;
67: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
68: RETURN BOOLEAN;
69:
70: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
71: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
72: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
73: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
74: RETURN BOOLEAN;
75:
68: RETURN BOOLEAN;
69:
70: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
71: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
72: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
73: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
74: RETURN BOOLEAN;
75:
76:
69:
70: FUNCTION update_dist_history(p_trans_rec IN FA_API_TYPES.trans_rec_type,
71: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
72: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
73: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
74: RETURN BOOLEAN;
75:
76:
77: END FA_DISTRIBUTION_PVT;