APPS.AMS_COLUMNS_METADATA_PKG dependencies on AMS_COLUMNS_METADATA

Line 1: package body AMS_COLUMNS_METADATA_PKG as

1: package body AMS_COLUMNS_METADATA_PKG as
2: /* $Header: amslcmdb.pls 120.1 2005/06/27 05:38:21 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_COLUMNS_METADATA_ID in NUMBER,

Line 51: insert into AMS_COLUMNS_METADATA (

47: X_LAST_UPDATE_LOGIN in NUMBER
48: ) is
49:
50: begin
51: insert into AMS_COLUMNS_METADATA (
52: SEARCH_EXCLUSION_GROUP,
53: SEARCH_OPERATOR_EXCLUSION_ID,
54: SEARCH_COLSPAN,
55: APPLICATION_ID,

Line 222: from AMS_COLUMNS_METADATA

218: SEARCH_PARAM9,
219: SEARCH_PARAM10,
220: SEARCH_DISPLAY_SCALE,
221: COLUMNS_METADATA_ID
222: from AMS_COLUMNS_METADATA
223: where COLUMNS_METADATA_ID = X_COLUMNS_METADATA_ID
224: for update of COLUMNS_METADATA_ID nowait;
225: begin
226: for tlinfo in c1 loop

Line 356: update AMS_COLUMNS_METADATA set

352: X_LAST_UPDATED_BY in NUMBER,
353: X_LAST_UPDATE_LOGIN in NUMBER
354: ) is
355: begin
356: update AMS_COLUMNS_METADATA set
357: SEARCH_EXCLUSION_GROUP = X_SEARCH_EXCLUSION_GROUP,
358: SEARCH_OPERATOR_EXCLUSION_ID = X_SEARCH_OPERATOR_EXCLUSION_ID,
359: SEARCH_COLSPAN = X_SEARCH_COLSPAN,
360: APPLICATION_ID = X_APPLICATION_ID,

Line 409: delete from AMS_COLUMNS_METADATA

405: procedure DELETE_ROW (
406: X_COLUMNS_METADATA_ID in NUMBER
407: ) is
408: begin
409: delete from AMS_COLUMNS_METADATA
410: where COLUMNS_METADATA_ID = X_COLUMNS_METADATA_ID;
411:
412: if (sql%notfound) then
413: raise no_data_found;

Line 469: from AMS_COLUMNS_METADATA

465: -- Commented after OZF is migrated from AMS : aranka
466:
467: cursor c_obj_verno is
468: select object_version_number, columns_metadata_id
469: from AMS_COLUMNS_METADATA
470: -- where OBJECT_TYPE = X_OBJECT_TYPE
471: -- and OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE
472: -- and nvl(ACTIVITY_TYPE_CODE,0) = nvl(X_ACTIVITY_TYPE_CODE, 0)
473: -- and HTML_FORM_PARAM = X_HTML_FORM_PARAM

Line 480: from AMS_COLUMNS_METADATA

476:
477: -- Commented after OZF is migrated from AMS : aranka
478: cursor c_chk_colmtd_exists is
479: select 'x'
480: from AMS_COLUMNS_METADATA
481: -- where OBJECT_TYPE = X_OBJECT_TYPE
482: -- and OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE
483: -- and nvl(ACTIVITY_TYPE_CODE,0) = nvl(X_ACTIVITY_TYPE_CODE, 0)
484: -- and HTML_FORM_PARAM = X_HTML_FORM_PARAM

Line 489: select AMS_COLUMNS_METADATA_S.nextval

485: -- and APPLICATION_ID = X_APPLICATION_ID;
486: where COLUMNS_METADATA_ID = X_COLUMNS_METADATA_ID;
487:
488: cursor c_get_colmtd_id is
489: select AMS_COLUMNS_METADATA_S.nextval
490: from dual;
491:
492: BEGIN
493: if X_OWNER = 'SEED' then

Line 511: AMS_COLUMNS_METADATA_PKG.INSERT_ROW (

507: else
508: l_COLUMNS_METADATA_ID := X_COLUMNS_METADATA_ID;
509: end if;
510:
511: AMS_COLUMNS_METADATA_PKG.INSERT_ROW (
512: X_ROWID => l_row_id,
513: X_COLUMNS_METADATA_ID => l_COLUMNS_METADATA_ID,
514: X_SEARCH_EXCLUSION_GROUP => X_SEARCH_EXCLUSION_GROUP,
515: X_SEARCH_OPERATOR_EXCLUSION_ID => X_SEARCH_OPERATOR_EXCLUSION_ID,

Line 564: AMS_COLUMNS_METADATA_PKG.UPDATE_ROW(

560: fetch c_obj_verno into l_obj_verno, l_COLUMNS_METADATA_ID;
561: close c_obj_verno;
562: -- assigning value for l_user_status_id
563: --l_COLUMNS_METADATA_ID := X_COLUMNS_METADATA_ID;
564: AMS_COLUMNS_METADATA_PKG.UPDATE_ROW(
565: X_COLUMNS_METADATA_ID => l_COLUMNS_METADATA_ID,
566: X_SEARCH_EXCLUSION_GROUP => X_SEARCH_EXCLUSION_GROUP,
567: X_SEARCH_OPERATOR_EXCLUSION_ID => X_SEARCH_OPERATOR_EXCLUSION_ID,
568: X_SEARCH_COLSPAN => X_SEARCH_COLSPAN,

Line 611: end AMS_COLUMNS_METADATA_PKG;

607: END IF;
608:
609: end LOAD_ROW;
610:
611: end AMS_COLUMNS_METADATA_PKG;