1 package EAM_CAP_MAIN_COST_PVT as
2 /* $Header: EAMCOMCS.pls 120.2.12010000.3 2008/11/20 02:16:16 lakmohan ship $ */
3
4 g_pkg_name varchar2(30) := 'EAM_CAP_MAIN_COST_PVT';
5
6 -- Name : EAM Work Order Bills Rec
7 -- Description : Information from the form to initiate the capitalization
8
9 TYPE EAM_WO_BILLS_REC IS RECORD
10 ( ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
11 WIP_ENTITY_ID NUMBER := FND_API.G_MISS_NUM,
12 OPERATION_SEQ_NUM NUMBER := FND_API.G_MISS_NUM,
13 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
14 BILLED_INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
15 BILLED_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
16 BILLED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17 BILLED_AMOUNT NUMBER := FND_API.G_MISS_NUM,
18 COST_OR_LISTPRICE NUMBER := FND_API.G_MISS_NUM,
19 TOTAL_COST NUMBER := FND_API.G_MISS_NUM,
20 COSTPLUS_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
21 REBUILD_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
22 ASSET_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
23 ASSET_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR, --for bug 7109827
24 REBUILD_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR, --for bug 7109827
25 COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
26 OFFSET_ACCOUNT_CCID NUMBER := FND_API.G_MISS_NUM
27 );
28 TYPE EAM_WO_BILLS_TBL is TABLE OF EAM_WO_BILLS_REC INDEX BY BINARY_INTEGER;
29
30
31 PROCEDURE initiate_capitalization (p_eam_wo_bills_tbl IN eam_cap_main_cost_pvt.eam_wo_bills_tbl,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_data OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER);
35
36 FUNCTION get_fa_book_cost (l_asset_id IN NUMBER,
37 l_book_type_code IN VARCHAR2) RETURN NUMBER;
38
39 FUNCTION get_book_type (l_org_id IN NUMBER) RETURN VARCHAR2;
40
41 FUNCTION get_asset_category_id (l_inventory_item_id IN NUMBER,
42 l_org_id IN NUMBER) RETURN NUMBER;
43
44 END EAM_CAP_MAIN_COST_PVT;