Passing NULL Values for the TCA APIs

Sometimes we need to pass the NULL values to some of the attributes using TCA APIs.

e.g. HZ_LOCATIONS, Address Line3 and Address Line4 can be NULL and you wanted to explicitly make them to update a NULL value using the APIs.

Simply assigning a NULL to the variable will not make this value as NULL.

Use the above values depending on the datatype you wanted to make the value to NULL. These standard variables are part of fnd_api package so you need to prefix this with using the below syntax.

p_location_rec.address_line4       := fnd_api.g_null_char;

Please note that earlier G_MISS_XXX were there and now is replaced by G_NULL_XXX.