DBA Data[Home] [Help]

APPS.ONT_HEADER_DEF_UTIL dependencies on ONT_SHIP_TO_CON_DEF_UTIL

Line 2047: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache

2043: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
2044: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2045: RETURN NULL;
2046: END IF;
2047: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2048: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then
2049: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2050: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2051: END IF;

Line 2049: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2

2045: RETURN NULL;
2046: END IF;
2047: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2048: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then
2049: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2050: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2051: END IF;
2052:
2053: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN

Line 2050: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);

2046: END IF;
2047: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2048: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then
2049: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2050: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2051: END IF;
2052:
2053: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
2054: IF NVL(p_record.ORDERED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

Line 2288: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache

2284: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
2285: IF NVL(p_record.SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2286: RETURN NULL;
2287: END IF;
2288: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2289: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then
2290: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2291: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2292: END IF;

Line 2290: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2

2286: RETURN NULL;
2287: END IF;
2288: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2289: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then
2290: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2291: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2292: END IF;
2293:
2294: ELSIF (p_foreign_database_object_name = 'OE_AK_T_EXEMPT_REASON_V') THEN

Line 2291: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);

2287: END IF;
2288: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2289: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then
2290: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2291: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2292: END IF;
2293:
2294: ELSIF (p_foreign_database_object_name = 'OE_AK_T_EXEMPT_REASON_V') THEN
2295: IF NVL(p_record.TAX_EXEMPT_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 2616: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache

2612: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
2613: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2614: RETURN NULL;
2615: END IF;
2616: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2617: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then
2618: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2619: END IF;
2620:

Line 2618: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);

2614: RETURN NULL;
2615: END IF;
2616: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2617: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then
2618: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2619: END IF;
2620:
2621: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
2622: IF NVL(p_record.ORDERED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

Line 2834: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache

2830: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
2831: IF NVL(p_record.SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2832: RETURN NULL;
2833: END IF;
2834: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2835: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then
2836: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2837: END IF;
2838:

Line 2836: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);

2832: RETURN NULL;
2833: END IF;
2834: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2835: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then
2836: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2837: END IF;
2838:
2839: ELSIF (p_foreign_database_object_name = 'OE_AK_T_EXEMPT_REASON_V') THEN
2840: IF NVL(p_record.TAX_EXEMPT_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN