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 3311: l_object_version_number per_addresses.object_version_number%TYPE;

3307: ) is
3308: --
3309: -- Declare cursors and local variables
3310: --
3311: l_object_version_number per_addresses.object_version_number%TYPE;
3312: l_proc varchar2(72) := g_package||'update_person_address';
3313: l_effective_date date;
3314: l_date_from per_addresses.date_from%TYPE;
3315: l_date_to per_addresses.date_to%TYPE;

Line 3314: l_date_from per_addresses.date_from%TYPE;

3310: --
3311: l_object_version_number per_addresses.object_version_number%TYPE;
3312: l_proc varchar2(72) := g_package||'update_person_address';
3313: l_effective_date date;
3314: l_date_from per_addresses.date_from%TYPE;
3315: l_date_to per_addresses.date_to%TYPE;
3316: --
3317: lv_object_version_number number := p_object_version_number ;
3318: --

Line 3315: l_date_to per_addresses.date_to%TYPE;

3311: l_object_version_number per_addresses.object_version_number%TYPE;
3312: l_proc varchar2(72) := g_package||'update_person_address';
3313: l_effective_date date;
3314: l_date_from per_addresses.date_from%TYPE;
3315: l_date_to per_addresses.date_to%TYPE;
3316: --
3317: lv_object_version_number number := p_object_version_number ;
3318: --
3319: begin

Line 3647: l_object_version_number per_addresses.object_version_number%TYPE;

3643: ) is
3644: --
3645: -- Declare cursors and local variables
3646: --
3647: l_object_version_number per_addresses.object_version_number%TYPE;
3648: l_proc varchar2(72) := g_package||'update_pers_addr_with_style';
3649: l_effective_date date;
3650: l_date_from per_addresses.date_from%TYPE;
3651: l_date_to per_addresses.date_to%TYPE;

Line 3650: l_date_from per_addresses.date_from%TYPE;

3646: --
3647: l_object_version_number per_addresses.object_version_number%TYPE;
3648: l_proc varchar2(72) := g_package||'update_pers_addr_with_style';
3649: l_effective_date date;
3650: l_date_from per_addresses.date_from%TYPE;
3651: l_date_to per_addresses.date_to%TYPE;
3652: --
3653: lv_object_version_number number := p_object_version_number ;
3654: --

Line 3651: l_date_to per_addresses.date_to%TYPE;

3647: l_object_version_number per_addresses.object_version_number%TYPE;
3648: l_proc varchar2(72) := g_package||'update_pers_addr_with_style';
3649: l_effective_date date;
3650: l_date_from per_addresses.date_from%TYPE;
3651: l_date_to per_addresses.date_to%TYPE;
3652: --
3653: lv_object_version_number number := p_object_version_number ;
3654: --
3655: begin

Line 3970: l_style per_addresses.style%TYPE;

3966: --
3967: -- Declare cursors and local variables
3968: --
3969: l_proc varchar2(72) := g_package||'update_gb_person_address';
3970: l_style per_addresses.style%TYPE;
3971: --
3972:
3973: cursor csr_add_style is
3974: select addr.style

Line 3975: from per_addresses addr

3971: --
3972:
3973: cursor csr_add_style is
3974: select addr.style
3975: from per_addresses addr
3976: where addr.address_id = p_address_id;
3977: --
3978: begin
3979: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4123: l_style per_addresses.style%TYPE;

4119: --
4120: -- Declare cursors and local variables
4121: --
4122: l_proc varchar2(72) := g_package||'update_us_person_address';
4123: l_style per_addresses.style%TYPE;
4124: --
4125: cursor csr_add_style is
4126: select style
4127: from per_addresses

Line 4127: from per_addresses

4123: l_style per_addresses.style%TYPE;
4124: --
4125: cursor csr_add_style is
4126: select style
4127: from per_addresses
4128: where address_id = p_address_id;
4129: --
4130: begin
4131: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4269: l_style per_addresses.style%TYPE;

4265: --
4266: -- Declare cursors and local variables
4267: --
4268: l_proc varchar2(72) := g_package||'update_AT_person_address';
4269: l_style per_addresses.style%TYPE;
4270: --
4271: cursor csr_add_style is
4272: select addr.style
4273: from per_addresses addr

Line 4273: from per_addresses addr

4269: l_style per_addresses.style%TYPE;
4270: --
4271: cursor csr_add_style is
4272: select addr.style
4273: from per_addresses addr
4274: where addr.address_id = p_address_id;
4275: --
4276: begin
4277: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4421: l_style per_addresses.style%TYPE;

4417: --
4418: -- Declare cursors and local variables
4419: --
4420: l_proc varchar2(72) := g_package||'update_AU_person_address';
4421: l_style per_addresses.style%TYPE;
4422: --
4423: cursor csr_add_style is
4424: select addr.style
4425: from per_addresses addr

Line 4425: from per_addresses addr

4421: l_style per_addresses.style%TYPE;
4422: --
4423: cursor csr_add_style is
4424: select addr.style
4425: from per_addresses addr
4426: where addr.address_id = p_address_id;
4427: --
4428: begin
4429: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4572: l_style per_addresses.style%TYPE;

4568: --
4569: -- Declare cursors and local variables
4570: --
4571: l_proc varchar2(72) := g_package||'update_DK_person_address';
4572: l_style per_addresses.style%TYPE;
4573: --
4574: cursor csr_add_style is
4575: select addr.style
4576: from per_addresses addr

Line 4576: from per_addresses addr

4572: l_style per_addresses.style%TYPE;
4573: --
4574: cursor csr_add_style is
4575: select addr.style
4576: from per_addresses addr
4577: where addr.address_id = p_address_id;
4578: --
4579: begin
4580: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4723: l_style per_addresses.style%TYPE;

4719: --
4720: -- Declare cursors and local variables
4721: --
4722: l_proc varchar2(72) := g_package||'update_DE_person_address';
4723: l_style per_addresses.style%TYPE;
4724: --
4725: cursor csr_add_style is
4726: select addr.style
4727: from per_addresses addr

Line 4727: from per_addresses addr

4723: l_style per_addresses.style%TYPE;
4724: --
4725: cursor csr_add_style is
4726: select addr.style
4727: from per_addresses addr
4728: where addr.address_id = p_address_id;
4729: --
4730: begin
4731: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 4875: l_style per_addresses.style%TYPE;

4871: --
4872: -- Declare cursors and local variables
4873: --
4874: l_proc varchar2(72) := g_package||'update_IT_person_address';
4875: l_style per_addresses.style%TYPE;
4876: --
4877: cursor csr_add_style is
4878: select addr.style
4879: from per_addresses addr

Line 4879: from per_addresses addr

4875: l_style per_addresses.style%TYPE;
4876: --
4877: cursor csr_add_style is
4878: select addr.style
4879: from per_addresses addr
4880: where addr.address_id = p_address_id;
4881: --
4882: begin
4883: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5027: l_style per_addresses.style%TYPE;

5023: --
5024: -- Declare cursors and local variables
5025: --
5026: l_proc varchar2(72) := g_package||'update_MX_person_address';
5027: l_style per_addresses.style%TYPE;
5028: --
5029: cursor csr_add_style is
5030: select addr.style
5031: from per_addresses addr

Line 5031: from per_addresses addr

5027: l_style per_addresses.style%TYPE;
5028: --
5029: cursor csr_add_style is
5030: select addr.style
5031: from per_addresses addr
5032: where addr.address_id = p_address_id;
5033: --
5034: begin
5035: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5180: l_style per_addresses.style%TYPE;

5176: --
5177: -- Declare cursors and local variables
5178: --
5179: l_proc varchar2(72) := g_package||'update_MX_LOC_person_address';
5180: l_style per_addresses.style%TYPE;
5181: --
5182: cursor csr_add_style is
5183: select addr.style
5184: from per_addresses addr

Line 5184: from per_addresses addr

5180: l_style per_addresses.style%TYPE;
5181: --
5182: cursor csr_add_style is
5183: select addr.style
5184: from per_addresses addr
5185: where addr.address_id = p_address_id;
5186: --
5187: begin
5188: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5333: l_style per_addresses.style%TYPE;

5329: --
5330: -- Declare cursors and local variables
5331: --
5332: l_proc varchar2(72) := g_package||'update_MY_person_address';
5333: l_style per_addresses.style%TYPE;
5334: --
5335: cursor csr_add_style is
5336: select addr.style
5337: from per_addresses addr

