3970: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3971: IF NVL(p_record.REQUEST_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3972: RETURN NULL;
3973: END IF;
3974: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3975: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then
3976: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3977: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3978: END IF;
3972: RETURN NULL;
3973: END IF;
3974: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3975: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then
3976: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3977: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3978: END IF;
3979:
3980: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3973: END IF;
3974: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3975: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then
3976: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3977: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3978: END IF;
3979:
3980: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3981: IF NVL(p_record.PROMISE_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3980: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3981: IF NVL(p_record.PROMISE_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3982: RETURN NULL;
3983: END IF;
3984: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3985: (p_REQUEST_DATE => p_record.PROMISE_DATE) = 1 then
3986: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3987: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3988: END IF;
3982: RETURN NULL;
3983: END IF;
3984: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3985: (p_REQUEST_DATE => p_record.PROMISE_DATE) = 1 then
3986: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3987: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3988: END IF;
3989:
3990: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3983: END IF;
3984: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3985: (p_REQUEST_DATE => p_record.PROMISE_DATE) = 1 then
3986: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3987: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3988: END IF;
3989:
3990: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3991: IF NVL(p_record.SCHEDULE_SHIP_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3990: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3991: IF NVL(p_record.SCHEDULE_SHIP_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3992: RETURN NULL;
3993: END IF;
3994: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3995: (p_REQUEST_DATE => p_record.SCHEDULE_SHIP_DATE) = 1 then
3996: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3997: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3998: END IF;
3992: RETURN NULL;
3993: END IF;
3994: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3995: (p_REQUEST_DATE => p_record.SCHEDULE_SHIP_DATE) = 1 then
3996: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3997: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3998: END IF;
3999:
4000: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3993: END IF;
3994: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3995: (p_REQUEST_DATE => p_record.SCHEDULE_SHIP_DATE) = 1 then
3996: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
3997: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
3998: END IF;
3999:
4000: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4001: IF NVL(p_record.SCHEDULE_ARRIVAL_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4000: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4001: IF NVL(p_record.SCHEDULE_ARRIVAL_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4002: RETURN NULL;
4003: END IF;
4004: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4005: (p_REQUEST_DATE => p_record.SCHEDULE_ARRIVAL_DATE) = 1 then
4006: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
4007: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4008: END IF;
4002: RETURN NULL;
4003: END IF;
4004: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4005: (p_REQUEST_DATE => p_record.SCHEDULE_ARRIVAL_DATE) = 1 then
4006: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
4007: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4008: END IF;
4009:
4010: ELSIF (p_foreign_database_object_name = 'OE_AK_ARRIVAL_SETS_V') THEN
4003: END IF;
4004: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4005: (p_REQUEST_DATE => p_record.SCHEDULE_ARRIVAL_DATE) = 1 then
4006: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2
4007: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4008: END IF;
4009:
4010: ELSIF (p_foreign_database_object_name = 'OE_AK_ARRIVAL_SETS_V') THEN
4011: IF NVL(p_record.ARRIVAL_SET_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4551: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4552: IF NVL(p_record.REQUEST_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4553: RETURN NULL;
4554: END IF;
4555: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4556: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then
4557: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4558: END IF;
4559:
4553: RETURN NULL;
4554: END IF;
4555: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4556: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then
4557: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4558: END IF;
4559:
4560: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4561: IF NVL(p_record.PROMISE_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4560: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4561: IF NVL(p_record.PROMISE_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4562: RETURN NULL;
4563: END IF;
4564: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4565: (p_REQUEST_DATE => p_record.PROMISE_DATE) = 1 then
4566: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4567: END IF;
4568:
4562: RETURN NULL;
4563: END IF;
4564: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4565: (p_REQUEST_DATE => p_record.PROMISE_DATE) = 1 then
4566: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4567: END IF;
4568:
4569: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4570: IF NVL(p_record.SCHEDULE_SHIP_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4569: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4570: IF NVL(p_record.SCHEDULE_SHIP_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4571: RETURN NULL;
4572: END IF;
4573: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4574: (p_REQUEST_DATE => p_record.SCHEDULE_SHIP_DATE) = 1 then
4575: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4576: END IF;
4577:
4571: RETURN NULL;
4572: END IF;
4573: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4574: (p_REQUEST_DATE => p_record.SCHEDULE_SHIP_DATE) = 1 then
4575: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4576: END IF;
4577:
4578: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4579: IF NVL(p_record.SCHEDULE_ARRIVAL_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4578: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
4579: IF NVL(p_record.SCHEDULE_ARRIVAL_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
4580: RETURN NULL;
4581: END IF;
4582: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4583: (p_REQUEST_DATE => p_record.SCHEDULE_ARRIVAL_DATE) = 1 then
4584: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4585: END IF;
4586:
4580: RETURN NULL;
4581: END IF;
4582: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
4583: (p_REQUEST_DATE => p_record.SCHEDULE_ARRIVAL_DATE) = 1 then
4584: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
4585: END IF;
4586:
4587: ELSIF (p_foreign_database_object_name = 'OE_AK_ARRIVAL_SETS_V') THEN
4588: IF NVL(p_record.ARRIVAL_SET_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN