APPS.AMS_IBA_PL_PAGES_B_PKG dependencies on AMS_IBA_PL_PAGES_B

Line 1: PACKAGE BODY AMS_IBA_PL_PAGES_B_PKG as

1: PACKAGE BODY AMS_IBA_PL_PAGES_B_PKG as
2: /* $Header: amstpagb.pls 115.11 2003/03/12 00:26:04 ryedator ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_IBA_PL_PAGES_B_PKG

2: /* $Header: amstpagb.pls 115.11 2003/03/12 00:26:04 ryedator ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_IBA_PL_PAGES_B_PKG
7: -- Purpose
8: -- Table api to insert/update/delete placement pages
9: -- History
10: --

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

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

Line 65: INSERT INTO AMS_IBA_PL_PAGES_B(

61:
62: AMS_UTILITY_PVT.debug_message( 'Table Handler : Just before insert');
63:
64: END IF;
65: INSERT INTO AMS_IBA_PL_PAGES_B(
66: page_id,
67: site_id,
68: site_ref_code,
69: page_ref_code,

Line 169: Update AMS_IBA_PL_PAGES_B

165: p_name VARCHAR2,
166: p_description VARCHAR2)
167: IS
168: BEGIN
169: Update AMS_IBA_PL_PAGES_B
170: SET
171: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
172: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
173: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),

Line 221: DELETE from ams_iba_pl_pages_b

217: -- ========================================================
218: PROCEDURE Delete_Row(p_page_id NUMBER)
219: IS
220: BEGIN
221: DELETE from ams_iba_pl_pages_b
222: WHERE PAGE_ID = p_page_id;
223:
224: IF (SQL%NOTFOUND) THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 245: from AMS_IBA_PL_PAGES_B B

241: begin
242: delete from AMS_IBA_PL_PAGES_TL T
243: where not exists
244: (select NULL
245: from AMS_IBA_PL_PAGES_B B
246: where B.PAGE_ID = T.PAGE_ID
247: );
248:
249: update AMS_IBA_PL_PAGES_TL T set (

Line 339: FROM AMS_IBA_PL_PAGES_B

335: )
336: IS
337: CURSOR C IS
338: SELECT *
339: FROM AMS_IBA_PL_PAGES_B
340: WHERE PAGE_ID = p_PAGE_ID
341: FOR UPDATE of PAGE_ID NOWAIT;
342: Recinfo C%ROWTYPE;
343: BEGIN

Line 451: from ams_iba_pl_pages_b

447:
448: /*
449: cursor c_obj_verno is
450: select object_version_number
451: from ams_iba_pl_pages_b
452: where page_id = x_page_id;
453: */
454: cursor c_db_data_details is
455: select last_updated_by, nvl(object_version_number,1)

Line 456: from ams_iba_pl_pages_b

452: where page_id = x_page_id;
453: */
454: cursor c_db_data_details is
455: select last_updated_by, nvl(object_version_number,1)
456: from ams_iba_pl_pages_b
457: where page_id = x_page_id;
458:
459: cursor c_chk_page_exists is
460: select 'x'

Line 461: from ams_iba_pl_pages_b

457: where page_id = x_page_id;
458:
459: cursor c_chk_page_exists is
460: select 'x'
461: from ams_iba_pl_pages_b
462: where page_id = x_page_id;
463:
464: cursor c_get_page_id is
465: select ams_iba_pl_pages_b_s.nextval

Line 465: select ams_iba_pl_pages_b_s.nextval

461: from ams_iba_pl_pages_b
462: where page_id = x_page_id;
463:
464: cursor c_get_page_id is
465: select ams_iba_pl_pages_b_s.nextval
466: from dual;
467: BEGIN
468:
469: if X_OWNER = 'SEED' then

Line 489: AMS_IBA_PL_PAGES_B_PKG.Insert_Row (

485: l_page_id := x_page_id;
486: end if;
487: l_obj_verno := 1;
488:
489: AMS_IBA_PL_PAGES_B_PKG.Insert_Row (
490: px_page_id => l_page_id,
491: p_site_id => x_site_id,
492: p_site_ref_code => x_site_ref_code,
493: p_page_ref_code => x_page_ref_code,

Line 511: AMS_IBA_PL_PAGES_B_PKG.UPDATE_ROW (

507: close c_db_data_details;
508:
509: if (l_db_luby_id IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
510: then
511: AMS_IBA_PL_PAGES_B_PKG.UPDATE_ROW (
512: p_page_id => x_page_id,
513: p_site_id => x_site_id,
514: p_site_ref_code => x_site_ref_code,
515: p_page_ref_code => x_page_ref_code,

Line 532: END AMS_IBA_PL_PAGES_B_PKG;

528: end if;
529: close c_chk_page_exists;
530: END load_row;
531:
532: END AMS_IBA_PL_PAGES_B_PKG;