APPS.AMS_IBA_PL_PARAMETERS_B_PKG dependencies on AMS_IBA_PL_PARAMETERS_B

Line 1: PACKAGE BODY AMS_IBA_PL_PARAMETERS_B_PKG as

1: PACKAGE BODY AMS_IBA_PL_PARAMETERS_B_PKG as
2: /* $Header: amstparb.pls 120.0 2005/05/31 15:23:03 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_IBA_PL_PARAMETERS_B_PKG

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

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

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

Line 59: INSERT INTO AMS_IBA_PL_PARAMETERS_B(

55: BEGIN
56:
57: px_object_version_number := 1;
58:
59: INSERT INTO AMS_IBA_PL_PARAMETERS_B(
60: parameter_id,
61: site_id,
62: site_ref_code,
63: parameter_ref_code,

Line 152: Update AMS_IBA_PL_PARAMETERS_B

148: )
149:
150: IS
151: BEGIN
152: Update AMS_IBA_PL_PARAMETERS_B
153: SET
154: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
155: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
156: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),

Line 208: DELETE FROM AMS_IBA_PL_PARAMETERS_B

204: PROCEDURE Delete_Row(
205: p_PARAMETER_ID NUMBER)
206: IS
207: BEGIN
208: DELETE FROM AMS_IBA_PL_PARAMETERS_B
209: WHERE PARAMETER_ID = p_PARAMETER_ID;
210: If (SQL%NOTFOUND) then
211: RAISE no_data_found;
212: End If;

Line 221: from AMS_IBA_PL_PARAMETERS_B B

217: begin
218: delete from AMS_IBA_PL_PARAMETERS_TL T
219: where not exists
220: (select NULL
221: from AMS_IBA_PL_PARAMETERS_B B
222: where B.PARAMETER_ID = T.PARAMETER_ID
223: );
224:
225: update AMS_IBA_PL_PARAMETERS_TL T set (

Line 315: FROM AMS_IBA_PL_PARAMETERS_B

311: )
312: IS
313: CURSOR C IS
314: SELECT *
315: FROM AMS_IBA_PL_PARAMETERS_B
316: WHERE PARAMETER_ID = p_PARAMETER_ID
317: FOR UPDATE of PARAMETER_ID NOWAIT;
318: Recinfo C%ROWTYPE;
319: BEGIN

Line 427: from ams_iba_pl_parameters_b

423: l_db_luby_id number;
424:
425: /* cursor c_obj_verno is
426: select object_version_number
427: from ams_iba_pl_parameters_b
428: where parameter_id = x_parameter_id;*/
429:
430: cursor c_db_data_details is
431: select last_updated_by, nvl(object_version_number,1)

Line 432: from ams_iba_pl_parameters_b

428: where parameter_id = x_parameter_id;*/
429:
430: cursor c_db_data_details is
431: select last_updated_by, nvl(object_version_number,1)
432: from ams_iba_pl_parameters_b
433: where parameter_id = x_parameter_id;
434:
435: cursor c_chk_parameter_exists is
436: select 'x'

Line 437: from ams_iba_pl_parameters_b

433: where parameter_id = x_parameter_id;
434:
435: cursor c_chk_parameter_exists is
436: select 'x'
437: from ams_iba_pl_parameters_b
438: where parameter_id = x_parameter_id;
439:
440: cursor c_get_parameter_id is
441: select ams_iba_pl_params_b_s.nextval

Line 464: AMS_IBA_PL_PARAMETERS_B_PKG.Insert_Row (

460: l_parameter_id := x_parameter_id;
461: end if;
462: l_obj_verno := 1;
463:
464: AMS_IBA_PL_PARAMETERS_B_PKG.Insert_Row (
465: px_parameter_id => l_parameter_id,
466: p_site_id => x_site_id,
467: p_site_ref_code => x_site_ref_code,
468: p_parameter_ref_code => x_parameter_ref_code,

Line 486: AMS_IBA_PL_PARAMETERS_B_PKG.UPDATE_ROW (

482: close c_db_data_details;
483:
484: if (l_db_luby_id IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
485: then
486: AMS_IBA_PL_PARAMETERS_B_PKG.UPDATE_ROW (
487: p_parameter_id => x_parameter_id,
488: p_site_id => x_site_id,
489: p_site_ref_code => x_site_ref_code,
490: p_parameter_ref_code => x_parameter_ref_code,

Line 506: END AMS_IBA_PL_PARAMETERS_B_PKG;

502: end if;
503: close c_chk_parameter_exists;
504: END load_row;
505:
506: END AMS_IBA_PL_PARAMETERS_B_PKG;