444: --
445: BEGIN
446:
447: --
448: l_ppe_id := wf_engine.getItemAttrText
449: (itemtype => itemtype,
450: itemkey => itemkey,
451: aname => an_event_id);
452:
464: ||''',''DD-MON-RR'') '
465: || ' BETWEEN ' || l_sd_name || ' AND ' || l_ed_name ;
466: hr_utility.trace('Col getting Statement ' || l_statement);
467:
468: wf_engine.setItemAttrText
469: (itemtype => itemtype,
470: itemkey => itemkey,
471: aname => an_retro_asg_nums,
472: aValue => l_ppe_id||' <- ->'||l_column_name);
480: close csr_usr_name;
481: end if;
482: hr_utility.trace('User ID, Name: '||l_usr_id||', '||l_user);
483:
484: wf_engine.setItemAttrText
485: (itemtype => itemtype,
486: itemkey => itemkey,
487: aname => an_user,
488: aValue => l_user);
486: itemkey => itemkey,
487: aname => an_user,
488: aValue => l_user);
489:
490: wf_engine.setItemAttrText
491: (itemtype => itemtype,
492: itemkey => itemkey,
493: aname => an_tab,
494: aValue => l_table_name);
492: itemkey => itemkey,
493: aname => an_tab,
494: aValue => l_table_name);
495:
496: wf_engine.setItemAttrText
497: (itemtype => itemtype,
498: itemkey => itemkey,
499: aname => an_col,
500: aValue => l_column_name);