DBA Data[Home] [Help]

APPS.ONT_HEADER_DEF_UTIL dependencies on ONT_SHIP_TO_CON_DEF_UTIL

Line 2388: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache

2384: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
2385: IF NVL(p_record.SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2386: RETURN NULL;
2387: END IF;
2388: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2389: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then
2390: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2391: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2392: END IF;

Line 2390: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2

2386: RETURN NULL;
2387: END IF;
2388: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2389: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then
2390: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2391: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2392: END IF;
2393:
2394: ELSIF (p_foreign_database_object_name = 'OE_AK_T_EXEMPT_REASON_V') THEN

Line 2391: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);

2387: END IF;
2388: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2389: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then
2390: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2391: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2392: END IF;
2393:
2394: ELSIF (p_foreign_database_object_name = 'OE_AK_T_EXEMPT_REASON_V') THEN
2395: IF NVL(p_record.TAX_EXEMPT_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 2538: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache

2534: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
2535: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2536: RETURN NULL;
2537: END IF;
2538: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2539: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then
2540: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2541: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2542: END IF;

Line 2540: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2

2536: RETURN NULL;
2537: END IF;
2538: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2539: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then
2540: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2541: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2542: END IF;
2543:
2544: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN

Line 2541: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);

2537: END IF;
2538: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2539: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then
2540: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2541: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2542: END IF;
2543:
2544: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
2545: IF NVL(p_record.ORDERED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

Line 2924: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache

2920: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
2921: IF NVL(p_record.SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2922: RETURN NULL;
2923: END IF;
2924: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2925: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then
2926: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2927: END IF;
2928:

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

2922: RETURN NULL;
2923: END IF;
2924: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2925: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then
2926: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2927: END IF;
2928:
2929: ELSIF (p_foreign_database_object_name = 'OE_AK_T_EXEMPT_REASON_V') THEN
2930: IF NVL(p_record.TAX_EXEMPT_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 3059: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache

3055: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
3056: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3057: RETURN NULL;
3058: END IF;
3059: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
3060: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then
3061: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
3062: END IF;
3063:

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

3057: RETURN NULL;
3058: END IF;
3059: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
3060: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then
3061: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
3062: END IF;
3063:
3064: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3065: IF NVL(p_record.ORDERED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN