eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLE_ASSOCIATIONS_PUB SQL Statements

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

Line: 171


  XLE_ASSOCIATION_PKG.Insert_Row (
      x_association_id           =>  x_association_id,
      p_association_type_id      =>  l_association_type_id,
      p_subject_id               =>  p_subject_id,
      p_object_id	         =>  p_object_id,
      p_subject_parent_id        =>  l_subject_parent_id,
      p_effective_from	         =>  p_effective_from,
      p_assoc_information_context =>  p_assoc_information_context,
      p_assoc_information1        =>  p_assoc_information1,
      p_assoc_information2        =>  p_assoc_information2,
      p_assoc_information3        =>  p_assoc_information3,
      p_assoc_information4        =>  p_assoc_information4,
      p_assoc_information5        =>  p_assoc_information5,
      p_assoc_information6        =>  p_assoc_information6,
      p_assoc_information7        =>  p_assoc_information7,
      p_assoc_information8        =>  p_assoc_information8,
      p_assoc_information9        =>  p_assoc_information9,
      p_assoc_information10       =>  p_assoc_information10,
      p_assoc_information11       =>  p_assoc_information11,
      p_assoc_information12       =>  p_assoc_information12,
      p_assoc_information13       =>  p_assoc_information13,
      p_assoc_information14       =>  p_assoc_information14,
      p_assoc_information15       =>  p_assoc_information15,
      p_assoc_information16       =>  p_assoc_information16,
      p_assoc_information17       =>  p_assoc_information17,
      p_assoc_information18       =>  p_assoc_information18,
      p_assoc_information19       =>  p_assoc_information19,
      p_assoc_information20       =>  p_assoc_information20,
      p_object_version_number =>  1);

Line: 248


 |    Update_Association
 |
 |
 |  DESCRIPTION
 |    Updates a Legal Association 					                |
 |
 |  ARGUMENTS
 |      IN     :
 |               p_init_msg_list
 |               p_commit
 |               p_context
 |               p_subject_type
 |               p_subject_id
 |               p_object_type
 |               p_object_id
 |               p_effective_from
 |               p_assoc_information_context
 |               p_assoc_information1
 |               p_assoc_information2
 |               p_assoc_information3
 |               p_assoc_information4
 |               p_assoc_information5
 |               p_assoc_information6
 |               p_assoc_information7
 |               p_assoc_information8
 |               p_assoc_information9
 |               p_assoc_information10
 |               p_assoc_information11
 |               p_assoc_information12
 |               p_assoc_information13
 |               p_assoc_information14
 |               p_assoc_information15
 |               p_assoc_information16
 |               p_assoc_information17
 |               p_assoc_information18
 |               p_assoc_information19
 |               p_assoc_information20
 |
 |      OUT    :
 |               x_return_status
 |               x_msg_count
 |               x_msg_data
 |               x_association_id
 |
 |      IN/OUT :
 |
 |
 |  MODIFICATION HISTORY
 |
 |    18-MAR-2005   T.Tran          Created.
 |
 |===========================================================================*/


PROCEDURE Update_Association(

  --   *****  Standard API parameters *****
  p_init_msg_list             IN  VARCHAR2 := FND_API.G_TRUE,
  p_commit                    IN  VARCHAR2 := FND_API.G_FALSE,
  x_return_status             OUT NOCOPY VARCHAR2,
  x_msg_count                 OUT NOCOPY NUMBER,
  x_msg_data                  OUT NOCOPY VARCHAR2,

  --   *****  Legal Association information parameters *****
  p_association_id            IN  NUMBER   := NULL,
  p_context                   IN  VARCHAR2 := NULL,
  p_subject_type              IN  VARCHAR2 := NULL,
  p_subject_id                IN  NUMBER   := NULL,
  p_object_type               IN  VARCHAR2 := NULL,
  p_object_id                 IN  NUMBER   := NULL,
  p_effective_from            IN  DATE     := NULL,
  p_effective_to              IN  DATE     := NULL,
  p_assoc_information_context IN VARCHAR2  := NULL,
  p_assoc_information1        IN VARCHAR2  := NULL,
  p_assoc_information2        IN VARCHAR2  := NULL,
  p_assoc_information3        IN VARCHAR2  := NULL,
  p_assoc_information4        IN VARCHAR2  := NULL,
  p_assoc_information5        IN VARCHAR2  := NULL,
  p_assoc_information6        IN VARCHAR2  := NULL,
  p_assoc_information7        IN VARCHAR2  := NULL,
  p_assoc_information8        IN VARCHAR2  := NULL,
  p_assoc_information9        IN VARCHAR2  := NULL,
  p_assoc_information10       IN VARCHAR2  := NULL,
  p_assoc_information11       IN VARCHAR2  := NULL,
  p_assoc_information12       IN VARCHAR2  := NULL,
  p_assoc_information13       IN VARCHAR2  := NULL,
  p_assoc_information14       IN VARCHAR2  := NULL,
  p_assoc_information15       IN VARCHAR2  := NULL,
  p_assoc_information16       IN VARCHAR2  := NULL,
  p_assoc_information17       IN VARCHAR2  := NULL,
  p_assoc_information18       IN VARCHAR2  := NULL,
  p_assoc_information19       IN VARCHAR2  := NULL,
  p_assoc_information20       IN VARCHAR2  := NULL,
  p_object_version_number     IN OUT NOCOPY NUMBER)

