DBA Data[Home] [Help]

APPS.ONT_LINE_DEF_UTIL dependencies on ONT_REQ_DATE_DEF_UTIL

Line 3851: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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;

Line 3853: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2

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

Line 3854: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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

Line 3861: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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;

Line 3863: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2

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

Line 3864: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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

Line 3871: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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;

Line 3873: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2

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

Line 3874: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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

Line 3881: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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;

Line 3883: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2

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

Line 3884: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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

Line 4447: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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:

Line 4449: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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

Line 4456: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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:

Line 4458: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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

Line 4465: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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:

Line 4467: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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

Line 4474: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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:

Line 4476: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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