1 PACKAGE EAM_ActivityAssociation_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVAAAS.pls 120.0.12020000.1 2012/06/27 12:21:31 appldev ship $ */
3
4 -- Start of comments
5 -- API name : Create_Association
6 -- Type : Private.
7 -- Function :
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN : p_api_version IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional
12 -- Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_validation_level IN NUMBER Optional
16 -- Default = FND_API.G_VALID_LEVEL_FULL
17 -- p_organization_id IN NUMBER,
18 -- p_inventory_item_id IN NUMBER, -- id of Asset Activity
19 -- p_wip_entity_id IN NUMBER, -- id of Work Order
20 -- p_association_copy_option IN VARCHAR2 := '2' -- 1 (NONE), 2 (CURRENT), OR 3 (ALL)
21 -- 3 (ALL) is only valid if source work order
22 -- has an activity specified.
23 --
24 -- OUT : x_return_status OUT VARCHAR2(1)
25 -- x_msg_count OUT NUMBER
26 -- x_msg_data OUT VARCHAR2(2000)
27 -- Version : Current version 1.0
28 -- Initial version 1.0
29 --
30 -- Notes : Associate Activity to (NONE/CURRENT/ALL) Asset Numbers linked to the Work Order.
31 --
32 -- End of comments
33 PROCEDURE Create_Association
34 ( p_api_version IN NUMBER ,
35 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
36 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
37 p_validation_level IN NUMBER :=
38 FND_API.G_VALID_LEVEL_FULL ,
39 x_return_status OUT NOCOPY VARCHAR2 ,
40 x_msg_count OUT NOCOPY NUMBER ,
41 x_msg_data OUT NOCOPY VARCHAR2 ,
42
43 p_target_org_id IN NUMBER, -- organzation Asset Activity is in
44 p_target_activity_id IN NUMBER, -- id of Asset Activity
45
46 -- If Copy Source is from Work Order, specify the Work_Entity_Id
47 p_wip_entity_id IN NUMBER := NULL, -- id of Work Order
48 -- If Copy Source is from another Activity, specify the Activity Id and Org Id
49 p_source_org_id IN NUMBER := NULL,
50 p_source_activity_id IN NUMBER := NULL,
51
52 p_association_copy_option IN NUMBER := 2, -- 1 (NONE), 2 (CURRENT), OR 3 (ALL)
53 -- 3 (ALL) is only valid if source work order
54 -- has an activity specified.
55 x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,
56 x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type
57
58 );
59
60
61 -- Start of comments
62 -- API name : Create_AssetNumberAssociation
63 -- Type : Private.
64 -- Function :
65 -- Pre-reqs : None.
66 -- Parameters :
67 -- IN : p_api_version IN NUMBER Required
68 -- p_init_msg_list IN VARCHAR2 Optional
69 -- Default = FND_API.G_FALSE
70 -- p_commit IN VARCHAR2 Optional
71 -- Default = FND_API.G_FALSE
72 -- p_validation_level IN NUMBER Optional
73 -- Default = FND_API.G_VALID_LEVEL_FULL
74 -- p_organization_id IN NUMBER, -- organzation Asset Activity is in
75 -- p_inventory_item_id IN NUMBER, -- id of Asset Activity
76 -- p_activity_association_tbl IN EAM_ActivityAssociation_PVT.Activity_Association_Tbl_Type
77
78 -- OUT : x_return_status OUT VARCHAR2(1)
79 -- x_msg_count OUT NUMBER
80 -- x_msg_data OUT VARCHAR2(2000)
81
82 -- Version : Current version 1.0
83 -- Initial version 1.0
84 --
85 -- Notes : Association Asset Activity to all Asset Numbers in p_activity_association_tbl.
86 --
87 -- End of comments
88 PROCEDURE Create_AssetNumberAssoc
89 ( p_api_version IN NUMBER ,
90 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
91 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
92 p_validation_level IN NUMBER :=
93 FND_API.G_VALID_LEVEL_FULL ,
94 x_return_status OUT NOCOPY VARCHAR2 ,
95 x_msg_count OUT NOCOPY NUMBER ,
96 x_msg_data OUT NOCOPY VARCHAR2 ,
97
98 p_activity_association_tbl IN EAM_Activity_PUB.Activity_Association_Tbl_Type,
99 x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type
100 );
101
102
103 PROCEDURE Inst_Activity_Template(
104 p_api_version IN NUMBER ,
105 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
106 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
107 p_validation_level IN NUMBER :=
108 FND_API.G_VALID_LEVEL_FULL ,
109 x_return_status OUT NOCOPY VARCHAR2 ,
110 x_msg_count OUT NOCOPY NUMBER ,
111 x_msg_data OUT NOCOPY VARCHAR2 ,
112
113 -- input: maintenance object (id and type)
114 p_maintenance_object_id IN NUMBER,
115 p_maintenance_object_type IN NUMBER, -- only supports type 1 (serial numbers) for now
116 -- output for activity association
117 x_activity_association_id_tbl OUT NOCOPY EAM_ObjectInstantiation_PUB.Association_Id_Tbl_Type
118
119 -- BUG: 3683229
120 ,p_class_code IN VARCHAR2
121 ,p_owning_department_id IN NUMBER
122 );
123
124
125 END EAM_ActivityAssociation_PVT;