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 ) 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 ) 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 ) 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 ) 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 ) 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 ) return boolean IS
176:
177:
174: p_derivation_type IN varchar2 DEFAULT 'ALL',
175: p_calling_function IN varchar2 ) 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 ) 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);
366: END derive_asset_attribute;
367:
368:
369: FUNCTION create_batch(
370: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
371: p_trans_rec IN FA_API_TYPES.trans_rec_type,
372: p_asset_hr_opt_rec IN FA_API_TYPES.asset_hr_options_rec_type ) return boolean IS
373:
374: l_err_code varchar2(600):= '0';
367:
368:
369: FUNCTION create_batch(
370: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
371: p_trans_rec IN FA_API_TYPES.trans_rec_type,
372: p_asset_hr_opt_rec IN FA_API_TYPES.asset_hr_options_rec_type ) return boolean IS
373:
374: l_err_code varchar2(600):= '0';
375: l_err_stack varchar2(600);
368:
369: FUNCTION create_batch(
370: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
371: p_trans_rec IN FA_API_TYPES.trans_rec_type,
372: p_asset_hr_opt_rec IN FA_API_TYPES.asset_hr_options_rec_type ) return boolean IS
373:
374: l_err_code varchar2(600):= '0';
375: l_err_stack varchar2(600);
376: l_err_stage varchar2(600);