3847: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3848: IF NVL(p_record.REQUEST_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3849: RETURN NULL;
3850: END IF;
3851: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3852: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then
3853: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3854: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3855: END IF;
3849: RETURN NULL;
3850: END IF;
3851: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3852: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then
3853: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3854: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3855: END IF;
3856:
3857: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3850: END IF;
3851: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3852: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then
3853: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3854: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3855: END IF;
3856:
3857: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3858: IF NVL(p_record.PROMISE_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3857: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3858: IF NVL(p_record.PROMISE_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3859: RETURN NULL;
3860: END IF;
3861: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3862: (p_REQUEST_DATE => p_record.PROMISE_DATE) = 1 then
3863: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3864: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3865: END IF;
3859: RETURN NULL;
3860: END IF;
3861: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3862: (p_REQUEST_DATE => p_record.PROMISE_DATE) = 1 then
3863: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3864: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3865: END IF;
3866:
3867: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3860: END IF;
3861: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3862: (p_REQUEST_DATE => p_record.PROMISE_DATE) = 1 then
3863: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3864: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3865: END IF;
3866:
3867: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3868: IF NVL(p_record.SCHEDULE_SHIP_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3867: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3868: IF NVL(p_record.SCHEDULE_SHIP_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3869: RETURN NULL;
3870: END IF;
3871: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3872: (p_REQUEST_DATE => p_record.SCHEDULE_SHIP_DATE) = 1 then
3873: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3874: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3875: END IF;
3869: RETURN NULL;
3870: END IF;
3871: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3872: (p_REQUEST_DATE => p_record.SCHEDULE_SHIP_DATE) = 1 then
3873: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3874: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3875: END IF;
3876:
3877: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3870: END IF;
3871: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3872: (p_REQUEST_DATE => p_record.SCHEDULE_SHIP_DATE) = 1 then
3873: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3874: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3875: END IF;
3876:
3877: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3878: IF NVL(p_record.SCHEDULE_ARRIVAL_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3877: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3878: IF NVL(p_record.SCHEDULE_ARRIVAL_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3879: RETURN NULL;
3880: END IF;
3881: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3882: (p_REQUEST_DATE => p_record.SCHEDULE_ARRIVAL_DATE) = 1 then
3883: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3884: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3885: END IF;
3879: RETURN NULL;
3880: END IF;
3881: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3882: (p_REQUEST_DATE => p_record.SCHEDULE_ARRIVAL_DATE) = 1 then
3883: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3884: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3885: END IF;
3886:
3887: ELSIF (p_foreign_database_object_name = 'OE_AK_ARRIVAL_SETS_V') THEN
3880: END IF;
3881: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3882: (p_REQUEST_DATE => p_record.SCHEDULE_ARRIVAL_DATE) = 1 then
3883: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3884: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3885: END IF;
3886:
3887: ELSIF (p_foreign_database_object_name = 'OE_AK_ARRIVAL_SETS_V') THEN
3888: IF NVL(p_record.ARRIVAL_SET_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4443: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4444: IF NVL(p_record.REQUEST_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4445: RETURN NULL;
4446: END IF;
4447: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4448: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then
4449: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4450: END IF;
4451:
4445: RETURN NULL;
4446: END IF;
4447: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4448: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then
4449: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4450: END IF;
4451:
4452: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4453: IF NVL(p_record.PROMISE_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4452: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4453: IF NVL(p_record.PROMISE_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4454: RETURN NULL;
4455: END IF;
4456: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4457: (p_REQUEST_DATE => p_record.PROMISE_DATE) = 1 then
4458: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4459: END IF;
4460:
4454: RETURN NULL;
4455: END IF;
4456: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4457: (p_REQUEST_DATE => p_record.PROMISE_DATE) = 1 then
4458: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4459: END IF;
4460:
4461: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4462: IF NVL(p_record.SCHEDULE_SHIP_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4461: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4462: IF NVL(p_record.SCHEDULE_SHIP_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4463: RETURN NULL;
4464: END IF;
4465: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4466: (p_REQUEST_DATE => p_record.SCHEDULE_SHIP_DATE) = 1 then
4467: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4468: END IF;
4469:
4463: RETURN NULL;
4464: END IF;
4465: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4466: (p_REQUEST_DATE => p_record.SCHEDULE_SHIP_DATE) = 1 then
4467: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4468: END IF;
4469:
4470: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4471: IF NVL(p_record.SCHEDULE_ARRIVAL_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4470: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4471: IF NVL(p_record.SCHEDULE_ARRIVAL_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4472: RETURN NULL;
4473: END IF;
4474: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4475: (p_REQUEST_DATE => p_record.SCHEDULE_ARRIVAL_DATE) = 1 then
4476: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4477: END IF;
4478:
4472: RETURN NULL;
4473: END IF;
4474: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4475: (p_REQUEST_DATE => p_record.SCHEDULE_ARRIVAL_DATE) = 1 then
4476: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4477: END IF;
4478:
4479: ELSIF (p_foreign_database_object_name = 'OE_AK_ARRIVAL_SETS_V') THEN
4480: IF NVL(p_record.ARRIVAL_SET_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN