APPS.HR_PROCESS_ADDRESS_SS dependencies on HR_API

Line 57: ,p_address_type in varchar2 default hr_api.g_varchar2

53: ,p_primary_flag in varchar2
54: ,p_style in varchar2
55: ,p_date_from in date
56: ,p_date_to in date default null
57: ,p_address_type in varchar2 default hr_api.g_varchar2
58: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
59: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
60: ,p_address_line1 in varchar2 default hr_api.g_varchar2
61: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 58: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2

54: ,p_style in varchar2
55: ,p_date_from in date
56: ,p_date_to in date default null
57: ,p_address_type in varchar2 default hr_api.g_varchar2
58: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
59: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
60: ,p_address_line1 in varchar2 default hr_api.g_varchar2
61: ,p_address_line2 in varchar2 default hr_api.g_varchar2
62: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 59: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792

55: ,p_date_from in date
56: ,p_date_to in date default null
57: ,p_address_type in varchar2 default hr_api.g_varchar2
58: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
59: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
60: ,p_address_line1 in varchar2 default hr_api.g_varchar2
61: ,p_address_line2 in varchar2 default hr_api.g_varchar2
62: ,p_address_line3 in varchar2 default hr_api.g_varchar2
63: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 60: ,p_address_line1 in varchar2 default hr_api.g_varchar2

56: ,p_date_to in date default null
57: ,p_address_type in varchar2 default hr_api.g_varchar2
58: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
59: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
60: ,p_address_line1 in varchar2 default hr_api.g_varchar2
61: ,p_address_line2 in varchar2 default hr_api.g_varchar2
62: ,p_address_line3 in varchar2 default hr_api.g_varchar2
63: ,p_town_or_city in varchar2 default hr_api.g_varchar2
64: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 61: ,p_address_line2 in varchar2 default hr_api.g_varchar2

57: ,p_address_type in varchar2 default hr_api.g_varchar2
58: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
59: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
60: ,p_address_line1 in varchar2 default hr_api.g_varchar2
61: ,p_address_line2 in varchar2 default hr_api.g_varchar2
62: ,p_address_line3 in varchar2 default hr_api.g_varchar2
63: ,p_town_or_city in varchar2 default hr_api.g_varchar2
64: ,p_region_1 in varchar2 default hr_api.g_varchar2
65: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 62: ,p_address_line3 in varchar2 default hr_api.g_varchar2

58: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
59: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
60: ,p_address_line1 in varchar2 default hr_api.g_varchar2
61: ,p_address_line2 in varchar2 default hr_api.g_varchar2
62: ,p_address_line3 in varchar2 default hr_api.g_varchar2
63: ,p_town_or_city in varchar2 default hr_api.g_varchar2
64: ,p_region_1 in varchar2 default hr_api.g_varchar2
65: ,p_region_2 in varchar2 default hr_api.g_varchar2
66: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 63: ,p_town_or_city in varchar2 default hr_api.g_varchar2

59: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
60: ,p_address_line1 in varchar2 default hr_api.g_varchar2
61: ,p_address_line2 in varchar2 default hr_api.g_varchar2
62: ,p_address_line3 in varchar2 default hr_api.g_varchar2
63: ,p_town_or_city in varchar2 default hr_api.g_varchar2
64: ,p_region_1 in varchar2 default hr_api.g_varchar2
65: ,p_region_2 in varchar2 default hr_api.g_varchar2
66: ,p_region_3 in varchar2 default hr_api.g_varchar2
67: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 64: ,p_region_1 in varchar2 default hr_api.g_varchar2

60: ,p_address_line1 in varchar2 default hr_api.g_varchar2
61: ,p_address_line2 in varchar2 default hr_api.g_varchar2
62: ,p_address_line3 in varchar2 default hr_api.g_varchar2
63: ,p_town_or_city in varchar2 default hr_api.g_varchar2
64: ,p_region_1 in varchar2 default hr_api.g_varchar2
65: ,p_region_2 in varchar2 default hr_api.g_varchar2
66: ,p_region_3 in varchar2 default hr_api.g_varchar2
67: ,p_postal_code in varchar2 default hr_api.g_varchar2
68: ,p_country in varchar2 default hr_api.g_varchar2

