Assets Retirements API


FA_RETIREMENT_PUB
PROCEDURE do_retirement
   (p_api_version                in     NUMBER
   ,p_init_msg_list              in     VARCHAR2 := FND_API.G_FALSE
   ,p_commit                     in     VARCHAR2 := FND_API.G_FALSE
   ,p_validation_level           in     NUMBER   := FND_API.G_VALID_LEVEL_FULL
   ,p_calling_fn                   in     VARCHAR2
   ,x_return_status              out    NOCOPY VARCHAR2
   ,x_msg_count                  out    NOCOPY NUMBER
   ,x_msg_data                   out    NOCOPY VARCHAR2

   ,px_trans_rec                 in out NOCOPY FA_API_TYPES.trans_rec_type
   ,px_dist_trans_rec            in out NOCOPY FA_API_TYPES.trans_rec_type
   ,px_asset_hdr_rec             in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
   ,px_asset_retire_rec          in out NOCOPY FA_API_TYPES.asset_retire_rec_type
   ,p_asset_dist_tbl             in     FA_API_TYPES.asset_dist_tbl_type
   ,p_subcomp_tbl                in     FA_API_TYPES.subcomp_tbl_type
   ,p_inv_tbl                    in     FA_API_TYPES.inv_tbl_type );

PROCEDURE undo_retirement
   (p_api_version                in     NUMBER
   ,p_init_msg_list              in     VARCHAR2 := FND_API.G_FALSE
   ,p_commit                     in     VARCHAR2 := FND_API.G_FALSE
   ,p_validation_level           in     NUMBER   := FND_API.G_VALID_LEVEL_FULL
   ,p_calling_fn                 in     VARCHAR2
   ,x_return_status              out    NOCOPY VARCHAR2
   ,x_msg_count                  out    NOCOPY NUMBER
   ,x_msg_data                   out    NOCOPY VARCHAR2

   ,px_trans_rec                 in out NOCOPY FA_API_TYPES.trans_rec_type
   ,px_asset_hdr_rec             in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
   ,px_asset_retire_rec          in out NOCOPY FA_API_TYPES.asset_retire_rec_type
   );

Public Types
-- Main record type
TYPE asset_retire_rec_type IS RECORD (
        retirement_id                   NUMBER,
        date_retired                    DATE,
        units_retired                   NUMBER,
        cost_retired                    NUMBER,
        proceeds_of_sale                NUMBER,
        cost_of_removal                 NUMBER,
        retirement_type_code            VARCHAR2(15),
        retirement_prorate_convention   VARCHAR2(10),
        sold_to                         VARCHAR2(30),
        trade_in_asset_id               VARCHAR2(15),
        reference_num                   VARCHAR2(15),
        status                          VARCHAR2(15),
        recognize_gain_loss             VARCHAR2(30),
        recapture_reserve_flag          VARCHAR2(1),
        limit_proceeds_flag             VARCHAR2(1),
        terminal_gain_loss              VARCHAR2(30),
        reserve_retired                 NUMBER,
        eofy_reserve                    NUMBER,
        reduction_rate                  NUMBER,
        calculate_gain_loss             varchar2(1),
        detail_info                     asset_retire_det_rec_type,
        desc_flex                       desc_flex_rec_type
        );

Comments

Post a Comment

Popular posts from this blog

How to use lexical parameters in Data template (XML document) R12

Lexical parameters can be added in data definition using &variable name This is flexible variable string where you can execute runtime conditions based on user-inputs Example 1. Append &gc_journal_filter at the end of sql statement 2. Define beforereport function in package signature FUNCTION beforereport RETURN BOOLEAN; 3. Define all the report parameters as a package variable in package signature including lexical parameters 4. Implement beforereport function by building your runtime conditions to be added to SQL statements  FUNCTION beforereport RETURN BOOLEAN IS  BEGIN          IF p_journal_source IS NULL THEN       gc_journal_filter := ' AND jh.je_source IN (''AutoCopy'',''Manual'')';     END IF;          IF p_journal_category IS NULL THEN       gc_journal_filter := 'AND jh.je_category IN (''Other'') ';     END IF;    RETURN TRUE;  END;
Read more

Query to get FSG report details with row/column set

Below query is to fetch FSG report titles, names, and description along with will give a view to list of row sets and column sets associated with the report. -- FSG REPORTS -- SELECT fst.id_flex_structure_name , R.NAME , R.report_title , R.DESCRIPTION , R.column_set "COLUMN SET" , rw2.structure_id , rw2.DESCRIPTION "COL DESC" , R.row_set "ROW SET" , rw.DESCRIPTION "ROW DESC" , R.report_display_set "DISPLAY SET" , R.content_set "CONTENT SET" , R.row_order "ROW ORDER" , R.rounding_option "RND" , u.user_name , u.DESCRIPTION , R.creation_date FROM rg_reports_v R    , fnd_id_flex_structures_v fst    , fnd_user u    , rg_report_axis_sets_v rw    , rg_report_axis_sets_v rw2 WHERE r.structure_id = fst.id_flex_num AND R.row_set_id     = rw.axis_set_id AND r.column_set_id  = rw2.axis_set_id AND SUBSTR(fst.id_flex_structure_name,1,2) IN ('DC') AND R.created_by     = u.user_id OR
Read more

Sub Inventory Transfer API.

Image
Sub Inventory transfer is used to move materials from one sub-inventory to another within same organization. This is especially used to 1. Adjust on-hand quantities between sub-inventories 2. Transfer to another sub-inventories for specific business need like additional sales 3. Damages/expiry products can be moved to non-asset sub-inventories to discard it from inventory valuation report and so on., Key elements 1. From sub inventory 2. To sub inventory 3. Organization 4. Inventory item 5. Transact quantity 6. Transact unit of measure 7. Transaction type 8. Transaction action 9. Transact Reference 10. Transact date 11. Lot Number Open Interfaces mtl_transactions_interface - is used to populate sub inventory transfer details mtl_transaction_lots_interface - is used to populate lot details for particular sub inventory transfer Base Tables mtl_material_transactions - is used to get all type of material transactions like sub-inventory transfer, inter-org tra
Read more