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: g_release number := fa_cache_pkg.fazarel_release;
12:
13: --*********************** Private procedures ******************************--
14:
12:
13: --*********************** Private procedures ******************************--
14:
15: FUNCTION do_all_books
16: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
17: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
18: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
19: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
20: p_period_counter IN NUMBER,
13: --*********************** Private procedures ******************************--
14:
15: FUNCTION do_all_books
16: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
17: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
18: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
19: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
20: p_period_counter IN NUMBER,
21: p_ccid IN NUMBER,
14:
15: FUNCTION do_all_books
16: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
17: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
18: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
19: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
20: p_period_counter IN NUMBER,
21: p_ccid IN NUMBER,
22: p_src_asset_type IN VARCHAR2,
15: FUNCTION do_all_books
16: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
17: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
18: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
19: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
20: p_period_counter IN NUMBER,
21: p_ccid IN NUMBER,
22: p_src_asset_type IN VARCHAR2,
23: p_dest_asset_type IN VARCHAR2,
23: p_dest_asset_type IN VARCHAR2,
24: p_src_current_units IN NUMBER,
25: p_dest_current_units IN NUMBER,
26: p_calling_fn IN varchar2
27: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;
28:
29: --*********************** Public procedures ******************************--
30:
31: PROCEDURE do_transfer
36: p_calling_fn IN VARCHAR2 := NULL,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
41: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
42: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
43: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
44: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
41: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
42: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
43: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
44: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS
45:
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
41: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
42: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
43: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
44: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS
45:
46: -- used for sob cache
39: x_msg_data OUT NOCOPY VARCHAR2,
40: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
41: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
42: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
43: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
44: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS
45:
46: -- used for sob cache
47: l_mrc_sob_type_code varchar2(1);
40: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
41: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
42: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
43: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
44: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS
45:
46: -- used for sob cache
47: l_mrc_sob_type_code varchar2(1);
48:
46: -- used for sob cache
47: l_mrc_sob_type_code varchar2(1);
48:
49: -- shared
50: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
51: l_return_status VARCHAR2(1);
52: l_return_status_bool boolean;
53: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
54:
49: -- shared
50: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
51: l_return_status VARCHAR2(1);
52: l_return_status_bool boolean;
53: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
54:
55: -- source
56: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
52: l_return_status_bool boolean;
53: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
54:
55: -- source
56: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
53: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
54:
55: -- source
56: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
54:
55: -- source
56: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
55: -- source
56: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
56: l_src_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
57: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
64: -- destination
57: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
58: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
64: -- destination
65: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
58: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
59: l_src_inv_tbl FA_API_TYPES.inv_tbl_type;
60: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
61: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
64: -- destination
65: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
66: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
61: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
62: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
64: -- destination
65: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
66: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
67: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
68: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
69: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
62: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
63:
64: -- destination
65: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
66: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
67: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
68: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
69: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
63:
64: -- destination
65: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
66: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
67: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
68: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
69: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
71: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
64: -- destination
65: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
66: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
67: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
68: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
69: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
71: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
72:
65: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
66: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
67: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
68: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
69: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
71: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
72:
73: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_type;
66: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
67: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
68: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
69: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
71: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
72:
73: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_type;
74: l_dest_asset_type_rec FA_API_TYPES.asset_type_rec_type;
67: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
68: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
69: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
71: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
72:
73: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_type;
74: l_dest_asset_type_rec FA_API_TYPES.asset_type_rec_type;
75:
69: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
71: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
72:
73: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_type;
74: l_dest_asset_type_rec FA_API_TYPES.asset_type_rec_type;
75:
76: l_from_asset_type varchar2(15);
77: l_to_asset_type varchar2(15);
70: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
71: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
72:
73: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_type;
74: l_dest_asset_type_rec FA_API_TYPES.asset_type_rec_type;
75:
76: l_from_asset_type varchar2(15);
77: l_to_asset_type varchar2(15);
78: l_from_current_units number;
77: l_to_asset_type varchar2(15);
78: l_from_current_units number;
79: l_to_current_units number;
80:
81: l_period_rec FA_API_TYPES.period_rec_type;
82: l_transaction_date date;
83:
84: l_clearing_ccid number;
85: l_interco_impact boolean;
95: l_dest_group_asset_id NUMBER;
96:
97: --Secondary
98: l_secondary_sob_id number;
99: l_secondary_src_trans_rec FA_API_TYPES.trans_rec_type;
100: l_secondary_dest_trans_rec FA_API_TYPES.trans_rec_type;
101: l_secondary_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
102: l_secondary_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
103:
96:
97: --Secondary
98: l_secondary_sob_id number;
99: l_secondary_src_trans_rec FA_API_TYPES.trans_rec_type;
100: l_secondary_dest_trans_rec FA_API_TYPES.trans_rec_type;
101: l_secondary_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
102: l_secondary_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
103:
104: CURSOR C_GET_SOURCE_GROUP IS
97: --Secondary
98: l_secondary_sob_id number;
99: l_secondary_src_trans_rec FA_API_TYPES.trans_rec_type;
100: l_secondary_dest_trans_rec FA_API_TYPES.trans_rec_type;
101: l_secondary_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
102: l_secondary_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
103:
104: CURSOR C_GET_SOURCE_GROUP IS
105: SELECT BK.GROUP_ASSET_ID
98: l_secondary_sob_id number;
99: l_secondary_src_trans_rec FA_API_TYPES.trans_rec_type;
100: l_secondary_dest_trans_rec FA_API_TYPES.trans_rec_type;
101: l_secondary_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
102: l_secondary_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
103:
104: CURSOR C_GET_SOURCE_GROUP IS
105: SELECT BK.GROUP_ASSET_ID
106: FROM FA_BOOKS BK,FA_DEPRN_PERIODS DP
666:
667: ---------------------------------------------------------------------------
668:
669: FUNCTION do_all_books
670: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
671: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
672: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
673: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
674: p_period_counter IN NUMBER,
667: ---------------------------------------------------------------------------
668:
669: FUNCTION do_all_books
670: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
671: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
672: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
673: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
674: p_period_counter IN NUMBER,
675: p_ccid IN NUMBER,
668:
669: FUNCTION do_all_books
670: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
671: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
672: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
673: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
674: p_period_counter IN NUMBER,
675: p_ccid IN NUMBER,
676: p_src_asset_type IN VARCHAR2,
669: FUNCTION do_all_books
670: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
671: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
672: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
673: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
674: p_period_counter IN NUMBER,
675: p_ccid IN NUMBER,
676: p_src_asset_type IN VARCHAR2,
677: p_dest_asset_type IN VARCHAR2,
677: p_dest_asset_type IN VARCHAR2,
678: p_src_current_units IN NUMBER,
679: p_dest_current_units IN NUMBER,
680: p_calling_fn IN varchar2
681: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
682:
683: l_src_interco_amount number;
684: l_src_cost_amount number;
685:
970: end do_all_books;
971:
972: -- Bug 8862296 Changes start here.
973: FUNCTION do_inv_sub_transfer
974: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
975: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
976: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
977: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
978: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
971:
972: -- Bug 8862296 Changes start here.
973: FUNCTION do_inv_sub_transfer
974: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
975: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
976: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
977: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
978: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
979: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
972: -- Bug 8862296 Changes start here.
973: FUNCTION do_inv_sub_transfer
974: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
975: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
976: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
977: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
978: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
979: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
980: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
973: FUNCTION do_inv_sub_transfer
974: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
975: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
976: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
977: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
978: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
979: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
980: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
981:
974: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,
975: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
976: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
977: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
978: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
979: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
980: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
981:
982: x_msg_count NUMBER;
975: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
976: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
977: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
978: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
979: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
980: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
981:
982: x_msg_count NUMBER;
983: x_msg_data VARCHAR2(1000);
976: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,
977: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
978: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
979: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
980: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
981:
982: x_msg_count NUMBER;
983: x_msg_data VARCHAR2(1000);
984: l_calling_fn VARCHAR2(35) := 'fa_inv_xfr_pub.do_inv_sub_transfer';
982: x_msg_count NUMBER;
983: x_msg_data VARCHAR2(1000);
984: l_calling_fn VARCHAR2(35) := 'fa_inv_xfr_pub.do_inv_sub_transfer';
985:
986: l_src_trans_rec FA_API_TYPES.trans_rec_type := p_src_trans_rec;
987: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_src_asset_hdr_rec;
988: l_dest_trans_rec FA_API_TYPES.trans_rec_type := p_dest_trans_rec;
989: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_dest_asset_hdr_rec;
990: l_inv_tbl FA_API_TYPES.inv_tbl_type := p_inv_tbl;
983: x_msg_data VARCHAR2(1000);
984: l_calling_fn VARCHAR2(35) := 'fa_inv_xfr_pub.do_inv_sub_transfer';
985:
986: l_src_trans_rec FA_API_TYPES.trans_rec_type := p_src_trans_rec;
987: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_src_asset_hdr_rec;
988: l_dest_trans_rec FA_API_TYPES.trans_rec_type := p_dest_trans_rec;
989: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_dest_asset_hdr_rec;
990: l_inv_tbl FA_API_TYPES.inv_tbl_type := p_inv_tbl;
991: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type := p_inv_trans_rec;
984: l_calling_fn VARCHAR2(35) := 'fa_inv_xfr_pub.do_inv_sub_transfer';
985:
986: l_src_trans_rec FA_API_TYPES.trans_rec_type := p_src_trans_rec;
987: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_src_asset_hdr_rec;
988: l_dest_trans_rec FA_API_TYPES.trans_rec_type := p_dest_trans_rec;
989: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_dest_asset_hdr_rec;
990: l_inv_tbl FA_API_TYPES.inv_tbl_type := p_inv_tbl;
991: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type := p_inv_trans_rec;
992:
985:
986: l_src_trans_rec FA_API_TYPES.trans_rec_type := p_src_trans_rec;
987: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_src_asset_hdr_rec;
988: l_dest_trans_rec FA_API_TYPES.trans_rec_type := p_dest_trans_rec;
989: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_dest_asset_hdr_rec;
990: l_inv_tbl FA_API_TYPES.inv_tbl_type := p_inv_tbl;
991: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type := p_inv_trans_rec;
992:
993: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
986: l_src_trans_rec FA_API_TYPES.trans_rec_type := p_src_trans_rec;
987: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_src_asset_hdr_rec;
988: l_dest_trans_rec FA_API_TYPES.trans_rec_type := p_dest_trans_rec;
989: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_dest_asset_hdr_rec;
990: l_inv_tbl FA_API_TYPES.inv_tbl_type := p_inv_tbl;
991: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type := p_inv_trans_rec;
992:
993: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
994: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
987: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_src_asset_hdr_rec;
988: l_dest_trans_rec FA_API_TYPES.trans_rec_type := p_dest_trans_rec;
989: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_dest_asset_hdr_rec;
990: l_inv_tbl FA_API_TYPES.inv_tbl_type := p_inv_tbl;
991: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type := p_inv_trans_rec;
992:
993: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
994: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
995: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
989: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_dest_asset_hdr_rec;
990: l_inv_tbl FA_API_TYPES.inv_tbl_type := p_inv_tbl;
991: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type := p_inv_trans_rec;
992:
993: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
994: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
995: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
996: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
997: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
990: l_inv_tbl FA_API_TYPES.inv_tbl_type := p_inv_tbl;
991: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type := p_inv_trans_rec;
992:
993: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
994: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
995: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
996: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
997: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
998: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
991: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type := p_inv_trans_rec;
992:
993: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
994: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
995: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
996: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
997: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
998: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
999: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
992:
993: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
994: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
995: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
996: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
997: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
998: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
999: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1000:
993: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
994: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
995: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
996: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
997: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
998: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
999: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1000:
1001: l_from_asset_type varchar2(15);
994: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
995: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
996: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
997: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
998: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
999: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1000:
1001: l_from_asset_type varchar2(15);
1002: l_to_asset_type varchar2(15);
995: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
996: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
997: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
998: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
999: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1000:
1001: l_from_asset_type varchar2(15);
1002: l_to_asset_type varchar2(15);
1003: l_from_current_units number;