1: package body AMS_LIST_QUERIES_PARAM_PKG as
2: /* $Header: amstlqpb.pls 120.1 2005/06/27 05:40:16 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_LIST_QUERY_PARAM_ID in NUMBER,
435: END IF;
436:
437: l_obj_verno := 1;
438:
439: AMS_LIST_QUERIES_PARAM_PKG.INSERT_ROW (
440: X_LIST_QUERY_PARAM_ID => x_list_query_param_id,
441: X_ATTB_LOV_ID => x_attb_lov_id,
442: X_PARAM_VALUE_2 => X_PARAM_VALUE_2 ,
443: X_CONDITION_VALUE => X_CONDITION_VALUE ,
461:
462: if (l_last_updated_by in (1,2,0) OR
463: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
464:
465: AMS_LIST_QUERIES_PARAM_PKG.UPDATE_ROW (
466: X_LIST_QUERY_PARAM_ID => x_list_query_param_id,
467: X_ATTB_LOV_ID => x_attb_lov_id,
468: X_PARAM_VALUE_2 => X_PARAM_VALUE_2 ,
469: X_CONDITION_VALUE => X_CONDITION_VALUE ,
522:
523: end if;
524: END TRANSLATE_ROW;
525:
526: end AMS_LIST_QUERIES_PARAM_PKG;