DBA Data[Home] [Help]

APPS.HR_RU_ADDRESS_HOOK dependencies on HR_API

Line 65: IF (p_add_information13 <> hr_api.g_varchar2)

61: CLOSE csr_get_address_details;
62:
63: IF (l_address_record.style = 'RU')
64: THEN
65: IF (p_add_information13 <> hr_api.g_varchar2)
66: OR (p_add_information13 IS NULL)
67: THEN
68: l_add_information13 := p_add_information13;
69: ELSE

Line 73: IF (p_postal_code <> hr_api.g_varchar2) OR (p_postal_code IS NULL)

69: ELSE
70: l_add_information13 := l_address_record.add_information13;
71: END IF;
72:
73: IF (p_postal_code <> hr_api.g_varchar2) OR (p_postal_code IS NULL)
74: THEN
75: l_postal_code := p_postal_code;
76: ELSE
77: l_postal_code := l_address_record.postal_code;

Line 125: IF (p_add_information13 <> hr_api.g_varchar2)

121: CLOSE csr_get_address_details;
122:
123: IF (p_style = 'RU')
124: THEN
125: IF (p_add_information13 <> hr_api.g_varchar2)
126: OR (p_add_information13 IS NULL)
127: THEN
128: l_add_information13 := p_add_information13;
129: ELSE

Line 133: IF (p_postal_code <> hr_api.g_varchar2) OR (p_postal_code IS NULL)

129: ELSE
130: l_add_information13 := l_address_record.add_information13;
131: END IF;
132:
133: IF (p_postal_code <> hr_api.g_varchar2) OR (p_postal_code IS NULL)
134: THEN
135: l_postal_code := p_postal_code;
136: ELSE
137: l_postal_code := l_address_record.postal_code;