DBA Data[Home] [Help]

APPS.OTA_ADD_TRAINING_SS dependencies on WF_ENGINE

Line 419: l_review_item_name := wf_engine.GetActivityAttrText(itemtype => p_item_type,

415: l_transaction_table(l_count).param_name := 'P_ORG_ID';
416: l_transaction_table(l_count).param_value := p_org_id;
417: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
418:
419: l_review_item_name := wf_engine.GetActivityAttrText(itemtype => p_item_type,
420: itemkey => p_item_key,
421: actid => p_activity_id,
422: aname => gv_wf_review_region_item);
423:

Line 479: WF_ENGINE.setitemattrnumber(p_item_type,

475: (p_item_type => p_item_type
476: ,p_item_key => p_item_key
477: ,p_name => 'OTA_TRANSACTION_STEP_ID');
478:
479: WF_ENGINE.setitemattrnumber(p_item_type,
480: p_item_key,
481: 'OTA_TRANSACTION_STEP_ID',
482: l_transaction_step_id);
483: -- bug 4146681

Line 485: WF_ENGINE.setitemattrtext(p_item_type,

481: 'OTA_TRANSACTION_STEP_ID',
482: l_transaction_step_id);
483: -- bug 4146681
484: If p_from='REVIEW' Then
485: WF_ENGINE.setitemattrtext(p_item_type,
486: p_item_key,
487: 'HR_RESTRICT_EDIT_ATTR',
488: 'Y');
489: end if;

Line 990: l_tran_submitted := wf_engine.GetItemAttrtext(itemtype => l_item_type

986: ,p_item_key => l_item_key
987: ,p_activity_id => l_activity_id);
988:
989:
990: l_tran_submitted := wf_engine.GetItemAttrtext(itemtype => l_item_type
991: ,itemkey => l_item_key
992: ,aname => 'TRAN_SUBMIT');
993:
994: If (l_from = 'REVIEW') Then

Line 1462: l_approval_reg_flag := wf_engine.GetActivityAttrText(itemtype => l_item_type

1458: (p_transaction_step_id => p_transaction_step_id
1459: ,p_name => 'P_ORG_ID');
1460:
1461:
1462: l_approval_reg_flag := wf_engine.GetActivityAttrText(itemtype => l_item_type
1463: ,itemkey => l_item_key
1464: ,actid => l_activity_id
1465: ,aname => 'HR_APPROVAL_REQ_FLAG');
1466:

Line 1586: /*WF_ENGINE.setitemattrtext(p_item_type,

1582:
1583: p_message := 'S';
1584:
1585: --set workflow attributes for notification
1586: /*WF_ENGINE.setitemattrtext(p_item_type,
1587: p_item_key,
1588: 'PROCESS_DISPLAY_NAME',
1589: 'External Training '); */
1590:

Line 1591: WF_ENGINE.setitemattrtext(p_item_type,

1587: p_item_key,
1588: 'PROCESS_DISPLAY_NAME',
1589: 'External Training '); */
1590:
1591: WF_ENGINE.setitemattrtext(p_item_type,
1592: p_item_key,
1593: 'OTA_EVENT_TITLE',
1594: p_trng_title);
1595:

Line 1754: WF_ENGINE.setitemattrtext(p_item_type,

1750: (p_item_type => p_item_type
1751: ,p_item_key => p_item_key
1752: ,p_name => 'OTA_TRANSACTION_MODE');
1753:
1754: WF_ENGINE.setitemattrtext(p_item_type,
1755: p_item_key,
1756: 'OTA_TRANSACTION_MODE',
1757: 'INSERT');
1758:

Line 1759: /* WF_ENGINE.setitemattrtext(p_item_type,

1755: p_item_key,
1756: 'OTA_TRANSACTION_MODE',
1757: 'INSERT');
1758:
1759: /* WF_ENGINE.setitemattrtext(p_item_type,
1760: p_item_key,
1761: 'PROCESS_DISPLAY_NAME',
1762: 'External Training '); */
1763:

Line 1765: WF_ENGINE.setitemattrtext(p_item_type,

1761: 'PROCESS_DISPLAY_NAME',
1762: 'External Training '); */
1763:
1764: --bug 3593080
1765: WF_ENGINE.setitemattrtext(p_item_type,
1766: p_item_key,
1767: 'CURRENT_PERSON_DISPLAY_NAME',
1768: l_learner_name);
1769: --bug 3593080

Line 1771: WF_ENGINE.setitemattrtext(p_item_type,

1767: 'CURRENT_PERSON_DISPLAY_NAME',
1768: l_learner_name);
1769: --bug 3593080
1770:
1771: WF_ENGINE.setitemattrtext(p_item_type,
1772: p_item_key,
1773: 'OTA_EVENT_TITLE',
1774: p_trng_title);
1775:

Line 1776: WF_ENGINE.setitemattrtext(p_item_type,

1772: p_item_key,
1773: 'OTA_EVENT_TITLE',
1774: p_trng_title);
1775:
1776: WF_ENGINE.setitemattrtext(p_item_type,
1777: p_item_key,
1778: 'OTA_COURSE_END_DATE',
1779: p_completion_date);
1780:

Line 1958: WF_ENGINE.setitemattrtext(p_item_type,

1954: (p_item_type => p_item_type
1955: ,p_item_key => p_item_key
1956: ,p_name => 'OTA_TRANSACTION_MODE');
1957:
1958: WF_ENGINE.setitemattrtext(p_item_type,
1959: p_item_key,
1960: 'OTA_TRANSACTION_MODE',
1961: 'UPDATE');
1962:

Line 1963: /*WF_ENGINE.setitemattrtext(p_item_type,

1959: p_item_key,
1960: 'OTA_TRANSACTION_MODE',
1961: 'UPDATE');
1962:
1963: /*WF_ENGINE.setitemattrtext(p_item_type,
1964: p_item_key,
1965: 'PROCESS_DISPLAY_NAME',
1966: 'External Training '); */
1967:

Line 1969: WF_ENGINE.setitemattrtext(p_item_type,

1965: 'PROCESS_DISPLAY_NAME',
1966: 'External Training '); */
1967:
1968: --bug 3593080
1969: WF_ENGINE.setitemattrtext(p_item_type,
1970: p_item_key,
1971: 'CURRENT_PERSON_DISPLAY_NAME',
1972: l_learner_name);
1973: --bug 3593080

Line 1974: WF_ENGINE.setitemattrtext(p_item_type,

1970: p_item_key,
1971: 'CURRENT_PERSON_DISPLAY_NAME',
1972: l_learner_name);
1973: --bug 3593080
1974: WF_ENGINE.setitemattrtext(p_item_type,
1975: p_item_key,
1976: 'OTA_EVENT_TITLE',
1977: p_trng_title);
1978:

Line 1979: WF_ENGINE.setitemattrtext(p_item_type,

1975: p_item_key,
1976: 'OTA_EVENT_TITLE',
1977: p_trng_title);
1978:
1979: WF_ENGINE.setitemattrtext(p_item_type,
1980: p_item_key,
1981: 'OTA_COURSE_END_DATE',
1982: p_completion_date);
1983:

Line 2047: l_transaction_mode := wf_engine.GetItemAttrText(itemtype => itemtype

2043: l_transaction_mode VARCHAR2(10);
2044:
2045: BEGIN
2046:
2047: l_transaction_mode := wf_engine.GetItemAttrText(itemtype => itemtype
2048: ,itemkey => itemkey
2049: ,aname => 'OTA_TRANSACTION_MODE');
2050:
2051: IF (funcmode='RUN') THEN

Line 2071: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type

2067: l_transaction_step_id number;
2068:
2069: Begin
2070:
2071: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
2072: ,itemkey => p_item_key
2073: ,aname => 'OTA_TRANSACTION_STEP_ID');
2074: process_api(true,l_transaction_step_id);
2075: