DBA Data[Home] [Help]

APPS.HR_SUPERVISOR_SS dependencies on WF_ENGINE

Line 189: ln_person_id := wf_engine.GetItemAttrNumber

185: BEGIN
186: --
187: -- Get the action person id, ie. selected person id
188: hr_utility.set_location('Entering '|| l_proc,5);
189: ln_person_id := wf_engine.GetItemAttrNumber
190: (itemtype => itemtype
191: ,itemkey => itemkey
192: ,aname => 'CURRENT_PERSON_ID');
193:

Line 194: ln_assignment_id := wf_engine.GetItemAttrNumber (

190: (itemtype => itemtype
191: ,itemkey => itemkey
192: ,aname => 'CURRENT_PERSON_ID');
193:
194: ln_assignment_id := wf_engine.GetItemAttrNumber (
195: itemtype => itemtype,
196: itemkey => itemkey,
197: aname => 'CURRENT_ASSIGNMENT_ID');
198:

Line 200: ln_creator_person_id := wf_engine.GetItemAttrNumber

196: itemkey => itemkey,
197: aname => 'CURRENT_ASSIGNMENT_ID');
198:
199: -- Get the login person id
200: ln_creator_person_id := wf_engine.GetItemAttrNumber
201: (itemtype => itemtype
202: ,itemkey => itemkey
203: ,aname => 'CREATOR_PERSON_ID');
204:

Line 208: ld_effective_date := wf_engine.GetItemAttrDate

204:
205:
206: -- The termination effective date was stored in the wf item attribute
207: -- CURRENT_EFFECTIVE_DATE as a date data type.
208: ld_effective_date := wf_engine.GetItemAttrDate
209: (itemtype => itemtype
210: ,itemkey => itemkey
211: ,aname => 'CURRENT_EFFECTIVE_DATE');
212:

Line 215: lv_term_sup_flag := wf_engine.GetItemAttrText

211: ,aname => 'CURRENT_EFFECTIVE_DATE');
212:
213: -- Need to get the wf item attribute HR_TERM_SUP_FLAG so that the Supervisor
214: -- page knows whether the caller is from Termination or not.
215: lv_term_sup_flag := wf_engine.GetItemAttrText
216: (itemtype => itemtype
217: ,itemkey => itemkey
218: ,aname => 'HR_TERM_SUP_FLAG');
219:

Line 232: l_term_sec_asg := wf_engine.getitemattrtext(itemtype, itemkey,

228: select primary_flag into dummy from per_all_assignments_f where
229: assignment_id=ln_assignment_id and ld_effective_date between
230: effective_start_date and effective_end_date;
231:
232: l_term_sec_asg := wf_engine.getitemattrtext(itemtype, itemkey,
233: 'HR_TERM_SEC_ASG',true);
234:
235: -- We need to run the update_access_check cursor to see if the
236: -- login person has the security access to select another manager

Line 260: l_vol_term := wf_engine.getitemattrtext(itemtype, itemkey,

256: END LOOP;
257: end if;
258:
259: if (ln_person_id = fnd_global.employee_id) then
260: l_vol_term := wf_engine.getitemattrtext(itemtype, itemkey,
261: 'HR_VOL_TERM_SS',true);
262: if (l_vol_term is not null) then
263: open csr_attr_value(actid,'BYPASS_ORG_MGR');
264: fetch csr_attr_value into dummy_2;

Line 272: wf_engine.setitemattrtext(itemtype,itemkey,'HR_VOL_TERM_SS','BOTH');

268:
269: if (dummy_2 = 'Y' and resultout = 'COMPLETE:Y') then
270: resultout := 'COMPLETE:'|| 'N';
271: if (l_vol_term = 'SUP') then
272: wf_engine.setitemattrtext(itemtype,itemkey,'HR_VOL_TERM_SS','BOTH');
273: elsif (l_vol_term = 'Y') then
274: wf_engine.setitemattrtext(itemtype,itemkey,'HR_VOL_TERM_SS','CCMGR');
275: end if;
276: end if;

Line 274: wf_engine.setitemattrtext(itemtype,itemkey,'HR_VOL_TERM_SS','CCMGR');

270: resultout := 'COMPLETE:'|| 'N';
271: if (l_vol_term = 'SUP') then
272: wf_engine.setitemattrtext(itemtype,itemkey,'HR_VOL_TERM_SS','BOTH');
273: elsif (l_vol_term = 'Y') then
274: wf_engine.setitemattrtext(itemtype,itemkey,'HR_VOL_TERM_SS','CCMGR');
275: end if;
276: end if;
277:
278: -- We need to get the login person's manager id and set the WF item

Line 295: wf_engine.SetItemAttrNumber

291: -- to. This is concurred by C. Beach on 02/18/2002. The reason
292: -- is that the login person can forward the notification to
293: -- someone else.
294:
295: wf_engine.SetItemAttrNumber
296: (itemtype => itemtype
297: ,itemkey => itemkey
298: ,aname => 'HR_MGR_ID_OF_LOGIN_PERSON'
299: ,avalue => ln_creator_person_id);

Line 301: wf_engine.SetItemAttrNumber

297: ,itemkey => itemkey
298: ,aname => 'HR_MGR_ID_OF_LOGIN_PERSON'
299: ,avalue => ln_creator_person_id);
300: ELSE
301: wf_engine.SetItemAttrNumber
302: (itemtype => itemtype
303: ,itemkey => itemkey
304: ,aname => 'HR_MGR_ID_OF_LOGIN_PERSON'
305: ,avalue => ln_manager_id);

Line 1657: p_review_proc_call => wf_engine.GetActivityAttrText(itemtype => p_item_type,

1653: p_act_id => p_actid,
1654: p_transaction_id => l_transaction_id,
1655: p_transaction_step_id => l_transaction_step_id,
1656: p_login_person_id => p_login_person_id,
1657: p_review_proc_call => wf_engine.GetActivityAttrText(itemtype => p_item_type,
1658: itemkey => p_item_key,
1659: actid => p_actid,
1660: aname => 'HR_REVIEW_REGION_ITEM'),
1661: p_selected_emp_id => p_selected_person_id,

Line 1940: l_re_hire_flow := wf_engine.GetItemAttrText(p_item_type,p_item_key,'HR_FLOW_IDENTIFIER',true);

1936: l_supervisor_assignment_id := p_supervisor_assignment_id;
1937: --Validate the p_supervisor_id
1938: if l_supervisor_id is not null then
1939: hr_utility.trace('In ( if l_supervisor_id is not null )'|| l_proc);
1940: l_re_hire_flow := wf_engine.GetItemAttrText(p_item_type,p_item_key,'HR_FLOW_IDENTIFIER',true);
1941: open chk_ex_emp(l_supervisor_id, p_effective_date);
1942: fetch chk_ex_emp into l_ex_emp;
1943: close chk_ex_emp;
1944:

Line 1971: l_current_person_id := wf_engine.GetItemAttrText(p_item_type,p_item_key,'CURRENT_PERSON_ID',true);

1967:
1968: --Fix for Bug 11679239
1969: --check whether the current employee has future date assignment changes
1970:
1971: l_current_person_id := wf_engine.GetItemAttrText(p_item_type,p_item_key,'CURRENT_PERSON_ID',true);
1972:
1973: open csr_assignment_person;
1974: fetch csr_assignment_person into l_person_id,l_person_name;
1975: close csr_assignment_person;

Line 2036: l_applicant_assignment_id := wf_engine.getItemAttrText(

2032: g_applicant_hire := true;
2033: isApplicantSubordinate := false;
2034: l_applicant_person_id := p_supervisor_id;
2035: -- Get the assignment_id for the applicant from workflow
2036: l_applicant_assignment_id := wf_engine.getItemAttrText(
2037: itemtype => p_item_type,
2038: itemkey => p_item_key,
2039: aname => 'CURRENT_ASSIGNMENT_ID');
2040: l_applicant_effective_date := wf_engine.getItemAttrDate(

Line 2040: l_applicant_effective_date := wf_engine.getItemAttrDate(

2036: l_applicant_assignment_id := wf_engine.getItemAttrText(
2037: itemtype => p_item_type,
2038: itemkey => p_item_key,
2039: aname => 'CURRENT_ASSIGNMENT_ID');
2040: l_applicant_effective_date := wf_engine.getItemAttrDate(
2041: itemtype => p_item_type,
2042: itemkey => p_item_key,
2043: aname => 'CURRENT_EFFECTIVE_DATE');
2044: -- Get the object version number

Line 2068: l_applicant_effective_date := wf_engine.getItemAttrDate(

2064: isApplicantSubordinate := false;
2065: -- Get the person_id from assignment record.
2066: l_applicant_person_id := l_person_id;
2067: l_applicant_assignment_id := p_assignment_id;
2068: l_applicant_effective_date := wf_engine.getItemAttrDate(
2069: itemtype => p_item_type,
2070: itemkey => p_item_key,
2071: aname => 'CURRENT_EFFECTIVE_DATE');
2072: -- first get the object_version_number for the applicant from