Line 65: ,p_region_2 in varchar2 default hr_api.g_varchar2

61: ,p_address_line2 in varchar2 default hr_api.g_varchar2
62: ,p_address_line3 in varchar2 default hr_api.g_varchar2
63: ,p_town_or_city in varchar2 default hr_api.g_varchar2
64: ,p_region_1 in varchar2 default hr_api.g_varchar2
65: ,p_region_2 in varchar2 default hr_api.g_varchar2
66: ,p_region_3 in varchar2 default hr_api.g_varchar2
67: ,p_postal_code in varchar2 default hr_api.g_varchar2
68: ,p_country in varchar2 default hr_api.g_varchar2
69: ,p_country_meaning in varchar2 default hr_api.g_varchar2

Line 66: ,p_region_3 in varchar2 default hr_api.g_varchar2

62: ,p_address_line3 in varchar2 default hr_api.g_varchar2
63: ,p_town_or_city in varchar2 default hr_api.g_varchar2
64: ,p_region_1 in varchar2 default hr_api.g_varchar2
65: ,p_region_2 in varchar2 default hr_api.g_varchar2
66: ,p_region_3 in varchar2 default hr_api.g_varchar2
67: ,p_postal_code in varchar2 default hr_api.g_varchar2
68: ,p_country in varchar2 default hr_api.g_varchar2
69: ,p_country_meaning in varchar2 default hr_api.g_varchar2
70: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 67: ,p_postal_code in varchar2 default hr_api.g_varchar2

63: ,p_town_or_city in varchar2 default hr_api.g_varchar2
64: ,p_region_1 in varchar2 default hr_api.g_varchar2
65: ,p_region_2 in varchar2 default hr_api.g_varchar2
66: ,p_region_3 in varchar2 default hr_api.g_varchar2
67: ,p_postal_code in varchar2 default hr_api.g_varchar2
68: ,p_country in varchar2 default hr_api.g_varchar2
69: ,p_country_meaning in varchar2 default hr_api.g_varchar2
70: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
71: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 68: ,p_country in varchar2 default hr_api.g_varchar2

64: ,p_region_1 in varchar2 default hr_api.g_varchar2
65: ,p_region_2 in varchar2 default hr_api.g_varchar2
66: ,p_region_3 in varchar2 default hr_api.g_varchar2
67: ,p_postal_code in varchar2 default hr_api.g_varchar2
68: ,p_country in varchar2 default hr_api.g_varchar2
69: ,p_country_meaning in varchar2 default hr_api.g_varchar2
70: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
71: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
72: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 69: ,p_country_meaning in varchar2 default hr_api.g_varchar2

65: ,p_region_2 in varchar2 default hr_api.g_varchar2
66: ,p_region_3 in varchar2 default hr_api.g_varchar2
67: ,p_postal_code in varchar2 default hr_api.g_varchar2
68: ,p_country in varchar2 default hr_api.g_varchar2
69: ,p_country_meaning in varchar2 default hr_api.g_varchar2
70: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
71: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
72: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
73: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 70: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

66: ,p_region_3 in varchar2 default hr_api.g_varchar2
67: ,p_postal_code in varchar2 default hr_api.g_varchar2
68: ,p_country in varchar2 default hr_api.g_varchar2
69: ,p_country_meaning in varchar2 default hr_api.g_varchar2
70: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
71: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
72: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
73: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
74: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 71: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

67: ,p_postal_code in varchar2 default hr_api.g_varchar2
68: ,p_country in varchar2 default hr_api.g_varchar2
69: ,p_country_meaning in varchar2 default hr_api.g_varchar2
70: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
71: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
72: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
73: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
74: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
75: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 72: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

68: ,p_country in varchar2 default hr_api.g_varchar2
69: ,p_country_meaning in varchar2 default hr_api.g_varchar2
70: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
71: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
72: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
73: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
74: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
75: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
76: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 73: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

69: ,p_country_meaning in varchar2 default hr_api.g_varchar2
70: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
71: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
72: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
73: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
74: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
75: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
76: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
77: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 74: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

70: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
71: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
72: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
73: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
74: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
75: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
76: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
77: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
78: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 75: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

71: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
72: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
73: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
74: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
75: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
76: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
77: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
78: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
79: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 76: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

72: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
73: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
74: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
75: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
76: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
77: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
78: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
79: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
80: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 77: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

73: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
74: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
75: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
76: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
77: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
78: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
79: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
80: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
81: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 78: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

74: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
75: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
76: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
77: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
78: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
79: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
80: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
81: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
82: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 79: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

75: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
76: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
77: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
78: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
79: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
80: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
81: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
82: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
83: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 80: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

76: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
77: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
78: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
79: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
80: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
81: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
82: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
83: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
84: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 81: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

77: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
78: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
79: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
80: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
81: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
82: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
83: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
84: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
85: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 82: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

78: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
79: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
80: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
81: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
82: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
83: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
84: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
85: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
86: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 83: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

79: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
80: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
81: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
82: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
83: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
84: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
85: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
86: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
87: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 84: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

80: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
81: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
82: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
83: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
84: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
85: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
86: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
87: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
88: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 85: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

81: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
82: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
83: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
84: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
85: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
86: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
87: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
88: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
89: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 86: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

82: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
83: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
84: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
85: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
86: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
87: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
88: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
89: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
90: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 87: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

83: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
84: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
85: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
86: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
87: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
88: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
89: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
90: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
91: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 88: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

84: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
85: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
86: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
87: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
88: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
89: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
90: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
91: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
92: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 89: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

85: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
86: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
87: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
88: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
89: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
90: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
91: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
92: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
93: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 90: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

86: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
87: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
88: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
89: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
90: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
91: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
92: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
93: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
94: ,p_add_information13 in varchar2 default hr_api.g_varchar2

Line 91: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

87: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
88: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
89: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
90: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
91: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
92: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
93: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
94: ,p_add_information13 in varchar2 default hr_api.g_varchar2
95: ,p_add_information14 in varchar2 default hr_api.g_varchar2

Line 92: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

88: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
89: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
90: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
91: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
92: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
93: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
94: ,p_add_information13 in varchar2 default hr_api.g_varchar2
95: ,p_add_information14 in varchar2 default hr_api.g_varchar2
96: ,p_add_information15 in varchar2 default hr_api.g_varchar2

Line 93: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

89: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
90: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
91: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
92: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
93: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
94: ,p_add_information13 in varchar2 default hr_api.g_varchar2
95: ,p_add_information14 in varchar2 default hr_api.g_varchar2
96: ,p_add_information15 in varchar2 default hr_api.g_varchar2
97: ,p_add_information16 in varchar2 default hr_api.g_varchar2

Line 94: ,p_add_information13 in varchar2 default hr_api.g_varchar2

90: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
91: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
92: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
93: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
94: ,p_add_information13 in varchar2 default hr_api.g_varchar2
95: ,p_add_information14 in varchar2 default hr_api.g_varchar2
96: ,p_add_information15 in varchar2 default hr_api.g_varchar2
97: ,p_add_information16 in varchar2 default hr_api.g_varchar2
98: ,p_add_information17 in varchar2 default hr_api.g_varchar2

Line 95: ,p_add_information14 in varchar2 default hr_api.g_varchar2

91: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
92: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
93: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
94: ,p_add_information13 in varchar2 default hr_api.g_varchar2
95: ,p_add_information14 in varchar2 default hr_api.g_varchar2
96: ,p_add_information15 in varchar2 default hr_api.g_varchar2
97: ,p_add_information16 in varchar2 default hr_api.g_varchar2
98: ,p_add_information17 in varchar2 default hr_api.g_varchar2
99: ,p_add_information18 in varchar2 default hr_api.g_varchar2