Line 5337: from per_addresses addr

5333: l_style per_addresses.style%TYPE;
5334: --
5335: cursor csr_add_style is
5336: select addr.style
5337: from per_addresses addr
5338: where addr.address_id = p_address_id;
5339: --
5340: begin
5341: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5484: l_style per_addresses.style%TYPE;

5480: --
5481: -- Declare cursors and local variables
5482: --
5483: l_proc varchar2(72) := g_package||'update_PT_person_address';
5484: l_style per_addresses.style%TYPE;
5485: --
5486: cursor csr_add_style is
5487: select addr.style
5488: from per_addresses addr

Line 5488: from per_addresses addr

5484: l_style per_addresses.style%TYPE;
5485: --
5486: cursor csr_add_style is
5487: select addr.style
5488: from per_addresses addr
5489: where addr.address_id = p_address_id;
5490: --
5491: begin
5492: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5634: l_style per_addresses.style%TYPE;

5630: --
5631: -- Declare cursors and local variables
5632: --
5633: l_proc varchar2(72) := g_package||'update_BE_person_address';
5634: l_style per_addresses.style%TYPE;
5635: --
5636: cursor csr_add_style is
5637: select addr.style
5638: from per_addresses addr

Line 5638: from per_addresses addr

5634: l_style per_addresses.style%TYPE;
5635: --
5636: cursor csr_add_style is
5637: select addr.style
5638: from per_addresses addr
5639: where addr.address_id = p_address_id;
5640: --
5641: begin
5642: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5784: l_style per_addresses.style%TYPE;

5780: --
5781: -- Declare cursors and local variables
5782: --
5783: l_proc varchar2(72) := g_package||'update_FI_person_address';
5784: l_style per_addresses.style%TYPE;
5785: --
5786: cursor csr_add_style is
5787: select addr.style
5788: from per_addresses addr

Line 5788: from per_addresses addr

5784: l_style per_addresses.style%TYPE;
5785: --
5786: cursor csr_add_style is
5787: select addr.style
5788: from per_addresses addr
5789: where addr.address_id = p_address_id;
5790: --
5791: begin
5792: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 5934: l_style per_addresses.style%TYPE;

5930: --
5931: -- Declare cursors and local variables
5932: --
5933: l_proc varchar2(72) := g_package||'update_GR_person_address';
5934: l_style per_addresses.style%TYPE;
5935: --
5936: cursor csr_add_style is
5937: select addr.style
5938: from per_addresses addr

Line 5938: from per_addresses addr

5934: l_style per_addresses.style%TYPE;
5935: --
5936: cursor csr_add_style is
5937: select addr.style
5938: from per_addresses addr
5939: where addr.address_id = p_address_id;
5940: --
5941: begin
5942: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6083: l_style per_addresses.style%TYPE;

6079: --
6080: -- Declare cursors and local variables
6081: --
6082: l_proc varchar2(72) := g_package||'update_HK_person_address';
6083: l_style per_addresses.style%TYPE;
6084: --
6085: cursor csr_add_style is
6086: select addr.style
6087: from per_addresses addr

Line 6087: from per_addresses addr

6083: l_style per_addresses.style%TYPE;
6084: --
6085: cursor csr_add_style is
6086: select addr.style
6087: from per_addresses addr
6088: where addr.address_id = p_address_id;
6089: --
6090: begin
6091: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6233: l_style per_addresses.style%TYPE;

6229: --
6230: -- Declare cursors and local variables
6231: --
6232: l_proc varchar2(72) := g_package||'update_IE_person_address';
6233: l_style per_addresses.style%TYPE;
6234: --
6235: cursor csr_add_style is
6236: select addr.style
6237: from per_addresses addr

Line 6237: from per_addresses addr

6233: l_style per_addresses.style%TYPE;
6234: --
6235: cursor csr_add_style is
6236: select addr.style
6237: from per_addresses addr
6238: where addr.address_id = p_address_id;
6239: --
6240: begin
6241: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6384: l_style per_addresses.style%TYPE;

