APPS.AMS_IBA_PL_SITES_B_PKG dependencies on AMS_IBA_PL_SITES_B_PKG

Line 1: PACKAGE BODY AMS_IBA_PL_SITES_B_PKG as

1: PACKAGE BODY AMS_IBA_PL_SITES_B_PKG as
2: /* $Header: amstsitb.pls 115.18 2003/03/12 00:28:51 ryedator ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_IBA_PL_SITES_B_PKG

2: /* $Header: amstsitb.pls 115.18 2003/03/12 00:28:51 ryedator ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_IBA_PL_SITES_B_PKG
7: -- Purpose
8: -- Table api to insert/update/delete iMarketing Sites.
9: -- History
10: -- 18-Apr-2000 sodixit Created.

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

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

Line 482: AMS_IBA_PL_SITES_B_PKG.Insert_Row (

478: l_site_id := x_site_id;
479: end if;
480: l_obj_verno := 1;
481:
482: AMS_IBA_PL_SITES_B_PKG.Insert_Row (
483: px_site_id => l_site_id,
484: p_site_ref_code => x_site_ref_code,
485: p_site_category_type => x_site_ctgy_type,
486: p_site_category_object_id => x_site_ctgy_obj_id,

Line 504: AMS_IBA_PL_SITES_B_PKG.UPDATE_ROW (

500: close c_db_data_details;
501:
502: if (l_db_luby_id IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
503: then
504: AMS_IBA_PL_SITES_B_PKG.UPDATE_ROW (
505: p_site_id => x_site_id,
506: p_site_ref_code => x_site_ref_code,
507: p_site_category_type => x_site_ctgy_type,
508: p_site_category_object_id => x_site_ctgy_obj_id,

Line 524: END AMS_IBA_PL_SITES_B_PKG;

520: end if;
521: close c_chk_site_exists;
522: END load_row;
523:
524: END AMS_IBA_PL_SITES_B_PKG;