DBA Data[Home] [Help]

APPS.FA_INV_XFR_PUB dependencies on FA_API_TYPES

Line 10: g_log_level_rec fa_api_types.log_level_rec_type;

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:

Line 16: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,

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,

Line 17: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

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,

Line 18: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,

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,

Line 19: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

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,

Line 27: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;

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

Line 40: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

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

Line 41: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

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:

Line 42: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

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

Line 43: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

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);

Line 44: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS

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:

Line 50: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

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:

Line 53: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;

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;

Line 56: l_src_asset_fin_rec_adj 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;

Line 57: l_src_asset_fin_rec_new FA_API_TYPES.asset_fin_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;

Line 58: l_src_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_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;

Line 59: l_src_inv_tbl FA_API_TYPES.inv_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:

Line 60: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

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

Line 61: l_src_asset_deprn_rec_new FA_API_TYPES.asset_deprn_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
65: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

Line 62: l_src_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_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;

Line 65: l_dest_asset_fin_rec_adj 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;

Line 66: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_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;

Line 67: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_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;
71: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 68: l_dest_inv_tbl FA_API_TYPES.inv_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:

Line 69: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

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;

Line 70: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_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;

Line 71: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_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:

Line 73: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_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:
76: l_from_asset_type varchar2(15);
77: l_to_asset_type varchar2(15);

Line 74: l_dest_asset_type_rec FA_API_TYPES.asset_type_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);
78: l_from_current_units number;

Line 81: l_period_rec FA_API_TYPES.period_rec_type;

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;

Line 99: l_secondary_src_trans_rec FA_API_TYPES.trans_rec_type;

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:

Line 100: l_secondary_dest_trans_rec FA_API_TYPES.trans_rec_type;

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

Line 101: l_secondary_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

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

Line 102: l_secondary_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

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

Line 670: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,

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,

Line 671: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

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,

Line 672: p_dest_trans_rec IN FA_API_TYPES.trans_rec_type,

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,

Line 673: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

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,

Line 681: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is

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:

Line 974: (p_src_trans_rec IN FA_API_TYPES.trans_rec_type,

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,

Line 975: p_src_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_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,

Line 976: p_dest_trans_rec IN FA_API_TYPES.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

Line 977: p_dest_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

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:

Line 978: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,

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;

Line 979: p_inv_trans_rec IN FA_API_TYPES.inv_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;
983: x_msg_data VARCHAR2(1000);

Line 980: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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';

Line 986: l_src_trans_rec FA_API_TYPES.trans_rec_type := p_src_trans_rec;

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;

Line 987: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_src_asset_hdr_rec;

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;

Line 988: l_dest_trans_rec FA_API_TYPES.trans_rec_type := p_dest_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:

Line 989: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type := p_dest_asset_hdr_rec;

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;

Line 990: l_inv_tbl FA_API_TYPES.inv_tbl_type := p_inv_tbl;

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;

Line 991: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type := p_inv_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;
995: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

Line 993: l_dest_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_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;

Line 994: l_dest_asset_fin_rec_new FA_API_TYPES.asset_fin_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;

Line 995: l_dest_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_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;

Line 996: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_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:

Line 997: l_dest_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

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);

Line 998: l_dest_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_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);
1002: l_to_asset_type varchar2(15);

Line 999: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_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);
1003: l_from_current_units number;