Pass Null Values

From the TCA Technical Implementation Guide:

For an Update API, if a particular attribute value is not passed into the API, then the database retains the existing value. In order to set a database value to null, 

the calling program must explicitly set the attribute value to one of the following constants, based on the data type of the attribute.

FND_API.G_MISS_NUM for NUMBER type.

FND_API.G_MISS_CHAR for VARCHAR2 type.

FND_API.G_MISS_DATE for DATE type.

These are pre-defined values in the FND_API Package (fndapis.pls)

G_MISS_NUM CONSTANT NUMBER:= 9.99E125

G_MISS_CHAR CONSTANT VARCHAR2(1):= chr(0)

G_MISS_DATE CONSTANT DATE:= TO_DATE('1','j')