IS

  l_api_name  CONSTANT  VARCHAR2(20) := 'Update_Association';

Line: 355


  SAVEPOINT Update_Association_SP;

Line: 374


  XLE_ASSOC_VALIDATIONS_PVT.Validate_Update_Association (
      l_association_id,
      p_context,
      p_subject_type,
      p_subject_id,
      p_object_type,
      p_object_id,
      p_effective_from,
      p_effective_to,
      p_assoc_information_context,
      p_assoc_information1,
      p_assoc_information2,
      p_assoc_information3,
      p_assoc_information4,
      p_assoc_information5,
      p_assoc_information6,
      p_assoc_information7,
      p_assoc_information8,
      p_assoc_information9,
      p_assoc_information10,
      p_assoc_information11,
      p_assoc_information12,
      p_assoc_information13,
      p_assoc_information14,
      p_assoc_information15,
      p_assoc_information16,
      p_assoc_information17,
      p_assoc_information18,
      p_assoc_information19,
      p_assoc_information20 );

Line: 417


  XLE_ASSOCIATION_PKG.Update_Row (
      p_association_id           =>  l_association_id,
      p_effective_from	         =>  p_effective_from,
      p_effective_to             =>  p_effective_to,
      p_assoc_information_context =>  p_assoc_information_context,
      p_assoc_information1        =>  p_assoc_information1,
      p_assoc_information2        =>  p_assoc_information2,
      p_assoc_information3        =>  p_assoc_information3,
      p_assoc_information4        =>  p_assoc_information4,
      p_assoc_information5        =>  p_assoc_information5,
      p_assoc_information6        =>  p_assoc_information6,
      p_assoc_information7        =>  p_assoc_information7,
      p_assoc_information8        =>  p_assoc_information8,
      p_assoc_information9        =>  p_assoc_information9,
      p_assoc_information10       =>  p_assoc_information10,
      p_assoc_information11       =>  p_assoc_information11,
      p_assoc_information12       =>  p_assoc_information12,
      p_assoc_information13       =>  p_assoc_information13,
      p_assoc_information14       =>  p_assoc_information14,
      p_assoc_information15       =>  p_assoc_information15,
      p_assoc_information16       =>  p_assoc_information16,
      p_assoc_information17       =>  p_assoc_information17,
      p_assoc_information18       =>  p_assoc_information18,
      p_assoc_information19       =>  p_assoc_information19,
      p_assoc_information20       =>  p_assoc_information20,
      p_object_version_number    =>  p_object_version_number,
      p_last_update_date         =>  XLE_UTILITY_PUB.LAST_UPDATE_DATE,
      p_last_updated_by          =>  XLE_UTILITY_PUB.LAST_UPDATED_BY,
      p_last_update_login        =>  XLE_UTILITY_PUB.LAST_UPDATE_LOGIN);

Line: 467


       ROLLBACK TO Update_Association_SP;

Line: 474


       ROLLBACK TO Update_Association_SP;

Line: 481


       ROLLBACK TO Update_Association_SP;

Line: 489


END Update_Association;