Skip to main content
Xdoxslt XML Publisher RTF Important Syntax’s

    1.       To convert CASE of a tag to UPPER case
     xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')
    2.       To convert CASE of a tag to LOWER case
     xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')
    3.       Syntax for CONTAIN
     contains(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER'),’IC CREDIT MEMO’)
    4.       Syntax for NOT CONTAIN
     not(contains(xdoxslt:convert_case(.//REFERENCE_ID,'UPPER'),'WSC'))
    5.       CHOOSE-WHEN-OTHERWISE Syntax
    <?choose:?><?when: contains(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER'),’IC CREDIT       MEMO’)?><?’Interco Credit Memo’?><?end when?><?otherwise:?><?.//INVOICETYPE?><?         end otherwise?><?end choose?>
    6.       IF - ELSE Syntax
    <?xdoxslt:ifelse(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')!='CONSIGNMENT                ORDER',.//BILLOFLADING,'NULL')?>
    7.       START-END BODY
     ----HEADER------
       <?start:body?>
     ----BODY---------
     <?end body?>
     ----FOOTER—
     8.       FOR-EACH Grouping
      <?for-each:XWII_810_OUT_LINE_OBJ?>
      <?end for-each?>
     9.       TEMPLATES
       <?template:XWII_LOGO?>
       ------Conditions-----
        <?end template?>
      Syntax to call Template
      <?call:XWII_LOGO?>
10.   Substring Before
        substring-before(.//ALLOY,’/’)
      11.   Substring After
        substring-after(.//ALLOY,’/’)
      12.   Set Variable
       <?xdoxslt:set_variable($_XDOCTX,'PRO',/ProcessInvoice/XWII_810_OUT_INVOICE_OBJ/XWII_810_OUT_HEADER/PRODUCT)?>
      Get Variable
       xdoxslt:get_variable($_XDOCTX,'PRO')
      13.   Concatenation
       concat(.//ALLOY,.//HAR,’TEST’)
      14.   Numeric
       xdoxslt:is_numeric(.//BILLTOIDENTIFIER)
      15.   Not Numeric
       not(xdoxslt:is_numeric(.//BILLTOIDENTIFIER))
      16.   Formatting Number
       format-number(LOTEXTENSION,'##,###,##0.00')
      17.   Tag Exists
       IF .//BILLTOIDENTIFIER THEN
      18.   Tag Not Exists
       IF not(.//BILLTOIDENTIFIER) THEN

Comments

Post a Comment

Popular posts from this blog

Oracle Forms -- Important Syntaxes

1. To get the enabled property of the item APP_ITEM_PROPERTY.GET_PROPERTY('CONTROL.FILTER_HOLD_RECORDS',ENABLED) 2. Disable Attachment for this Block in WHEN-NEW-BLOCK-INSTANCE  APP_SPECIAL.ENABLE('ATTACHMENTS', PROPERTY_OFF); 3. Default Where / Default Order By Set_block_property('XWII_MATL_DISP_HOLDS_V', Default_where, Lc_query); Set_block_property('XWII_MATL_DISP_HOLDS_V', order_by, Lc_query); 4. Visual Attribute    a. Define Visual Attribute for eg 'XWII' where you can set Colour  b. SET_ITEM_INSTANCE_PROPERTY('block.item_name',CURRENT_RECORD,VISUAL_ATTRIBUTE ,'XWII'); 4. Visual Attribute for Record APP_RECORD.HIGHLIGHT('XWII'); Where 'XWII' is the visual attribute where you can set Colour. 5. Initiliaze SPECIAL Menu app_special.instantiate ('SPECIAL1', GET_GROUP_CHAR_CELL ('SPECIAL_MENU.SPECIAL_MENU_ITEM', 1), '', TRUE, ''); 6. execute_trigger('SPECIAL25...
1 comment
Read more

Customize New Oracle Apps Form (11i and 12i)

Create and Register of a Custom Form in Oracle Applications(11i and R12) Steps to Create a new form in oracle Apps R12   1. Check the Form builder version is compatible with your application server or not. 2. Download all the necessary .FMb and .PLL files from the server     FMB- TEMPLATE.fmb and APPSTAND.fmb files Server location FMB -$AU_TOP/forms/US Server location PLL - $AU_TOP/resource (Try to download all PLL files) First try to download below PLL files see if it works .If it does work then you don't need to download all the PLL files APPCORE.pll                   APPCORE2.pll              APPDAYPK.pll APPFLDR.pll                   CUSTOM.pll    ...
Post a Comment
Read more