4322: ELSIF (p_foreign_database_object_name = 'OE_AK_FREIGHT_TERMS_V') THEN
4323: IF NVL(p_record.FREIGHT_TERMS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4324: RETURN NULL;
4325: END IF;
4326: IF ONT_FR_TERM_Def_Util.Sync_FR_TERM_Cache
4327: (p_FREIGHT_TERMS_CODE => p_record.FREIGHT_TERMS_CODE) = 1 then
4328: RETURN ONT_FR_TERM_Def_Util.Get_Attr_Val_Varchar2
4329: (p_foreign_attr_code,ONT_FR_TERM_Def_Util.g_cached_record);
4330: END IF;
4324: RETURN NULL;
4325: END IF;
4326: IF ONT_FR_TERM_Def_Util.Sync_FR_TERM_Cache
4327: (p_FREIGHT_TERMS_CODE => p_record.FREIGHT_TERMS_CODE) = 1 then
4328: RETURN ONT_FR_TERM_Def_Util.Get_Attr_Val_Varchar2
4329: (p_foreign_attr_code,ONT_FR_TERM_Def_Util.g_cached_record);
4330: END IF;
4331:
4332: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_HEADERS_V') THEN
4325: END IF;
4326: IF ONT_FR_TERM_Def_Util.Sync_FR_TERM_Cache
4327: (p_FREIGHT_TERMS_CODE => p_record.FREIGHT_TERMS_CODE) = 1 then
4328: RETURN ONT_FR_TERM_Def_Util.Get_Attr_Val_Varchar2
4329: (p_foreign_attr_code,ONT_FR_TERM_Def_Util.g_cached_record);
4330: END IF;
4331:
4332: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_HEADERS_V') THEN
4333: IF NVL(p_record.HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4876: ELSIF (p_foreign_database_object_name = 'OE_AK_FREIGHT_TERMS_V') THEN
4877: IF NVL(p_record.FREIGHT_TERMS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4878: RETURN NULL;
4879: END IF;
4880: IF ONT_FR_TERM_Def_Util.Sync_FR_TERM_Cache
4881: (p_FREIGHT_TERMS_CODE => p_record.FREIGHT_TERMS_CODE) = 1 then
4882: RETURN ONT_FR_TERM_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_FR_TERM_Def_Util.g_cached_record);
4883: END IF;
4884:
4878: RETURN NULL;
4879: END IF;
4880: IF ONT_FR_TERM_Def_Util.Sync_FR_TERM_Cache
4881: (p_FREIGHT_TERMS_CODE => p_record.FREIGHT_TERMS_CODE) = 1 then
4882: RETURN ONT_FR_TERM_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_FR_TERM_Def_Util.g_cached_record);
4883: END IF;
4884:
4885: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_HEADERS_V') THEN
4886: IF NVL(p_record.HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN