59: --+
60: --Changed from 'dd-mon-yyyy hh24:mi:ss' from 'dd-mon-yyyy hh24:mi:sssss' to have more control.
61: SELECT p_posting_detail_id ||'--'|| to_char(sysdate, 'dd-mon-yyyy hh24:mi:sssss')
62: INTO itemkey 63: FROM dual; 64:
65: open get_accgen_type;
66: fetch get_accgen_type into l_accgen_type;
67: close get_accgen_type;