6380: --
6381: -- Declare cursors and local variables
6382: --
6383: l_proc varchar2(72) := g_package||'update_LU_person_address';
6384: l_style per_addresses.style%TYPE;
6385: --
6386: cursor csr_add_style is
6387: select addr.style
6388: from per_addresses addr

Line 6388: from per_addresses addr

6384: l_style per_addresses.style%TYPE;
6385: --
6386: cursor csr_add_style is
6387: select addr.style
6388: from per_addresses addr
6389: where addr.address_id = p_address_id;
6390: --
6391: begin
6392: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6535: l_style per_addresses.style%TYPE;

6531: --
6532: -- Declare cursors and local variables
6533: --
6534: l_proc varchar2(72) := g_package||'update_NL_person_address';
6535: l_style per_addresses.style%TYPE;
6536: --
6537: cursor csr_add_style is
6538: select addr.style
6539: from per_addresses addr

Line 6539: from per_addresses addr

6535: l_style per_addresses.style%TYPE;
6536: --
6537: cursor csr_add_style is
6538: select addr.style
6539: from per_addresses addr
6540: where addr.address_id = p_address_id;
6541: --
6542: begin
6543: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6686: l_style per_addresses.style%TYPE;

6682: --
6683: -- Declare cursors and local variables
6684: --
6685: l_proc varchar2(72) := g_package||'update_SG_person_address';
6686: l_style per_addresses.style%TYPE;
6687: --
6688: cursor csr_add_style is
6689: select addr.style
6690: from per_addresses addr

Line 6690: from per_addresses addr

6686: l_style per_addresses.style%TYPE;
6687: --
6688: cursor csr_add_style is
6689: select addr.style
6690: from per_addresses addr
6691: where addr.address_id = p_address_id;
6692: --
6693: begin
6694: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6836: l_style per_addresses.style%TYPE;

6832: --
6833: -- Declare cursors and local variables
6834: --
6835: l_proc varchar2(72) := g_package||'update_SE_person_address';
6836: l_style per_addresses.style%TYPE;
6837: --
6838: cursor csr_add_style is
6839: select addr.style
6840: from per_addresses addr

Line 6840: from per_addresses addr

6836: l_style per_addresses.style%TYPE;
6837: --
6838: cursor csr_add_style is
6839: select addr.style
6840: from per_addresses addr
6841: where addr.address_id = p_address_id;
6842: --
6843: begin
6844: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 6986: l_style per_addresses.style%TYPE;

6982: --
6983: -- Declare cursors and local variables
6984: --
6985: l_proc varchar2(72);
6986: l_style per_addresses.style%TYPE;
6987: --
6988: cursor csr_add_style is
6989: select addr.style
6990: from per_addresses addr

Line 6990: from per_addresses addr

6986: l_style per_addresses.style%TYPE;
6987: --
6988: cursor csr_add_style is
6989: select addr.style
6990: from per_addresses addr
6991: where addr.address_id = p_address_id;
6992: --
6993: begin
6994: --

Line 7139: l_style per_addresses.style%TYPE;

7135: --
7136: -- Declare cursors and local variables
7137: --
7138: l_proc varchar2(72) ;
7139: l_style per_addresses.style%TYPE;
7140: --
7141: cursor csr_add_style is
7142: select addr.style
7143: from per_addresses addr

Line 7143: from per_addresses addr

7139: l_style per_addresses.style%TYPE;
7140: --
7141: cursor csr_add_style is
7142: select addr.style
7143: from per_addresses addr
7144: where addr.address_id = p_address_id;
7145: --
7146: begin
7147: --

Line 7282: l_style per_addresses.style%TYPE;

7278: --
7279: -- Declare cursors and local variables
7280: --
7281: l_proc varchar2(72) := g_package||'update_SA_person_address';
7282: l_style per_addresses.style%TYPE;
7283: --
7284: cursor csr_add_style is
7285: select addr.style
7286: from per_addresses addr

Line 7286: from per_addresses addr

7282: l_style per_addresses.style%TYPE;
7283: --
7284: cursor csr_add_style is
7285: select addr.style
7286: from per_addresses addr
7287: where addr.address_id = p_address_id;
7288: --
7289: begin
7290: hr_utility.set_location('Entering:'|| l_proc, 5);