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_RESOURCE_DEFINITION_BK2 SQL Statements

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

Line: 5


procedure UPDATE_RESOURCE_DEFINITION_A
(P_SUPPLIED_RESOURCE_ID in NUMBER
,P_VENDOR_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_RESOURCE_DEFINITION_ID in NUMBER
,P_CONSUMABLE_FLAG in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_RESOURCE_TYPE in VARCHAR2
,P_START_DATE in DATE
,P_COMMENTS in VARCHAR2
,P_COST in NUMBER
,P_COST_UNIT in VARCHAR2
,P_CURRENCY_CODE in VARCHAR2
,P_END_DATE in DATE
,P_INTERNAL_ADDRESS_LINE in VARCHAR2
,P_LEAD_TIME in NUMBER
,P_NAME in VARCHAR2
,P_SUPPLIER_REFERENCE in VARCHAR2
,P_TSR_INFORMATION_CATEGORY in VARCHAR2
,P_TSR_INFORMATION1 in VARCHAR2
,P_TSR_INFORMATION2 in VARCHAR2
,P_TSR_INFORMATION3 in VARCHAR2
,P_TSR_INFORMATION4 in VARCHAR2
,P_TSR_INFORMATION5 in VARCHAR2
,P_TSR_INFORMATION6 in VARCHAR2
,P_TSR_INFORMATION7 in VARCHAR2
,P_TSR_INFORMATION8 in VARCHAR2
,P_TSR_INFORMATION9 in VARCHAR2
,P_TSR_INFORMATION10 in VARCHAR2
,P_TSR_INFORMATION11 in VARCHAR2
,P_TSR_INFORMATION12 in VARCHAR2
,P_TSR_INFORMATION13 in VARCHAR2
,P_TSR_INFORMATION14 in VARCHAR2
,P_TSR_INFORMATION15 in VARCHAR2
,P_TSR_INFORMATION16 in VARCHAR2
,P_TSR_INFORMATION17 in VARCHAR2
,P_TSR_INFORMATION18 in VARCHAR2
,P_TSR_INFORMATION19 in VARCHAR2
,P_TSR_INFORMATION20 in VARCHAR2
,P_TRAINING_CENTER_ID in NUMBER
,P_LOCATION_ID in NUMBER
,P_TRAINER_ID in NUMBER
,P_SPECIAL_INSTRUCTION in VARCHAR2
,P_EFFECTIVE_DATE in DATE
,P_DATA_SOURCE in VARCHAR2
)is
begin
hr_utility.set_location('Entering: OTA_RESOURCE_DEFINITION_BK2.UPDATE_RESOURCE_DEFINITION_A', 10);

Line: 53


hr_utility.set_location(' Leaving: OTA_RESOURCE_DEFINITION_BK2.UPDATE_RESOURCE_DEFINITION_A', 20);

Line: 54


end UPDATE_RESOURCE_DEFINITION_A;

Line: 55


procedure UPDATE_RESOURCE_DEFINITION_B
(P_SUPPLIED_RESOURCE_ID in NUMBER
,P_VENDOR_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_RESOURCE_DEFINITION_ID in NUMBER
,P_CONSUMABLE_FLAG in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_RESOURCE_TYPE in VARCHAR2
,P_START_DATE in DATE
,P_COMMENTS in VARCHAR2
,P_COST in NUMBER
,P_COST_UNIT in VARCHAR2
,P_CURRENCY_CODE in VARCHAR2
,P_END_DATE in DATE
,P_INTERNAL_ADDRESS_LINE in VARCHAR2
,P_LEAD_TIME in NUMBER
,P_NAME in VARCHAR2
,P_SUPPLIER_REFERENCE in VARCHAR2
,P_TSR_INFORMATION_CATEGORY in VARCHAR2
,P_TSR_INFORMATION1 in VARCHAR2
,P_TSR_INFORMATION2 in VARCHAR2
,P_TSR_INFORMATION3 in VARCHAR2
,P_TSR_INFORMATION4 in VARCHAR2
,P_TSR_INFORMATION5 in VARCHAR2
,P_TSR_INFORMATION6 in VARCHAR2
,P_TSR_INFORMATION7 in VARCHAR2
,P_TSR_INFORMATION8 in VARCHAR2
,P_TSR_INFORMATION9 in VARCHAR2
,P_TSR_INFORMATION10 in VARCHAR2
,P_TSR_INFORMATION11 in VARCHAR2
,P_TSR_INFORMATION12 in VARCHAR2
,P_TSR_INFORMATION13 in VARCHAR2
,P_TSR_INFORMATION14 in VARCHAR2
,P_TSR_INFORMATION15 in VARCHAR2
,P_TSR_INFORMATION16 in VARCHAR2
,P_TSR_INFORMATION17 in VARCHAR2
,P_TSR_INFORMATION18 in VARCHAR2
,P_TSR_INFORMATION19 in VARCHAR2
,P_TSR_INFORMATION20 in VARCHAR2
,P_TRAINING_CENTER_ID in NUMBER
,P_LOCATION_ID in NUMBER
,P_TRAINER_ID in NUMBER
,P_SPECIAL_INSTRUCTION in VARCHAR2
,P_EFFECTIVE_DATE in DATE
,P_DATA_SOURCE in VARCHAR2
)is
begin
hr_utility.set_location('Entering: OTA_RESOURCE_DEFINITION_BK2.UPDATE_RESOURCE_DEFINITION_B', 10);

Line: 103


hr_utility.set_location(' Leaving: OTA_RESOURCE_DEFINITION_BK2.UPDATE_RESOURCE_DEFINITION_B', 20);

Line: 104


end UPDATE_RESOURCE_DEFINITION_B;