R12.2 RTF Sample xdo functions

-- Excel template date column function
 =IFERROR(DATEVALUE(LEFT(AM2,10)),"")

--conditional printing in rtf
<?xdofx:if P_ATTRIBUTE3 = 'Y' then 'USD'    else     'AED'  end if?>

<fo:basic-link color="blue" external-destination="{CP_RFO_LINK}"><?UNIT_NO?></fo:basic-link>

<?xdofx:if (CF_TRX_TYPE!='CM' and >0) then 'Invoice' else 'CREDIT MEMO' end if?> 

<?xdofx:if APS_DUE_DATE='' then 'Immediate' else APS_DUE_DATE end if?>

<?xdofx:if CF_ACC_DEPR='' then CURRENT_COST else CF_ACC_DEPR end if?>

<?xdofx:if to_date(xdoxslt:get_variable($_XDOCTX,"V_ORD_DATE")) > to_date("03-AUG-22") then '30Nov22' else '31Aug22' end if?>

<?xdofx:if SRNO = 1 then 'Purchaser Two' else 'Purchaser Three' end if?>
<?xdofx:if SRNO = 1 then 'المشترى الثاني' else 'المشترى الثالث' end if?>

<?xdofx:if ../../CS_LAST_INST_NUM = INSTALLMENT_NO then ../../HO_RFO_PAY_DUE_DATE else nvl(DUE_DATE,TRX_DATE) end if?>

<?xdofx:if P_ORG_ID='' then '' else OPERATING_UNIT end if?>

<?split-by-page-break:?>

<?xdoxslt:ifelse((ORDER_DATE > '03-AUG-22'),'30 November 2022','31 August 2022')?>

<?xdoxslt:ora_format_date(ORDER_DATE,"yyyy-MM-dd")?>

<?xdoxslt:set_variable($_XDOCTX,'V_DATE',"")?>
<?xdofx:nvl(PAYMENT_DATE,'Upon '||DESCRIPTION)?>
<?xdoxslt:ifelse((xdoxslt:ora_format_date(xdoxslt:get_variable($_XDOCTX,"V_ORD_DATE"),"yyyyMMdd")> '20220803'),'AAA','BBB' )?>

<?xsl:variable xdofo:ctx="incontext" name="V_ORD_DATE" select=".//G_SO_DETAILS/ORDER_DATE"?>

--for empty group tags

<?if:not(//G_Group_Name/Tag_Name)?><?end if?>

<?xdoxslt:set_variable($_XDOCTX,"V_ORD_DATE",ORDER_DATE)?>

<?xdoxslt:ora_format_date(xdoxslt:get_variable($_XDOCTX,"V_ORD_DATE"),"dd-MON-yy")?>

<?if:((BUILDING1!='Heart1' and BUILDING1!='Heart2' and BUILDING1!='Heart3' and BUILDING1!='Heart5') and (FLOOR1!='07' or FLOOR1!='08'))?>
<?if:(CF_TRX_TYPE='CM' or UNIT_SELLING_PRICE<0)?>