APPS.AMS_IBA_PL_STYLESHTS_B_PKG dependencies on AMS_IBA_PL_STYLESHTS_B

Line 1: PACKAGE BODY AMS_IBA_PL_STYLESHTS_B_PKG as

1: PACKAGE BODY AMS_IBA_PL_STYLESHTS_B_PKG as
2: /* $Header: amststyb.pls 120.0 2005/05/31 23:24:49 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_IBA_PL_STYLESHTS_B_PKG

2: /* $Header: amststyb.pls 120.0 2005/05/31 23:24:49 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_IBA_PL_STYLESHTS_B_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 68: INSERT INTO AMS_IBA_PL_STYLESHTS_B(

64: IF (AMS_DEBUG_HIGH_ON) THEN
65: AMS_UTILITY_PVT.debug_message('table handler : before actual insert');
66: END IF;
67:
68: INSERT INTO AMS_IBA_PL_STYLESHTS_B(
69: stylesheet_id,
70: content_type,
71: stylesheet_filename,
72: status_code,

Line 173: Update AMS_IBA_PL_STYLESHTS_B

169: p_name VARCHAR2,
170: p_description VARCHAR2)
171: IS
172: BEGIN
173: Update AMS_IBA_PL_STYLESHTS_B
174: SET
175: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
176: stylesheet_filename = DECODE( p_stylesheet_filename, FND_API.g_miss_char, stylesheet_filename, p_stylesheet_filename),
177: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),

Line 226: DELETE FROM ams_iba_pl_styleshts_b

222: PROCEDURE Delete_Row(
223: p_STYLESHEET_ID NUMBER)
224: IS
225: BEGIN
226: DELETE FROM ams_iba_pl_styleshts_b
227: WHERE stylesheet_id = p_stylesheet_id;
228:
229: If (SQL%NOTFOUND) then
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 244: from AMS_IBA_PL_STYLESHTS_B B

240: begin
241: delete from AMS_IBA_PL_STYLESHTS_TL T
242: where not exists
243: (select NULL
244: from AMS_IBA_PL_STYLESHTS_B B
245: where B.STYLESHEET_ID = T.STYLESHEET_ID
246: );
247:
248: update AMS_IBA_PL_STYLESHTS_TL T set (

Line 338: FROM AMS_IBA_PL_STYLESHTS_B

334:
335: IS
336: CURSOR C IS
337: SELECT *
338: FROM AMS_IBA_PL_STYLESHTS_B
339: WHERE STYLESHEET_ID = p_STYLESHEET_ID
340: FOR UPDATE of STYLESHEET_ID NOWAIT;
341: Recinfo C%ROWTYPE;
342: BEGIN

Line 446: from ams_iba_pl_styleshts_b

442: l_db_luby_id number;
443:
444: /*cursor c_obj_verno is
445: select object_version_number
446: from ams_iba_pl_styleshts_b
447: where stylesheet_id = x_stylesheet_id;*/
448:
449: cursor c_db_data_details is
450: select last_updated_by, nvl(object_version_number,1)

Line 451: from ams_iba_pl_styleshts_b

447: where stylesheet_id = x_stylesheet_id;*/
448:
449: cursor c_db_data_details is
450: select last_updated_by, nvl(object_version_number,1)
451: from ams_iba_pl_styleshts_b
452: where stylesheet_id = x_stylesheet_id;
453:
454: cursor c_chk_style_exists is
455: select 'x'

Line 456: from ams_iba_pl_styleshts_b

452: where stylesheet_id = x_stylesheet_id;
453:
454: cursor c_chk_style_exists is
455: select 'x'
456: from ams_iba_pl_styleshts_b
457: where stylesheet_id = x_stylesheet_id;
458:
459: cursor c_get_stylesheet_id is
460: select ams_iba_pl_styleshts_b_s.nextval

Line 460: select ams_iba_pl_styleshts_b_s.nextval

456: from ams_iba_pl_styleshts_b
457: where stylesheet_id = x_stylesheet_id;
458:
459: cursor c_get_stylesheet_id is
460: select ams_iba_pl_styleshts_b_s.nextval
461: from dual;
462: BEGIN
463: if X_OWNER = 'SEED' then
464: l_user_id := 1;

Line 483: AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row (

479: l_stylesheet_id := x_stylesheet_id;
480: end if;
481: l_obj_verno := 1;
482:
483: AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row (
484: px_stylesheet_id => l_stylesheet_id,
485: p_content_type => x_content_type,
486: p_stylesheet_filename => x_stylesheet_filename,
487: p_status_code => x_status_code,

Line 504: AMS_IBA_PL_STYLESHTS_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_STYLESHTS_B_PKG.UPDATE_ROW (
505: p_stylesheet_id => x_stylesheet_id,
506: p_content_type => x_content_type,
507: p_stylesheet_filename => x_stylesheet_filename,
508: p_status_code => x_status_code,

Line 523: END AMS_IBA_PL_STYLESHTS_B_PKG;

519: end if;
520: close c_chk_style_exists;
521: END load_row;
522:
523: END AMS_IBA_PL_STYLESHTS_B_PKG;