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:
12: --*********************** Private procedures ******************************--
13:
14: -- SLA: do_all_books is obsolete and removed as we handle interco

Line 29: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

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

Line 30: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

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:

Line 31: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

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

Line 32: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

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

Line 33: p_inv_tbl IN FA_API_TYPES.inv_tbl_type) IS

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;

Line 41: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

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:

Line 44: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;

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;

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

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

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

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

Line 51: l_src_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

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

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

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

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

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

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

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

Line 60: l_dest_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

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;

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

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

Line 64: l_src_asset_type_rec FA_API_TYPES.asset_type_rec_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:
67: l_from_asset_type varchar2(15);
68: l_to_asset_type varchar2(15);

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

Line 72: l_period_rec FA_API_TYPES.period_rec_type;

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: