DBA Data[Home] [Help]

APPS.HR_TRANSACTION_SS dependencies on HR_WORKFLOW_UTILITY

Line 217: if hr_workflow_utility.item_attribute_exists

213: END IF;
214:
215:
216: -- get AME related WF attribute values
217: if hr_workflow_utility.item_attribute_exists
218: (p_item_type => p_item_type
219: ,p_item_key => p_item_key
220: ,p_name => 'HR_AME_APP_ID_ATTR') then
221: -- get the attribute value

Line 222: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

218: (p_item_type => p_item_type
219: ,p_item_key => p_item_key
220: ,p_name => 'HR_AME_APP_ID_ATTR') then
221: -- get the attribute value
222: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
223: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
224: itemkey => p_item_key,
225: aname => 'HR_AME_APP_ID_ATTR');
226:

Line 228: hr_utility.trace('In : else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

224: itemkey => p_item_key,
225: aname => 'HR_AME_APP_ID_ATTR');
226:
227: else
228: hr_utility.trace('In : else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
229: c_application_id := null;
230: end if;
231:
232: c_application_id := nvl(c_application_id,800);

Line 234: if hr_workflow_utility.item_attribute_exists

230: end if;
231:
232: c_application_id := nvl(c_application_id,800);
233:
234: if hr_workflow_utility.item_attribute_exists
235: (p_item_type => p_item_type
236: ,p_item_key => p_item_key
237: ,p_name => 'TRANSACTION_ID') then
238: -- get the attribute value

Line 239: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

235: (p_item_type => p_item_type
236: ,p_item_key => p_item_key
237: ,p_name => 'TRANSACTION_ID') then
238: -- get the attribute value
239: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
240: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
241: itemkey => p_item_key,
242: aname => 'TRANSACTION_ID');
243: else

Line 244: hr_utility.trace('In : else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

240: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
241: itemkey => p_item_key,
242: aname => 'TRANSACTION_ID');
243: else
244: hr_utility.trace('In : else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
245: c_transaction_id := null;
246: end if;
247:
248:

Line 249: if hr_workflow_utility.item_attribute_exists

245: c_transaction_id := null;
246: end if;
247:
248:
249: if hr_workflow_utility.item_attribute_exists
250: (p_item_type => p_item_type
251: ,p_item_key => p_item_key
252: ,p_name => 'HR_AME_TRAN_TYPE_ATTR') then
253: -- get the attribute value

Line 254: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

250: (p_item_type => p_item_type
251: ,p_item_key => p_item_key
252: ,p_name => 'HR_AME_TRAN_TYPE_ATTR') then
253: -- get the attribute value
254: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
255: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
256: itemkey => p_item_key,
257: aname => 'HR_AME_TRAN_TYPE_ATTR');
258: else

Line 259: hr_utility.trace('In : else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

255: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
256: itemkey => p_item_key,
257: aname => 'HR_AME_TRAN_TYPE_ATTR');
258: else
259: hr_utility.trace('In : else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
260: c_transaction_type := null;
261:
262: end if;
263:

Line 374: if hr_workflow_utility.item_attribute_exists

370:
371: -- need to reset all the Workflow item attributes used in the approval process
372:
373: -- FORWARD_FROM_DISPLAY_NAME
374: if hr_workflow_utility.item_attribute_exists
375: (p_item_type => p_item_type
376: ,p_item_key => p_item_key
377: ,p_name => 'FORWARD_FROM_DISPLAY_NAME') then
378: -- set the attribute value to null

Line 385: if hr_workflow_utility.item_attribute_exists

381: aname => 'FORWARD_FROM_DISPLAY_NAME',
382: avalue=>null);
383: end if;
384: -- FORWARD_FROM_USERNAME
385: if hr_workflow_utility.item_attribute_exists
386: (p_item_type => p_item_type
387: ,p_item_key => p_item_key
388: ,p_name => 'FORWARD_FROM_USERNAME') then
389: -- set the attribute value to null

Line 396: if hr_workflow_utility.item_attribute_exists

392: aname => 'FORWARD_FROM_USERNAME',
393: avalue=>null);
394: end if;
395: -- FORWARD_FROM_PERSON_ID
396: if hr_workflow_utility.item_attribute_exists
397: (p_item_type => p_item_type
398: ,p_item_key => p_item_key
399: ,p_name => 'FORWARD_FROM_PERSON_ID') then
400: -- set the attribute value to null

Line 407: if hr_workflow_utility.item_attribute_exists

403: aname => 'FORWARD_FROM_PERSON_ID',
404: avalue=>null);
405: end if;
406: -- FORWARD_TO_DISPLAY_NAME
407: if hr_workflow_utility.item_attribute_exists
408: (p_item_type => p_item_type
409: ,p_item_key => p_item_key
410: ,p_name => 'FORWARD_TO_DISPLAY_NAME') then
411: -- set the attribute value to null

Line 418: if hr_workflow_utility.item_attribute_exists

414: aname => 'FORWARD_TO_DISPLAY_NAME',
415: avalue=>null);
416: end if;
417: -- FORWARD_TO_USERNAME
418: if hr_workflow_utility.item_attribute_exists
419: (p_item_type => p_item_type
420: ,p_item_key => p_item_key
421: ,p_name => 'FORWARD_TO_USERNAME') then
422: -- set the attribute value to null

Line 429: if hr_workflow_utility.item_attribute_exists

425: aname => 'FORWARD_TO_USERNAME',
426: avalue=>null);
427: end if;
428: -- FORWARD_TO_PERSON_ID
429: if hr_workflow_utility.item_attribute_exists
430: (p_item_type => p_item_type
431: ,p_item_key => p_item_key
432: ,p_name => 'FORWARD_TO_PERSON_ID') then
433: -- set the attribute value to null

Line 465: if hr_workflow_utility.item_attribute_exists

461: aname => 'HR_AME_TRAN_TYPE_ATTR') IS NOT NULL) THEN
462: -- CURRENT_APPROVER_INDEX
463: hr_utility.trace('In ( IF ( NVL(l_approvalProcessversion,X) <> V5 OR
464: wf_engine.GetItemAttrText(..,..,..,)IS NOT NULL '|| l_proc);
465: if hr_workflow_utility.item_attribute_exists
466: (p_item_type => p_item_type
467: ,p_item_key => p_item_key
468: ,p_name => 'CURRENT_APPROVER_INDEX') then
469: -- set the attribute value to null

Line 477: if hr_workflow_utility.item_attribute_exists

473: avalue=>null);
474: end if;
475:
476: -- 'LAST_DEFAULT_APPROVER'
477: if hr_workflow_utility.item_attribute_exists
478: (p_item_type => p_item_type
479: ,p_item_key => p_item_key
480: ,p_name => 'LAST_DEFAULT_APPROVER') then
481: -- set the attribute value to null

Line 490: if hr_workflow_utility.item_attribute_exists

486: end if;
487: END IF;
488:
489: -- CURRENT_DEF_APPR_INDEX
490: if hr_workflow_utility.item_attribute_exists
491: (p_item_type => p_item_type
492: ,p_item_key => p_item_key
493: ,p_name => 'CURRENT_DEF_APPR_INDEX') then
494: -- set the attribute value to null

Line 1005: if hr_workflow_utility.item_attribute_exists

1001: if funmode = 'RUN' then
1002: hr_utility.trace('In (if funmode = RUN) '|| l_proc);
1003: savepoint start_transaction;
1004: -- check to see if the TRANSACTION_ID attribute has been created
1005: if hr_workflow_utility.item_attribute_exists
1006: (p_item_type => itemtype
1007: ,p_item_key => itemkey
1008: ,p_name => 'TRANSACTION_ID') then
1009: hr_utility.trace('In (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

Line 1009: hr_utility.trace('In (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

1005: if hr_workflow_utility.item_attribute_exists
1006: (p_item_type => itemtype
1007: ,p_item_key => itemkey
1008: ,p_name => 'TRANSACTION_ID') then
1009: hr_utility.trace('In (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
1010: -- the TRANSACTION_ID exists so ensure that it is null
1011: if get_transaction_id
1012: (p_item_type => itemtype
1013: ,p_item_key => itemkey) is not null then

Line 1022: hr_utility.trace('In else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

1018: hr_utility.set_location('Leaving: '|| l_proc,25);
1019: return;
1020: end if;
1021: else
1022: hr_utility.trace('In else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
1023: -- the TRANSACTION_ID does not exist so create it
1024: wf_engine.additemattr
1025: (itemtype => itemtype
1026: ,itemkey => itemkey

Line 1030: if not hr_workflow_utility.item_attribute_exists

1026: ,itemkey => itemkey
1027: ,aname => 'TRANSACTION_ID');
1028: end if;
1029: -- check to see if the TRANSACTION_PRIVILEGE attribute has been created
1030: if not hr_workflow_utility.item_attribute_exists
1031: (p_item_type => itemtype
1032: ,p_item_key => itemkey
1033: ,p_name => 'TRANSACTION_PRIVILEGE') then
1034: -- the TRANSACTION_PRIVILEGE does not exist so create it

Line 1968: hr_workflow_utility.workflow_transition

1964: (p_item_type => p_item_type
1965: ,p_item_key => p_item_key
1966: ,p_ignore_warnings => 'Y');
1967: -- Complete the activity with SUCCESS
1968: hr_workflow_utility.workflow_transition
1969: (p_item_type => p_item_type
1970: ,p_item_key => p_item_key
1971: ,p_actid => p_actid
1972: ,p_result => 'SUCCESS');