1 PACKAGE CST_MGD_INFL_ADJUSTMENT_PUB AUTHID CURRENT_USER AS
2 /* $Header: CSTPIADS.pls 120.1 2006/01/10 18:51:00 vjavli noship $ */
3
4 --===================
5 -- TYPES
6 --===================
7 TYPE Inflation_Adjustment_Rec_Type IS RECORD
8 ( country_code VARCHAR2(2)
9 , organization_id NUMBER
10 , acct_period_id NUMBER
11 , inventory_item_id NUMBER
12 , category_id NUMBER
13 , category_set_id NUMBER
14 , last_update_date DATE
15 , last_updated_by NUMBER
16 , creation_date DATE
17 , created_by NUMBER
18 , last_update_login NUMBER
19 , request_id NUMBER
20 , program_application_id NUMBER
21 , program_id NUMBER
22 , program_update_date DATE
23 , begin_qty NUMBER
24 , begin_cost NUMBER
25 , begin_inflation_adj NUMBER
26 , purchase_qty NUMBER
27 , purchase_cost NUMBER
28 , actual_qty NUMBER
29 , actual_cost NUMBER
30 , actual_inflation_adj NUMBER
31 , issue_qty NUMBER
32 , issue_cost NUMBER
33 , issue_inflation_adj NUMBER
34 , inventory_adj_acct_cr NUMBER
35 , inventory_adj_acct_dr NUMBER
36 , monetary_corr_acct_cr NUMBER
37 , sales_cost_acct_dr NUMBER
38 , Historical_Flag VARCHAR2(1)
39 , item_unit_cost NUMBER
40 );
41
42
43 --===================
44 -- PUBLIC PROCEDURES
45 --===================
46
47 --========================================================================
48 -- PROCEDURE : Create_Historical_Cost PUBLIC
49 -- PARAMETERS: p_api_version_number known api version error buffer
50 -- p_init_msg_list FND_API.G_TRUE to reset list
51 -- x_return_status return status
52 -- x_msg_count number of messages in the list
53 -- x_msg_data text of messages
54 -- p_historical_infl_adj_rec Historical data record
55 -- VERSION : current version 1.0
56 -- initial version 1.0
57 -- COMMENT : User use this API to create historical inflation
58 -- adjustment data
59 --========================================================================
60 PROCEDURE Create_Historical_Cost (
61 p_api_version_number IN NUMBER
62 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
63 , x_return_status OUT NOCOPY VARCHAR2
64 , x_msg_count OUT NOCOPY NUMBER
65 , x_msg_data OUT NOCOPY VARCHAR2
66 , p_historical_infl_adj_rec IN Inflation_Adjustment_Rec_Type
67 );
68
69
70 --========================================================================
71 -- PROCEDURE : Delete_All_Historical_Costs PUBLIC
72 -- PARAMETERS: p_api_version_number known api version error buffer
73 -- p_init_msg_list
74 -- x_return_status return status
75 -- x_msg_count number of messages in the list
76 -- x_msg_data text of messages
77 -- VERSION : current version 1.0
78 -- initial version 1.0
79 -- COMMENT : User use this API to refresh the inflation adjustment
80 -- process
81 --========================================================================
82 PROCEDURE Delete_All_Historical_Costs (
83 p_api_version_number IN NUMBER
84 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
85 , x_return_status OUT NOCOPY VARCHAR2
86 , x_msg_count OUT NOCOPY NUMBER
87 , x_msg_data OUT NOCOPY VARCHAR2
88 );
89
90
91 END CST_MGD_INFL_ADJUSTMENT_PUB;