APPS.ONT_HEADER_DEF_UTIL SQL Statements

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

Line: 620

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: 626

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: 632

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: 770

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: 1047

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: 1071

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: 1617

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: 1623

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: 1956

  SELECT * FROM   OE_AK_ORDER_HEADERS_V
  WHERE HEADER_ID  = p_HEADER_ID
  ;

Line: 3097

  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: 3161

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

Line: 3169

    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: 3230

		'Update_Attr_Rules_Cache: '||l_attribute_code
            );

Line: 3234

END Update_Attr_Rules_Cache;

Line: 3250

    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: 3318

     Update_Attr_Rules_Cache(l_valid_condn_index_tbl(I));