APPS.AMS_COMPETITOR_PRODUCT_PVT dependencies on AMS_COMPETITOR_PRODUCTS_B

Line 54: SELECT AMS_COMPETITOR_PRODUCTS_B_s.NEXTVAL

50: l_COMPETITOR_PRODUCT_ID NUMBER;
51: l_dummy NUMBER;
52:
53: CURSOR c_id IS
54: SELECT AMS_COMPETITOR_PRODUCTS_B_s.NEXTVAL
55: FROM dual;
56:
57: CURSOR c_id_exists (l_id IN NUMBER) IS
58: SELECT 1

Line 59: FROM AMS_COMPETITOR_PRODUCTS_B

55: FROM dual;
56:
57: CURSOR c_id_exists (l_id IN NUMBER) IS
58: SELECT 1
59: FROM AMS_COMPETITOR_PRODUCTS_B
60: WHERE COMPETITOR_PRODUCT_ID = l_id;
61:
62: BEGIN
63: -- Standard Start of API savepoint

Line 144: -- Invoke table handler(AMS_COMPETITOR_PRODUCTS_B_PKG.Insert_Row)

140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142:
143:
144: -- Invoke table handler(AMS_COMPETITOR_PRODUCTS_B_PKG.Insert_Row)
145: AMS_COMPETITOR_PRODUCTS_B_PKG.Insert_Row(
146: px_competitor_product_id => l_competitor_product_id,
147: px_object_version_number => l_object_version_number,
148: p_last_update_date => SYSDATE,

Line 145: AMS_COMPETITOR_PRODUCTS_B_PKG.Insert_Row(

141: END IF;
142:
143:
144: -- Invoke table handler(AMS_COMPETITOR_PRODUCTS_B_PKG.Insert_Row)
145: AMS_COMPETITOR_PRODUCTS_B_PKG.Insert_Row(
146: px_competitor_product_id => l_competitor_product_id,
147: px_object_version_number => l_object_version_number,
148: p_last_update_date => SYSDATE,
149: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 268: FROM AMS_COMPETITOR_PRODUCTS_B

264:
265:
266: CURSOR c_get_ams_Comp_Product(competitor_product_id NUMBER) IS
267: SELECT *
268: FROM AMS_COMPETITOR_PRODUCTS_B
269: WHERE competitor_product_id = p_comp_prod_rec.competitor_product_id;
270:
271: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Ams_Comp_Product';
272: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 373: -- Invoke table handler(AMS_COMPETITOR_PRODUCTS_B_PKG.Update_Row)

369: END IF;
370:
371:
372:
373: -- Invoke table handler(AMS_COMPETITOR_PRODUCTS_B_PKG.Update_Row)
374: AMS_COMPETITOR_PRODUCTS_B_PKG.Update_Row(
375: p_competitor_product_id => p_comp_prod_rec.competitor_product_id
376: , p_object_version_number => p_comp_prod_rec.object_version_number,
377: p_last_update_date => SYSDATE,

Line 374: AMS_COMPETITOR_PRODUCTS_B_PKG.Update_Row(

370:
371:
372:
373: -- Invoke table handler(AMS_COMPETITOR_PRODUCTS_B_PKG.Update_Row)
374: AMS_COMPETITOR_PRODUCTS_B_PKG.Update_Row(
375: p_competitor_product_id => p_comp_prod_rec.competitor_product_id
376: , p_object_version_number => p_comp_prod_rec.object_version_number,
377: p_last_update_date => SYSDATE,
378: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 533: -- Invoke table handler(AMS_COMPETITOR_PRODUCTS_B_PKG.Delete_Row)

529:
530: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
531: END IF;
532:
533: -- Invoke table handler(AMS_COMPETITOR_PRODUCTS_B_PKG.Delete_Row)
534: AMS_COMPETITOR_PRODUCTS_B_PKG.Delete_Row(
535: p_COMPETITOR_PRODUCT_ID => p_COMPETITOR_PRODUCT_ID,
536: p_Object_Version_number => p_object_version_number
537: );

Line 534: AMS_COMPETITOR_PRODUCTS_B_PKG.Delete_Row(

530: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
531: END IF;
532:
533: -- Invoke table handler(AMS_COMPETITOR_PRODUCTS_B_PKG.Delete_Row)
534: AMS_COMPETITOR_PRODUCTS_B_PKG.Delete_Row(
535: p_COMPETITOR_PRODUCT_ID => p_COMPETITOR_PRODUCT_ID,
536: p_Object_Version_number => p_object_version_number
537: );
538: --

Line 625: FROM AMS_COMPETITOR_PRODUCTS_B

621: l_COMPETITOR_PRODUCT_ID NUMBER;
622:
623: CURSOR c_Ams_Comp_Product IS
624: SELECT COMPETITOR_PRODUCT_ID
625: FROM AMS_COMPETITOR_PRODUCTS_B
626: WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID
627: AND object_version_number = p_object_version
628: FOR UPDATE NOWAIT;
629:

Line 869: 'AMS_COMPETITOR_PRODUCTS_B',

865: BEGIN
866: x_return_status := FND_API.g_ret_sts_success;
867: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
868: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
869: 'AMS_COMPETITOR_PRODUCTS_B',
870: 'competitor_product_id = '|| p_comp_prod_rec.competitor_product_id
871: );
872: ELSE
873: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 874: 'AMS_COMPETITOR_PRODUCTS_B',

870: 'competitor_product_id = '|| p_comp_prod_rec.competitor_product_id
871: );
872: ELSE
873: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
874: 'AMS_COMPETITOR_PRODUCTS_B',
875: 'competitor_product_id = ''' || p_comp_prod_rec.competitor_product_id ||
876: ''' AND competitor_product_id <> ' || p_comp_prod_rec.competitor_product_id
877: );
878: END IF;