1 PACKAGE eam_asset_move_util AUTHID CURRENT_USER AS
2 /* $Header: EAMAMUTS.pls 120.4.12010000.2 2008/10/20 10:55:10 vchidura ship $ */
3
4 -- validate whether an asset under context can be moved or not (before Asset Move UI is thrown)
5 -- Also called by isValidAssetMove() which will be called for a list of asset records
6
7 Procedure isValidMove(
8 p_instance_id IN NUMBER,
9 p_transaction_date IN DATE DEFAULT SYSDATE,
10 p_inventory_item_id IN NUMBER,
11 p_curr_org_id IN NUMBER,
12 x_return_status IN OUT NOCOPY varchar2,
13 x_return_message OUT NOCOPY varchar2
14 );
15
16 Procedure isValidAssetMove(
17 p_asset_hierarchy_REC IN eam_asset_move_pub.asset_move_hierarchy_REC_TYPE,
18 p_dest_org_id IN NUMBER,
19 p_counter IN NUMBER,
20 x_return_status OUT NOCOPY varchar2,
21 x_return_message OUT NOCOPY varchar2
22 );
23
24 -- isOpenPeriod(sysdate) as sysdate is passed as the transaction date
25 FUNCTION isOpenPeriod(
26 p_organization_id IN NUMBER,
27 p_transaction_date IN DATE
28 )
29 RETURN BOOLEAN;
30
31 -- isTransactable(inventory_item_id,org_id)
32 FUNCTION isTransactable(
33 p_inventory_item_id IN NUMBER
34 ,p_organization_id IN NUMBER
35 )
36 RETURN BOOLEAN;
37
38 -- hasSubInventory(instance_id)
39 FUNCTION hasSubInventory(
40 p_instance_id IN NUMBER
41 )
42 RETURN BOOLEAN;
43
44 -- isLocated(instance_id) --assets in location
45 FUNCTION isLocated(
46 p_instance_id IN NUMBER
47 )
48 RETURN BOOLEAN;
49
50 -- isInTransit(instance_id)
51 FUNCTION isInTransit(
52 p_instance_id IN NUMBER
53 )
54 RETURN BOOLEAN;
55
56 -- isAssetRoute(instance_id)
57 FUNCTION isAssetRoute(
58 p_instance_id IN NUMBER
59 )
60 RETURN BOOLEAN;
61
62 -- hasProdEquipLink(instance_id)
63 FUNCTION hasProdEquipLink(
64 p_instance_id IN NUMBER
65 )
66 RETURN BOOLEAN;
67
68 -- hasPropMngrLink(instance_id)
69 FUNCTION hasPropMngrLink(
70 p_instance_id IN NUMBER
71 )
72 RETURN BOOLEAN;
73
74 -- isInMaintOrg(instance_id,org_id)
75 -- Assets in Diff Maint Org
76 -- Assets in Diff Prod Org which are not maintained by the current parent maint_org_id
77 FUNCTION isInMaintOrg(
78 p_instance_id IN NUMBER
79 ,p_organization_id IN NUMBER
80 ,p_gen_object_id IN NUMBER
81 )
82 RETURN BOOLEAN;
83
84 -- for Inter Org Transfers
85
86 -- isItemAssigned(inventory_item_id, org_id);
87 FUNCTION isItemAssigned(
88 p_inventory_item_id IN NUMBER
89 ,p_organization_id IN NUMBER
90 )
91 RETURN BOOLEAN;
92
93 -- isUniqueShipmentNumber(shipment_number);
94 FUNCTION isUniqueShipmentNumber(
95 p_shipment_number IN VARCHAR2
96 )
97 RETURN boolean;
98
99 FUNCTION translate_message(
100 prod IN VARCHAR2
101 ,msg IN VARCHAR2
102 )
103 return VARCHAR2 ;
104
105
106
107 END eam_asset_move_util;