PACKAGE: APPS.IGI_IAC_REVAL_CRUD

Source

1 PACKAGE IGI_IAC_REVAL_CRUD AS
2 -- $Header: igiiards.pls 120.4.12000000.3 2007/10/22 06:27:51 npandya ship $
3 
4 l_rec igi_iac_revaluation_rates%rowtype;  -- create this for quicker access via sql navigator
5 
6 function create_exceptions
7     ( fp_reval_exceptions    in out NOCOPY IGI_IAC_TYPES.iac_reval_exception_line
8     , fp_revaluation_id      in     NUMBER
9     )
10 return boolean;
11 
12 function create_txn_headers
13     ( fp_reval_params    in out NOCOPY IGI_IAC_TYPES.iac_reval_params
14     , fp_second_set      in boolean default false )
15 return boolean;
16 
17 function create_asset_balances
18     ( fp_reval_params    in out NOCOPY IGI_IAC_TYPES.iac_reval_params
19      , fp_second_set     in boolean default false )
20 return boolean;
21 
22 function create_det_balances
23     ( fp_reval_params    in out NOCOPY IGI_IAC_TYPES.iac_reval_params
24     , fp_second_set      in boolean default false
25      )
26 return boolean;
27 
28 function create_reval_rates
29     ( fp_reval_params    in out NOCOPY IGI_IAC_TYPES.iac_reval_params
30     , fp_second_set      in boolean default false  )
31 return boolean;
32 
33 function update_reval_rates ( fp_adjustment_id in number )
34 return boolean;
35 
36 function crud_iac_tables
37      ( fp_reval_params   in out NOCOPY IGI_IAC_TYPES.iac_reval_params
38       , fp_second_set    in boolean default false )
39 return boolean ;
40 
41 function reval_status_to_previewed
42      ( fp_reval_id       in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE  )
43 return boolean ;
44 
45 function reval_status_to_failed_pre
46      ( fp_reval_id       in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
47 return boolean ;
48 
49 function reval_status_to_completed
50      ( fp_reval_id       in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE,
51        p_event_id      in number)
52 return boolean ;
53 
54 function reval_status_to_failed_run
55      ( fp_reval_id       in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
56 return boolean ;
57 
58 function adjustment_status_to_run
59      ( fp_reval_id       in  IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
60      , fp_asset_id       in  IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
61      )
62 return boolean ;
63 
64 function update_balances
65      ( fp_reval_id       in  IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
66      , fp_asset_id       in  IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
67      , fp_period_counter in IGI_IAC_TRANSACTION_HEADERS.PERIOD_COUNTER%TYPE
68      , fp_book_type_code in IGI_IAC_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE
69      )
70 return boolean ;
71 
72 function allow_transfer_to_gl
73      ( fp_reval_id       in  IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
74      , fp_book_type_code in  IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
75      , fp_asset_id       in  IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
76      )
77 return boolean
78 ;
79 
80 function stamp_sla_event
81      ( fp_reval_id       in  IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
82      , fp_book_type_code in  IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
83      , fp_event_id       in  IGI_IAC_REVALUATIONS.EVENT_ID%TYPE
84      )
85 return boolean;
86 
87 END;