4213: ELSIF (p_foreign_database_object_name = 'OE_AK_SOURCE_TYPE_V') THEN
4214: IF NVL(p_record.SOURCE_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4215: RETURN NULL;
4216: END IF;
4217: IF ONT_SOURCE_TYPE_Def_Util.Sync_SOURCE_TYPE_Cache
4218: (p_SOURCE_TYPE_CODE => p_record.SOURCE_TYPE_CODE) = 1 then
4219: RETURN ONT_SOURCE_TYPE_Def_Util.Get_Attr_Val_Varchar2
4220: (p_foreign_attr_code,ONT_SOURCE_TYPE_Def_Util.g_cached_record);
4221: END IF;
4215: RETURN NULL;
4216: END IF;
4217: IF ONT_SOURCE_TYPE_Def_Util.Sync_SOURCE_TYPE_Cache
4218: (p_SOURCE_TYPE_CODE => p_record.SOURCE_TYPE_CODE) = 1 then
4219: RETURN ONT_SOURCE_TYPE_Def_Util.Get_Attr_Val_Varchar2
4220: (p_foreign_attr_code,ONT_SOURCE_TYPE_Def_Util.g_cached_record);
4221: END IF;
4222:
4223: ELSIF (p_foreign_database_object_name = 'OE_AK_DELIVER_TO_ORGS_V') THEN
4216: END IF;
4217: IF ONT_SOURCE_TYPE_Def_Util.Sync_SOURCE_TYPE_Cache
4218: (p_SOURCE_TYPE_CODE => p_record.SOURCE_TYPE_CODE) = 1 then
4219: RETURN ONT_SOURCE_TYPE_Def_Util.Get_Attr_Val_Varchar2
4220: (p_foreign_attr_code,ONT_SOURCE_TYPE_Def_Util.g_cached_record);
4221: END IF;
4222:
4223: ELSIF (p_foreign_database_object_name = 'OE_AK_DELIVER_TO_ORGS_V') THEN
4224: IF NVL(p_record.DELIVER_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4773: ELSIF (p_foreign_database_object_name = 'OE_AK_SOURCE_TYPE_V') THEN
4774: IF NVL(p_record.SOURCE_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4775: RETURN NULL;
4776: END IF;
4777: IF ONT_SOURCE_TYPE_Def_Util.Sync_SOURCE_TYPE_Cache
4778: (p_SOURCE_TYPE_CODE => p_record.SOURCE_TYPE_CODE) = 1 then
4779: RETURN ONT_SOURCE_TYPE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SOURCE_TYPE_Def_Util.g_cached_record);
4780: END IF;
4781:
4775: RETURN NULL;
4776: END IF;
4777: IF ONT_SOURCE_TYPE_Def_Util.Sync_SOURCE_TYPE_Cache
4778: (p_SOURCE_TYPE_CODE => p_record.SOURCE_TYPE_CODE) = 1 then
4779: RETURN ONT_SOURCE_TYPE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SOURCE_TYPE_Def_Util.g_cached_record);
4780: END IF;
4781:
4782: ELSIF (p_foreign_database_object_name = 'OE_AK_DELIVER_TO_ORGS_V') THEN
4783: IF NVL(p_record.DELIVER_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN