Need PL/SQL Script [message #641109] |
Mon, 10 August 2015 12:07 |
|
vharish006
Messages: 70 Registered: August 2015 Location: Chicago
|
Member |
|
|
HI All,
need to use below API.But as there are more than 100 values to pass as input
Parameters:
&Asset_id; and '&Book' (Common for all the asset_id) are the input which needs to be passed. I need to pass different Asset_Id values. Could you please let me know how can this be done or provide me a sample script??I'm not a technical person.
I have the Problematic Asset_id value which needs to be passed to the script.Please let me know how this can be achieved.
declare
fa_record fa_api_types.asset_hdr_rec_type;
l_return_status varchar2(1);
l_msg_count number:= 0;
l_msg_data varchar2(4000);
l_trans_rec fa_api_types.trans_rec_type;
l_dist_trans_rec fa_api_types.trans_rec_type;
l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
l_asset_desc_rec fa_api_types.asset_desc_rec_type;
l_asset_type_rec fa_api_types.asset_type_rec_type;
l_asset_cat_rec fa_api_types.asset_cat_rec_type;
l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
l_asset_fin_rec fa_api_types.asset_fin_rec_type;
l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
l_inv_tbl fa_api_types.inv_tbl_type;
l_inv_rate_tbl fa_api_types.inv_rate_tbl_type;
begin
fa_record.asset_id := &Asset_id;
fa_record.book_type_code := '&Book';
fa_addition_pub.do_addition (
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_calling_fn => NULL,
-- Transaction Object --
px_trans_rec => l_trans_rec,
px_dist_trans_rec => l_dist_trans_rec,
-- Asset Object --
px_asset_hdr_rec => fa_record,
px_asset_desc_rec => l_asset_desc_rec,
px_asset_type_rec => l_asset_type_rec,
px_asset_cat_rec => l_asset_cat_rec,
px_asset_hierarchy_rec => l_asset_hierarchy_rec,
px_asset_fin_rec => l_asset_fin_rec,
px_asset_deprn_rec => l_asset_deprn_rec,
px_asset_dist_tbl => l_asset_dist_tbl,
-- Invoice Object --
px_inv_tbl => l_inv_tbl);
-- px_inv_rate_tbl => l_inv_rate_tbl);
commit;
end;
/
Thanks In Advance
|
|
|
|
|
|
Re: Need PL/SQL Script [message #641117 is a reply to message #641112] |
Mon, 10 August 2015 13:51 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
Honestly? Sorry no. I think you/your employers need to be hiring someone who has the technical skills required to do this job. If the job you have taken on requires you to work with sql and pl/sql then it appears that you have taken the job under false pretences. If your bosses are giving you tasks that are not under your remit, then you should be pushing back and telling them to hire someone with the requisite skills as this is not your job to perform these tasks. I personally, am not comfortable writing code for someone to allow them to do a job that they should not be doing. I have no doubt that someone will end up doing this for you, and I wish you luck in finding your answer, but this isn't something that I'm comfortable with, not least of all because it takes work away from people who have worked to gain the skills required to perform such tasks. Sorry.
|
|
|
|