APPS.OTA_FINANCE_LINE_BK2 SQL Statements

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

Line: 5

procedure UPDATE_FINANCE_LINE_A
(P_FINANCE_LINE_ID in NUMBER
,P_FINANCE_HEADER_ID in NUMBER
,P_CANCELLED_FLAG in VARCHAR2
,P_DATE_RAISED in DATE
,P_LINE_TYPE in VARCHAR2
,P_SEQUENCE_NUMBER in 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_EFFECTIVE_DATE in DATE
)is
begin
hr_utility.set_location('Entering: OTA_FINANCE_LINE_BK2.UPDATE_FINANCE_LINE_A', 10);

Line: 75

hr_utility.set_location(' Leaving: OTA_FINANCE_LINE_BK2.UPDATE_FINANCE_LINE_A', 20);

Line: 76

end UPDATE_FINANCE_LINE_A;

Line: 77

procedure UPDATE_FINANCE_LINE_B
(P_FINANCE_LINE_ID in NUMBER
,P_FINANCE_HEADER_ID in NUMBER
,P_CANCELLED_FLAG in VARCHAR2
,P_DATE_RAISED in DATE
,P_LINE_TYPE in VARCHAR2
,P_SEQUENCE_NUMBER in 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_EFFECTIVE_DATE in DATE
)is
begin
hr_utility.set_location('Entering: OTA_FINANCE_LINE_BK2.UPDATE_FINANCE_LINE_B', 10);

Line: 147

hr_utility.set_location(' Leaving: OTA_FINANCE_LINE_BK2.UPDATE_FINANCE_LINE_B', 20);

Line: 148

end UPDATE_FINANCE_LINE_B;