DBA Data[Home] [Help]

APPS.FA_MASSADD_PKG dependencies on FA_API_TYPES

Line 6: g_log_level_rec fa_api_types.log_level_rec_type;

2: /* $Header: FAMAPTB.pls 120.32.12010000.1 2008/07/28 13:12:26 appldev ship $ */
3:
4: ----------------------------------------------------------------
5:
6: g_log_level_rec fa_api_types.log_level_rec_type;
7: G_times_called number := 0;
8:
9: -- used for new MP assets in current session
10: type mp_asset_rec_type IS RECORD (

Line 53: l_trans_rec FA_API_TYPES.trans_rec_type;

49: l_msg_count NUMBER;
50: l_msg_data VARCHAR2(4000);
51: l_return_status VARCHAR2(1);
52:
53: l_trans_rec FA_API_TYPES.trans_rec_type;
54: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
55: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
57: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 54: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

50: l_msg_data VARCHAR2(4000);
51: l_return_status VARCHAR2(1);
52:
53: l_trans_rec FA_API_TYPES.trans_rec_type;
54: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
55: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
57: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
58: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 55: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

51: l_return_status VARCHAR2(1);
52:
53: l_trans_rec FA_API_TYPES.trans_rec_type;
54: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
55: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
57: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
58: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
59: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;

Line 56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

52:
53: l_trans_rec FA_API_TYPES.trans_rec_type;
54: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
55: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
57: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
58: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
59: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
60: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

Line 57: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

53: l_trans_rec FA_API_TYPES.trans_rec_type;
54: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
55: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
57: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
58: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
59: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
60: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
61: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

Line 58: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

54: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
55: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
57: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
58: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
59: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
60: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
61: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
62: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

Line 59: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;

55: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
57: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
58: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
59: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
60: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
61: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
62: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
63: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

Line 60: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

56: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
57: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
58: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
59: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
60: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
61: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
62: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
63: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
64: l_inv_rec FA_API_TYPES.inv_rec_type;

Line 61: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

57: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
58: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
59: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
60: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
61: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
62: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
63: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
64: l_inv_rec FA_API_TYPES.inv_rec_type;
65: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 62: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

58: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
59: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
60: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
61: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
62: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
63: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
64: l_inv_rec FA_API_TYPES.inv_rec_type;
65: l_inv_tbl FA_API_TYPES.inv_tbl_type;
66: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;

Line 63: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

59: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
60: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
61: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
62: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
63: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
64: l_inv_rec FA_API_TYPES.inv_rec_type;
65: l_inv_tbl FA_API_TYPES.inv_tbl_type;
66: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
67: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 64: l_inv_rec FA_API_TYPES.inv_rec_type;

60: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
61: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
62: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
63: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
64: l_inv_rec FA_API_TYPES.inv_rec_type;
65: l_inv_tbl FA_API_TYPES.inv_tbl_type;
66: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
67: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
68: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 65: l_inv_tbl FA_API_TYPES.inv_tbl_type;

61: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
62: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
63: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
64: l_inv_rec FA_API_TYPES.inv_rec_type;
65: l_inv_tbl FA_API_TYPES.inv_tbl_type;
66: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
67: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
68: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
69: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 66: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;

62: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
63: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
64: l_inv_rec FA_API_TYPES.inv_rec_type;
65: l_inv_tbl FA_API_TYPES.inv_tbl_type;
66: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
67: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
68: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
69: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
70: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

Line 67: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

63: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
64: l_inv_rec FA_API_TYPES.inv_rec_type;
65: l_inv_tbl FA_API_TYPES.inv_tbl_type;
66: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
67: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
68: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
69: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
70: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
71: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 68: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

64: l_inv_rec FA_API_TYPES.inv_rec_type;
65: l_inv_tbl FA_API_TYPES.inv_tbl_type;
66: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
67: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
68: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
69: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
70: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
71: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
72: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 69: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

65: l_inv_tbl FA_API_TYPES.inv_tbl_type;
66: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
67: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
68: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
69: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
70: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
71: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
72: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
73: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;

Line 70: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

66: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
67: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
68: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
69: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
70: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
71: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
72: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
73: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
74:

Line 71: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

67: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
68: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
69: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
70: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
71: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
72: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
73: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
74:
75: -- Fix for Bug #6336083/6636504

Line 72: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;

68: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
69: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
70: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
71: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
72: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
73: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
74:
75: -- Fix for Bug #6336083/6636504
76: l_trans_desc_flex_rec FA_API_TYPES.desc_flex_rec_type;

Line 73: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;

69: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
70: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
71: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
72: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
73: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
74:
75: -- Fix for Bug #6336083/6636504
76: l_trans_desc_flex_rec FA_API_TYPES.desc_flex_rec_type;
77:

Line 76: l_trans_desc_flex_rec FA_API_TYPES.desc_flex_rec_type;

72: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
73: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
74:
75: -- Fix for Bug #6336083/6636504
76: l_trans_desc_flex_rec FA_API_TYPES.desc_flex_rec_type;
77:
78: l_dist_id_tbl num_tbl_type;
79: l_dist_units_tbl num_tbl_type;
80: l_dist_ccid_tbl num_tbl_type;

Line 1878: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

1874: px_amortization_start_date_tbl IN OUT NOCOPY date_tbl_type ,
1875: px_description_tbl IN OUT NOCOPY char_tbl_type ,
1876: p_fixed_assets_units_tbl IN num_tbl_type ,
1877: px_units_to_adjust_tbl IN OUT NOCOPY num_tbl_type ,
1878: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1879:
1880: Error varchar2(100);
1881:
1882: Cursor c_fy_add (p_category_id number,

Line 2253: l_period_rec FA_API_TYPES.period_rec_type;

2249: x_return_status OUT NOCOPY NUMBER
2250: ) AS
2251:
2252: -- local variables
2253: l_period_rec FA_API_TYPES.period_rec_type;
2254: l_calendar_period_close_date date;
2255:
2256: -- Used for bulk fetching
2257: l_batch_size number;