2073: ELSIF (p_foreign_database_object_name = 'OE_AK_TRXN_PHASE_V') THEN
2074: IF NVL(p_record.TRANSACTION_PHASE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2075: RETURN NULL;
2076: END IF;
2077: IF ONT_TRXN_PHASE_Def_Util.Sync_TRXN_PHASE_Cache
2078: (p_TRANSACTION_PHASE_CODE => p_record.TRANSACTION_PHASE_CODE) = 1 then
2079: RETURN ONT_TRXN_PHASE_Def_Util.Get_Attr_Val_Varchar2
2080: (p_foreign_attr_code,ONT_TRXN_PHASE_Def_Util.g_cached_record);
2081: END IF;
2075: RETURN NULL;
2076: END IF;
2077: IF ONT_TRXN_PHASE_Def_Util.Sync_TRXN_PHASE_Cache
2078: (p_TRANSACTION_PHASE_CODE => p_record.TRANSACTION_PHASE_CODE) = 1 then
2079: RETURN ONT_TRXN_PHASE_Def_Util.Get_Attr_Val_Varchar2
2080: (p_foreign_attr_code,ONT_TRXN_PHASE_Def_Util.g_cached_record);
2081: END IF;
2082:
2083: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_V') THEN
2076: END IF;
2077: IF ONT_TRXN_PHASE_Def_Util.Sync_TRXN_PHASE_Cache
2078: (p_TRANSACTION_PHASE_CODE => p_record.TRANSACTION_PHASE_CODE) = 1 then
2079: RETURN ONT_TRXN_PHASE_Def_Util.Get_Attr_Val_Varchar2
2080: (p_foreign_attr_code,ONT_TRXN_PHASE_Def_Util.g_cached_record);
2081: END IF;
2082:
2083: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_V') THEN
2084: IF NVL(p_record.END_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2639: ELSIF (p_foreign_database_object_name = 'OE_AK_TRXN_PHASE_V') THEN
2640: IF NVL(p_record.TRANSACTION_PHASE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2641: RETURN NULL;
2642: END IF;
2643: IF ONT_TRXN_PHASE_Def_Util.Sync_TRXN_PHASE_Cache
2644: (p_TRANSACTION_PHASE_CODE => p_record.TRANSACTION_PHASE_CODE) = 1 then
2645: RETURN ONT_TRXN_PHASE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_TRXN_PHASE_Def_Util.g_cached_record);
2646: END IF;
2647:
2641: RETURN NULL;
2642: END IF;
2643: IF ONT_TRXN_PHASE_Def_Util.Sync_TRXN_PHASE_Cache
2644: (p_TRANSACTION_PHASE_CODE => p_record.TRANSACTION_PHASE_CODE) = 1 then
2645: RETURN ONT_TRXN_PHASE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_TRXN_PHASE_Def_Util.g_cached_record);
2646: END IF;
2647:
2648: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_V') THEN
2649: IF NVL(p_record.END_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN