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

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

Line: 5


procedure UPDATE_PERS_ADDR_WITH_STYLE_A
(P_EFFECTIVE_DATE in DATE
,P_VALIDATE_COUNTY in BOOLEAN
,P_ADDRESS_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_DATE_FROM in DATE
,P_DATE_TO in DATE
,P_ADDRESS_TYPE in VARCHAR2
,P_COMMENTS in LONG
,P_ADDRESS_LINE1 in VARCHAR2
,P_ADDRESS_LINE2 in VARCHAR2
,P_ADDRESS_LINE3 in VARCHAR2
,P_TOWN_OR_CITY in VARCHAR2
,P_REGION_1 in VARCHAR2
,P_REGION_2 in VARCHAR2
,P_REGION_3 in VARCHAR2
,P_POSTAL_CODE in VARCHAR2
,P_COUNTRY in VARCHAR2
,P_TELEPHONE_NUMBER_1 in VARCHAR2
,P_TELEPHONE_NUMBER_2 in VARCHAR2
,P_TELEPHONE_NUMBER_3 in VARCHAR2
,P_ADDR_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ADDR_ATTRIBUTE1 in VARCHAR2
,P_ADDR_ATTRIBUTE2 in VARCHAR2
,P_ADDR_ATTRIBUTE3 in VARCHAR2
,P_ADDR_ATTRIBUTE4 in VARCHAR2
,P_ADDR_ATTRIBUTE5 in VARCHAR2
,P_ADDR_ATTRIBUTE6 in VARCHAR2
,P_ADDR_ATTRIBUTE7 in VARCHAR2
,P_ADDR_ATTRIBUTE8 in VARCHAR2
,P_ADDR_ATTRIBUTE9 in VARCHAR2
,P_ADDR_ATTRIBUTE10 in VARCHAR2
,P_ADDR_ATTRIBUTE11 in VARCHAR2
,P_ADDR_ATTRIBUTE12 in VARCHAR2
,P_ADDR_ATTRIBUTE13 in VARCHAR2
,P_ADDR_ATTRIBUTE14 in VARCHAR2
,P_ADDR_ATTRIBUTE15 in VARCHAR2
,P_ADDR_ATTRIBUTE16 in VARCHAR2
,P_ADDR_ATTRIBUTE17 in VARCHAR2
,P_ADDR_ATTRIBUTE18 in VARCHAR2
,P_ADDR_ATTRIBUTE19 in VARCHAR2
,P_ADDR_ATTRIBUTE20 in VARCHAR2
,P_ADD_INFORMATION13 in VARCHAR2
,P_ADD_INFORMATION14 in VARCHAR2
,P_ADD_INFORMATION15 in VARCHAR2
,P_ADD_INFORMATION16 in VARCHAR2
,P_ADD_INFORMATION17 in VARCHAR2
,P_ADD_INFORMATION18 in VARCHAR2
,P_ADD_INFORMATION19 in VARCHAR2
,P_ADD_INFORMATION20 in VARCHAR2
,P_STYLE in VARCHAR2
)is
l_commit_unit_number number;

Line: 60


hr_utility.set_location('Entering: HR_PERSON_ADDRESS_BK3.UPDATE_PERS_ADDR_WITH_STYLE_A', 10);

Line: 63


hr_person_address_be3.UPDATE_PERS_ADDR_WITH_STYLE_A
(P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
,P_VALIDATE_COUNTY => P_VALIDATE_COUNTY
,P_ADDRESS_ID => P_ADDRESS_ID
,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
,P_DATE_FROM => P_DATE_FROM
,P_DATE_TO => P_DATE_TO
,P_ADDRESS_TYPE => P_ADDRESS_TYPE
,P_COMMENTS => P_COMMENTS
,P_ADDRESS_LINE1 => P_ADDRESS_LINE1
,P_ADDRESS_LINE2 => P_ADDRESS_LINE2
,P_ADDRESS_LINE3 => P_ADDRESS_LINE3
,P_TOWN_OR_CITY => P_TOWN_OR_CITY
,P_REGION_1 => P_REGION_1
,P_REGION_2 => P_REGION_2
,P_REGION_3 => P_REGION_3
,P_POSTAL_CODE => P_POSTAL_CODE
,P_COUNTRY => P_COUNTRY
,P_TELEPHONE_NUMBER_1 => P_TELEPHONE_NUMBER_1
,P_TELEPHONE_NUMBER_2 => P_TELEPHONE_NUMBER_2
,P_TELEPHONE_NUMBER_3 => P_TELEPHONE_NUMBER_3
,P_ADDR_ATTRIBUTE_CATEGORY => P_ADDR_ATTRIBUTE_CATEGORY
,P_ADDR_ATTRIBUTE1 => P_ADDR_ATTRIBUTE1
,P_ADDR_ATTRIBUTE2 => P_ADDR_ATTRIBUTE2
,P_ADDR_ATTRIBUTE3 => P_ADDR_ATTRIBUTE3
,P_ADDR_ATTRIBUTE4 => P_ADDR_ATTRIBUTE4
,P_ADDR_ATTRIBUTE5 => P_ADDR_ATTRIBUTE5
,P_ADDR_ATTRIBUTE6 => P_ADDR_ATTRIBUTE6
,P_ADDR_ATTRIBUTE7 => P_ADDR_ATTRIBUTE7
,P_ADDR_ATTRIBUTE8 => P_ADDR_ATTRIBUTE8
,P_ADDR_ATTRIBUTE9 => P_ADDR_ATTRIBUTE9
,P_ADDR_ATTRIBUTE10 => P_ADDR_ATTRIBUTE10
,P_ADDR_ATTRIBUTE11 => P_ADDR_ATTRIBUTE11
,P_ADDR_ATTRIBUTE12 => P_ADDR_ATTRIBUTE12
,P_ADDR_ATTRIBUTE13 => P_ADDR_ATTRIBUTE13
,P_ADDR_ATTRIBUTE14 => P_ADDR_ATTRIBUTE14
,P_ADDR_ATTRIBUTE15 => P_ADDR_ATTRIBUTE15
,P_ADDR_ATTRIBUTE16 => P_ADDR_ATTRIBUTE16
,P_ADDR_ATTRIBUTE17 => P_ADDR_ATTRIBUTE17
,P_ADDR_ATTRIBUTE18 => P_ADDR_ATTRIBUTE18
,P_ADDR_ATTRIBUTE19 => P_ADDR_ATTRIBUTE19
,P_ADDR_ATTRIBUTE20 => P_ADDR_ATTRIBUTE20
,P_ADD_INFORMATION13 => P_ADD_INFORMATION13
,P_ADD_INFORMATION14 => P_ADD_INFORMATION14
,P_ADD_INFORMATION15 => P_ADD_INFORMATION15
,P_ADD_INFORMATION16 => P_ADD_INFORMATION16
,P_ADD_INFORMATION17 => P_ADD_INFORMATION17
,P_ADD_INFORMATION18 => P_ADD_INFORMATION18
,P_ADD_INFORMATION19 => P_ADD_INFORMATION19
,P_ADD_INFORMATION20 => P_ADD_INFORMATION20
,P_STYLE => P_STYLE
);

Line: 120


PER_US_EXTRA_ADDRESS_RULES.UPDATE_TAX_RECORD
(P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
,P_ADDRESS_ID => P_ADDRESS_ID
);

Line: 127


hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_PERS_ADDR_WITH_STYLE', 'AP');

Line: 128


hr_utility.set_location(' Leaving: HR_PERSON_ADDRESS_BK3.UPDATE_PERS_ADDR_WITH_STYLE_A', 20);

Line: 129


end UPDATE_PERS_ADDR_WITH_STYLE_A;

Line: 130


procedure UPDATE_PERS_ADDR_WITH_STYLE_B
(P_EFFECTIVE_DATE in DATE
,P_VALIDATE_COUNTY in BOOLEAN
,P_ADDRESS_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_DATE_FROM in DATE
,P_DATE_TO in DATE
,P_ADDRESS_TYPE in VARCHAR2
,P_COMMENTS in LONG
,P_ADDRESS_LINE1 in VARCHAR2
,P_ADDRESS_LINE2 in VARCHAR2
,P_ADDRESS_LINE3 in VARCHAR2
,P_TOWN_OR_CITY in VARCHAR2
,P_REGION_1 in VARCHAR2
,P_REGION_2 in VARCHAR2
,P_REGION_3 in VARCHAR2
,P_POSTAL_CODE in VARCHAR2
,P_COUNTRY in VARCHAR2
,P_TELEPHONE_NUMBER_1 in VARCHAR2
,P_TELEPHONE_NUMBER_2 in VARCHAR2
,P_TELEPHONE_NUMBER_3 in VARCHAR2
,P_ADDR_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ADDR_ATTRIBUTE1 in VARCHAR2
,P_ADDR_ATTRIBUTE2 in VARCHAR2
,P_ADDR_ATTRIBUTE3 in VARCHAR2
,P_ADDR_ATTRIBUTE4 in VARCHAR2
,P_ADDR_ATTRIBUTE5 in VARCHAR2
,P_ADDR_ATTRIBUTE6 in VARCHAR2
,P_ADDR_ATTRIBUTE7 in VARCHAR2
,P_ADDR_ATTRIBUTE8 in VARCHAR2
,P_ADDR_ATTRIBUTE9 in VARCHAR2
,P_ADDR_ATTRIBUTE10 in VARCHAR2
,P_ADDR_ATTRIBUTE11 in VARCHAR2
,P_ADDR_ATTRIBUTE12 in VARCHAR2
,P_ADDR_ATTRIBUTE13 in VARCHAR2
,P_ADDR_ATTRIBUTE14 in VARCHAR2
,P_ADDR_ATTRIBUTE15 in VARCHAR2
,P_ADDR_ATTRIBUTE16 in VARCHAR2
,P_ADDR_ATTRIBUTE17 in VARCHAR2
,P_ADDR_ATTRIBUTE18 in VARCHAR2
,P_ADDR_ATTRIBUTE19 in VARCHAR2
,P_ADDR_ATTRIBUTE20 in VARCHAR2
,P_ADD_INFORMATION13 in VARCHAR2
,P_ADD_INFORMATION14 in VARCHAR2
,P_ADD_INFORMATION15 in VARCHAR2
,P_ADD_INFORMATION16 in VARCHAR2
,P_ADD_INFORMATION17 in VARCHAR2
,P_ADD_INFORMATION18 in VARCHAR2
,P_ADD_INFORMATION19 in VARCHAR2
,P_ADD_INFORMATION20 in VARCHAR2
,P_STYLE in VARCHAR2
)is
l_commit_unit_number number;

Line: 185


hr_utility.set_location('Entering: HR_PERSON_ADDRESS_BK3.UPDATE_PERS_ADDR_WITH_STYLE_B', 10);

Line: 191


HR_AE_VALIDATE_PKG.UPDATE_ADDRESS_VALIDATE
(P_ADDRESS_ID => P_ADDRESS_ID
,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
,P_ADDRESS_LINE3 => P_ADDRESS_LINE3
,P_TOWN_OR_CITY => P_TOWN_OR_CITY
,P_REGION_1 => P_REGION_1
);

Line: 199


PER_ES_ADDRESS.UPDATE_ES_ADDRESS_STYLE
(P_ADDRESS_ID => P_ADDRESS_ID
,P_POSTAL_CODE => P_POSTAL_CODE
,P_REGION_2 => P_REGION_2
,P_STYLE => P_STYLE
);

Line: 206


PER_PL_ADDRESS.UPDATE_PL_ADDRESS_STYLE
(P_ADDRESS_ID => P_ADDRESS_ID
,P_STYLE => P_STYLE
,P_ADDRESS_TYPE => P_ADDRESS_TYPE
,P_DATE_FROM => P_DATE_FROM
,P_DATE_TO => P_DATE_TO
,P_ADDRESS_LINE1 => P_ADDRESS_LINE1
,P_ADDRESS_LINE2 => P_ADDRESS_LINE2
);

Line: 216


HR_RU_ADDRESS_HOOK.UPDATE_RU_ADDRESS_WITH_STYLE
(P_STYLE => P_STYLE
,P_ADDRESS_ID => P_ADDRESS_ID
,P_ADD_INFORMATION13 => P_ADD_INFORMATION13
,P_POSTAL_CODE => P_POSTAL_CODE
);

Line: 224


hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_PERS_ADDR_WITH_STYLE', 'BP');

Line: 225


hr_utility.set_location(' Leaving: HR_PERSON_ADDRESS_BK3.UPDATE_PERS_ADDR_WITH_STYLE_B', 20);

Line: 226


end UPDATE_PERS_ADDR_WITH_STYLE_B;