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

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

Line: 5


procedure UPDATE_SUCCESSEE_DETAIL_A
(P_EFFECTIVE_DATE in DATE
,P_BUSINESS_GROUP_ID in NUMBER
,P_SUCCESSEE_TYPE in VARCHAR2
,P_SUCCESSEE_ID in NUMBER
,P_DISPLAY_PERMISSIONS in VARCHAR2
,P_ALLOW_NPWS in VARCHAR2
,P_ALLOW_APPLICANTS in VARCHAR2
,P_ALLOW_OVERRIDE_SEARCH in VARCHAR2
,P_MAX_PLANS in NUMBER
,P_KEY_ENTITY in VARCHAR2
,P_RISK_OF_LOSS in VARCHAR2
,P_IMPACT_OF_LOSS in VARCHAR2
,P_PLAN_READINESS_RULE in VARCHAR2
,P_MAX_SUCCESSORS in NUMBER
,P_SUCCESSEE_DETAIL_ID in NUMBER
)is
begin
hr_utility.set_location('Entering: PER_SP_SUCCESSEE_DETAIL_BK2.UPDATE_SUCCESSEE_DETAIL_A', 10);

Line: 24


hr_utility.set_location(' Leaving: PER_SP_SUCCESSEE_DETAIL_BK2.UPDATE_SUCCESSEE_DETAIL_A', 20);

Line: 25


end UPDATE_SUCCESSEE_DETAIL_A;

Line: 26


procedure UPDATE_SUCCESSEE_DETAIL_B
(P_EFFECTIVE_DATE in DATE
,P_BUSINESS_GROUP_ID in NUMBER
,P_SUCCESSEE_TYPE in VARCHAR2
,P_SUCCESSEE_ID in NUMBER
,P_DISPLAY_PERMISSIONS in VARCHAR2
,P_ALLOW_NPWS in VARCHAR2
,P_ALLOW_APPLICANTS in VARCHAR2
,P_ALLOW_OVERRIDE_SEARCH in VARCHAR2
,P_MAX_PLANS in NUMBER
,P_KEY_ENTITY in VARCHAR2
,P_RISK_OF_LOSS in VARCHAR2
,P_IMPACT_OF_LOSS in VARCHAR2
,P_PLAN_READINESS_RULE in VARCHAR2
,P_MAX_SUCCESSORS in NUMBER
,P_SUCCESSEE_DETAIL_ID in NUMBER
)is
begin
hr_utility.set_location('Entering: PER_SP_SUCCESSEE_DETAIL_BK2.UPDATE_SUCCESSEE_DETAIL_B', 10);

Line: 45


hr_utility.set_location(' Leaving: PER_SP_SUCCESSEE_DETAIL_BK2.UPDATE_SUCCESSEE_DETAIL_B', 20);

Line: 46


end UPDATE_SUCCESSEE_DETAIL_B;