Line 96: ,p_add_information15 in varchar2 default hr_api.g_varchar2

92: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
93: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
94: ,p_add_information13 in varchar2 default hr_api.g_varchar2
95: ,p_add_information14 in varchar2 default hr_api.g_varchar2
96: ,p_add_information15 in varchar2 default hr_api.g_varchar2
97: ,p_add_information16 in varchar2 default hr_api.g_varchar2
98: ,p_add_information17 in varchar2 default hr_api.g_varchar2
99: ,p_add_information18 in varchar2 default hr_api.g_varchar2
100: ,p_add_information19 in varchar2 default hr_api.g_varchar2

Line 97: ,p_add_information16 in varchar2 default hr_api.g_varchar2

93: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
94: ,p_add_information13 in varchar2 default hr_api.g_varchar2
95: ,p_add_information14 in varchar2 default hr_api.g_varchar2
96: ,p_add_information15 in varchar2 default hr_api.g_varchar2
97: ,p_add_information16 in varchar2 default hr_api.g_varchar2
98: ,p_add_information17 in varchar2 default hr_api.g_varchar2
99: ,p_add_information18 in varchar2 default hr_api.g_varchar2
100: ,p_add_information19 in varchar2 default hr_api.g_varchar2
101: ,p_add_information20 in varchar2 default hr_api.g_varchar2

Line 98: ,p_add_information17 in varchar2 default hr_api.g_varchar2

94: ,p_add_information13 in varchar2 default hr_api.g_varchar2
95: ,p_add_information14 in varchar2 default hr_api.g_varchar2
96: ,p_add_information15 in varchar2 default hr_api.g_varchar2
97: ,p_add_information16 in varchar2 default hr_api.g_varchar2
98: ,p_add_information17 in varchar2 default hr_api.g_varchar2
99: ,p_add_information18 in varchar2 default hr_api.g_varchar2
100: ,p_add_information19 in varchar2 default hr_api.g_varchar2
101: ,p_add_information20 in varchar2 default hr_api.g_varchar2
102: ,p_address_id out nocopy number

Line 99: ,p_add_information18 in varchar2 default hr_api.g_varchar2

95: ,p_add_information14 in varchar2 default hr_api.g_varchar2
96: ,p_add_information15 in varchar2 default hr_api.g_varchar2
97: ,p_add_information16 in varchar2 default hr_api.g_varchar2
98: ,p_add_information17 in varchar2 default hr_api.g_varchar2
99: ,p_add_information18 in varchar2 default hr_api.g_varchar2
100: ,p_add_information19 in varchar2 default hr_api.g_varchar2
101: ,p_add_information20 in varchar2 default hr_api.g_varchar2
102: ,p_address_id out nocopy number
103: ,p_object_version_number out nocopy number

Line 100: ,p_add_information19 in varchar2 default hr_api.g_varchar2

96: ,p_add_information15 in varchar2 default hr_api.g_varchar2
97: ,p_add_information16 in varchar2 default hr_api.g_varchar2
98: ,p_add_information17 in varchar2 default hr_api.g_varchar2
99: ,p_add_information18 in varchar2 default hr_api.g_varchar2
100: ,p_add_information19 in varchar2 default hr_api.g_varchar2
101: ,p_add_information20 in varchar2 default hr_api.g_varchar2
102: ,p_address_id out nocopy number
103: ,p_object_version_number out nocopy number
104: -- StartRegistration

Line 101: ,p_add_information20 in varchar2 default hr_api.g_varchar2

97: ,p_add_information16 in varchar2 default hr_api.g_varchar2
98: ,p_add_information17 in varchar2 default hr_api.g_varchar2
99: ,p_add_information18 in varchar2 default hr_api.g_varchar2
100: ,p_add_information19 in varchar2 default hr_api.g_varchar2
101: ,p_add_information20 in varchar2 default hr_api.g_varchar2
102: ,p_address_id out nocopy number
103: ,p_object_version_number out nocopy number
104: -- StartRegistration
105: ,p_contact_or_person in varchar2 default null

Line 115: ,p_contact_relationship_id in number default hr_api.g_number

111: ,p_old_address_id in number default null
112: ,p_old_object_version_number in number default null
113: ,p_save_mode in varchar2 default null
114: ,p_error_message out nocopy long
115: ,p_contact_relationship_id in number default hr_api.g_number
116: );
117:
118: /*
119: ||===========================================================================

Line 156: ,p_date_from in date default hr_api.g_date

152: ,p_effective_date in date
153: ,p_validate_county in number default 1
154: ,p_address_id in number
155: ,p_object_version_number in out nocopy number
156: ,p_date_from in date default hr_api.g_date
157: ,p_date_to in date default hr_api.g_date
158: ,p_address_type in varchar2 default hr_api.g_varchar2
159: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
160: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792

Line 157: ,p_date_to in date default hr_api.g_date

153: ,p_validate_county in number default 1
154: ,p_address_id in number
155: ,p_object_version_number in out nocopy number
156: ,p_date_from in date default hr_api.g_date
157: ,p_date_to in date default hr_api.g_date
158: ,p_address_type in varchar2 default hr_api.g_varchar2
159: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
160: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
161: ,p_address_line1 in varchar2 default hr_api.g_varchar2

Line 158: ,p_address_type in varchar2 default hr_api.g_varchar2

154: ,p_address_id in number
155: ,p_object_version_number in out nocopy number
156: ,p_date_from in date default hr_api.g_date
157: ,p_date_to in date default hr_api.g_date
158: ,p_address_type in varchar2 default hr_api.g_varchar2
159: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
160: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
161: ,p_address_line1 in varchar2 default hr_api.g_varchar2
162: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 159: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2

155: ,p_object_version_number in out nocopy number
156: ,p_date_from in date default hr_api.g_date
157: ,p_date_to in date default hr_api.g_date
158: ,p_address_type in varchar2 default hr_api.g_varchar2
159: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
160: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
161: ,p_address_line1 in varchar2 default hr_api.g_varchar2
162: ,p_address_line2 in varchar2 default hr_api.g_varchar2
163: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 160: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792

156: ,p_date_from in date default hr_api.g_date
157: ,p_date_to in date default hr_api.g_date
158: ,p_address_type in varchar2 default hr_api.g_varchar2
159: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
160: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
161: ,p_address_line1 in varchar2 default hr_api.g_varchar2
162: ,p_address_line2 in varchar2 default hr_api.g_varchar2
163: ,p_address_line3 in varchar2 default hr_api.g_varchar2
164: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 161: ,p_address_line1 in varchar2 default hr_api.g_varchar2

157: ,p_date_to in date default hr_api.g_date
158: ,p_address_type in varchar2 default hr_api.g_varchar2
159: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
160: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
161: ,p_address_line1 in varchar2 default hr_api.g_varchar2
162: ,p_address_line2 in varchar2 default hr_api.g_varchar2
163: ,p_address_line3 in varchar2 default hr_api.g_varchar2
164: ,p_town_or_city in varchar2 default hr_api.g_varchar2
165: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 162: ,p_address_line2 in varchar2 default hr_api.g_varchar2

158: ,p_address_type in varchar2 default hr_api.g_varchar2
159: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
160: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
161: ,p_address_line1 in varchar2 default hr_api.g_varchar2
162: ,p_address_line2 in varchar2 default hr_api.g_varchar2
163: ,p_address_line3 in varchar2 default hr_api.g_varchar2
164: ,p_town_or_city in varchar2 default hr_api.g_varchar2
165: ,p_region_1 in varchar2 default hr_api.g_varchar2
166: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 163: ,p_address_line3 in varchar2 default hr_api.g_varchar2

159: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
160: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
161: ,p_address_line1 in varchar2 default hr_api.g_varchar2
162: ,p_address_line2 in varchar2 default hr_api.g_varchar2
163: ,p_address_line3 in varchar2 default hr_api.g_varchar2
164: ,p_town_or_city in varchar2 default hr_api.g_varchar2
165: ,p_region_1 in varchar2 default hr_api.g_varchar2
166: ,p_region_2 in varchar2 default hr_api.g_varchar2
167: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 164: ,p_town_or_city in varchar2 default hr_api.g_varchar2

160: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
161: ,p_address_line1 in varchar2 default hr_api.g_varchar2
162: ,p_address_line2 in varchar2 default hr_api.g_varchar2
163: ,p_address_line3 in varchar2 default hr_api.g_varchar2
164: ,p_town_or_city in varchar2 default hr_api.g_varchar2
165: ,p_region_1 in varchar2 default hr_api.g_varchar2
166: ,p_region_2 in varchar2 default hr_api.g_varchar2
167: ,p_region_3 in varchar2 default hr_api.g_varchar2
168: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 165: ,p_region_1 in varchar2 default hr_api.g_varchar2

161: ,p_address_line1 in varchar2 default hr_api.g_varchar2
162: ,p_address_line2 in varchar2 default hr_api.g_varchar2
163: ,p_address_line3 in varchar2 default hr_api.g_varchar2
164: ,p_town_or_city in varchar2 default hr_api.g_varchar2
165: ,p_region_1 in varchar2 default hr_api.g_varchar2
166: ,p_region_2 in varchar2 default hr_api.g_varchar2
167: ,p_region_3 in varchar2 default hr_api.g_varchar2
168: ,p_postal_code in varchar2 default hr_api.g_varchar2
169: ,p_country in varchar2 default hr_api.g_varchar2

Line 166: ,p_region_2 in varchar2 default hr_api.g_varchar2

162: ,p_address_line2 in varchar2 default hr_api.g_varchar2
163: ,p_address_line3 in varchar2 default hr_api.g_varchar2
164: ,p_town_or_city in varchar2 default hr_api.g_varchar2
165: ,p_region_1 in varchar2 default hr_api.g_varchar2
166: ,p_region_2 in varchar2 default hr_api.g_varchar2
167: ,p_region_3 in varchar2 default hr_api.g_varchar2
168: ,p_postal_code in varchar2 default hr_api.g_varchar2
169: ,p_country in varchar2 default hr_api.g_varchar2
170: ,p_country_meaning in varchar2 default hr_api.g_varchar2

Line 167: ,p_region_3 in varchar2 default hr_api.g_varchar2

163: ,p_address_line3 in varchar2 default hr_api.g_varchar2
164: ,p_town_or_city in varchar2 default hr_api.g_varchar2
165: ,p_region_1 in varchar2 default hr_api.g_varchar2
166: ,p_region_2 in varchar2 default hr_api.g_varchar2
167: ,p_region_3 in varchar2 default hr_api.g_varchar2
168: ,p_postal_code in varchar2 default hr_api.g_varchar2
169: ,p_country in varchar2 default hr_api.g_varchar2
170: ,p_country_meaning in varchar2 default hr_api.g_varchar2
171: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 168: ,p_postal_code in varchar2 default hr_api.g_varchar2

164: ,p_town_or_city in varchar2 default hr_api.g_varchar2
165: ,p_region_1 in varchar2 default hr_api.g_varchar2
166: ,p_region_2 in varchar2 default hr_api.g_varchar2
167: ,p_region_3 in varchar2 default hr_api.g_varchar2
168: ,p_postal_code in varchar2 default hr_api.g_varchar2
169: ,p_country in varchar2 default hr_api.g_varchar2
170: ,p_country_meaning in varchar2 default hr_api.g_varchar2
171: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
172: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 169: ,p_country in varchar2 default hr_api.g_varchar2

165: ,p_region_1 in varchar2 default hr_api.g_varchar2
166: ,p_region_2 in varchar2 default hr_api.g_varchar2
167: ,p_region_3 in varchar2 default hr_api.g_varchar2
168: ,p_postal_code in varchar2 default hr_api.g_varchar2
169: ,p_country in varchar2 default hr_api.g_varchar2
170: ,p_country_meaning in varchar2 default hr_api.g_varchar2
171: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
172: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
173: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 170: ,p_country_meaning in varchar2 default hr_api.g_varchar2

166: ,p_region_2 in varchar2 default hr_api.g_varchar2
167: ,p_region_3 in varchar2 default hr_api.g_varchar2
168: ,p_postal_code in varchar2 default hr_api.g_varchar2
169: ,p_country in varchar2 default hr_api.g_varchar2
170: ,p_country_meaning in varchar2 default hr_api.g_varchar2
171: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
172: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
173: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
174: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 171: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

167: ,p_region_3 in varchar2 default hr_api.g_varchar2
168: ,p_postal_code in varchar2 default hr_api.g_varchar2
169: ,p_country in varchar2 default hr_api.g_varchar2
170: ,p_country_meaning in varchar2 default hr_api.g_varchar2
171: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
172: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
173: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
174: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 172: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

168: ,p_postal_code in varchar2 default hr_api.g_varchar2
169: ,p_country in varchar2 default hr_api.g_varchar2
170: ,p_country_meaning in varchar2 default hr_api.g_varchar2
171: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
172: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
173: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
174: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 173: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

169: ,p_country in varchar2 default hr_api.g_varchar2
170: ,p_country_meaning in varchar2 default hr_api.g_varchar2
171: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
172: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
173: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
174: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 174: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

170: ,p_country_meaning in varchar2 default hr_api.g_varchar2
171: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
172: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
173: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
174: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 175: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

171: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
172: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
173: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
174: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 176: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

172: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
173: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
174: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 177: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

173: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
174: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 178: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

174: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 179: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

175: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 180: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

176: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 181: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

177: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 182: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

178: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 183: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

179: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 184: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

180: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 185: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

181: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 186: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

182: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 187: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

183: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 188: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

184: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 189: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

185: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 190: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

186: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 191: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

187: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_add_information13 in varchar2 default hr_api.g_varchar2

Line 192: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

188: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_add_information13 in varchar2 default hr_api.g_varchar2
196: ,p_add_information14 in varchar2 default hr_api.g_varchar2

Line 193: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

189: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_add_information13 in varchar2 default hr_api.g_varchar2
196: ,p_add_information14 in varchar2 default hr_api.g_varchar2
197: ,p_add_information15 in varchar2 default hr_api.g_varchar2

Line 194: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

190: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_add_information13 in varchar2 default hr_api.g_varchar2
196: ,p_add_information14 in varchar2 default hr_api.g_varchar2
197: ,p_add_information15 in varchar2 default hr_api.g_varchar2
198: ,p_add_information16 in varchar2 default hr_api.g_varchar2

Line 195: ,p_add_information13 in varchar2 default hr_api.g_varchar2

191: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_add_information13 in varchar2 default hr_api.g_varchar2
196: ,p_add_information14 in varchar2 default hr_api.g_varchar2
197: ,p_add_information15 in varchar2 default hr_api.g_varchar2
198: ,p_add_information16 in varchar2 default hr_api.g_varchar2
199: ,p_add_information17 in varchar2 default hr_api.g_varchar2

Line 196: ,p_add_information14 in varchar2 default hr_api.g_varchar2

192: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_add_information13 in varchar2 default hr_api.g_varchar2
196: ,p_add_information14 in varchar2 default hr_api.g_varchar2
197: ,p_add_information15 in varchar2 default hr_api.g_varchar2
198: ,p_add_information16 in varchar2 default hr_api.g_varchar2
199: ,p_add_information17 in varchar2 default hr_api.g_varchar2
200: ,p_add_information18 in varchar2 default hr_api.g_varchar2

Line 197: ,p_add_information15 in varchar2 default hr_api.g_varchar2

193: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_add_information13 in varchar2 default hr_api.g_varchar2
196: ,p_add_information14 in varchar2 default hr_api.g_varchar2
197: ,p_add_information15 in varchar2 default hr_api.g_varchar2
198: ,p_add_information16 in varchar2 default hr_api.g_varchar2
199: ,p_add_information17 in varchar2 default hr_api.g_varchar2
200: ,p_add_information18 in varchar2 default hr_api.g_varchar2
201: ,p_add_information19 in varchar2 default hr_api.g_varchar2

Line 198: ,p_add_information16 in varchar2 default hr_api.g_varchar2

194: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_add_information13 in varchar2 default hr_api.g_varchar2
196: ,p_add_information14 in varchar2 default hr_api.g_varchar2
197: ,p_add_information15 in varchar2 default hr_api.g_varchar2
198: ,p_add_information16 in varchar2 default hr_api.g_varchar2
199: ,p_add_information17 in varchar2 default hr_api.g_varchar2
200: ,p_add_information18 in varchar2 default hr_api.g_varchar2
201: ,p_add_information19 in varchar2 default hr_api.g_varchar2
202: ,p_add_information20 in varchar2 default hr_api.g_varchar2

Line 199: ,p_add_information17 in varchar2 default hr_api.g_varchar2

195: ,p_add_information13 in varchar2 default hr_api.g_varchar2
196: ,p_add_information14 in varchar2 default hr_api.g_varchar2
197: ,p_add_information15 in varchar2 default hr_api.g_varchar2
198: ,p_add_information16 in varchar2 default hr_api.g_varchar2
199: ,p_add_information17 in varchar2 default hr_api.g_varchar2
200: ,p_add_information18 in varchar2 default hr_api.g_varchar2
201: ,p_add_information19 in varchar2 default hr_api.g_varchar2
202: ,p_add_information20 in varchar2 default hr_api.g_varchar2
203: ,p_item_type in varchar2

Line 200: ,p_add_information18 in varchar2 default hr_api.g_varchar2

196: ,p_add_information14 in varchar2 default hr_api.g_varchar2
197: ,p_add_information15 in varchar2 default hr_api.g_varchar2
198: ,p_add_information16 in varchar2 default hr_api.g_varchar2
199: ,p_add_information17 in varchar2 default hr_api.g_varchar2
200: ,p_add_information18 in varchar2 default hr_api.g_varchar2
201: ,p_add_information19 in varchar2 default hr_api.g_varchar2
202: ,p_add_information20 in varchar2 default hr_api.g_varchar2
203: ,p_item_type in varchar2
204: ,p_item_key in varchar2

Line 201: ,p_add_information19 in varchar2 default hr_api.g_varchar2

197: ,p_add_information15 in varchar2 default hr_api.g_varchar2
198: ,p_add_information16 in varchar2 default hr_api.g_varchar2
199: ,p_add_information17 in varchar2 default hr_api.g_varchar2
200: ,p_add_information18 in varchar2 default hr_api.g_varchar2
201: ,p_add_information19 in varchar2 default hr_api.g_varchar2
202: ,p_add_information20 in varchar2 default hr_api.g_varchar2
203: ,p_item_type in varchar2
204: ,p_item_key in varchar2
205: ,p_activity_id in number

Line 202: ,p_add_information20 in varchar2 default hr_api.g_varchar2

198: ,p_add_information16 in varchar2 default hr_api.g_varchar2
199: ,p_add_information17 in varchar2 default hr_api.g_varchar2
200: ,p_add_information18 in varchar2 default hr_api.g_varchar2
201: ,p_add_information19 in varchar2 default hr_api.g_varchar2
202: ,p_add_information20 in varchar2 default hr_api.g_varchar2
203: ,p_item_type in varchar2
204: ,p_item_key in varchar2
205: ,p_activity_id in number
206: ,p_person_id in number

Line 220: ,p_contact_relationship_id in number default hr_api.g_number

216: ,p_style in varchar2
217: ,p_action in varchar2
218: ,p_save_mode in varchar2 default null
219: ,p_error_message out nocopy long
220: ,p_contact_relationship_id in number default hr_api.g_number
221: );
222:
223: -- ---------------------- < get_address_data_from_tt> -------------------------
224: -- ---------------------------------------------------------------------------