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

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

Line: 5


procedure UPDATE_PL_SII_DETAILS_A
(P_EFFECTIVE_DATE in DATE
,P_SII_DETAILS_ID in NUMBER
,P_DATETRACK_UPDATE_MODE in VARCHAR2
,P_EMP_SOCIAL_SECURITY_INFO in VARCHAR2
,P_OLD_AGE_CONTRIBUTION in VARCHAR2
,P_PENSION_CONTRIBUTION in VARCHAR2
,P_SICKNESS_CONTRIBUTION in VARCHAR2
,P_WORK_INJURY_CONTRIBUTION in VARCHAR2
,P_LABOR_CONTRIBUTION in VARCHAR2
,P_HEALTH_CONTRIBUTION in VARCHAR2
,P_UNEMPLOYMENT_CONTRIBUTION in VARCHAR2
,P_OLD_AGE_CONT_END_REASON in VARCHAR2
,P_PENSION_CONT_END_REASON in VARCHAR2
,P_SICKNESS_CONT_END_REASON in VARCHAR2
,P_WORK_INJURY_CONT_END_REASON in VARCHAR2
,P_LABOR_FUND_CONT_END_REASON in VARCHAR2
,P_HEALTH_CONT_END_REASON in VARCHAR2
,P_UNEMPLOYMENT_CONT_END_REASON in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
)is
begin
hr_utility.set_location('Entering: PAY_PL_SII_BK2.UPDATE_PL_SII_DETAILS_A', 10);

Line: 30


hr_utility.set_location(' Leaving: PAY_PL_SII_BK2.UPDATE_PL_SII_DETAILS_A', 20);

Line: 31


end UPDATE_PL_SII_DETAILS_A;

Line: 32


procedure UPDATE_PL_SII_DETAILS_B
(P_EFFECTIVE_DATE in DATE
,P_SII_DETAILS_ID in NUMBER
,P_DATETRACK_UPDATE_MODE in VARCHAR2
,P_EMP_SOCIAL_SECURITY_INFO in VARCHAR2
,P_OLD_AGE_CONTRIBUTION in VARCHAR2
,P_PENSION_CONTRIBUTION in VARCHAR2
,P_SICKNESS_CONTRIBUTION in VARCHAR2
,P_WORK_INJURY_CONTRIBUTION in VARCHAR2
,P_LABOR_CONTRIBUTION in VARCHAR2
,P_HEALTH_CONTRIBUTION in VARCHAR2
,P_UNEMPLOYMENT_CONTRIBUTION in VARCHAR2
,P_OLD_AGE_CONT_END_REASON in VARCHAR2
,P_PENSION_CONT_END_REASON in VARCHAR2
,P_SICKNESS_CONT_END_REASON in VARCHAR2
,P_WORK_INJURY_CONT_END_REASON in VARCHAR2
,P_LABOR_FUND_CONT_END_REASON in VARCHAR2
,P_HEALTH_CONT_END_REASON in VARCHAR2
,P_UNEMPLOYMENT_CONT_END_REASON in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: PAY_PL_SII_BK2.UPDATE_PL_SII_DETAILS_B', 10);

Line: 55


hr_utility.set_location(' Leaving: PAY_PL_SII_BK2.UPDATE_PL_SII_DETAILS_B', 20);

Line: 56


end UPDATE_PL_SII_DETAILS_B;