DBA Data[Home] [Help]

APPS.AMS_WEB_CITEM_ASSOC_PKG dependencies on AMS_WEB_CITEM_ASSOC_PKG

Line 1: PACKAGE BODY AMS_WEB_CITEM_ASSOC_PKG as

1: PACKAGE BODY AMS_WEB_CITEM_ASSOC_PKG as
2: /* $Header: amstwmpb.pls 120.0 2005/07/01 03:56:14 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_WEB_CITEM_ASSOC_PKG

2: /* $Header: amstwmpb.pls 120.0 2005/07/01 03:56:14 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_WEB_CITEM_ASSOC_PKG
7: -- Purpose
8: -- Table api to insert/update/delete WebPlanner Citems Associations..
9: -- History
10: -- 10-May-2005 sikalyan Created.

Line 16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_WEB_CITEM_ASSOC_PKG';

12: --
13: -- End of Comments
14: -- ===============================================================
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_WEB_CITEM_ASSOC_PKG';
17: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstwmpb.pls';
18:
19: -- ========================================================
20: --

Line 318: AMS_WEB_CITEM_ASSOC_PKG.Insert_Row (

314: l_placement_citem_id := x_placement_citem_id;
315: end if;
316: l_obj_verno := 1;
317:
318: AMS_WEB_CITEM_ASSOC_PKG.Insert_Row (
319: px_placement_citem_id => l_placement_citem_id,
320: p_placement_mp_id => x_placement_mp_id,
321: p_content_item_id => x_content_item_id,
322: p_citem_version_id => x_citem_version_id,

Line 340: AMS_WEB_CITEM_ASSOC_PKG.Update_Row (

336: close c_db_data_details;
337:
338: if (l_db_luby_id IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
339: then
340: AMS_WEB_CITEM_ASSOC_PKG.Update_Row (
341: p_placement_citem_id => l_placement_citem_id,
342: p_placement_mp_id => x_placement_mp_id ,
343: p_content_item_id => x_content_item_id,
344: p_citem_version_id => x_citem_version_id,

Line 357: END AMS_WEB_CITEM_ASSOC_PKG;

353: end if;
354: close c_chk_plce_citem_id_exists;
355: END load_row;
356:
357: END AMS_WEB_CITEM_ASSOC_PKG;