APPS.AMS_COMPETITOR_PRODUCT_PVT dependencies on AMS_COMPETITOR_PRODUCT_PVT

Line 1: PACKAGE BODY Ams_Competitor_Product_Pvt as

1: PACKAGE BODY Ams_Competitor_Product_Pvt as
2: /* $Header: amsvcprb.pls 120.1 2005/08/04 08:24:57 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- Ams_Competitor_Product_Pvt

2: /* $Header: amsvcprb.pls 120.1 2005/08/04 08:24:57 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- Ams_Competitor_Product_Pvt
7: -- Purpose
8: --
9: -- History
10: -- 01-Oct-2001 musman created

Line 21: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Ams_Competitor_Product_Pvt';

17: -- End of Comments
18: -- ===============================================================
19:
20:
21: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Ams_Competitor_Product_Pvt';
22: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvcprb.pls';
23:
24:
25: -- Hint: Primary key needs to be returned.

Line 277: l_tar_comp_prod_type_rec Ams_Competitor_Product_Pvt.comp_prod_rec_type := p_comp_prod_rec;

273: -- Local Variables
274: l_object_version_number NUMBER;
275: l_COMPETITOR_PRODUCT_ID NUMBER;
276: l_ref_comp_prod_rec c_get_Ams_Comp_Product%ROWTYPE ;
277: l_tar_comp_prod_type_rec Ams_Competitor_Product_Pvt.comp_prod_rec_type := p_comp_prod_rec;
278: l_rowid ROWID;
279:
280: BEGIN
281: -- Standard Start of API savepoint

Line 322: p_token_value => 'Ams_Competitor_Product_Pvt') ;

318:
319: If ( c_get_Ams_Comp_Product%NOTFOUND) THEN
320: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
321: p_token_name => 'INFO',
322: p_token_value => 'Ams_Competitor_Product_Pvt') ;
323: RAISE FND_API.G_EXC_ERROR;
324: END IF;
325: -- Debug Message
326: IF (AMS_DEBUG_HIGH_ON) THEN

Line 344: p_token_value => 'Ams_Competitor_Product_Pvt') ;

340: -- Check Whether record has been changed by someone else
341: If (l_tar_comp_prod_type_rec.object_version_number <> l_ref_comp_prod_rec.object_version_number) Then
342: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
343: p_token_name => 'INFO',
344: p_token_value => 'Ams_Competitor_Product_Pvt') ;
345: raise FND_API.G_EXC_ERROR;
346: End if;
347: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
348: THEN

Line 1185: l_comp_prod_rec_type_rec Ams_Competitor_Product_Pvt.comp_prod_rec_type;

1181: IS
1182: L_API_NAME CONSTANT VARCHAR2(50) := 'Validate_Ams_Comp_Product';
1183: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1184: l_object_version_number NUMBER;
1185: l_comp_prod_rec_type_rec Ams_Competitor_Product_Pvt.comp_prod_rec_type;
1186:
1187: BEGIN
1188: -- Standard Start of API savepoint
1189: SAVEPOINT VALIDATE_Ams_Comp_Product_;

Line 1304: End Ams_Competitor_Product_Pvt;

1300: p_data => x_msg_data
1301: );
1302: End Validate_comp_prod;
1303:
1304: End Ams_Competitor_Product_Pvt;