How to add parameters in application front end for below code
reference6
VARCHAR2
100
Journal Ref
||'|'||NULL
reference7
VARCHAR2
100
Journal Rev Flag
||'|'||NULL
reference8
VARCHAR2
100
Journal Rev Period
||'|'||NULL
||'|'||'Y'
||'|'||b.period_name -- /*-- Commented for Version 1.1 */