[Home] [Help]
2344: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
2345: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2346: RETURN NULL;
2347: END IF;
2348: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2349: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
2350: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Varchar2
2351: (p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2352: END IF;
2346: RETURN NULL;
2347: END IF;
2348: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2349: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
2350: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Varchar2
2351: (p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2352: END IF;
2353:
2354: ELSIF (p_foreign_database_object_name = 'OE_AK_RETURN_REASON_V') THEN
2347: END IF;
2348: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2349: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
2350: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Varchar2
2351: (p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2352: END IF;
2353:
2354: ELSIF (p_foreign_database_object_name = 'OE_AK_RETURN_REASON_V') THEN
2355: IF NVL(p_record.RETURN_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2884: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
2885: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2886: RETURN NULL;
2887: END IF;
2888: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2889: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
2890: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2891: END IF;
2892:
2886: RETURN NULL;
2887: END IF;
2888: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2889: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
2890: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2891: END IF;
2892:
2893: ELSIF (p_foreign_database_object_name = 'OE_AK_RETURN_REASON_V') THEN
2894: IF NVL(p_record.RETURN_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN