4020: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PRIORITIES_V') THEN
4021: IF NVL(p_record.SHIPMENT_PRIORITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4022: RETURN NULL;
4023: END IF;
4024: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
4025: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then
4026: RETURN ONT_SHIP_PR_Def_Util.Get_Attr_Val_Varchar2
4027: (p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
4028: END IF;
4022: RETURN NULL;
4023: END IF;
4024: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
4025: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then
4026: RETURN ONT_SHIP_PR_Def_Util.Get_Attr_Val_Varchar2
4027: (p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
4028: END IF;
4029:
4030: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_FROM_ORGS_V') THEN
4023: END IF;
4024: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
4025: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then
4026: RETURN ONT_SHIP_PR_Def_Util.Get_Attr_Val_Varchar2
4027: (p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
4028: END IF;
4029:
4030: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_FROM_ORGS_V') THEN
4031: IF NVL(p_record.SHIP_FROM_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4596: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PRIORITIES_V') THEN
4597: IF NVL(p_record.SHIPMENT_PRIORITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4598: RETURN NULL;
4599: END IF;
4600: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
4601: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then
4602: RETURN ONT_SHIP_PR_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
4603: END IF;
4604:
4598: RETURN NULL;
4599: END IF;
4600: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
4601: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then
4602: RETURN ONT_SHIP_PR_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
4603: END IF;
4604:
4605: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_FROM_ORGS_V') THEN
4606: IF NVL(p_record.SHIP_FROM_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN