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.OTA_FINANCE_LINE_API SQL Statements

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

Line: 53


P_LAST_UPDATE_DATE                  IN  DATE,
P_LAST_UPDATED_BY                   IN  NUMBER,
P_LAST_UPDATE_LOGIN                 IN  NUMBER,
P_CREATED_BY                        IN  NUMBER,
P_CREATION_DATE                     IN  DATE   ,
P_TFL_INFORMATION_CATEGORY          IN  VARCHAR2,
P_TFL_INFORMATION1                  IN  VARCHAR2,
P_TFL_INFORMATION2                  IN  VARCHAR2,
P_TFL_INFORMATION3                  IN  VARCHAR2,
P_TFL_INFORMATION4                  IN  VARCHAR2,
P_TFL_INFORMATION5                  IN  VARCHAR2,
P_TFL_INFORMATION6                  IN  VARCHAR2,
P_TFL_INFORMATION7                  IN  VARCHAR2,
P_TFL_INFORMATION8                  IN  VARCHAR2,
P_TFL_INFORMATION9                  IN  VARCHAR2,
P_TFL_INFORMATION10                 IN  VARCHAR2,
P_TFL_INFORMATION11                 IN  VARCHAR2,
P_TFL_INFORMATION12                 IN  VARCHAR2,
P_TFL_INFORMATION13                 IN  VARCHAR2,
P_TFL_INFORMATION14                 IN  VARCHAR2,
P_TFL_INFORMATION15                 IN  VARCHAR2,
P_TFL_INFORMATION16                 IN  VARCHAR2,
P_TFL_INFORMATION17                 IN  VARCHAR2,
P_TFL_INFORMATION18                 IN  VARCHAR2,
P_TFL_INFORMATION19                 IN  VARCHAR2,
P_TFL_INFORMATION20                 IN  VARCHAR2,
P_VALIDATE                          IN	boolean  default false,
P_EFFECTIVE_DATE                    IN  DATE
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Create Finance Line';

Line: 145


	P_LAST_UPDATE_DATE                => 	 P_LAST_UPDATE_DATE,
	P_LAST_UPDATED_BY                 => 	 P_LAST_UPDATED_BY,
	P_LAST_UPDATE_LOGIN               => 	 P_LAST_UPDATE_LOGIN,
	P_CREATED_BY                      => 	 P_CREATED_BY,
	P_CREATION_DATE                   => 	 P_CREATION_DATE,
P_TFL_INFORMATION_CATEGORY        => 	 P_TFL_INFORMATION_CATEGORY,
P_TFL_INFORMATION1                => 	 P_TFL_INFORMATION1,
P_TFL_INFORMATION2                => 	 P_TFL_INFORMATION2,
P_TFL_INFORMATION3                => 	 P_TFL_INFORMATION3,
P_TFL_INFORMATION4                => 	 P_TFL_INFORMATION4,
P_TFL_INFORMATION5                => 	 P_TFL_INFORMATION5,
P_TFL_INFORMATION6                => 	 P_TFL_INFORMATION6,
P_TFL_INFORMATION7                => 	 P_TFL_INFORMATION7,
P_TFL_INFORMATION8                => 	 P_TFL_INFORMATION8,
P_TFL_INFORMATION9                => 	 P_TFL_INFORMATION9,
P_TFL_INFORMATION10               => 	 P_TFL_INFORMATION10,
P_TFL_INFORMATION11               => 	 P_TFL_INFORMATION11,
P_TFL_INFORMATION12               => 	 P_TFL_INFORMATION12,
P_TFL_INFORMATION13               => 	 P_TFL_INFORMATION13,
P_TFL_INFORMATION14               => 	 P_TFL_INFORMATION14,
P_TFL_INFORMATION15               => 	 P_TFL_INFORMATION15,
P_TFL_INFORMATION16               => 	 P_TFL_INFORMATION16,
P_TFL_INFORMATION17               => 	 P_TFL_INFORMATION17,
P_TFL_INFORMATION18               => 	 P_TFL_INFORMATION18,
P_TFL_INFORMATION19               => 	 P_TFL_INFORMATION19,
P_TFL_INFORMATION20               => 	 P_TFL_INFORMATION20,
P_EFFECTIVE_DATE                  => 	 P_EFFECTIVE_DATE

   );

Line: 247


       ,P_transaction_type          =>  'INSERT'
);

Line: 296


P_LAST_UPDATE_DATE                => 	 P_LAST_UPDATE_DATE,
P_LAST_UPDATED_BY                 => 	 P_LAST_UPDATED_BY,
P_LAST_UPDATE_LOGIN               => 	 P_LAST_UPDATE_LOGIN,
P_CREATED_BY                      => 	 P_CREATED_BY,
P_CREATION_DATE                   => 	 P_CREATION_DATE,
P_TFL_INFORMATION_CATEGORY        => 	 P_TFL_INFORMATION_CATEGORY,
P_TFL_INFORMATION1                => 	 P_TFL_INFORMATION1,
P_TFL_INFORMATION2                => 	 P_TFL_INFORMATION2,
P_TFL_INFORMATION3                => 	 P_TFL_INFORMATION3,
P_TFL_INFORMATION4                => 	 P_TFL_INFORMATION4,
P_TFL_INFORMATION5                => 	 P_TFL_INFORMATION5,
P_TFL_INFORMATION6                => 	 P_TFL_INFORMATION6,
P_TFL_INFORMATION7                => 	 P_TFL_INFORMATION7,
P_TFL_INFORMATION8                => 	 P_TFL_INFORMATION8,
P_TFL_INFORMATION9                => 	 P_TFL_INFORMATION9,
P_TFL_INFORMATION10               => 	 P_TFL_INFORMATION10,
P_TFL_INFORMATION11               => 	 P_TFL_INFORMATION11,
P_TFL_INFORMATION12               => 	 P_TFL_INFORMATION12,
P_TFL_INFORMATION13               => 	 P_TFL_INFORMATION13,
P_TFL_INFORMATION14               => 	 P_TFL_INFORMATION14,
P_TFL_INFORMATION15               => 	 P_TFL_INFORMATION15,
P_TFL_INFORMATION16               => 	 P_TFL_INFORMATION16,
P_TFL_INFORMATION17               => 	 P_TFL_INFORMATION17,
P_TFL_INFORMATION18               => 	 P_TFL_INFORMATION18,
P_TFL_INFORMATION19               => 	 P_TFL_INFORMATION19,
P_TFL_INFORMATION20               => 	 P_TFL_INFORMATION20,
P_EFFECTIVE_DATE                  => 	 P_EFFECTIVE_DATE

  );

Line: 376


