DBA Data[Home] [Help]

APPS.ONT_LINE_DEF_UTIL dependencies on ONT_REQ_DATE_DEF_UTIL

Line 3974: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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;

Line 3976: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2

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

Line 3977: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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

Line 3984: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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;

Line 3986: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2

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

Line 3987: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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

Line 3994: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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;

Line 3996: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2

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

Line 3997: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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

Line 4004: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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;

Line 4006: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Varchar2

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

Line 4007: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);

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

Line 4555: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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:

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

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

Line 4564: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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:

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

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

Line 4573: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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:

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

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

Line 4582: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache

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:

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

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