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

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

Line: 5


procedure AFTER_UPDATE
(P_WORKSHEET_DETAIL_ID in NUMBER
,P_WORKSHEET_ID in NUMBER
,P_ORGANIZATION_ID in NUMBER
,P_JOB_ID in NUMBER
,P_POSITION_ID in NUMBER
,P_GRADE_ID in NUMBER
,P_POSITION_TRANSACTION_ID in NUMBER
,P_BUDGET_DETAIL_ID in NUMBER
,P_PARENT_WORKSHEET_DETAIL_ID in NUMBER
,P_USER_ID in NUMBER
,P_ACTION_CD in VARCHAR2
,P_BUDGET_UNIT1_PERCENT in NUMBER
,P_BUDGET_UNIT1_VALUE in NUMBER
,P_BUDGET_UNIT2_PERCENT in NUMBER
,P_BUDGET_UNIT2_VALUE in NUMBER
,P_BUDGET_UNIT3_PERCENT in NUMBER
,P_BUDGET_UNIT3_VALUE in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_BUDGET_UNIT1_VALUE_TYPE_CD in VARCHAR2
,P_BUDGET_UNIT2_VALUE_TYPE_CD in VARCHAR2
,P_BUDGET_UNIT3_VALUE_TYPE_CD in VARCHAR2
,P_STATUS in VARCHAR2
,P_BUDGET_UNIT1_AVAILABLE in NUMBER
,P_BUDGET_UNIT2_AVAILABLE in NUMBER
,P_BUDGET_UNIT3_AVAILABLE in NUMBER
,P_OLD_UNIT1_VALUE in NUMBER
,P_OLD_UNIT2_VALUE in NUMBER
,P_OLD_UNIT3_VALUE in NUMBER
,P_DEFER_FLAG in VARCHAR2
,P_PROPAGATION_METHOD in VARCHAR2
,P_EFFECTIVE_DATE in DATE
,P_WORKSHEET_ID_O in NUMBER
,P_ORGANIZATION_ID_O in NUMBER
,P_JOB_ID_O in NUMBER
,P_POSITION_ID_O in NUMBER
,P_GRADE_ID_O in NUMBER
,P_POSITION_TRANSACTION_ID_O in NUMBER
,P_BUDGET_DETAIL_ID_O in NUMBER
,P_PARENT_WORKSHEET_DETAIL_ID_O in NUMBER
,P_USER_ID_O in NUMBER
,P_ACTION_CD_O in VARCHAR2
,P_BUDGET_UNIT1_PERCENT_O in NUMBER
,P_BUDGET_UNIT1_VALUE_O in NUMBER
,P_BUDGET_UNIT2_PERCENT_O in NUMBER
,P_BUDGET_UNIT2_VALUE_O in NUMBER
,P_BUDGET_UNIT3_PERCENT_O in NUMBER
,P_BUDGET_UNIT3_VALUE_O in NUMBER
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_BUDGET_UNIT1_VALUE_TYPE_CD_O in VARCHAR2
,P_BUDGET_UNIT2_VALUE_TYPE_CD_O in VARCHAR2
,P_BUDGET_UNIT3_VALUE_TYPE_CD_O in VARCHAR2
,P_STATUS_O in VARCHAR2
,P_BUDGET_UNIT1_AVAILABLE_O in NUMBER
,P_BUDGET_UNIT2_AVAILABLE_O in NUMBER
,P_BUDGET_UNIT3_AVAILABLE_O in NUMBER
,P_OLD_UNIT1_VALUE_O in NUMBER
,P_OLD_UNIT2_VALUE_O in NUMBER
,P_OLD_UNIT3_VALUE_O in NUMBER
,P_DEFER_FLAG_O in VARCHAR2
,P_PROPAGATION_METHOD_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PQH_WDT_RKU.AFTER_UPDATE', 10);

Line: 69


hr_utility.set_location(' Leaving: PQH_WDT_RKU.AFTER_UPDATE', 20);

Line: 70


end AFTER_UPDATE;