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_API dependencies on PER_ADDRESSES

Line 113: from per_addresses adr

109: cursor csr_befpradd is
110: select adr.address_id,
111: adr.object_version_number,
112: adr.date_to
113: from per_addresses adr
114: where adr.person_id = p_person_id
115: and adr.primary_flag = 'Y'
116: and l_effective_date
117: between adr.date_from

Line 3432: l_object_version_number per_addresses.object_version_number%TYPE;

3428: ) is
3429: --
3430: -- Declare cursors and local variables
3431: --
3432: l_object_version_number per_addresses.object_version_number%TYPE;
3433: l_proc varchar2(72) := g_package||'update_person_address';
3434: l_effective_date date;
3435: l_date_from per_addresses.date_from%TYPE;
3436: l_date_to per_addresses.date_to%TYPE;

Line 3435: l_date_from per_addresses.date_from%TYPE;

3431: --
3432: l_object_version_number per_addresses.object_version_number%TYPE;
3433: l_proc varchar2(72) := g_package||'update_person_address';
3434: l_effective_date date;
3435: l_date_from per_addresses.date_from%TYPE;
3436: l_date_to per_addresses.date_to%TYPE;
3437: --
3438: lv_object_version_number number := p_object_version_number ;
3439: --

Line 3436: l_date_to per_addresses.date_to%TYPE;

3432: l_object_version_number per_addresses.object_version_number%TYPE;
3433: l_proc varchar2(72) := g_package||'update_person_address';
3434: l_effective_date date;
3435: l_date_from per_addresses.date_from%TYPE;
3436: l_date_to per_addresses.date_to%TYPE;
3437: --
3438: lv_object_version_number number := p_object_version_number ;
3439: --
3440: begin

Line 3768: l_object_version_number per_addresses.object_version_number%TYPE;

3764: ) is
3765: --
3766: -- Declare cursors and local variables
3767: --
3768: l_object_version_number per_addresses.object_version_number%TYPE;
3769: l_proc varchar2(72) := g_package||'update_pers_addr_with_style';
3770: l_effective_date date;
3771: l_date_from per_addresses.date_from%TYPE;
3772: l_date_to per_addresses.date_to%TYPE;

Line 3771: l_date_from per_addresses.date_from%TYPE;

3767: --
3768: l_object_version_number per_addresses.object_version_number%TYPE;
3769: l_proc varchar2(72) := g_package||'update_pers_addr_with_style';
3770: l_effective_date date;
3771: l_date_from per_addresses.date_from%TYPE;
3772: l_date_to per_addresses.date_to%TYPE;
3773: --
3774: lv_object_version_number number := p_object_version_number ;
3775: --

Line 3772: l_date_to per_addresses.date_to%TYPE;

3768: l_object_version_number per_addresses.object_version_number%TYPE;
3769: l_proc varchar2(72) := g_package||'update_pers_addr_with_style';
3770: l_effective_date date;
3771: l_date_from per_addresses.date_from%TYPE;
3772: l_date_to per_addresses.date_to%TYPE;
3773: --
3774: lv_object_version_number number := p_object_version_number ;
3775: --
3776: begin

Line 4092: l_style per_addresses.style%TYPE;

4088: --
4089: -- Declare cursors and local variables
4090: --
4091: l_proc varchar2(72) := g_package||'update_gb_person_address';
4092: l_style per_addresses.style%TYPE;
4093: --
4094:
4095: cursor csr_add_style is
4096: select addr.style

Line 4097: from per_addresses addr

4093: --
4094:
4095: cursor csr_add_style is
4096: select addr.style
4097: from per_addresses addr
4098: where addr.address_id = p_address_id;
4099: --
4100: begin
4101: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4245: l_style per_addresses.style%TYPE;

4241: --
4242: -- Declare cursors and local variables
4243: --
4244: l_proc varchar2(72) := g_package||'update_us_person_address';
4245: l_style per_addresses.style%TYPE;
4246: --
4247: cursor csr_add_style is
4248: select style
4249: from per_addresses

Line 4249: from per_addresses

4245: l_style per_addresses.style%TYPE;
4246: --
4247: cursor csr_add_style is
4248: select style
4249: from per_addresses
4250: where address_id = p_address_id;
4251: --
4252: begin
4253: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4391: l_style per_addresses.style%TYPE;

4387: --
4388: -- Declare cursors and local variables
4389: --
4390: l_proc varchar2(72) := g_package||'update_AT_person_address';
4391: l_style per_addresses.style%TYPE;
4392: --
4393: cursor csr_add_style is
4394: select addr.style
4395: from per_addresses addr

Line 4395: from per_addresses addr

4391: l_style per_addresses.style%TYPE;
4392: --
4393: cursor csr_add_style is
4394: select addr.style
4395: from per_addresses addr
4396: where addr.address_id = p_address_id;
4397: --
4398: begin
4399: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4543: l_style per_addresses.style%TYPE;

4539: --
4540: -- Declare cursors and local variables
4541: --
4542: l_proc varchar2(72) := g_package||'update_AU_person_address';
4543: l_style per_addresses.style%TYPE;
4544: --
4545: cursor csr_add_style is
4546: select addr.style
4547: from per_addresses addr

Line 4547: from per_addresses addr

4543: l_style per_addresses.style%TYPE;
4544: --
4545: cursor csr_add_style is
4546: select addr.style
4547: from per_addresses addr
4548: where addr.address_id = p_address_id;
4549: --
4550: begin
4551: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4694: l_style per_addresses.style%TYPE;

4690: --
4691: -- Declare cursors and local variables
4692: --
4693: l_proc varchar2(72) := g_package||'update_AU_LOC_person_address';
4694: l_style per_addresses.style%TYPE;
4695: --
4696: cursor csr_add_style is
4697: select addr.style
4698: from per_addresses addr

Line 4698: from per_addresses addr

4694: l_style per_addresses.style%TYPE;
4695: --
4696: cursor csr_add_style is
4697: select addr.style
4698: from per_addresses addr
4699: where addr.address_id = p_address_id;
4700: --
4701: begin
4702: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4844: l_style per_addresses.style%TYPE;

4840: --
4841: -- Declare cursors and local variables
4842: --
4843: l_proc varchar2(72) := g_package||'update_DK_person_address';
4844: l_style per_addresses.style%TYPE;
4845: --
4846: cursor csr_add_style is
4847: select addr.style
4848: from per_addresses addr

Line 4848: from per_addresses addr

4844: l_style per_addresses.style%TYPE;
4845: --
4846: cursor csr_add_style is
4847: select addr.style
4848: from per_addresses addr
4849: where addr.address_id = p_address_id;
4850: --
4851: begin
4852: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4995: l_style per_addresses.style%TYPE;

4991: --
4992: -- Declare cursors and local variables
4993: --
4994: l_proc varchar2(72) := g_package||'update_DE_person_address';
4995: l_style per_addresses.style%TYPE;
4996: --
4997: cursor csr_add_style is
4998: select addr.style
4999: from per_addresses addr

Line 4999: from per_addresses addr

4995: l_style per_addresses.style%TYPE;
4996: --
4997: cursor csr_add_style is
4998: select addr.style
4999: from per_addresses addr
5000: where addr.address_id = p_address_id;
5001: --
5002: begin
5003: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5147: l_style per_addresses.style%TYPE;

5143: --
5144: -- Declare cursors and local variables
5145: --
5146: l_proc varchar2(72) := g_package||'update_IT_person_address';
5147: l_style per_addresses.style%TYPE;
5148: --
5149: cursor csr_add_style is
5150: select addr.style
5151: from per_addresses addr

Line 5151: from per_addresses addr

5147: l_style per_addresses.style%TYPE;
5148: --
5149: cursor csr_add_style is
5150: select addr.style
5151: from per_addresses addr
5152: where addr.address_id = p_address_id;
5153: --
5154: begin
5155: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5299: l_style per_addresses.style%TYPE;

5295: --
5296: -- Declare cursors and local variables
5297: --
5298: l_proc varchar2(72) := g_package||'update_MX_person_address';
5299: l_style per_addresses.style%TYPE;
5300: --
5301: cursor csr_add_style is
5302: select addr.style
5303: from per_addresses addr

Line 5303: from per_addresses addr

5299: l_style per_addresses.style%TYPE;
5300: --
5301: cursor csr_add_style is
5302: select addr.style
5303: from per_addresses addr
5304: where addr.address_id = p_address_id;
5305: --
5306: begin
5307: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5452: l_style per_addresses.style%TYPE;

5448: --
5449: -- Declare cursors and local variables
5450: --
5451: l_proc varchar2(72) := g_package||'update_MX_LOC_person_address';
5452: l_style per_addresses.style%TYPE;
5453: --
5454: cursor csr_add_style is
5455: select addr.style
5456: from per_addresses addr

Line 5456: from per_addresses addr

5452: l_style per_addresses.style%TYPE;
5453: --
5454: cursor csr_add_style is
5455: select addr.style
5456: from per_addresses addr
5457: where addr.address_id = p_address_id;
5458: --
5459: begin
5460: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5605: l_style per_addresses.style%TYPE;

5601: --
5602: -- Declare cursors and local variables
5603: --
5604: l_proc varchar2(72) := g_package||'update_MY_person_address';
5605: l_style per_addresses.style%TYPE;
5606: --
5607: cursor csr_add_style is
5608: select addr.style
5609: from per_addresses addr

Line 5609: from per_addresses addr

5605: l_style per_addresses.style%TYPE;
5606: --
5607: cursor csr_add_style is
5608: select addr.style
5609: from per_addresses addr
5610: where addr.address_id = p_address_id;
5611: --
5612: begin
5613: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5756: l_style per_addresses.style%TYPE;

5752: --
5753: -- Declare cursors and local variables
5754: --
5755: l_proc varchar2(72) := g_package||'update_PT_person_address';
5756: l_style per_addresses.style%TYPE;
5757: --
5758: cursor csr_add_style is
5759: select addr.style
5760: from per_addresses addr

Line 5760: from per_addresses addr

5756: l_style per_addresses.style%TYPE;
5757: --
5758: cursor csr_add_style is
5759: select addr.style
5760: from per_addresses addr
5761: where addr.address_id = p_address_id;
5762: --
5763: begin
5764: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5906: l_style per_addresses.style%TYPE;

5902: --
5903: -- Declare cursors and local variables
5904: --
5905: l_proc varchar2(72) := g_package||'update_BE_person_address';
5906: l_style per_addresses.style%TYPE;
5907: --
5908: cursor csr_add_style is
5909: select addr.style
5910: from per_addresses addr

Line 5910: from per_addresses addr

5906: l_style per_addresses.style%TYPE;
5907: --
5908: cursor csr_add_style is
5909: select addr.style
5910: from per_addresses addr
5911: where addr.address_id = p_address_id;
5912: --
5913: begin
5914: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6056: l_style per_addresses.style%TYPE;

6052: --
6053: -- Declare cursors and local variables
6054: --
6055: l_proc varchar2(72) := g_package||'update_FI_person_address';
6056: l_style per_addresses.style%TYPE;
6057: --
6058: cursor csr_add_style is
6059: select addr.style
6060: from per_addresses addr

Line 6060: from per_addresses addr

6056: l_style per_addresses.style%TYPE;
6057: --
6058: cursor csr_add_style is
6059: select addr.style
6060: from per_addresses addr
6061: where addr.address_id = p_address_id;
6062: --
6063: begin
6064: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6206: l_style per_addresses.style%TYPE;

6202: --
6203: -- Declare cursors and local variables
6204: --
6205: l_proc varchar2(72) := g_package||'update_GR_person_address';
6206: l_style per_addresses.style%TYPE;
6207: --
6208: cursor csr_add_style is
6209: select addr.style
6210: from per_addresses addr

Line 6210: from per_addresses addr

6206: l_style per_addresses.style%TYPE;
6207: --
6208: cursor csr_add_style is
6209: select addr.style
6210: from per_addresses addr
6211: where addr.address_id = p_address_id;
6212: --
6213: begin
6214: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6355: l_style per_addresses.style%TYPE;

6351: --
6352: -- Declare cursors and local variables
6353: --
6354: l_proc varchar2(72) := g_package||'update_HK_person_address';
6355: l_style per_addresses.style%TYPE;
6356: --
6357: cursor csr_add_style is
6358: select addr.style
6359: from per_addresses addr

Line 6359: from per_addresses addr

6355: l_style per_addresses.style%TYPE;
6356: --
6357: cursor csr_add_style is
6358: select addr.style
6359: from per_addresses addr
6360: where addr.address_id = p_address_id;
6361: --
6362: begin
6363: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6505: l_style per_addresses.style%TYPE;

6501: --
6502: -- Declare cursors and local variables
6503: --
6504: l_proc varchar2(72) := g_package||'update_IE_person_address';
6505: l_style per_addresses.style%TYPE;
6506: --
6507: cursor csr_add_style is
6508: select addr.style
6509: from per_addresses addr

Line 6509: from per_addresses addr

6505: l_style per_addresses.style%TYPE;
6506: --
6507: cursor csr_add_style is
6508: select addr.style
6509: from per_addresses addr
6510: where addr.address_id = p_address_id;
6511: --
6512: begin
6513: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6657: l_style per_addresses.style%TYPE;

6653: --
6654: -- Declare cursors and local variables
6655: --
6656: l_proc varchar2(72) := g_package||'update_LU_person_address';
6657: l_style per_addresses.style%TYPE;
6658: --
6659: cursor csr_add_style is
6660: select addr.style
6661: from per_addresses addr

Line 6661: from per_addresses addr

6657: l_style per_addresses.style%TYPE;
6658: --
6659: cursor csr_add_style is
6660: select addr.style
6661: from per_addresses addr
6662: where addr.address_id = p_address_id;
6663: --
6664: begin
6665: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6808: l_style per_addresses.style%TYPE;

6804: --
6805: -- Declare cursors and local variables
6806: --
6807: l_proc varchar2(72) := g_package||'update_NL_person_address';
6808: l_style per_addresses.style%TYPE;
6809: --
6810: cursor csr_add_style is
6811: select addr.style
6812: from per_addresses addr

Line 6812: from per_addresses addr

6808: l_style per_addresses.style%TYPE;
6809: --
6810: cursor csr_add_style is
6811: select addr.style
6812: from per_addresses addr
6813: where addr.address_id = p_address_id;
6814: --
6815: begin
6816: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6959: l_style per_addresses.style%TYPE;

6955: --
6956: -- Declare cursors and local variables
6957: --
6958: l_proc varchar2(72) := g_package||'update_SG_person_address';
6959: l_style per_addresses.style%TYPE;
6960: --
6961: cursor csr_add_style is
6962: select addr.style
6963: from per_addresses addr

Line 6963: from per_addresses addr

6959: l_style per_addresses.style%TYPE;
6960: --
6961: cursor csr_add_style is
6962: select addr.style
6963: from per_addresses addr
6964: where addr.address_id = p_address_id;
6965: --
6966: begin
6967: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 7109: l_style per_addresses.style%TYPE;

7105: --
7106: -- Declare cursors and local variables
7107: --
7108: l_proc varchar2(72) := g_package||'update_SE_person_address';
7109: l_style per_addresses.style%TYPE;
7110: --
7111: cursor csr_add_style is
7112: select addr.style
7113: from per_addresses addr

Line 7113: from per_addresses addr

7109: l_style per_addresses.style%TYPE;
7110: --
7111: cursor csr_add_style is
7112: select addr.style
7113: from per_addresses addr
7114: where addr.address_id = p_address_id;
7115: --
7116: begin
7117: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 7259: l_style per_addresses.style%TYPE;

7255: --
7256: -- Declare cursors and local variables
7257: --
7258: l_proc varchar2(72);
7259: l_style per_addresses.style%TYPE;
7260: --
7261: cursor csr_add_style is
7262: select addr.style
7263: from per_addresses addr

Line 7263: from per_addresses addr

7259: l_style per_addresses.style%TYPE;
7260: --
7261: cursor csr_add_style is
7262: select addr.style
7263: from per_addresses addr
7264: where addr.address_id = p_address_id;
7265: --
7266: begin
7267: --

Line 7412: l_style per_addresses.style%TYPE;

7408: --
7409: -- Declare cursors and local variables
7410: --
7411: l_proc varchar2(72) ;
7412: l_style per_addresses.style%TYPE;
7413: --
7414: cursor csr_add_style is
7415: select addr.style
7416: from per_addresses addr

Line 7416: from per_addresses addr

7412: l_style per_addresses.style%TYPE;
7413: --
7414: cursor csr_add_style is
7415: select addr.style
7416: from per_addresses addr
7417: where addr.address_id = p_address_id;
7418: --
7419: begin
7420: --

Line 7555: l_style per_addresses.style%TYPE;

7551: --
7552: -- Declare cursors and local variables
7553: --
7554: l_proc varchar2(72) := g_package||'update_SA_person_address';
7555: l_style per_addresses.style%TYPE;
7556: --
7557: cursor csr_add_style is
7558: select addr.style
7559: from per_addresses addr

Line 7559: from per_addresses addr

7555: l_style per_addresses.style%TYPE;
7556: --
7557: cursor csr_add_style is
7558: select addr.style
7559: from per_addresses addr
7560: where addr.address_id = p_address_id;
7561: --
7562: begin
7563: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 8239: l_style per_addresses.style%TYPE;

8235: --
8236: -- Declare cursors and local variables
8237: --
8238: l_proc varchar2(72) := g_package||'update_IE_GLB_person_address';
8239: l_style per_addresses.style%TYPE;
8240: --
8241: cursor csr_add_style is
8242: select addr.style
8243: from per_addresses addr

Line 8243: from per_addresses addr

8239: l_style per_addresses.style%TYPE;
8240: --
8241: cursor csr_add_style is
8242: select addr.style
8243: from per_addresses addr
8244: where addr.address_id = p_address_id;
8245: --
8246: begin
8247: hr_utility.set_location('Entering:'|| l_proc, 5);