APPS.AMS_IBA_PL_PG_PARAMS_PKG dependencies on AMS_IBA_PL_PG_PARAMS

Line 1: PACKAGE BODY AMS_IBA_PL_PG_PARAMS_PKG as

1: PACKAGE BODY AMS_IBA_PL_PG_PARAMS_PKG as
2: /* $Header: amstpgpb.pls 120.0 2005/06/01 01:36:26 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_IBA_PL_PG_PARAMS_PKG

2: /* $Header: amstpgpb.pls 120.0 2005/06/01 01:36:26 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_IBA_PL_PG_PARAMS_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_IBA_PL_PG_PARAMS_PKG';

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

Line 62: INSERT INTO AMS_IBA_PL_PG_PARAMS(

58:
59: px_object_version_number := 1;
60:
61:
62: INSERT INTO AMS_IBA_PL_PG_PARAMS(
63: page_parameter_id,
64: page_id,
65: site_ref_code,
66: page_ref_code,

Line 126: Update AMS_IBA_PL_PG_PARAMS

122: p_object_version_number NUMBER)
123:
124: IS
125: BEGIN
126: Update AMS_IBA_PL_PG_PARAMS
127: SET
128: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
129: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
130: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),

Line 167: DELETE FROM AMS_IBA_PL_PG_PARAMS

163: PROCEDURE Delete_Row(
164: p_PAGE_PARAMETER_ID NUMBER)
165: IS
166: BEGIN
167: DELETE FROM AMS_IBA_PL_PG_PARAMS
168: WHERE PAGE_PARAMETER_ID = p_PAGE_PARAMETER_ID;
169: If (SQL%NOTFOUND) then
170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171: End If;

Line 210: FROM AMS_IBA_PL_PG_PARAMS

206:
207: IS
208: CURSOR C IS
209: SELECT *
210: FROM AMS_IBA_PL_PG_PARAMS
211: WHERE PAGE_PARAMETER_ID = p_PAGE_PARAMETER_ID
212: FOR UPDATE of PAGE_PARAMETER_ID NOWAIT;
213: Recinfo C%ROWTYPE;
214: BEGIN

Line 290: from ams_iba_pl_pg_params

286: l_db_luby_id number;
287:
288: /* cursor c_obj_verno is
289: select object_version_number
290: from ams_iba_pl_pg_params
291: where page_parameter_id = x_page_parameter_id;*/
292:
293: cursor c_db_data_details is
294: select last_updated_by, nvl(object_version_number,1)

Line 295: from ams_iba_pl_pg_params

291: where page_parameter_id = x_page_parameter_id;*/
292:
293: cursor c_db_data_details is
294: select last_updated_by, nvl(object_version_number,1)
295: from ams_iba_pl_pg_params
296: where page_parameter_id = x_page_parameter_id;
297:
298: cursor c_chk_page_parameter_exists is
299: select 'x'

Line 300: from ams_iba_pl_pg_params

296: where page_parameter_id = x_page_parameter_id;
297:
298: cursor c_chk_page_parameter_exists is
299: select 'x'
300: from ams_iba_pl_pg_params
301: where page_parameter_id = x_page_parameter_id;
302:
303: cursor c_get_page_parameter_id is
304: select ams_iba_pl_params_b_s.nextval

Line 327: AMS_IBA_PL_PG_PARAMS_PKG.Insert_Row (

323: l_page_parameter_id := x_page_parameter_id;
324: end if;
325: l_obj_verno := 1;
326:
327: AMS_IBA_PL_PG_PARAMS_PKG.Insert_Row (
328: px_page_parameter_id => l_page_parameter_id,
329: p_page_id => x_page_id,
330: p_site_ref_code => x_site_ref_code,
331: p_page_ref_code => x_page_ref_code,

Line 350: AMS_IBA_PL_PG_PARAMS_PKG.UPDATE_ROW (

346:
347: if (l_db_luby_id IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
348: then
349:
350: AMS_IBA_PL_PG_PARAMS_PKG.UPDATE_ROW (
351: p_page_parameter_id => x_page_parameter_id,
352: p_page_id => x_page_id,
353: p_site_ref_code => x_site_ref_code,
354: p_page_ref_code => x_page_ref_code,

Line 370: END AMS_IBA_PL_PG_PARAMS_PKG;

366: end if;
367: close c_chk_page_parameter_exists;
368: END load_row;
369:
370: END AMS_IBA_PL_PG_PARAMS_PKG;