DBA Data[Home] [Help]

APPS.PAY_ACTION_INFORMATION_BK2 SQL Statements

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

Line: 5

procedure UPDATE_ACTION_INFORMATION_A
(P_ACTION_INFORMATION_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_ACTION_INFORMATION1 in VARCHAR2
,P_ACTION_INFORMATION2 in VARCHAR2
,P_ACTION_INFORMATION3 in VARCHAR2
,P_ACTION_INFORMATION4 in VARCHAR2
,P_ACTION_INFORMATION5 in VARCHAR2
,P_ACTION_INFORMATION6 in VARCHAR2
,P_ACTION_INFORMATION7 in VARCHAR2
,P_ACTION_INFORMATION8 in VARCHAR2
,P_ACTION_INFORMATION9 in VARCHAR2
,P_ACTION_INFORMATION10 in VARCHAR2
,P_ACTION_INFORMATION11 in VARCHAR2
,P_ACTION_INFORMATION12 in VARCHAR2
,P_ACTION_INFORMATION13 in VARCHAR2
,P_ACTION_INFORMATION14 in VARCHAR2
,P_ACTION_INFORMATION15 in VARCHAR2
,P_ACTION_INFORMATION16 in VARCHAR2
,P_ACTION_INFORMATION17 in VARCHAR2
,P_ACTION_INFORMATION18 in VARCHAR2
,P_ACTION_INFORMATION19 in VARCHAR2
,P_ACTION_INFORMATION20 in VARCHAR2
,P_ACTION_INFORMATION21 in VARCHAR2
,P_ACTION_INFORMATION22 in VARCHAR2
,P_ACTION_INFORMATION23 in VARCHAR2
,P_ACTION_INFORMATION24 in VARCHAR2
,P_ACTION_INFORMATION25 in VARCHAR2
,P_ACTION_INFORMATION26 in VARCHAR2
,P_ACTION_INFORMATION27 in VARCHAR2
,P_ACTION_INFORMATION28 in VARCHAR2
,P_ACTION_INFORMATION29 in VARCHAR2
,P_ACTION_INFORMATION30 in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PAY_ACTION_INFORMATION_BK2.UPDATE_ACTION_INFORMATION_A', 10);
Line: 41

hr_utility.set_location(' Leaving: PAY_ACTION_INFORMATION_BK2.UPDATE_ACTION_INFORMATION_A', 20);
Line: 42

end UPDATE_ACTION_INFORMATION_A;
Line: 43

procedure UPDATE_ACTION_INFORMATION_B
(P_ACTION_INFORMATION_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_ACTION_INFORMATION1 in VARCHAR2
,P_ACTION_INFORMATION2 in VARCHAR2
,P_ACTION_INFORMATION3 in VARCHAR2
,P_ACTION_INFORMATION4 in VARCHAR2
,P_ACTION_INFORMATION5 in VARCHAR2
,P_ACTION_INFORMATION6 in VARCHAR2
,P_ACTION_INFORMATION7 in VARCHAR2
,P_ACTION_INFORMATION8 in VARCHAR2
,P_ACTION_INFORMATION9 in VARCHAR2
,P_ACTION_INFORMATION10 in VARCHAR2
,P_ACTION_INFORMATION11 in VARCHAR2
,P_ACTION_INFORMATION12 in VARCHAR2
,P_ACTION_INFORMATION13 in VARCHAR2
,P_ACTION_INFORMATION14 in VARCHAR2
,P_ACTION_INFORMATION15 in VARCHAR2
,P_ACTION_INFORMATION16 in VARCHAR2
,P_ACTION_INFORMATION17 in VARCHAR2
,P_ACTION_INFORMATION18 in VARCHAR2
,P_ACTION_INFORMATION19 in VARCHAR2
,P_ACTION_INFORMATION20 in VARCHAR2
,P_ACTION_INFORMATION21 in VARCHAR2
,P_ACTION_INFORMATION22 in VARCHAR2
,P_ACTION_INFORMATION23 in VARCHAR2
,P_ACTION_INFORMATION24 in VARCHAR2
,P_ACTION_INFORMATION25 in VARCHAR2
,P_ACTION_INFORMATION26 in VARCHAR2
,P_ACTION_INFORMATION27 in VARCHAR2
,P_ACTION_INFORMATION28 in VARCHAR2
,P_ACTION_INFORMATION29 in VARCHAR2
,P_ACTION_INFORMATION30 in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PAY_ACTION_INFORMATION_BK2.UPDATE_ACTION_INFORMATION_B', 10);
Line: 79

hr_utility.set_location(' Leaving: PAY_ACTION_INFORMATION_BK2.UPDATE_ACTION_INFORMATION_B', 20);
Line: 80

end UPDATE_ACTION_INFORMATION_B;