APPS.AMS_IBA_PL_SITES_B_PKG dependencies on AMS_IBA_PL_SITES_B

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 59: INSERT INTO ams_iba_pl_sites_b(

55:
56: px_object_version_number := 1;
57:
58:
59: INSERT INTO ams_iba_pl_sites_b(
60: site_id,
61: site_ref_code,
62: site_category_type,
63: site_category_object_id,

Line 151: UPDATE ams_iba_pl_sites_b

147: IF (AMS_DEBUG_HIGH_ON) THEN
148:
149: AMS_UTILITY_PVT.debug_message('table handler : before update site_id = ' || p_site_id );
150: END IF;
151: UPDATE ams_iba_pl_sites_b
152: SET
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 205: DELETE FROM ams_iba_pl_sites_b

201: IF (AMS_DEBUG_HIGH_ON) THEN
202:
203: AMS_UTILITY_PVT.debug_message('table handler : before delete of b; site_id = ' || p_site_id || ' object_version_num = ' || p_object_version_number);
204: END IF;
205: DELETE FROM ams_iba_pl_sites_b
206: WHERE site_id = p_site_id
207: AND object_version_number = p_object_version_number;
208:
209: IF (AMS_DEBUG_HIGH_ON) THEN

Line 236: from AMS_IBA_PL_SITES_B B

232: begin
233: delete from AMS_IBA_PL_SITES_TL T
234: where not exists
235: (select NULL
236: from AMS_IBA_PL_SITES_B B
237: where B.SITE_ID = T.SITE_ID
238: );
239:
240: update AMS_IBA_PL_SITES_TL T set (

Line 333: FROM AMS_IBA_PL_SITES_B

329:
330: IS
331: CURSOR C IS
332: SELECT *
333: FROM AMS_IBA_PL_SITES_B
334: WHERE SITE_ID = p_SITE_ID
335: FOR UPDATE of SITE_ID NOWAIT;
336: Recinfo C%ROWTYPE;
337: BEGIN

Line 445: from ams_iba_pl_sites_b

441: l_db_luby_id number;
442:
443: /* cursor c_obj_verno is
444: select object_version_number
445: from ams_iba_pl_sites_b
446: where site_id = x_site_id;*/
447:
448: cursor c_db_data_details is
449: select last_updated_by, nvl(object_version_number,1)

Line 450: from ams_iba_pl_sites_b

446: where site_id = x_site_id;*/
447:
448: cursor c_db_data_details is
449: select last_updated_by, nvl(object_version_number,1)
450: from ams_iba_pl_sites_b
451: where site_id = x_site_id;
452:
453: cursor c_chk_site_exists is
454: select 'x'

Line 455: from ams_iba_pl_sites_b

451: where site_id = x_site_id;
452:
453: cursor c_chk_site_exists is
454: select 'x'
455: from ams_iba_pl_sites_b
456: where site_id = x_site_id;
457:
458: cursor c_get_site_id is
459: select ams_iba_pl_sites_b_s.nextval

Line 459: select ams_iba_pl_sites_b_s.nextval

455: from ams_iba_pl_sites_b
456: where site_id = x_site_id;
457:
458: cursor c_get_site_id is
459: select ams_iba_pl_sites_b_s.nextval
460: from dual;
461: BEGIN
462: if X_OWNER = 'SEED' then
463: l_user_id := 1;

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;