DBA Data[Home] [Help]

APPS.FA_ASSET_HIERARCHY_PVT dependencies on FA_API_TYPES

Line 6: p_book_type_code in varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is

2: /* $Header: FAVAHRB.pls 120.4 2009/04/16 14:37:26 bridgway ship $ */
3:
4:
5: FUNCTION validate_parent ( p_parent_hierarchy_id in number,
6: p_book_type_code in varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
7:
8: l_purpose_book varchar2(30);
9: l_parent_id number;
10:

Line 47: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

43: -----
44: -----
45: FUNCTION add_asset(
46: -- api parameters
47: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
48: p_asset_hierarchy_rec IN FA_API_TYPES.asset_hierarchy_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
49:
50: cursor C_purpose is
51: select asset_hierarchy_purpose_id

Line 48: p_asset_hierarchy_rec IN FA_API_TYPES.asset_hierarchy_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

44: -----
45: FUNCTION add_asset(
46: -- api parameters
47: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
48: p_asset_hierarchy_rec IN FA_API_TYPES.asset_hierarchy_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
49:
50: cursor C_purpose is
51: select asset_hierarchy_purpose_id
52: from fa_asset_hierarchy_purpose

Line 124: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

120:
121: FUNCTION load_distributions(
122: p_hr_dist_set_id IN number,
123: p_asset_units IN number,
124: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
125:
126: i binary_integer := 0;
127: l_distribution_set_id number;
128: CURSOR distset_cur is

Line 168: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,

164:
165: -----------------------------------
166:
167: FUNCTION derive_asset_attribute(
168: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
169: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
170: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
171: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
172: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,

Line 169: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,

165: -----------------------------------
166:
167: FUNCTION derive_asset_attribute(
168: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
169: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
170: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
171: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
172: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
173: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,

Line 170: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,

166:
167: FUNCTION derive_asset_attribute(
168: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
169: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
170: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
171: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
172: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
173: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
174: p_derivation_type IN varchar2 DEFAULT 'ALL',

Line 171: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,

167: FUNCTION derive_asset_attribute(
168: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
169: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
170: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
171: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
172: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
173: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
174: p_derivation_type IN varchar2 DEFAULT 'ALL',
175: p_calling_function IN varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

Line 172: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,

168: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
169: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
170: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
171: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
172: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
173: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
174: p_derivation_type IN varchar2 DEFAULT 'ALL',
175: p_calling_function IN varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
176:

Line 173: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,

169: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
170: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
171: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
172: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
173: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
174: p_derivation_type IN varchar2 DEFAULT 'ALL',
175: p_calling_function IN varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
176:
177:

Line 175: p_calling_function IN varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

171: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
172: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
173: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
174: p_derivation_type IN varchar2 DEFAULT 'ALL',
175: p_calling_function IN varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
176:
177:
178: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
179: l_asset_desc_rec fa_api_types.asset_desc_rec_type;

Line 178: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

174: p_derivation_type IN varchar2 DEFAULT 'ALL',
175: p_calling_function IN varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
176:
177:
178: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
179: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
180: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
181: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
182: l_asset_fin_rec fa_api_types.asset_fin_rec_type;

Line 179: l_asset_desc_rec fa_api_types.asset_desc_rec_type;

175: p_calling_function IN varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
176:
177:
178: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
179: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
180: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
181: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
182: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
183: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

Line 180: l_asset_cat_rec fa_api_types.asset_cat_rec_type;

176:
177:
178: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
179: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
180: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
181: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
182: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
183: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
184:

Line 181: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;

177:
178: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
179: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
180: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
181: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
182: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
183: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
184:
185: l_category_id_out number;

Line 182: l_asset_fin_rec fa_api_types.asset_fin_rec_type;

178: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
179: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
180: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
181: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
182: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
183: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
184:
185: l_category_id_out number;
186: l_cat_OA varchar2(1);

Line 183: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

179: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
180: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
181: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
182: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
183: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
184:
185: l_category_id_out number;
186: l_cat_OA varchar2(1);
187: l_cat_RF varchar2(1);

Line 373: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

369: END derive_asset_attribute;
370:
371:
372: FUNCTION create_batch(
373: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
374: p_trans_rec IN FA_API_TYPES.trans_rec_type,
375: p_asset_hr_opt_rec IN FA_API_TYPES.asset_hr_options_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
376:
377: l_err_code varchar2(600):= '0';

Line 374: p_trans_rec IN FA_API_TYPES.trans_rec_type,

370:
371:
372: FUNCTION create_batch(
373: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
374: p_trans_rec IN FA_API_TYPES.trans_rec_type,
375: p_asset_hr_opt_rec IN FA_API_TYPES.asset_hr_options_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
376:
377: l_err_code varchar2(600):= '0';
378: l_err_stack varchar2(600);

Line 375: p_asset_hr_opt_rec IN FA_API_TYPES.asset_hr_options_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

371:
372: FUNCTION create_batch(
373: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
374: p_trans_rec IN FA_API_TYPES.trans_rec_type,
375: p_asset_hr_opt_rec IN FA_API_TYPES.asset_hr_options_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
376:
377: l_err_code varchar2(600):= '0';
378: l_err_stack varchar2(600);
379: l_err_stage varchar2(600);