6: G_PKG_NAME CONSTANT varchar2(30) := 'FA_UNPLANNED_PUB';
7: G_API_NAME CONSTANT varchar2(30) := 'Unplanned API';
8: G_API_VERSION CONSTANT number := 1.0;
9:
10: g_log_level_rec fa_api_types.log_level_rec_type;
11:
12: --*********************** Private procedures ******************************--
13:
14: -- SLA: do_all_books is obsolete and removed as we handle interco
25: p_calling_fn IN VARCHAR2 := NULL,
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER,
28: x_msg_data OUT NOCOPY VARCHAR2,
29: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
30: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
31: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
32: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
33: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER,
28: x_msg_data OUT NOCOPY VARCHAR2,
29: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
30: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
31: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
32: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
33: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS
34:
27: x_msg_count OUT NOCOPY NUMBER,
28: x_msg_data OUT NOCOPY VARCHAR2,
29: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
30: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
31: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
32: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
33: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS
34:
35: -- used for sob cache
28: x_msg_data OUT NOCOPY VARCHAR2,
29: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
30: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
31: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
32: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
33: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS
34:
35: -- used for sob cache
36: l_mrc_sob_type_code varchar2(1);
29: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
30: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
31: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
32: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
33: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS
34:
35: -- used for sob cache
36: l_mrc_sob_type_code varchar2(1);
37: l_orig_sob_id NUMBER;
37: l_orig_sob_id NUMBER;
38: l_orig_currency_context VARCHAR2(64);
39:
40: -- shared
41: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
42: l_return_status VARCHAR2(1);
43: l_return_status_bool boolean;
44: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
45:
40: -- shared
41: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
42: l_return_status VARCHAR2(1);
43: l_return_status_bool boolean;
44: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
45:
46: -- source
47: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
48: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
43: l_return_status_bool boolean;
44: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
45:
46: -- source
47: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
48: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
51: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
44: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
45:
46: -- source
47: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
48: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
51: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
52: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
45:
46: -- source
47: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
48: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
51: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
52: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
53: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
46: -- source
47: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
48: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
51: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
52: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
53: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
54:
47: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
48: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
51: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
52: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
53: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
54:
55: -- destination
48: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
51: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
52: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
53: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
54:
55: -- destination
56: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
49: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
51: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
52: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
53: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
54:
55: -- destination
56: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
52: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
53: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
54:
55: -- destination
56: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
53: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
54:
55: -- destination
56: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
54:
55: -- destination
56: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
55: -- destination
56: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
56: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
64: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_type;
57: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
64: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_type;
65: l_dest_asset_type_rec FA_API_TYPES.asset_type_rec_type;
58: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
64: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_type;
65: l_dest_asset_type_rec FA_API_TYPES.asset_type_rec_type;
66:
60: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
64: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_type;
65: l_dest_asset_type_rec FA_API_TYPES.asset_type_rec_type;
66:
67: l_from_asset_type varchar2(15);
68: l_to_asset_type varchar2(15);
61: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
64: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_type;
65: l_dest_asset_type_rec FA_API_TYPES.asset_type_rec_type;
66:
67: l_from_asset_type varchar2(15);
68: l_to_asset_type varchar2(15);
69: l_from_current_units number;
68: l_to_asset_type varchar2(15);
69: l_from_current_units number;
70: l_to_current_units number;
71:
72: l_period_rec FA_API_TYPES.period_rec_type;
73: l_transaction_date date;
74:
75: l_clearing_ccid number;
76: