APPS.AMS_COMPETITOR_PRODUCTS_B_PKG dependencies on AMS_COMPETITOR_PRODUCTS_B

Line 1: PACKAGE BODY AMS_COMPETITOR_PRODUCTS_B_PKG as

1: PACKAGE BODY AMS_COMPETITOR_PRODUCTS_B_PKG as
2: /* $Header: amstcprb.pls 120.3 2005/11/14 02:07:27 inanaiah ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_COMPETITOR_PRODUCTS_B_PKG

2: /* $Header: amstcprb.pls 120.3 2005/11/14 02:07:27 inanaiah ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_COMPETITOR_PRODUCTS_B_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

17: -- End of Comments
18: -- ===============================================================
19:
20:
21: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_COMPETITOR_PRODUCTS_B_PKG';
22: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstcprb.pls';
23:
24:
25: ----------------------------------------------------------

Line 90: INSERT INTO AMS_COMPETITOR_PRODUCTS_B(

86:
87: px_object_version_number := 1;
88:
89:
90: INSERT INTO AMS_COMPETITOR_PRODUCTS_B(
91: competitor_product_id,
92: object_version_number,
93: last_update_date,
94: last_updated_by,

Line 259: Update AMS_COMPETITOR_PRODUCTS_B

255: BEGIN
256:
257: AMS_UTILITY_PVT.debug_message('Pub update: start');
258:
259: Update AMS_COMPETITOR_PRODUCTS_B
260: SET
261: competitor_product_id = DECODE( p_competitor_product_id, FND_API.g_miss_num, null, null, competitor_product_id, p_competitor_product_id),
262: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, null, null, object_version_number, p_object_version_number),
263: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, to_date(null), to_date(null), last_update_date, p_last_update_date),

Line 340: DELETE FROM AMS_COMPETITOR_PRODUCTS_B

336: p_COMPETITOR_PRODUCT_ID NUMBER,
337: p_object_version_number NUMBER)
338: IS
339: BEGIN
340: DELETE FROM AMS_COMPETITOR_PRODUCTS_B
341: WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID
342: AND object_version_number = p_object_version_number;
343: If (SQL%NOTFOUND) then
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 485: from AMS_COMPETITOR_PRODUCTS_B B

481: begin
482: delete from AMS_COMPETITOR_PRODUCTS_TL T
483: where not exists
484: (select NULL
485: from AMS_COMPETITOR_PRODUCTS_B B
486: where B.competitor_product_id = T.competitor_product_id
487: );
488:
489: update AMS_COMPETITOR_PRODUCTS_TL T set (

Line 544: END AMS_COMPETITOR_PRODUCTS_B_PKG;

540:
541: end ADD_LANGUAGE;
542:
543:
544: END AMS_COMPETITOR_PRODUCTS_B_PKG;