4049: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
4050: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4051: RETURN NULL;
4052: END IF;
4053: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
4054: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
4055: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Varchar2
4056: (p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
4057: END IF;
4051: RETURN NULL;
4052: END IF;
4053: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
4054: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
4055: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Varchar2
4056: (p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
4057: END IF;
4058:
4059: ELSIF (p_foreign_database_object_name = 'OE_AK_BLANKET_LINES_V') THEN
4052: END IF;
4053: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
4054: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
4055: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Varchar2
4056: (p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
4057: END IF;
4058:
4059: ELSIF (p_foreign_database_object_name = 'OE_AK_BLANKET_LINES_V') THEN
4060: IF ( NVL(p_record.BLANKET_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
4627: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
4628: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4629: RETURN NULL;
4630: END IF;
4631: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
4632: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
4633: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
4634: END IF;
4635:
4629: RETURN NULL;
4630: END IF;
4631: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
4632: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
4633: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
4634: END IF;
4635:
4636: ELSIF (p_foreign_database_object_name = 'OE_AK_BLANKET_LINES_V') THEN
4637: IF ( NVL(p_record.BLANKET_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )