eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.EAM_ACTIVITYSUPN_PUB

Source


1 PACKAGE EAM_ActivitySupn_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPASRS.pls 120.0 2005/05/25 15:38:49 appldev noship $ */
3 /*#
4  * This package is used for the INSERT / UPDATE of suppression relationships of the asset activity associations.
5  * It defines 2 key procedures insert_activitysupn, update_activitysupn
6  * which first validates and massages the IN parameters
7  * and then carries out the respective operations.
8  * @rep:scope public
9  * @rep:product EAM
10  * @rep:lifecycle active
11  * @rep:displayname Activity Suppression
12  * @rep:category BUSINESS_ENTITY EAM_ASSET_ACTIVITY_SUPPRESSION
13  */
14 
15 
16 	G_PKG_NAME 	CONSTANT VARCHAR2(30):='EAM_ActivitySupn_PUB';
17 
18 
19 /*#
20  * This procedure is used to insert records in EAM_SUPPRESSION_RELATIONS.
21  * It is used to create Activity Suppression.
22  * @param p_api_version  Version of the API
23  * @param p_init_msg_list Flag to indicate initialization of message list
24  * @param p_commit Flag to indicate whether API should commit changes
25  * @param p_validation_level Validation Level of the API
26  * @param x_return_status Return status of the procedure call
27  * @param x_msg_count Count of the return messages that API returns
28  * @param x_msg_data The collection of the messages.
29 * @param p_parent_association_id Parent (suppressing) Activity Association Identifier
30 * @param p_child_association_id Child (suppressed) Activity Association Identifier
31 * @param p_tmpl_flag Flag indicating suppression of type template
32 * @param p_description Description text
33 * @param p_attribute_category Attribute Category
34 * @param p_attribute1 Descriptive flexfield column
35 * @param p_attribute2 Descriptive flexfield column
36 * @param p_attribute3 Descriptive flexfield column
37 * @param p_attribute4 Descriptive flexfield column
38 * @param p_attribute5 Descriptive flexfield column
39 * @param p_attribute6 Descriptive flexfield column
40 * @param p_attribute7 Descriptive flexfield column
41 * @param p_attribute8 Descriptive flexfield column
42 * @param p_attribute9 Descriptive flexfield column
43 * @param p_attribute10 Descriptive flexfield column
44 * @param p_attribute11 Descriptive flexfield column
45 * @param p_attribute12 Descriptive flexfield column
46 * @param p_attribute13 Descriptive flexfield column
47 * @param p_attribute14 Descriptive flexfield column
48 * @param p_attribute15 Descriptive flexfield column
49  * @return Returns the status of the procedure call as well as the return messages
50  * @rep:scope public
51  * @rep:displayname Create Activity Suppression
52  */
53 
54 PROCEDURE Insert_ActivitySupn
55 (
56 	p_api_version		IN	NUMBER			,
57 	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE	,
58 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE	,
59 	p_validation_level	IN  	NUMBER   := FND_API.G_VALID_LEVEL_FULL,
60 	x_return_status		OUT	NOCOPY VARCHAR2	,
61 	x_msg_count		OUT	NOCOPY NUMBER	,
62 	x_msg_data		OUT	NOCOPY VARCHAR2	,
63 	p_parent_association_id IN	NUMBER    ,
64 	p_child_association_id  IN	NUMBER    ,
65 	p_tmpl_flag		IN	VARCHAR2 DEFAULT NULL,
66 	p_description		IN	VARCHAR2 DEFAULT NULL,
67 	p_attribute_category    IN	VARCHAR2 DEFAULT NULL,
68 	p_attribute1            IN	VARCHAR2 DEFAULT NULL,
69 	p_attribute2            IN	VARCHAR2 DEFAULT NULL,
70 	p_attribute3            IN	VARCHAR2 DEFAULT NULL,
71 	p_attribute4            IN	VARCHAR2 DEFAULT NULL,
72 	p_attribute5            IN	VARCHAR2 DEFAULT NULL,
73 	p_attribute6            IN	VARCHAR2 DEFAULT NULL,
74 	p_attribute7            IN	VARCHAR2 DEFAULT NULL,
75 	p_attribute8            IN	VARCHAR2 DEFAULT NULL,
76 	p_attribute9            IN	VARCHAR2 DEFAULT NULL,
77 	p_attribute10           IN	VARCHAR2 DEFAULT NULL,
78 	p_attribute11           IN	VARCHAR2 DEFAULT NULL,
79 	p_attribute12           IN	VARCHAR2 DEFAULT NULL,
80 	p_attribute13           IN	VARCHAR2 DEFAULT NULL,
81 	p_attribute14           IN	VARCHAR2 DEFAULT NULL,
82 	p_attribute15           IN	VARCHAR2 DEFAULT NULL
83 );
84 
85 
86 /*#
87  * This procedure is used to update the existing records in EAM_SUPPRESSION_RELATIONS .
88  * It is used to update Activity Suppression.
89  * @param p_api_version  Version of the API
90  * @param p_init_msg_list Flag to indicate initialization of message list
91  * @param p_commit Flag to indicate whether API should commit changes
92  * @param p_validation_level Validation Level of the API
93  * @param x_return_status Return status of the procedure call
94  * @param x_msg_count Count of the return messages that API returns
95  * @param x_msg_data The collection of the messages.
96  * @param p_parent_association_id Parent (suppressing) Activity Association Identifier
97 * @param p_child_association_id Child (suppressed) Activity Association Identifier
98 * @param p_tmpl_flag Flag indicating suppression of type template
99 * @param p_description Description text
100 * @param p_attribute_category Attribute Category
101 * @param p_attribute1 Descriptive flexfield column
102 * @param p_attribute2 Descriptive flexfield column
103 * @param p_attribute3 Descriptive flexfield column
104 * @param p_attribute4 Descriptive flexfield column
105 * @param p_attribute5 Descriptive flexfield column
106 * @param p_attribute6 Descriptive flexfield column
107 * @param p_attribute7 Descriptive flexfield column
108 * @param p_attribute8 Descriptive flexfield column
109 * @param p_attribute9 Descriptive flexfield column
110 * @param p_attribute10 Descriptive flexfield column
111 * @param p_attribute11 Descriptive flexfield column
112 * @param p_attribute12 Descriptive flexfield column
113 * @param p_attribute13 Descriptive flexfield column
114 * @param p_attribute14 Descriptive flexfield column
115 * @param p_attribute15 Descriptive flexfield column
116  * @return Returns the status of the procedure call as well as the return messages
117  * @rep:scope public
118  * @rep:displayname Update Activity Suppression
119  */
120 
121 PROCEDURE Update_ActivitySupn
122 (
123 	p_api_version		IN	NUMBER			,
124 	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE	,
125 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE	,
126 	p_validation_level	IN  	NUMBER   := FND_API.G_VALID_LEVEL_FULL,
127 	x_return_status		OUT	NOCOPY  VARCHAR2 ,
128 	x_msg_count		OUT	NOCOPY  NUMBER	  ,
129 	x_msg_data		OUT	NOCOPY  VARCHAR2 ,
130 	p_parent_association_id IN	NUMBER    ,
131 	p_child_association_id  IN	NUMBER    ,
132 	p_tmpl_flag		IN	VARCHAR2 DEFAULT NULL,
133 	p_description		IN	VARCHAR2 DEFAULT NULL,
134 	p_attribute_category	IN	VARCHAR2 DEFAULT NULL,
135 	p_attribute1		IN	VARCHAR2 DEFAULT NULL,
136 	p_attribute2		IN	VARCHAR2 DEFAULT NULL,
137 	p_attribute3		IN	VARCHAR2 DEFAULT NULL,
138 	p_attribute4		IN	VARCHAR2 DEFAULT NULL,
139 	p_attribute5		IN	VARCHAR2 DEFAULT NULL,
140 	p_attribute6		IN	VARCHAR2 DEFAULT NULL,
141 	p_attribute7		IN	VARCHAR2 DEFAULT NULL,
142 	p_attribute8		IN	VARCHAR2 DEFAULT NULL,
143 	p_attribute9		IN	VARCHAR2 DEFAULT NULL,
144 	p_attribute10		IN	VARCHAR2 DEFAULT NULL,
145 	p_attribute11		IN	VARCHAR2 DEFAULT NULL,
146 	p_attribute12		IN	VARCHAR2 DEFAULT NULL,
147 	p_attribute13		IN	VARCHAR2 DEFAULT NULL,
148 	p_attribute14		IN	VARCHAR2 DEFAULT NULL,
149 	p_attribute15		IN	VARCHAR2 DEFAULT NULL
150 );
151 
152 /* EAM_ASSETATTR_GRP_PUB.VALIDATE_EAM_ENABLED (p_organization_id) */
153 
154 /* EAM_ASSETATTR_GRP_PUB.VALIDATE_ITEM_ID (p_asset_group_id,p_organization_id) */
155 
156 /* organization is eam enabled */
157 FUNCTION Validate_EamEnabled (p_organization_id NUMBER)
158 	RETURN boolean;
159 
160 
161 /* CHECK THE SUPPRESSION RECORD EXISTS, FOR UPDATE CASE */
162 FUNCTION Validate_SuppressionRecord (p_parent_association_id NUMBER,
163 					p_child_association_id NUMBER)
164 	RETURN boolean;
165 
166 
167 /* CHECK THE PARENT ASSOCIATION ID AND CHILD ASSOCIATION ID SHOULD NOT INTERCHANGE */
168 FUNCTION Validate_ParentChildAssets (p_parent_association_id NUMBER,
169 					p_child_association_id NUMBER)
170 	RETURN boolean;
171 
172 
173 /* For checking the association_id exists in the mtl_eam_asset_activities table */
174 FUNCTION Validate_AssociationId (p_association_id NUMBER)
175 	RETURN boolean;
176 
177 /* For checking the asset/item is the same for both parent and child activity association */
178 FUNCTION Validate_MaintainedObjUnique (p_parent_association_id NUMBER,
179 					p_child_association_id number,
180 					p_tmpl_flag varchar2)
181 	RETURN boolean;
182 
183 PROCEDURE RAISE_ERROR (ERROR VARCHAR2);
184 PROCEDURE PRINT_LOG(info varchar2);
185 
186 END EAM_ActivitySupn_PUB;