90: IS
91: lv_status varchar2(4000);
92:
93: BEGIN
94: if( (wf_engine.GetItemAttrText(item_type, item_key, gv_appr_compl_status, true) is null) or
95: (wf_engine.GetItemAttrText(item_type, item_key, gv_appr_compl_status, true) = 'W')) then
96: wf_engine.setitemattrtext(item_type, item_key, gv_appr_compl_status, status);
97: end if;
98: wf_engine.setitemattrtext(item_type, item_key, attr_name, l_log);
91: lv_status varchar2(4000);
92:
93: BEGIN
94: if( (wf_engine.GetItemAttrText(item_type, item_key, gv_appr_compl_status, true) is null) or
95: (wf_engine.GetItemAttrText(item_type, item_key, gv_appr_compl_status, true) = 'W')) then
96: wf_engine.setitemattrtext(item_type, item_key, gv_appr_compl_status, status);
97: end if;
98: wf_engine.setitemattrtext(item_type, item_key, attr_name, l_log);
99: EXCEPTION
92:
93: BEGIN
94: if( (wf_engine.GetItemAttrText(item_type, item_key, gv_appr_compl_status, true) is null) or
95: (wf_engine.GetItemAttrText(item_type, item_key, gv_appr_compl_status, true) = 'W')) then
96: wf_engine.setitemattrtext(item_type, item_key, gv_appr_compl_status, status);
97: end if;
98: wf_engine.setitemattrtext(item_type, item_key, attr_name, l_log);
99: EXCEPTION
100: WHEN others then
94: if( (wf_engine.GetItemAttrText(item_type, item_key, gv_appr_compl_status, true) is null) or
95: (wf_engine.GetItemAttrText(item_type, item_key, gv_appr_compl_status, true) = 'W')) then
96: wf_engine.setitemattrtext(item_type, item_key, gv_appr_compl_status, status);
97: end if;
98: wf_engine.setitemattrtext(item_type, item_key, attr_name, l_log);
99: EXCEPTION
100: WHEN others then
101: raise;
102: END;
1559: (p_item_type => p_item_type
1560: ,p_item_key => p_item_key
1561: ,p_name => p_attr_name) then
1562: -- the item attribute does not exist so create it
1563: wf_engine.additemattr
1564: (itemtype => p_item_type
1565: ,itemkey => p_item_key
1566: ,aname => p_attr_name);
1567: end if;
1790: BEGIN
1791: l_proc := 'HR_COMPLETE_APPRAISAL_SS.COMPLETE_APPR';
1792: -- hr_utility.trace_on(null,'APPR');
1793: hr_utility.set_location(' Entering:' || l_proc,5);
1794: appraisal_id := wf_engine.GetItemAttrNumber (itemtype => item_type ,
1795: itemkey => item_key ,
1796: aname => 'APPRAISAL_ID',
1797: ignore_notfound => true);
1798: hr_utility.set_location(' Entering:' || l_proc,10);
1916:
1917: BEGIN
1918:
1919: p_result_out := 'N';
1920: l_appraisal_id := wf_engine.GetItemAttrNumber (itemtype => p_item_type ,
1921: itemkey => p_item_key ,
1922: aname => 'APPRAISAL_ID',
1923: ignore_notfound=>false);
1924: