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:
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
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
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
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,
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,
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',
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
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:
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:
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;
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;
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;
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:
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;
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);
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);
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';
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);
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);