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 HR_PERSON_ADDRESS_API

Line 1: Package Body hr_person_address_api as

1: Package Body hr_person_address_api as
2: /* $Header: peaddapi.pkb 120.2.12010000.1 2008/07/28 04:02:14 appldev ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' hr_person_address_api.';

2: /* $Header: peaddapi.pkb 120.2.12010000.1 2008/07/28 04:02:14 appldev ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_person_address_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_person_address >-------------------------|
10: -- ----------------------------------------------------------------------------

Line 519: hr_person_address_api.create_person_address

515: hr_utility.set_location('Entering:'|| l_proc, 5);
516: --
517: -- Create Person Address details.
518: --
519: hr_person_address_api.create_person_address
520: (p_validate => p_validate
521: ,p_effective_date => p_effective_date
522: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
523: ,p_person_id => p_person_id

Line 644: hr_person_address_api.create_person_address

640: hr_utility.set_location('Entering:'|| l_proc, 5);
641: --
642: -- Create Person Address details.
643: --
644: hr_person_address_api.create_person_address
645: (p_validate => p_validate
646: ,p_effective_date => p_effective_date
647: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
648: ,p_validate_county => p_validate_county

Line 769: hr_person_address_api.create_person_address

765: hr_utility.set_location('Entering:'|| l_proc, 5);
766: --
767: -- Create Person Address details.
768: --
769: hr_person_address_api.create_person_address
770: (p_validate => p_validate
771: ,p_effective_date => p_effective_date
772: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
773: ,p_person_id => p_person_id

Line 892: hr_person_address_api.create_person_address

888: hr_utility.set_location('Entering:'|| l_proc, 5);
889: --
890: -- Create Person Address details.
891: --
892: hr_person_address_api.create_person_address
893: (p_validate => p_validate
894: ,p_effective_date => p_effective_date
895: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
896: ,p_person_id => p_person_id

Line 1014: hr_person_address_api.create_person_address

1010: hr_utility.set_location('Entering:'|| l_proc, 5);
1011: --
1012: -- Create Person Address details.
1013: --
1014: hr_person_address_api.create_person_address
1015: (p_validate => p_validate
1016: ,p_effective_date => p_effective_date
1017: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
1018: ,p_person_id => p_person_id

Line 1136: hr_person_address_api.create_person_address

1132: hr_utility.set_location('Entering:'|| l_proc, 5);
1133: --
1134: -- Create Person Address details.
1135: --
1136: hr_person_address_api.create_person_address
1137: (p_validate => p_validate
1138: ,p_effective_date => p_effective_date
1139: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
1140: ,p_person_id => p_person_id

Line 1259: hr_person_address_api.create_person_address

1255: hr_utility.set_location('Entering:'|| l_proc, 5);
1256: --
1257: -- Create Person Address details.
1258: --
1259: hr_person_address_api.create_person_address
1260: (p_validate => p_validate
1261: ,p_effective_date => p_effective_date
1262: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
1263: ,p_person_id => p_person_id

Line 1382: hr_person_address_api.create_person_address

1378: hr_utility.set_location('Entering:'|| l_proc, 5);
1379: --
1380: -- Create Person Address details.
1381: --
1382: hr_person_address_api.create_person_address
1383: (p_validate => p_validate
1384: ,p_effective_date => p_effective_date
1385: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
1386: ,p_person_id => p_person_id

Line 1506: hr_person_address_api.create_person_address

1502: hr_utility.set_location('Entering:'|| l_proc, 5);
1503: --
1504: -- Create Person Address details.
1505: --
1506: hr_person_address_api.create_person_address
1507: (p_validate => p_validate
1508: ,p_effective_date => p_effective_date
1509: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
1510: ,p_person_id => p_person_id

Line 1630: hr_person_address_api.create_person_address

1626: hr_utility.set_location('Entering:'|| l_proc, 5);
1627: --
1628: -- Create Person Address details.
1629: --
1630: hr_person_address_api.create_person_address
1631: (p_validate => p_validate
1632: ,p_effective_date => p_effective_date
1633: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
1634: ,p_person_id => p_person_id

Line 1752: hr_person_address_api.create_person_address

1748: hr_utility.set_location('Entering:'|| l_proc, 5);
1749: --
1750: -- Create Person Address details.
1751: --
1752: hr_person_address_api.create_person_address
1753: (p_validate => p_validate
1754: ,p_effective_date => p_effective_date
1755: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
1756: ,p_person_id => p_person_id

Line 1873: hr_person_address_api.create_person_address

1869: hr_utility.set_location('Entering:'|| l_proc, 5);
1870: --
1871: -- Create Person Address details.
1872: --
1873: hr_person_address_api.create_person_address
1874: (p_validate => p_validate
1875: ,p_effective_date => p_effective_date
1876: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
1877: ,p_person_id => p_person_id

Line 1994: hr_person_address_api.create_person_address

1990: hr_utility.set_location('Entering:'|| l_proc, 5);
1991: --
1992: -- Create Person Address details.
1993: --
1994: hr_person_address_api.create_person_address
1995: (p_validate => p_validate
1996: ,p_effective_date => p_effective_date
1997: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
1998: ,p_person_id => p_person_id

Line 2115: hr_person_address_api.create_person_address

2111: hr_utility.set_location('Entering:'|| l_proc, 5);
2112: --
2113: -- Create Person Address details.
2114: --
2115: hr_person_address_api.create_person_address
2116: (p_validate => p_validate
2117: ,p_effective_date => p_effective_date
2118: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
2119: ,p_person_id => p_person_id

Line 2235: hr_person_address_api.create_person_address

2231: hr_utility.set_location('Entering:'|| l_proc, 5);
2232: --
2233: -- Create Person Address details.
2234: --
2235: hr_person_address_api.create_person_address
2236: (p_validate => p_validate
2237: ,p_effective_date => p_effective_date
2238: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
2239: ,p_person_id => p_person_id

Line 2356: hr_person_address_api.create_person_address

2352: hr_utility.set_location('Entering:'|| l_proc, 5);
2353: --
2354: -- Create Person Address details.
2355: --
2356: hr_person_address_api.create_person_address
2357: (p_validate => p_validate
2358: ,p_effective_date => p_effective_date
2359: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
2360: ,p_person_id => p_person_id

Line 2478: hr_person_address_api.create_person_address

2474: hr_utility.set_location('Entering:'|| l_proc, 5);
2475: --
2476: -- Create Person Address details.
2477: --
2478: hr_person_address_api.create_person_address
2479: (p_validate => p_validate
2480: ,p_effective_date => p_effective_date
2481: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
2482: ,p_person_id => p_person_id

Line 2600: hr_person_address_api.create_person_address

2596: hr_utility.set_location('Entering:'|| l_proc, 5);
2597: --
2598: -- Create Person Address details.
2599: --
2600: hr_person_address_api.create_person_address
2601: (p_validate => p_validate
2602: ,p_effective_date => p_effective_date
2603: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
2604: ,p_person_id => p_person_id

Line 2722: hr_person_address_api.create_person_address

2718: hr_utility.set_location('Entering:'|| l_proc, 5);
2719: --
2720: -- Create Person Address details.
2721: --
2722: hr_person_address_api.create_person_address
2723: (p_validate => p_validate
2724: ,p_effective_date => p_effective_date
2725: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
2726: ,p_person_id => p_person_id

Line 2843: hr_person_address_api.create_person_address

2839: hr_utility.set_location('Entering:'|| l_proc, 5);
2840: --
2841: -- Create Person Address details.
2842: --
2843: hr_person_address_api.create_person_address
2844: (p_validate => p_validate
2845: ,p_effective_date => p_effective_date
2846: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
2847: ,p_person_id => p_person_id

Line 2967: hr_person_address_api.create_person_address

2963: hr_utility.set_location('Entering:'|| l_proc, 5);
2964: --
2965: -- Create Person Address details.
2966: --
2967: hr_person_address_api.create_person_address
2968: (p_validate => p_validate
2969: ,p_effective_date => p_effective_date
2970: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
2971: ,p_person_id => p_person_id

Line 3091: hr_person_address_api.create_person_address

3087: hr_utility.set_location('Entering:'|| l_proc, 5);
3088: --
3089: -- Create Person Address details.
3090: --
3091: hr_person_address_api.create_person_address
3092: (p_validate => p_validate
3093: ,p_effective_date => p_effective_date
3094: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
3095: ,p_person_id => p_person_id

Line 3202: hr_person_address_api.create_person_address

3198: hr_utility.set_location('Entering:'|| l_proc, 5);
3199: --
3200: -- Create Person Address details.
3201: --
3202: hr_person_address_api.create_person_address
3203: (p_validate => p_validate
3204: ,p_effective_date => p_effective_date
3205: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
3206: ,p_person_id => p_person_id

Line 4013: hr_person_address_api.update_person_address

4009: hr_utility.set_location(l_proc, 9);
4010: --
4011: -- Update Person Address details.
4012: --
4013: hr_person_address_api.update_person_address
4014: (p_validate => p_validate
4015: ,p_effective_date => p_effective_date
4016: ,p_address_id => p_address_id
4017: ,p_object_version_number => p_object_version_number

Line 4158: hr_person_address_api.update_person_address

4154: hr_utility.set_location(l_proc, 15);
4155: --
4156: -- Update Person Address details.
4157: --
4158: hr_person_address_api.update_person_address
4159: (p_validate => p_validate
4160: ,p_validate_county => p_validate_county
4161: ,p_effective_date => p_effective_date
4162: ,p_address_id => p_address_id

Line 4311: hr_person_address_api.update_person_address

4307: hr_utility.set_location(l_proc, 9);
4308: --
4309: -- Update Person Address details.
4310: --
4311: hr_person_address_api.update_person_address
4312: (p_validate => p_validate
4313: ,p_effective_date => p_effective_date
4314: ,p_address_id => p_address_id
4315: ,p_object_version_number => p_object_version_number

Line 4463: hr_person_address_api.update_person_address

4459: hr_utility.set_location(l_proc, 9);
4460: --
4461: -- Update Person Address details.
4462: --
4463: hr_person_address_api.update_person_address
4464: (p_validate => p_validate
4465: ,p_effective_date => p_effective_date
4466: ,p_address_id => p_address_id
4467: ,p_object_version_number => p_object_version_number

Line 4614: hr_person_address_api.update_person_address

4610: hr_utility.set_location(l_proc, 9);
4611: --
4612: -- Update Person Address details.
4613: --
4614: hr_person_address_api.update_person_address
4615: (p_validate => p_validate
4616: ,p_effective_date => p_effective_date
4617: ,p_address_id => p_address_id
4618: ,p_object_version_number => p_object_version_number

Line 4765: hr_person_address_api.update_person_address

4761: hr_utility.set_location(l_proc, 9);
4762: --
4763: -- Update Person Address details.
4764: --
4765: hr_person_address_api.update_person_address
4766: (p_validate => p_validate
4767: ,p_effective_date => p_effective_date
4768: ,p_address_id => p_address_id
4769: ,p_object_version_number => p_object_version_number

Line 4917: hr_person_address_api.update_person_address

4913: hr_utility.set_location(l_proc, 9);
4914: --
4915: -- Update Person Address details.
4916: --
4917: hr_person_address_api.update_person_address
4918: (p_validate => p_validate
4919: ,p_effective_date => p_effective_date
4920: ,p_address_id => p_address_id
4921: ,p_object_version_number => p_object_version_number

Line 5069: hr_person_address_api.update_person_address

5065: hr_utility.set_location(l_proc, 9);
5066: --
5067: -- Update Person Address details.
5068: --
5069: hr_person_address_api.update_person_address
5070: (p_validate => p_validate
5071: ,p_effective_date => p_effective_date
5072: ,p_address_id => p_address_id
5073: ,p_object_version_number => p_object_version_number

Line 5222: hr_person_address_api.update_person_address

5218: hr_utility.set_location(l_proc, 9);
5219: --
5220: -- Update Person Address details.
5221: --
5222: hr_person_address_api.update_person_address
5223: (p_validate => p_validate
5224: ,p_effective_date => p_effective_date
5225: ,p_address_id => p_address_id
5226: ,p_object_version_number => p_object_version_number

Line 5375: hr_person_address_api.update_person_address

5371: hr_utility.set_location(l_proc, 9);
5372: --
5373: -- Update Person Address details.
5374: --
5375: hr_person_address_api.update_person_address
5376: (p_validate => p_validate
5377: ,p_effective_date => p_effective_date
5378: ,p_address_id => p_address_id
5379: ,p_object_version_number => p_object_version_number

Line 5526: hr_person_address_api.update_person_address

5522: hr_utility.set_location(l_proc, 9);
5523: --
5524: -- Update Person Address details.
5525: --
5526: hr_person_address_api.update_person_address
5527: (p_validate => p_validate
5528: ,p_effective_date => p_effective_date
5529: ,p_address_id => p_address_id
5530: ,p_object_version_number => p_object_version_number

Line 5676: hr_person_address_api.update_person_address

5672: hr_utility.set_location(l_proc, 9);
5673: --
5674: -- Update Person Address details.
5675: --
5676: hr_person_address_api.update_person_address
5677: (p_validate => p_validate
5678: ,p_effective_date => p_effective_date
5679: ,p_address_id => p_address_id
5680: ,p_object_version_number => p_object_version_number

Line 5826: hr_person_address_api.update_person_address

5822: hr_utility.set_location(l_proc, 9);
5823: --
5824: -- Update Person Address details.
5825: --
5826: hr_person_address_api.update_person_address
5827: (p_validate => p_validate
5828: ,p_effective_date => p_effective_date
5829: ,p_address_id => p_address_id
5830: ,p_object_version_number => p_object_version_number

Line 5976: hr_person_address_api.update_person_address

5972: hr_utility.set_location(l_proc, 9);
5973: --
5974: -- Update Person Address details.
5975: --
5976: hr_person_address_api.update_person_address
5977: (p_validate => p_validate
5978: ,p_effective_date => p_effective_date
5979: ,p_address_id => p_address_id
5980: ,p_object_version_number => p_object_version_number

Line 6125: hr_person_address_api.update_person_address

6121: hr_utility.set_location(l_proc, 9);
6122: --
6123: -- Update Person Address details.
6124: --
6125: hr_person_address_api.update_person_address
6126: (p_validate => p_validate
6127: ,p_effective_date => p_effective_date
6128: ,p_address_id => p_address_id
6129: ,p_object_version_number => p_object_version_number

Line 6275: hr_person_address_api.update_person_address

6271: hr_utility.set_location(l_proc, 9);
6272: --
6273: -- Update Person Address details.
6274: --
6275: hr_person_address_api.update_person_address
6276: (p_validate => p_validate
6277: ,p_effective_date => p_effective_date
6278: ,p_address_id => p_address_id
6279: ,p_object_version_number => p_object_version_number

Line 6426: hr_person_address_api.update_person_address

6422: hr_utility.set_location(l_proc, 9);
6423: --
6424: -- Update Person Address details.
6425: --
6426: hr_person_address_api.update_person_address
6427: (p_validate => p_validate
6428: ,p_effective_date => p_effective_date
6429: ,p_address_id => p_address_id
6430: ,p_object_version_number => p_object_version_number

Line 6577: hr_person_address_api.update_person_address

6573: hr_utility.set_location(l_proc, 9);
6574: --
6575: -- Update Person Address details.
6576: --
6577: hr_person_address_api.update_person_address
6578: (p_validate => p_validate
6579: ,p_effective_date => p_effective_date
6580: ,p_address_id => p_address_id
6581: ,p_object_version_number => p_object_version_number

Line 6728: hr_person_address_api.update_person_address

6724: hr_utility.set_location(l_proc, 9);
6725: --
6726: -- Update Person Address details.
6727: --
6728: hr_person_address_api.update_person_address
6729: (p_validate => p_validate
6730: ,p_effective_date => p_effective_date
6731: ,p_address_id => p_address_id
6732: ,p_object_version_number => p_object_version_number

Line 6878: hr_person_address_api.update_person_address

6874: hr_utility.set_location(l_proc, 9);
6875: --
6876: -- Update Person Address details.
6877: --
6878: hr_person_address_api.update_person_address
6879: (p_validate => p_validate
6880: ,p_effective_date => p_effective_date
6881: ,p_address_id => p_address_id
6882: ,p_object_version_number => p_object_version_number

Line 7031: hr_person_address_api.update_person_address

7027: hr_utility.set_location(l_proc, 9);
7028: --
7029: -- Update Person Address details.
7030: --
7031: hr_person_address_api.update_person_address
7032: (p_validate => p_validate
7033: ,p_effective_date => p_effective_date
7034: ,p_address_id => p_address_id
7035: ,p_object_version_number => p_object_version_number

Line 7184: hr_person_address_api.update_person_address

7180: hr_utility.set_location(l_proc, 9);
7181: --
7182: -- Update Person Address details.
7183: --
7184: hr_person_address_api.update_person_address
7185: (p_validate => p_validate
7186: ,p_effective_date => p_effective_date
7187: ,p_address_id => p_address_id
7188: ,p_object_version_number => p_object_version_number

Line 7324: hr_person_address_api.update_person_address

7320: hr_utility.set_location(l_proc, 9);
7321: --
7322: -- Update Person Address details.
7323: --
7324: hr_person_address_api.update_person_address
7325: (p_validate => p_validate
7326: ,p_effective_date => p_effective_date
7327: ,p_address_id => p_address_id
7328: ,p_object_version_number => p_object_version_number

Line 7532: hr_person_address_api.create_person_address

7528: --
7529: -- insert the data
7530: --
7531: hr_utility.set_location(l_proc, 50);
7532: hr_person_address_api.create_person_address
7533: (p_validate => FALSE
7534: ,p_effective_date => l_effective_date
7535: ,p_validate_county => p_validate_county
7536: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override

Line 7646: hr_person_address_api.update_pers_addr_with_style

7642: IF per_add_shd.g_old_rec.style <> l_add_rec.style THEN
7643: --
7644: hr_utility.set_location(l_proc, 142);
7645: --
7646: hr_person_address_api.update_pers_addr_with_style
7647: (p_validate => FALSE
7648: ,p_effective_date => l_effective_date
7649: ,p_validate_county => p_validate_county
7650: ,p_address_id => l_add_rec.address_id

Line 7708: hr_person_address_api.update_person_address

7704: -- Address style is not changed.
7705: --
7706: hr_utility.set_location(l_proc, 146);
7707: --
7708: hr_person_address_api.update_person_address
7709: (p_validate => FALSE
7710: ,p_effective_date => l_effective_date
7711: ,p_validate_county => p_validate_county
7712: ,p_address_id => l_add_rec.address_id

Line 7792: -- hr_person_address_api.update_person_address

7788: --
7789: -- end the old address
7790: --2660711, remove this call, change the create call to pass TRUE for
7791: --p_pradd_ovlapval_override which will achieve the same thing
7792: -- hr_person_address_api.update_person_address
7793: -- (p_validate => FALSE
7794: -- ,p_effective_date => l_effective_date
7795: -- ,p_validate_county => p_validate_county
7796: -- ,p_address_id => l_add_rec.address_id

Line 7804: hr_person_address_api.update_person_address

7800: --
7801:
7802: -- changes started for bug5372061
7803: if per_add_shd.g_old_rec.primary_flag <> 'Y' and p_primary_flag <> 'Y' then
7804: hr_person_address_api.update_person_address
7805: (p_validate => FALSE
7806: ,p_effective_date => l_effective_date
7807: ,p_validate_county => p_validate_county
7808: ,p_address_id => l_add_rec.address_id

Line 7822: hr_person_address_api.create_person_address

7818: hr_utility.set_location(l_proc, 190);
7819: --
7820: -- insert the new address
7821: --
7822: hr_person_address_api.create_person_address
7823: (p_validate => FALSE
7824: ,p_effective_date => l_effective_date
7825: ,p_validate_county => p_validate_county
7826: ,p_pradd_ovlapval_override => TRUE --p_pradd_ovlapval_override changed for 2660711

Line 7908: end hr_person_address_api;

7904: raise;
7905: --
7906: end cre_or_upd_person_address;
7907: --
7908: end hr_person_address_api;