APPS.ONT_LINE_DEF_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 230

ELSIF p_attr_code =('AUTO_SELECTED_QUANTITY') THEN
  IF NVL(p_record.AUTO_SELECTED_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
  RETURN p_record.AUTO_SELECTED_QUANTITY;

Line: 986

ELSIF p_attr_code =('LAST_UPDATED_BY') THEN
  IF NVL(p_record.LAST_UPDATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
  RETURN p_record.LAST_UPDATED_BY;

Line: 992

ELSIF p_attr_code =('LAST_UPDATE_DATE') THEN
  IF NVL(p_record.LAST_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
  RETURN p_record.LAST_UPDATE_DATE;

Line: 998

ELSIF p_attr_code =('LAST_UPDATE_LOGIN') THEN
  IF NVL(p_record.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
  RETURN p_record.LAST_UPDATE_LOGIN;

Line: 1286

ELSIF p_attr_code =('PROGRAM_UPDATE_DATE') THEN
  IF NVL(p_record.PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
  RETURN p_record.PROGRAM_UPDATE_DATE;

Line: 1935

ELSIF p_attr_code =('LAST_UPDATE_DATE') THEN
    IF NVL(p_record.LAST_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
    RETURN p_record.LAST_UPDATE_DATE;

Line: 1959

ELSIF p_attr_code =('PROGRAM_UPDATE_DATE') THEN
    IF NVL(p_record.PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
    RETURN p_record.PROGRAM_UPDATE_DATE;

Line: 2169

ELSIF p_attr_code =('AUTO_SELECTED_QUANTITY') THEN
    IF NVL(p_record.AUTO_SELECTED_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
    RETURN to_date(p_record.AUTO_SELECTED_QUANTITY,'RRRR/MM/DD HH24:MI:SS');

Line: 2889

ELSIF p_attr_code =('LAST_UPDATED_BY') THEN
    IF NVL(p_record.LAST_UPDATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
    RETURN to_date(p_record.LAST_UPDATED_BY,'RRRR/MM/DD HH24:MI:SS');

Line: 2895

ELSIF p_attr_code =('LAST_UPDATE_LOGIN') THEN
    IF NVL(p_record.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
    RETURN to_date(p_record.LAST_UPDATE_LOGIN,'RRRR/MM/DD HH24:MI:SS');

Line: 3720

  SELECT * FROM   OE_AK_ORDER_LINES_V
  WHERE LINE_ID  = p_LINE_ID
  ;

Line: 4914

  SELECT condition_id,group_number,attribute_code,
    value_op,value_string
  FROM OE_DEF_CONDN_ELEMS
  WHERE condition_id = p_condition_id
  ORDER BY group_number;

Line: 4978

PROCEDURE Update_Attr_Rules_Cache
	( p_condn_index		        IN NUMBER
	)
IS
l_index			NUMBER := 0;

Line: 4986

    CURSOR DEFSRC IS SELECT
    R.SEQUENCE_NO,
    R.SRC_TYPE,
    R.SRC_ATTRIBUTE_CODE,
    R.SRC_DATABASE_OBJECT_NAME,
    R.SRC_PARAMETER_NAME,
    R.SRC_SYSTEM_VARIABLE_EXPR,
    R.SRC_PROFILE_OPTION,
    R.SRC_API_PKG||'.'||R.SRC_API_FN SRC_API_NAME,
    R.SRC_CONSTANT_VALUE,
    R.SRC_SEQUENCE_NAME
    FROM OE_DEF_ATTR_DEF_RULES R, OE_DEF_ATTR_CONDNS C
    WHERE R.database_object_name = g_database_object_name
    AND R.attribute_code = l_attribute_code
    AND C.database_object_name = g_database_object_name
    AND C.attribute_code = l_attribute_code
    AND R.attr_def_condition_id = C.attr_def_condition_id
    AND C.CONDITION_ID = l_condition_id
    AND C.ENABLED_FLAG = 'Y'
    ORDER BY SEQUENCE_NO;

Line: 5047

		'Update_Attr_Rules_Cache: '||l_attribute_code
            );

Line: 5051

END Update_Attr_Rules_Cache;

Line: 5067

    SELECT condition_id  
    FROM OE_DEF_ATTR_CONDNS    
    WHERE attribute_code = p_attr_code  
      AND database_object_name = g_database_object_name  
      AND enabled_flag = 'Y'
    ORDER BY precedence;

Line: 5135

     Update_Attr_Rules_Cache(l_valid_condn_index_tbl(I));