DBA Data[Home] [Help]

APPS.ONT_LINE_DEF_UTIL dependencies on ONT_RET_REASON_DEF_UTIL

Line 4043: IF ONT_RET_REASON_Def_Util.Sync_RET_REASON_Cache

4039: ELSIF (p_foreign_database_object_name = 'OE_AK_RETURN_REASON_V') THEN
4040: IF NVL(p_record.RETURN_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4041: RETURN NULL;
4042: END IF;
4043: IF ONT_RET_REASON_Def_Util.Sync_RET_REASON_Cache
4044: (p_RETURN_REASON_CODE => p_record.RETURN_REASON_CODE) = 1 then
4045: RETURN ONT_RET_REASON_Def_Util.Get_Attr_Val_Varchar2
4046: (p_foreign_attr_code,ONT_RET_REASON_Def_Util.g_cached_record);
4047: END IF;

Line 4045: RETURN ONT_RET_REASON_Def_Util.Get_Attr_Val_Varchar2

4041: RETURN NULL;
4042: END IF;
4043: IF ONT_RET_REASON_Def_Util.Sync_RET_REASON_Cache
4044: (p_RETURN_REASON_CODE => p_record.RETURN_REASON_CODE) = 1 then
4045: RETURN ONT_RET_REASON_Def_Util.Get_Attr_Val_Varchar2
4046: (p_foreign_attr_code,ONT_RET_REASON_Def_Util.g_cached_record);
4047: END IF;
4048:
4049: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN

Line 4046: (p_foreign_attr_code,ONT_RET_REASON_Def_Util.g_cached_record);

4042: END IF;
4043: IF ONT_RET_REASON_Def_Util.Sync_RET_REASON_Cache
4044: (p_RETURN_REASON_CODE => p_record.RETURN_REASON_CODE) = 1 then
4045: RETURN ONT_RET_REASON_Def_Util.Get_Attr_Val_Varchar2
4046: (p_foreign_attr_code,ONT_RET_REASON_Def_Util.g_cached_record);
4047: END IF;
4048:
4049: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
4050: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 4622: IF ONT_RET_REASON_Def_Util.Sync_RET_REASON_Cache

4618: ELSIF (p_foreign_database_object_name = 'OE_AK_RETURN_REASON_V') THEN
4619: IF NVL(p_record.RETURN_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4620: RETURN NULL;
4621: END IF;
4622: IF ONT_RET_REASON_Def_Util.Sync_RET_REASON_Cache
4623: (p_RETURN_REASON_CODE => p_record.RETURN_REASON_CODE) = 1 then
4624: RETURN ONT_RET_REASON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_RET_REASON_Def_Util.g_cached_record);
4625: END IF;
4626:

Line 4624: RETURN ONT_RET_REASON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_RET_REASON_Def_Util.g_cached_record);

4620: RETURN NULL;
4621: END IF;
4622: IF ONT_RET_REASON_Def_Util.Sync_RET_REASON_Cache
4623: (p_RETURN_REASON_CODE => p_record.RETURN_REASON_CODE) = 1 then
4624: RETURN ONT_RET_REASON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_RET_REASON_Def_Util.g_cached_record);
4625: END IF;
4626:
4627: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
4628: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN