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
||'|'||'N'