1: PACKAGE BODY FA_TRANSFER_PUB AS
2: /* $Header: FAPTFRB.pls 120.9.12010000.2 2008/07/31 07:28:34 sbhaskar ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FA_TRANSFER_PUB';
5: g_log_level_rec fa_api_types.log_level_rec_type;
6:
7: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FA_TRANSFER_PUB';
5: g_log_level_rec fa_api_types.log_level_rec_type;
6:
7: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10: RETURN BOOLEAN;
11:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FA_TRANSFER_PUB';
5: g_log_level_rec fa_api_types.log_level_rec_type;
6:
7: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10: RETURN BOOLEAN;
11:
12: PROCEDURE do_transfer(p_api_version IN NUMBER,
5: g_log_level_rec fa_api_types.log_level_rec_type;
6:
7: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10: RETURN BOOLEAN;
11:
12: PROCEDURE do_transfer(p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_calling_fn IN VARCHAR2,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
21: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type)
23:
24: IS
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
21: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type)
23:
24: IS
25:
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
21: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type)
23:
24: IS
25:
26: l_api_version CONSTANT NUMBER := 1.0;
36: AND bks.asset_id = p_asset_id
37: AND bks.transaction_header_id_out is null;
38:
39: l_period_addition varchar2(1);
40: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
41:
42: BEGIN
43:
44: SAVEPOINT transfer_pub;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230:
231: END;
232:
233: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
234: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
235: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
236: RETURN BOOLEAN IS
237:
230:
231: END;
232:
233: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
234: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
235: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
236: RETURN BOOLEAN IS
237:
238: l_fiscal_year_name varchar2(30);
231: END;
232:
233: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
234: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
235: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
236: RETURN BOOLEAN IS
237:
238: l_fiscal_year_name varchar2(30);
239: l_fiscal_year number;
240: l_fy_start_date date;
241: l_fy_end_date date;
242: l_count number;
243: l_max_transaction_date date;
244: l_period_rec FA_API_TYPES.period_rec_type;
245: l_override_flag varchar2(1);
246: l_transaction_date date;
247:
248: BEGIN