6: G_API_NAME CONSTANT varchar2(30) := 'Transfer API';
7: G_API_VERSION CONSTANT number := 1.0;
8: g_release number := fa_cache_pkg.fazarel_release; --Bug 8477066
9:
10: g_log_level_rec fa_api_types.log_level_rec_type;
11:
12: --*********************** Private procedures *****************************--
13:
14: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
10: g_log_level_rec fa_api_types.log_level_rec_type;
11:
12: --*********************** Private procedures *****************************--
13:
14: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
16: RETURN BOOLEAN;
17:
18: --*********************** Public procedures ******************************--
11:
12: --*********************** Private procedures *****************************--
13:
14: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
16: RETURN BOOLEAN;
17:
18: --*********************** Public procedures ******************************--
19:
24: p_calling_fn IN VARCHAR2,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,
28: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
29: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
30: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type)
31:
32: IS
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,
28: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
29: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
30: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type)
31:
32: IS
33:
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,
28: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
29: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
30: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type)
31:
32: IS
33:
34: -- Bug 8252607/5475276 Cursor to get the book_type_code
41: AND bks.asset_id = p_asset_id
42: AND bks.transaction_header_id_out is null;
43:
44: l_period_addition varchar2(1);
45: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
46:
47: --10328635
48: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
49: --10328635
44: l_period_addition varchar2(1);
45: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
46:
47: --10328635
48: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
49: --10328635
50:
51: BEGIN
52:
276: x_return_status := FND_API.G_RET_STS_ERROR;
277:
278: END;
279:
280: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
281: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
282: RETURN BOOLEAN IS
283:
284: l_fiscal_year_name varchar2(30);
277:
278: END;
279:
280: FUNCTION valid_input(px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
281: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
282: RETURN BOOLEAN IS
283:
284: l_fiscal_year_name varchar2(30);
285: l_fiscal_year number;
286: l_fy_start_date date;
287: l_fy_end_date date;
288: l_count number;
289: l_max_transaction_date date;
290: l_period_rec FA_API_TYPES.period_rec_type;
291: l_override_flag varchar2(1);
292: l_transaction_date date;
293:
294: BEGIN