APPS.XLE_ASSOC_VALIDATIONS_PVT SQL Statements

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

Line: 55

  SELECT  Association_Type_Id
  FROM 	  XLE_ASSOCIATION_TYPES
  WHERE   CONTEXT = upper(p_context);

Line: 107

  l_select_statement VARCHAR2(1000);

Line: 113

  SELECT  *
  FROM 	  XLE_ASSOC_OBJECT_TYPES
  WHERE   name = upper(p_object_type);

Line: 130

  l_select_statement := 'SELECT 1 FROM ' || l_OBJECT_type_rec.source_table ||
  ' WHERE ' || l_OBJECT_type_rec.source_column1 || ' =:pk_id';

Line: 134

     l_select_statement := l_select_statement || ' AND ' || l_OBJECT_type_rec.where_clause;

Line: 139

  DBMS_SQL.PARSE(l_cursor, l_select_statement, DBMS_SQL.V7);

Line: 186

  SELECT association_type_id, subject_id, object_id
  INTO   p_association_type_id, p_subject_id, p_object_id
  FROM   XLE_ASSOCIATIONS
  WHERE  ASSOCIATION_ID = p_association_id;

Line: 231

  SELECT ASSOCIATION_TYPE_ID
  INTO   x_association_type_id
  FROM   XLE_ASSOCIATION_TYPES
  WHERE  CONTEXT         =  upper(p_context)
  AND    SUBJECT_TYPE_ID =  p_subject_type
  AND	 OBJECT_TYPE_ID  =  p_object_type;

Line: 275

  SELECT AT.ASSOCIATION_TYPE_ID
  INTO   x_association_type_id
  FROM   XLE_ASSOCIATION_TYPES AT,
         XLE_ASSOC_OBJECT_TYPES ST,
         XLE_ASSOC_OBJECT_TYPES OT
  WHERE  AT.CONTEXT         =  p_context
  AND    AT.SUBJECT_TYPE_ID =  ST.object_type_id
  AND    ST.NAME            =  upper (P_SUBJECT_TYPE)
  AND    AT.OBJECT_TYPE_ID  =  OT.object_type_id
  AND    OT.NAME            =  upper (P_OBJECT_TYPE);

Line: 325

SELECT *
FROM   XLE_ASSOCIATION_TYPES
WHERE  ASSOCIATION_TYPE_ID = p_association_type_id;

Line: 331

SELECT *
FROM   XLE_ASSOCIATIONS
WHERE  ASSOCIATION_TYPE_ID = p_association_type_id
AND    SUBJECT_ID = p_subject_id
AND    EFFECTIVE_TO IS NULL;

Line: 339

SELECT *
FROM   XLE_ASSOCIATIONS
WHERE  ASSOCIATION_TYPE_ID = p_association_type_id
AND    OBJECT_ID = p_object_id
AND    EFFECTIVE_TO IS NULL;

Line: 425

  SELECT effective_from
  INTO   p_effective_from
  FROM   XLE_ASSOCIATIONS
  WHERE  ASSOCIATION_ID = p_association_id;

Line: 507

SELECT *
FROM   XLE_ASSOCIATION_TYPES
WHERE  ASSOCIATION_TYPE_ID = p_association_type_id;

Line: 579

SELECT *
FROM   XLE_ASSOCIATIONS
WHERE  ASSOCIATION_TYPE_ID = p_association_type_id
AND    SUBJECT_ID = p_subject_id
AND    OBJECT_ID  = p_object_id;

Line: 656

      SELECT legal_entity_id
      INTO   x_object_parent_id
      FROM   XLE_ETB_PROFILES
      WHERE  establishment_id = p_object_id;

Line: 758

  SELECT association_id
  INTO   x_association_id
  FROM   XLE_ASSOCIATIONS
  WHERE  association_type_id = p_association_type_id
  AND    subject_id          = p_subject_id
  AND    object_id           = p_object_id
  AND    effective_to        IS NULL;

Line: 804

  SELECT le2.name, le1.transacting_entity_flag, le2.transacting_entity_flag
  INTO   le2_name, le1_transacting, le2_transacting
  FROM   XLE_ENTITY_PROFILES le1,
         XLE_ENTITY_PROFILES le2
  WHERE  le1.legal_entity_id = p_subject_id
  AND    le2.legal_entity_id = p_object_id;

Line: 978

PROCEDURE Validate_Update_Association (
  p_association_id        IN OUT NOCOPY NUMBER,
  p_context               IN     VARCHAR2,
  p_subject_type          IN     VARCHAR2,
  p_subject_id 		  IN     NUMBER  ,
  p_object_type           IN     VARCHAR2,
  p_object_id             IN     NUMBER  ,
  p_effective_from        IN     DATE    ,
  p_effective_to          IN     DATE    ,
  p_assoc_information_context IN VARCHAR2,
  p_assoc_information1    IN     VARCHAR2,
  p_assoc_information2    IN     VARCHAR2,
  p_assoc_information3    IN     VARCHAR2,
  p_assoc_information4    IN     VARCHAR2,
  p_assoc_information5    IN     VARCHAR2,
  p_assoc_information6    IN     VARCHAR2,
  p_assoc_information7    IN     VARCHAR2,
  p_assoc_information8    IN     VARCHAR2,
  p_assoc_information9    IN     VARCHAR2,
  p_assoc_information10   IN     VARCHAR2,
  p_assoc_information11   IN     VARCHAR2,
  p_assoc_information12   IN     VARCHAR2,
  p_assoc_information13   IN     VARCHAR2,
  p_assoc_information14   IN     VARCHAR2,
  p_assoc_information15   IN     VARCHAR2,
  p_assoc_information16   IN     VARCHAR2,
  p_assoc_information17   IN     VARCHAR2,
  p_assoc_information18   IN     VARCHAR2,
  p_assoc_information19   IN     VARCHAR2,
  p_assoc_information20   IN     VARCHAR2)

IS
  l_association_type_id  NUMBER := NULL;

Line: 1074

END Validate_Update_Association;