APPS.HZ_ORGANIZATION_PROFILES_PKG dependencies on HZ_PARTIES

Line 193: l_duns_number_c HZ_PARTIES.duns_number_c%type := X_DUNS_NUMBER_C;

189: ) IS
190:
191: l_duns_number NUMBER;
192: l_success VARCHAR2(1) := 'N';
193: l_duns_number_c HZ_PARTIES.duns_number_c%type := X_DUNS_NUMBER_C;
194: BEGIN
195:
196: IF x_duns_number_c IS NOT NULL AND
197: x_duns_number_c <> FND_API.G_MISS_CHAR

Line 929: l_duns_number_c HZ_PARTIES.duns_number_c%type := X_DUNS_NUMBER_C;

925: x_home_country IN VARCHAR2 DEFAULT NULL
926: ) IS
927:
928: l_duns_number NUMBER;
929: l_duns_number_c HZ_PARTIES.duns_number_c%type := X_DUNS_NUMBER_C;
930: BEGIN
931:
932: IF x_duns_number_c IS NOT NULL AND
933: x_duns_number_c <> FND_API.G_MISS_CHAR