procedure UPDATE_FINANCE_LINE
  (
  P_FINANCE_LINE_ID                   IN  NUMBER,
  P_OBJECT_VERSION_NUMBER             IN OUT NOCOPY  NUMBER,
  P_NEW_OBJECT_VERSION_NUMBER         OUT NOCOPY  NUMBER,
  P_FINANCE_HEADER_ID                 IN  NUMBER,
  P_CANCELLED_FLAG                    IN  VARCHAR2,
  P_DATE_RAISED                       IN OUT NOCOPY DATE,
  P_LINE_TYPE                         IN  VARCHAR2,
  P_SEQUENCE_NUMBER                   IN OUT NOCOPY NUMBER,
  P_TRANSFER_STATUS                   IN  VARCHAR2,
  P_COMMENTS                          IN  VARCHAR2,
  P_CURRENCY_CODE                     IN  VARCHAR2,
  P_MONEY_AMOUNT                      IN  NUMBER,
  P_STANDARD_AMOUNT                   IN  NUMBER,
  P_TRANS_INFORMATION_CATEGORY        IN  VARCHAR2,
  P_TRANS_INFORMATION1                IN  VARCHAR2,
  P_TRANS_INFORMATION10               IN  VARCHAR2,
  P_TRANS_INFORMATION11               IN  VARCHAR2,
  P_TRANS_INFORMATION12               IN  VARCHAR2,
  P_TRANS_INFORMATION13               IN  VARCHAR2,
  P_TRANS_INFORMATION14               IN  VARCHAR2,
  P_TRANS_INFORMATION15               IN  VARCHAR2,
  P_TRANS_INFORMATION16               IN  VARCHAR2,
  P_TRANS_INFORMATION17               IN  VARCHAR2,
  P_TRANS_INFORMATION18               IN  VARCHAR2,
  P_TRANS_INFORMATION19               IN  VARCHAR2,
  P_TRANS_INFORMATION2                IN  VARCHAR2,
  P_TRANS_INFORMATION20               IN  VARCHAR2,
  P_TRANS_INFORMATION3                IN  VARCHAR2,
  P_TRANS_INFORMATION4                IN  VARCHAR2,
  P_TRANS_INFORMATION5                IN  VARCHAR2,
  P_TRANS_INFORMATION6                IN  VARCHAR2,
  P_TRANS_INFORMATION7                IN  VARCHAR2,
  P_TRANS_INFORMATION8                IN  VARCHAR2,
  P_TRANS_INFORMATION9                IN  VARCHAR2,
  P_TRANSFER_DATE                     IN  DATE  ,
  P_TRANSFER_MESSAGE                  IN  VARCHAR2,
  P_UNITARY_AMOUNT                    IN  NUMBER,
  P_BOOKING_DEAL_ID                   IN  NUMBER,
  P_BOOKING_ID                        IN  NUMBER,
  P_RESOURCE_ALLOCATION_ID            IN  NUMBER,
  P_RESOURCE_BOOKING_ID           IN  NUMBER,
  P_LAST_UPDATE_DATE                  IN  DATE,
  P_LAST_UPDATED_BY                   IN  NUMBER,
  P_LAST_UPDATE_LOGIN                 IN  NUMBER,
  P_CREATED_BY                        IN  NUMBER,
  P_CREATION_DATE                     IN  DATE   ,
  P_TFL_INFORMATION_CATEGORY          IN  VARCHAR2,
  P_TFL_INFORMATION1                  IN  VARCHAR2,
  P_TFL_INFORMATION2                  IN  VARCHAR2,
  P_TFL_INFORMATION3                  IN  VARCHAR2,
  P_TFL_INFORMATION4                  IN  VARCHAR2,
  P_TFL_INFORMATION5                  IN  VARCHAR2,
  P_TFL_INFORMATION6                  IN  VARCHAR2,
  P_TFL_INFORMATION7                  IN  VARCHAR2,
  P_TFL_INFORMATION8                  IN  VARCHAR2,
  P_TFL_INFORMATION9                  IN  VARCHAR2,
  P_TFL_INFORMATION10                 IN  VARCHAR2,
  P_TFL_INFORMATION11                 IN  VARCHAR2,
  P_TFL_INFORMATION12                 IN  VARCHAR2,
  P_TFL_INFORMATION13                 IN  VARCHAR2,
  P_TFL_INFORMATION14                 IN  VARCHAR2,
  P_TFL_INFORMATION15                 IN  VARCHAR2,
  P_TFL_INFORMATION16                 IN  VARCHAR2,
  P_TFL_INFORMATION17                 IN  VARCHAR2,
  P_TFL_INFORMATION18                 IN  VARCHAR2,
  P_TFL_INFORMATION19                 IN  VARCHAR2,
  P_TFL_INFORMATION20                 IN  VARCHAR2,
  P_VALIDATE                          IN  boolean  default false,
  P_TRANSACTION_TYPE                  IN  VARCHAR2 default 'UPDATE',
  P_EFFECTIVE_DATE                    IN  DATE
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Finance Line';

Line: 461


  savepoint UPDATE_FINANCE_LINE;

Line: 471


    OTA_FINANCE_LINE_BK2.UPDATE_FINANCE_LINE_B
  (    P_FINANCE_LINE_ID                => 	 P_FINANCE_LINE_ID,
P_FINANCE_HEADER_ID               => 	 P_FINANCE_HEADER_ID,
P_CANCELLED_FLAG                  => 	 P_CANCELLED_FLAG,
P_DATE_RAISED                     => 	 P_DATE_RAISED,
P_LINE_TYPE                       => 	 P_LINE_TYPE,
P_SEQUENCE_NUMBER                 => 	 P_SEQUENCE_NUMBER,
P_TRANSFER_STATUS                 => 	 P_TRANSFER_STATUS,
P_COMMENTS                        => 	 P_COMMENTS,
P_CURRENCY_CODE                   => 	 P_CURRENCY_CODE,
P_MONEY_AMOUNT                    => 	 P_MONEY_AMOUNT,
P_STANDARD_AMOUNT                 => 	 P_STANDARD_AMOUNT,
P_TRANS_INFORMATION_CATEGORY      => 	 P_TRANS_INFORMATION_CATEGORY,
P_TRANS_INFORMATION1              => 	 P_TRANS_INFORMATION1,
P_TRANS_INFORMATION10             => 	 P_TRANS_INFORMATION10,
P_TRANS_INFORMATION11             => 	 P_TRANS_INFORMATION11,
P_TRANS_INFORMATION12             => 	 P_TRANS_INFORMATION12,
P_TRANS_INFORMATION13             => 	 P_TRANS_INFORMATION13,
P_TRANS_INFORMATION14             => 	 P_TRANS_INFORMATION14,
P_TRANS_INFORMATION15             => 	 P_TRANS_INFORMATION15,
P_TRANS_INFORMATION16             => 	 P_TRANS_INFORMATION16,
P_TRANS_INFORMATION17             => 	 P_TRANS_INFORMATION17,
P_TRANS_INFORMATION18             => 	 P_TRANS_INFORMATION18,
P_TRANS_INFORMATION19             => 	 P_TRANS_INFORMATION19,
P_TRANS_INFORMATION2              => 	 P_TRANS_INFORMATION2,
P_TRANS_INFORMATION20             => 	 P_TRANS_INFORMATION20,
P_TRANS_INFORMATION3              => 	 P_TRANS_INFORMATION3,
P_TRANS_INFORMATION4              => 	 P_TRANS_INFORMATION4,
P_TRANS_INFORMATION5              => 	 P_TRANS_INFORMATION5,
P_TRANS_INFORMATION6              => 	 P_TRANS_INFORMATION6,
P_TRANS_INFORMATION7              => 	 P_TRANS_INFORMATION7,
P_TRANS_INFORMATION8              => 	 P_TRANS_INFORMATION8,
P_TRANS_INFORMATION9              => 	 P_TRANS_INFORMATION9,
P_TRANSFER_DATE                   => 	 P_TRANSFER_DATE,
P_TRANSFER_MESSAGE                => 	 P_TRANSFER_MESSAGE,
P_UNITARY_AMOUNT                  => 	 P_UNITARY_AMOUNT,
P_BOOKING_DEAL_ID                 => 	 P_BOOKING_DEAL_ID,
P_BOOKING_ID                      => 	 P_BOOKING_ID,
P_RESOURCE_ALLOCATION_ID          => 	 P_RESOURCE_ALLOCATION_ID,
P_RESOURCE_BOOKING_ID         => 	 P_RESOURCE_BOOKING_ID,
P_LAST_UPDATE_DATE                => 	 P_LAST_UPDATE_DATE,
P_LAST_UPDATED_BY                 => 	 P_LAST_UPDATED_BY,
P_LAST_UPDATE_LOGIN               => 	 P_LAST_UPDATE_LOGIN,
P_CREATED_BY                      => 	 P_CREATED_BY,
P_CREATION_DATE                   => 	 P_CREATION_DATE,
P_TFL_INFORMATION_CATEGORY        => 	 P_TFL_INFORMATION_CATEGORY,
P_TFL_INFORMATION1                => 	 P_TFL_INFORMATION1,
P_TFL_INFORMATION2                => 	 P_TFL_INFORMATION2,
P_TFL_INFORMATION3                => 	 P_TFL_INFORMATION3,
P_TFL_INFORMATION4                => 	 P_TFL_INFORMATION4,
P_TFL_INFORMATION5                => 	 P_TFL_INFORMATION5,
P_TFL_INFORMATION6                => 	 P_TFL_INFORMATION6,
P_TFL_INFORMATION7                => 	 P_TFL_INFORMATION7,
P_TFL_INFORMATION8                => 	 P_TFL_INFORMATION8,
P_TFL_INFORMATION9                => 	 P_TFL_INFORMATION9,
P_TFL_INFORMATION10               => 	 P_TFL_INFORMATION10,
P_TFL_INFORMATION11               => 	 P_TFL_INFORMATION11,
P_TFL_INFORMATION12               => 	 P_TFL_INFORMATION12,
P_TFL_INFORMATION13               => 	 P_TFL_INFORMATION13,
P_TFL_INFORMATION14               => 	 P_TFL_INFORMATION14,
P_TFL_INFORMATION15               => 	 P_TFL_INFORMATION15,
P_TFL_INFORMATION16               => 	 P_TFL_INFORMATION16,
P_TFL_INFORMATION17               => 	 P_TFL_INFORMATION17,
P_TFL_INFORMATION18               => 	 P_TFL_INFORMATION18,
P_TFL_INFORMATION19               => 	 P_TFL_INFORMATION19,
P_TFL_INFORMATION20               => 	 P_TFL_INFORMATION20,
P_EFFECTIVE_DATE                  => 	 P_EFFECTIVE_DATE
  );

Line: 542


        (p_module_name => 'UPDATE_FINANCE_LINE'
        ,p_hook_type   => 'BP'
        );

Line: 621


  OTA_FINANCE_LINE_BK2.UPDATE_FINANCE_LINE_A
  (     P_FINANCE_LINE_ID                => 	 P_FINANCE_LINE_ID,
P_FINANCE_HEADER_ID               => 	 P_FINANCE_HEADER_ID,
P_CANCELLED_FLAG                  => 	 P_CANCELLED_FLAG,
P_DATE_RAISED                     => 	 P_DATE_RAISED,
P_LINE_TYPE                       => 	 P_LINE_TYPE,
P_SEQUENCE_NUMBER                 => 	 P_SEQUENCE_NUMBER,
P_TRANSFER_STATUS                 => 	 P_TRANSFER_STATUS,
P_COMMENTS                        => 	 P_COMMENTS,
P_CURRENCY_CODE                   => 	 P_CURRENCY_CODE,
P_MONEY_AMOUNT                    => 	 P_MONEY_AMOUNT,
P_STANDARD_AMOUNT                 => 	 P_STANDARD_AMOUNT,
P_TRANS_INFORMATION_CATEGORY      => 	 P_TRANS_INFORMATION_CATEGORY,
P_TRANS_INFORMATION1              => 	 P_TRANS_INFORMATION1,
P_TRANS_INFORMATION10             => 	 P_TRANS_INFORMATION10,
P_TRANS_INFORMATION11             => 	 P_TRANS_INFORMATION11,
P_TRANS_INFORMATION12             => 	 P_TRANS_INFORMATION12,
P_TRANS_INFORMATION13             => 	 P_TRANS_INFORMATION13,
P_TRANS_INFORMATION14             => 	 P_TRANS_INFORMATION14,
P_TRANS_INFORMATION15             => 	 P_TRANS_INFORMATION15,
P_TRANS_INFORMATION16             => 	 P_TRANS_INFORMATION16,
P_TRANS_INFORMATION17             => 	 P_TRANS_INFORMATION17,
P_TRANS_INFORMATION18             => 	 P_TRANS_INFORMATION18,
P_TRANS_INFORMATION19             => 	 P_TRANS_INFORMATION19,
P_TRANS_INFORMATION2              => 	 P_TRANS_INFORMATION2,
P_TRANS_INFORMATION20             => 	 P_TRANS_INFORMATION20,
P_TRANS_INFORMATION3              => 	 P_TRANS_INFORMATION3,
P_TRANS_INFORMATION4              => 	 P_TRANS_INFORMATION4,
P_TRANS_INFORMATION5              => 	 P_TRANS_INFORMATION5,
P_TRANS_INFORMATION6              => 	 P_TRANS_INFORMATION6,
P_TRANS_INFORMATION7              => 	 P_TRANS_INFORMATION7,
P_TRANS_INFORMATION8              => 	 P_TRANS_INFORMATION8,
P_TRANS_INFORMATION9              => 	 P_TRANS_INFORMATION9,
P_TRANSFER_DATE                   => 	 P_TRANSFER_DATE,
P_TRANSFER_MESSAGE                => 	 P_TRANSFER_MESSAGE,
P_UNITARY_AMOUNT                  => 	 P_UNITARY_AMOUNT,
P_BOOKING_DEAL_ID                 => 	 P_BOOKING_DEAL_ID,
P_BOOKING_ID                      => 	 P_BOOKING_ID,
P_RESOURCE_ALLOCATION_ID          => 	 P_RESOURCE_ALLOCATION_ID,
P_RESOURCE_BOOKING_ID         => 	 P_RESOURCE_BOOKING_ID,
P_LAST_UPDATE_DATE                => 	 P_LAST_UPDATE_DATE,
P_LAST_UPDATED_BY                 => 	 P_LAST_UPDATED_BY,
P_LAST_UPDATE_LOGIN               => 	 P_LAST_UPDATE_LOGIN,
P_CREATED_BY                      => 	 P_CREATED_BY,
P_CREATION_DATE                   => 	 P_CREATION_DATE,
P_TFL_INFORMATION_CATEGORY        => 	 P_TFL_INFORMATION_CATEGORY,
P_TFL_INFORMATION1                => 	 P_TFL_INFORMATION1,
P_TFL_INFORMATION2                => 	 P_TFL_INFORMATION2,
P_TFL_INFORMATION3                => 	 P_TFL_INFORMATION3,
P_TFL_INFORMATION4                => 	 P_TFL_INFORMATION4,
P_TFL_INFORMATION5                => 	 P_TFL_INFORMATION5,
P_TFL_INFORMATION6                => 	 P_TFL_INFORMATION6,
P_TFL_INFORMATION7                => 	 P_TFL_INFORMATION7,
P_TFL_INFORMATION8                => 	 P_TFL_INFORMATION8,
P_TFL_INFORMATION9                => 	 P_TFL_INFORMATION9,
P_TFL_INFORMATION10               => 	 P_TFL_INFORMATION10,
P_TFL_INFORMATION11               => 	 P_TFL_INFORMATION11,
P_TFL_INFORMATION12               => 	 P_TFL_INFORMATION12,
P_TFL_INFORMATION13               => 	 P_TFL_INFORMATION13,
P_TFL_INFORMATION14               => 	 P_TFL_INFORMATION14,
P_TFL_INFORMATION15               => 	 P_TFL_INFORMATION15,
P_TFL_INFORMATION16               => 	 P_TFL_INFORMATION16,
P_TFL_INFORMATION17               => 	 P_TFL_INFORMATION17,
P_TFL_INFORMATION18               => 	 P_TFL_INFORMATION18,
P_TFL_INFORMATION19               => 	 P_TFL_INFORMATION19,
P_TFL_INFORMATION20               => 	 P_TFL_INFORMATION20,
P_EFFECTIVE_DATE                  => 	 P_EFFECTIVE_DATE
  );

Line: 692


        (p_module_name => 'UPDATE_FINANCE_LINE'
        ,p_hook_type   => 'AP'
        );

Line: 713


    rollback to UPDATE_FINANCE_LINE;

Line: 725


    rollback to UPDATE_FINANCE_LINE;

Line: 729


end update_FINANCE_LINE;

Line: 735


procedure DELETE_FINANCE_LINE
  (p_validate                      in     boolean  default false
  ,p_finance_line_id               in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Delete Finance Line';

Line: 752


  savepoint DELETE_FINANCE_LINE;

Line: 761


    OTA_FINANCE_LINE_BK3.DELETE_FINANCE_LINE_B
  (p_finance_line_id            => p_finance_line_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 768


        (p_module_name => 'DELETE_FINANCE_LINE'
        ,p_hook_type   => 'BP'
        );

Line: 787


  OTA_FINANCE_LINE_BK3.DELETE_FINANCE_LINE_A
  (p_finance_line_id            => p_finance_line_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 794


        (p_module_name => 'DELETE_FINANCE_LINE'
        ,p_hook_type   => 'AP'
        );

Line: 816


    rollback to DELETE_FINANCE_LINE;

Line: 827


    rollback to DELETE_FINANCE_LINE;

Line: 830


end DELETE_FINANCE_LINE;