DBA Data[Home] [Help]

APPS.FA_CUA_DERIVE_ASSET_ATTR_PKG dependencies on FA_CUA_ASSET_APIS

Line 65: x_err_stage:= 'Assigning fa_cua_asset_apis.G_multi_books_flg';

61: x_err_code:= '0';
62: v_old_err_stack := substr(x_err_stack, 1, 600 );
63: x_err_stack:= substr(x_err_stack, 1, 600)||'insert_mass_update_batch_hdrs';
64:
65: x_err_stage:= 'Assigning fa_cua_asset_apis.G_multi_books_flg';
66: if nvl(fa_cua_asset_apis.G_multi_books_flg, 'N') = 'Y' then
67: -- insert header info only for the corporate book
68: OPEN C1;
69: FETCH C1 into v_dummy;

Line 66: if nvl(fa_cua_asset_apis.G_multi_books_flg, 'N') = 'Y' then

62: v_old_err_stack := substr(x_err_stack, 1, 600 );
63: x_err_stack:= substr(x_err_stack, 1, 600)||'insert_mass_update_batch_hdrs';
64:
65: x_err_stage:= 'Assigning fa_cua_asset_apis.G_multi_books_flg';
66: if nvl(fa_cua_asset_apis.G_multi_books_flg, 'N') = 'Y' then
67: -- insert header info only for the corporate book
68: OPEN C1;
69: FETCH C1 into v_dummy;
70: CLOSE C1;

Line 485: fa_cua_asset_apis.g_asset_array(i).asset_id:= assets_attr_rec.asset_id;

481: x_asset_array(i).asset_key_ccid := assets_attr_rec.asset_key_ccid;
482: x_asset_array(i).serial_number := assets_attr_rec.serial_number;
483: x_asset_array(i).life_in_months := assets_attr_rec.life_in_months;
484: -- save assets to be used by tax books, if any
485: fa_cua_asset_apis.g_asset_array(i).asset_id:= assets_attr_rec.asset_id;
486: fa_cua_asset_apis.g_asset_array(i).rule_set_id:= assets_attr_rec.asset_id;
487: fa_cua_asset_apis.g_asset_array(i).parent_hierarchy_id_old:= assets_rec.parent_hierarchy_id;
488: end loop;
489: -- update the asset_parent with the new parent_id

Line 486: fa_cua_asset_apis.g_asset_array(i).rule_set_id:= assets_attr_rec.asset_id;

482: x_asset_array(i).serial_number := assets_attr_rec.serial_number;
483: x_asset_array(i).life_in_months := assets_attr_rec.life_in_months;
484: -- save assets to be used by tax books, if any
485: fa_cua_asset_apis.g_asset_array(i).asset_id:= assets_attr_rec.asset_id;
486: fa_cua_asset_apis.g_asset_array(i).rule_set_id:= assets_attr_rec.asset_id;
487: fa_cua_asset_apis.g_asset_array(i).parent_hierarchy_id_old:= assets_rec.parent_hierarchy_id;
488: end loop;
489: -- update the asset_parent with the new parent_id
490: update fa_asset_hierarchy

Line 487: fa_cua_asset_apis.g_asset_array(i).parent_hierarchy_id_old:= assets_rec.parent_hierarchy_id;

483: x_asset_array(i).life_in_months := assets_attr_rec.life_in_months;
484: -- save assets to be used by tax books, if any
485: fa_cua_asset_apis.g_asset_array(i).asset_id:= assets_attr_rec.asset_id;
486: fa_cua_asset_apis.g_asset_array(i).rule_set_id:= assets_attr_rec.asset_id;
487: fa_cua_asset_apis.g_asset_array(i).parent_hierarchy_id_old:= assets_rec.parent_hierarchy_id;
488: end loop;
489: -- update the asset_parent with the new parent_id
490: update fa_asset_hierarchy
491: set parent_hierarchy_id = x_parent_id_new

Line 496: for j in 1..fa_cua_asset_apis.g_asset_array.count LOOP

492: where asset_id = assets_rec.asset_id;
493: end loop;
494: elsif x_book_class = 'TAX' then
495: i:=0;
496: for j in 1..fa_cua_asset_apis.g_asset_array.count LOOP
497: for assets_attr_rec in C_asset_attr( fa_cua_asset_apis.g_asset_array(j).asset_id) LOOP
498: i:=i+1;
499: x_asset_array(i).parent_hierarchy_id:= x_parent_id_new;
500: x_asset_array(i).parent_hierarchy_id_old:= fa_cua_asset_apis.g_asset_array(j).parent_hierarchy_id;

Line 497: for assets_attr_rec in C_asset_attr( fa_cua_asset_apis.g_asset_array(j).asset_id) LOOP

493: end loop;
494: elsif x_book_class = 'TAX' then
495: i:=0;
496: for j in 1..fa_cua_asset_apis.g_asset_array.count LOOP
497: for assets_attr_rec in C_asset_attr( fa_cua_asset_apis.g_asset_array(j).asset_id) LOOP
498: i:=i+1;
499: x_asset_array(i).parent_hierarchy_id:= x_parent_id_new;
500: x_asset_array(i).parent_hierarchy_id_old:= fa_cua_asset_apis.g_asset_array(j).parent_hierarchy_id;
501: x_asset_array(i).rule_set_id := fa_cua_asset_apis.g_asset_array(j).rule_set_id;

Line 500: x_asset_array(i).parent_hierarchy_id_old:= fa_cua_asset_apis.g_asset_array(j).parent_hierarchy_id;

496: for j in 1..fa_cua_asset_apis.g_asset_array.count LOOP
497: for assets_attr_rec in C_asset_attr( fa_cua_asset_apis.g_asset_array(j).asset_id) LOOP
498: i:=i+1;
499: x_asset_array(i).parent_hierarchy_id:= x_parent_id_new;
500: x_asset_array(i).parent_hierarchy_id_old:= fa_cua_asset_apis.g_asset_array(j).parent_hierarchy_id;
501: x_asset_array(i).rule_set_id := fa_cua_asset_apis.g_asset_array(j).rule_set_id;
502: x_asset_array(i).asset_id := assets_attr_rec.asset_id;
503: x_asset_array(i).asset_category_id := assets_attr_rec.asset_category_id;
504: x_asset_array(i).lease_id := assets_attr_rec.lease_id;

Line 501: x_asset_array(i).rule_set_id := fa_cua_asset_apis.g_asset_array(j).rule_set_id;

497: for assets_attr_rec in C_asset_attr( fa_cua_asset_apis.g_asset_array(j).asset_id) LOOP
498: i:=i+1;
499: x_asset_array(i).parent_hierarchy_id:= x_parent_id_new;
500: x_asset_array(i).parent_hierarchy_id_old:= fa_cua_asset_apis.g_asset_array(j).parent_hierarchy_id;
501: x_asset_array(i).rule_set_id := fa_cua_asset_apis.g_asset_array(j).rule_set_id;
502: x_asset_array(i).asset_id := assets_attr_rec.asset_id;
503: x_asset_array(i).asset_category_id := assets_attr_rec.asset_category_id;
504: x_asset_array(i).lease_id := assets_attr_rec.lease_id;
505: x_asset_array(i).asset_key_ccid := assets_attr_rec.asset_key_ccid;