eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on WF_ENGINE

Line 510: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

506: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
507:
508:
509: -- get AME related WF attribute values
510: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
511: itemkey => p_item_key,
512: aname => 'HR_AME_APP_ID_ATTR');
513:
514: c_application_id := nvl(c_application_id,800);

Line 517: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

513:
514: c_application_id := nvl(c_application_id,800);
515:
516:
517: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
518: itemkey => p_item_key,
519: aname => 'TRANSACTION_ID');
520:
521:

Line 523: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

519: aname => 'TRANSACTION_ID');
520:
521:
522:
523: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
524: itemkey => p_item_key,
525: aname => 'HR_AME_TRAN_TYPE_ATTR');
526:
527: hr_utility.trace('Going into (FOR I IN 1..p_approver_name.count LOOP): '|| l_proc);

Line 656: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

652: gv_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
653:
654: -- check if we need to call AME
655: -- get the AME transaction type value from WF item attributes
656: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
657: itemkey => p_item_key,
658: aname => 'HR_AME_TRAN_TYPE_ATTR');
659:
660:

Line 685: wf_engine.SetItemAttrText

681: IF csr_wiav%notfound then
682: null;
683: ELSE
684: -- set the item attribute text value to DELETED
685: wf_engine.SetItemAttrText
686: (itemtype => p_item_type,
687: itemkey => p_item_key,
688: aname => lv_item_name,
689: avalue => 'DELETED');

Line 727: wf_engine.SetItemAttrNumber

723: hr_approval_wf.create_item_attrib_if_notexist
724: (p_item_type => p_item_type,
725: p_item_key => p_item_key,
726: p_name => lv_item_name);
727: wf_engine.SetItemAttrNumber
728: (itemtype => p_item_type,
729: itemkey => p_item_key,
730: aname => lv_item_name,
731: avalue => ln_person_id);

Line 732: wf_engine.SetItemAttrText

728: (itemtype => p_item_type,
729: itemkey => p_item_key,
730: aname => lv_item_name,
731: avalue => ln_person_id);
732: wf_engine.SetItemAttrText
733: (itemtype => p_item_type,
734: itemkey => p_item_key,
735: aname => lv_item_name,
736: avalue => 'VALID');

Line 738: wf_engine.SetItemAttrNumber

734: itemkey => p_item_key,
735: aname => lv_item_name,
736: avalue => 'VALID');
737: ELSE
738: wf_engine.SetItemAttrNumber
739: (itemtype => p_item_type,
740: itemkey => p_item_key,
741: aname => lv_item_name,
742: avalue => ln_person_id);

Line 743: wf_engine.SetItemAttrText

739: (itemtype => p_item_type,
740: itemkey => p_item_key,
741: aname => lv_item_name,
742: avalue => ln_person_id);
743: wf_engine.SetItemAttrText
744: (itemtype => p_item_type,
745: itemkey => p_item_key,
746: aname => lv_item_name,
747: avalue => 'VALID');

Line 769: wf_engine.SetItemAttrNumber

765: (p_item_type => p_item_type
766: ,p_item_key => p_item_key
767: ,p_name => 'ADDITIONAL_APPROVERS_NUMBER');
768:
769: wf_engine.SetItemAttrNumber
770: (itemtype => p_item_type,
771: itemkey => p_item_key,
772: aname => 'ADDITIONAL_APPROVERS_NUMBER',
773: avalue => ln_addntl_approvers );

Line 775: wf_engine.SetItemAttrNumber

771: itemkey => p_item_key,
772: aname => 'ADDITIONAL_APPROVERS_NUMBER',
773: avalue => ln_addntl_approvers );
774: ELSE
775: wf_engine.SetItemAttrNumber
776: (itemtype => p_item_type,
777: itemkey => p_item_key,
778: aname => 'ADDITIONAL_APPROVERS_NUMBER',
779: avalue => ln_addntl_approvers );

Line 815: wf_engine.SetItemAttrNumber

811: hr_approval_wf.create_item_attrib_if_notexist
812: (p_item_type => p_item_type,
813: p_item_key => p_item_key,
814: p_name => lv_item_name);
815: wf_engine.SetItemAttrNumber
816: (itemtype => p_item_type,
817: itemkey => p_item_key,
818: aname => lv_item_name,
819: avalue => ln_person_id);

Line 822: wf_engine.SetItemAttrNumber

818: aname => lv_item_name,
819: avalue => ln_person_id);
820:
821: ELSE
822: wf_engine.SetItemAttrNumber
823: (itemtype => p_item_type,
824: itemkey => p_item_key,
825: aname => lv_item_name,
826: avalue => ln_person_id);

Line 864: wf_engine.SetItemAttrText

860: hr_utility.trace('Out of ( FOR K IN 1..p_notify_onapproval_flag.count): '|| l_proc);
861: lv_notify:= lv_notify||lv_exists;
862:
863: -- set the notification flag for this notifier
864: wf_engine.SetItemAttrText
865: (itemtype => p_item_type,
866: itemkey => p_item_key,
867: aname => lv_item_name,
868: avalue => lv_notify);

Line 886: wf_engine.SetItemAttrNumber

882: (p_item_type => p_item_type
883: ,p_item_key => p_item_key
884: ,p_name => 'NOTIFIERS_NUMBER');
885:
886: wf_engine.SetItemAttrNumber
887: (itemtype => p_item_type,
888: itemkey => p_item_key,
889: aname => 'NOTIFIERS_NUMBER',
890: avalue => ln_notifiers );

Line 892: wf_engine.SetItemAttrNumber

888: itemkey => p_item_key,
889: aname => 'NOTIFIERS_NUMBER',
890: avalue => ln_notifiers );
891: ELSE
892: wf_engine.SetItemAttrNumber
893: (itemtype => p_item_type,
894: itemkey => p_item_key,
895: aname => 'NOTIFIERS_NUMBER',
896: avalue => ln_notifiers );

Line 911: wf_engine.SetItemAttrText

907: (p_item_type => p_item_type
908: ,p_item_key => p_item_key
909: ,p_name => 'APPROVAL_ENTRY_MODE');
910:
911: wf_engine.SetItemAttrText
912: (itemtype => p_item_type,
913: itemkey => p_item_key,
914: aname => 'APPROVAL_ENTRY_MODE',
915: avalue => 'RE-ENTER');

Line 917: wf_engine.SetItemAttrText

913: itemkey => p_item_key,
914: aname => 'APPROVAL_ENTRY_MODE',
915: avalue => 'RE-ENTER');
916: ELSE
917: wf_engine.SetItemAttrText
918: (itemtype => p_item_type,
919: itemkey => p_item_key,
920: aname => 'APPROVAL_ENTRY_MODE',
921: avalue => 'RE-ENTER');

Line 940: wf_engine.SetItemAttrNumber

936: (p_item_type => p_item_type
937: ,p_item_key => p_item_key
938: ,p_name => 'LAST_DEFAULT_APPROVER');
939:
940: wf_engine.SetItemAttrNumber
941: (itemtype => p_item_type,
942: itemkey => p_item_key,
943: aname => 'LAST_DEFAULT_APPROVER',
944: avalue => NULL);

Line 946: wf_engine.SetItemAttrNumber

942: itemkey => p_item_key,
943: aname => 'LAST_DEFAULT_APPROVER',
944: avalue => NULL);
945: ELSE
946: wf_engine.SetItemAttrNumber
947: (itemtype => p_item_type,
948: itemkey => p_item_key,
949: aname => 'LAST_DEFAULT_APPROVER',
950: avalue => NULL);

Line 963: wf_engine.GetActivityAttrNumber(

959: IF csr_wfaav%notfound THEN
960: ln_approval_level :=NULL;
961: ELSE
962: ln_approval_level :=
963: wf_engine.GetActivityAttrNumber(
964: itemtype => p_item_type,
965: itemkey => p_item_key,
966: actid => p_act_id,
967: aname => 'HR_DYNA_APPR_LEVEL_ATR');

Line 986: wf_engine.SetItemAttrNumber

982: END IF;
983: CLOSE csr_wiav;
984: -- set the process level approval level
985: IF ln_approval_level IS NOT NULL THEN
986: wf_engine.SetItemAttrNumber
987: (itemtype => p_item_type,
988: itemkey => p_item_key,
989: aname => 'APPROVAL_LEVEL',
990: avalue => ln_approval_level);

Line 1005: wf_engine.SetItemAttrNumber

1001: (p_item_type => p_item_type
1002: ,p_item_key => p_item_key
1003: ,p_name => 'CURRENT_DEF_APPR_INDEX');
1004:
1005: wf_engine.SetItemAttrNumber
1006: (itemtype => p_item_type,
1007: itemkey => p_item_key,
1008: aname => 'CURRENT_DEF_APPR_INDEX',
1009: avalue => 0);

Line 1011: wf_engine.SetItemAttrNumber

1007: itemkey => p_item_key,
1008: aname => 'CURRENT_DEF_APPR_INDEX',
1009: avalue => 0);
1010: ELSE
1011: wf_engine.SetItemAttrNumber
1012: (itemtype => p_item_type,
1013: itemkey => p_item_key,
1014: aname => 'CURRENT_DEF_APPR_INDEX',
1015: avalue => 0);

Line 1033: wf_engine.SetItemAttrNumber

1029: (p_item_type => p_item_type
1030: ,p_item_key => p_item_key
1031: ,p_name => 'CURRENT_APPROVER_INDEX');
1032:
1033: wf_engine.SetItemAttrNumber
1034: (itemtype => p_item_type,
1035: itemkey => p_item_key,
1036: aname => 'CURRENT_APPROVER_INDEX',
1037: avalue => 0);

Line 1039: wf_engine.SetItemAttrNumber

1035: itemkey => p_item_key,
1036: aname => 'CURRENT_APPROVER_INDEX',
1037: avalue => 0);
1038: ELSE
1039: wf_engine.SetItemAttrNumber
1040: (itemtype => p_item_type,
1041: itemkey => p_item_key,
1042: aname => 'CURRENT_APPROVER_INDEX',
1043: avalue => 0);

Line 1058: wf_engine.SetItemAttrNumber

1054: (p_item_type => p_item_type
1055: ,p_item_key => p_item_key
1056: ,p_name => 'CURRENT_ONSUBMIT_INDEX');
1057:
1058: wf_engine.SetItemAttrNumber
1059: (itemtype => p_item_type,
1060: itemkey => p_item_key,
1061: aname => 'CURRENT_ONSUBMIT_INDEX',
1062: avalue => 0);

Line 1064: wf_engine.SetItemAttrNumber

1060: itemkey => p_item_key,
1061: aname => 'CURRENT_ONSUBMIT_INDEX',
1062: avalue => 0);
1063: ELSE
1064: wf_engine.SetItemAttrNumber
1065: (itemtype => p_item_type,
1066: itemkey => p_item_key,
1067: aname => 'CURRENT_ONSUBMIT_INDEX',
1068: avalue => 0);

Line 1083: wf_engine.SetItemAttrNumber

1079: (p_item_type => p_item_type
1080: ,p_item_key => p_item_key
1081: ,p_name => 'CURRENT_ONAPPROVAL_INDEX');
1082:
1083: wf_engine.SetItemAttrNumber
1084: (itemtype => p_item_type,
1085: itemkey => p_item_key,
1086: aname => 'CURRENT_ONAPPROVAL_INDEX',
1087: avalue => 0);

Line 1089: wf_engine.SetItemAttrNumber

1085: itemkey => p_item_key,
1086: aname => 'CURRENT_ONAPPROVAL_INDEX',
1087: avalue => 0);
1088: ELSE
1089: wf_engine.SetItemAttrNumber
1090: (itemtype => p_item_type,
1091: itemkey => p_item_key,
1092: aname => 'CURRENT_ONAPPROVAL_INDEX',
1093: avalue => 0);

Line 1166: gv_effective_date := wf_engine.getItemAttrText(

1162: -- get session language code
1163: gv_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1164:
1165: -- get effective date from Workflow Item Attribute
1166: gv_effective_date := wf_engine.getItemAttrText(
1167: itemtype => p_item_type,
1168: itemkey => p_item_key,
1169: aname => 'CURRENT_EFFECTIVE_DATE');
1170:

Line 1344: gv_effective_date := wf_engine.getItemAttrText(

1340: -- get session language code
1341: gv_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1342:
1343: -- get effective date from Workflow Item Attribute
1344: gv_effective_date := wf_engine.getItemAttrText(
1345: itemtype => p_item_type,
1346: itemkey => p_item_key,
1347: aname => 'CURRENT_EFFECTIVE_DATE');
1348:

Line 1495: -- need to invesitgate further and debug. Making a direct call to wf_engine

1491: p_web_page_section_code => ln_approval_level
1492: );
1493: END IF;
1494: -- The hr_mee_workflow_service.get_web_page_code is not returning values
1495: -- need to invesitgate further and debug. Making a direct call to wf_engine
1496: -- package.
1497: -- check if the acitvity attribute for approval level exists
1498: OPEN csr_wfaav(ln_approval_level,p_actid );
1499: hr_utility.trace('Going into Fetch after ( OPEN csr_wfaav(ln_approval_level,p_actid ) ): '|| l_proc);

Line 1505: wf_engine.GetActivityAttrNumber(

1501: IF csr_wfaav%notfound THEN
1502: grt_wf_attributes_rec.approval_level :=NULL;
1503: ELSE
1504: grt_wf_attributes_rec.approval_level :=
1505: wf_engine.GetActivityAttrNumber(
1506: itemtype => p_item_type,
1507: itemkey => p_item_key,
1508: actid => p_actid,
1509: aname => ln_approval_level);

Line 1580: gn_person_id := wf_engine.GetItemAttrNumber

1576:
1577: BEGIN
1578: hr_utility.set_location('Entering: '|| l_proc,5);
1579:
1580: gn_person_id := wf_engine.GetItemAttrNumber
1581: (itemtype => p_item_type
1582: ,itemkey => p_item_key
1583: ,aname => 'CREATOR_PERSON_ID');
1584:

Line 1587: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

1583: ,aname => 'CREATOR_PERSON_ID');
1584:
1585: -- Get AME related data from WF attributes
1586: -- get the AME transaction type and app id
1587: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1588: itemkey => p_item_key,
1589: aname => 'HR_AME_APP_ID_ATTR');
1590:
1591:

Line 1594: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

1590:
1591:
1592: c_application_id := nvl(c_application_id,800);
1593:
1594: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1595: itemkey => p_item_key,
1596: aname => 'TRANSACTION_ID');
1597:
1598:

Line 1600: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

1596: aname => 'TRANSACTION_ID');
1597:
1598:
1599:
1600: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1601: itemkey => p_item_key,
1602: aname => 'HR_AME_TRAN_TYPE_ATTR');
1603:
1604:

Line 1720: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

1716: hr_utility.trace('In (IF gv_mode=RE-ENTER): '|| l_proc);
1717:
1718: -- Get AME related data from WF attributes
1719: -- get the AME transaction type and app id
1720: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1721: itemkey => p_item_key,
1722: aname => 'HR_AME_APP_ID_ATTR');
1723:
1724:

Line 1727: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

1723:
1724:
1725: c_application_id := nvl(c_application_id,800);
1726:
1727: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1728: itemkey => p_item_key,
1729: aname => 'TRANSACTION_ID');
1730:
1731:

Line 1733: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

1729: aname => 'TRANSACTION_ID');
1730:
1731:
1732:
1733: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1734: itemkey => p_item_key,
1735: aname => 'HR_AME_TRAN_TYPE_ATTR');
1736:
1737:

Line 2049: gn_person_id := wf_engine.GetItemAttrNumber

2045: -- validate the session
2046: -- ******************************************************************************
2047: -- commented out for v 4 by pzwalker - replaced with GetItemAttrNumber call
2048: -- hr_util_misc_web.validate_session(p_person_id => gn_person_id);
2049: gn_person_id := wf_engine.GetItemAttrNumber
2050: (itemtype => p_item_type
2051: ,itemkey => p_item_key
2052: ,aname => 'CREATOR_PERSON_ID');
2053:

Line 2057: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

2053:
2054:
2055: -- Get AME related data from WF attributes
2056: -- get the AME transaction type and app id
2057: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2058: itemkey => p_item_key,
2059: aname => 'HR_AME_APP_ID_ATTR');
2060:
2061:

Line 2064: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

2060:
2061:
2062: c_application_id := nvl(c_application_id,800);
2063:
2064: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2065: itemkey => p_item_key,
2066: aname => 'TRANSACTION_ID');
2067:
2068:

Line 2070: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

2066: aname => 'TRANSACTION_ID');
2067:
2068:
2069:
2070: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2071: itemkey => p_item_key,
2072: aname => 'HR_AME_TRAN_TYPE_ATTR');
2073:
2074:

Line 2087: ln_approval_level:= wf_engine.GetItemAttrNumber

2083:
2084: end if;
2085:
2086: -- bug # 1964924
2087: ln_approval_level:= wf_engine.GetItemAttrNumber
2088: (itemtype => p_item_type
2089: ,itemkey => p_item_key
2090: ,aname => 'APPROVAL_LEVEL');
2091:

Line 2261: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

2257: IF gv_mode='RE-ENTER' THEN
2258: hr_utility.trace('In (IF gv_mode=RE-ENTER): '|| l_proc);
2259: -- check if we need to call AME
2260: -- get the AME transaction type value from WF item attributes
2261: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2262: itemkey => p_item_key,
2263: aname => 'HR_AME_TRAN_TYPE_ATTR');
2264:
2265:

Line 2294: ln_num_of_add_apprs := wf_engine.GetItemAttrNumber

2290: (p_item_type => p_item_type
2291: ,p_item_key => p_item_key
2292: ,p_name => 'ADDITIONAL_APPROVERS_NUMBER') then
2293: -- get the attribute value
2294: ln_num_of_add_apprs := wf_engine.GetItemAttrNumber
2295: (itemtype => p_item_type,
2296: itemkey => p_item_key,
2297: aname => 'ADDITIONAL_APPROVERS_NUMBER');
2298:

Line 2300: wf_engine.additemattr

2296: itemkey => p_item_key,
2297: aname => 'ADDITIONAL_APPROVERS_NUMBER');
2298:
2299: else
2300: wf_engine.additemattr
2301: (itemtype => p_item_type
2302: ,itemkey => p_item_key
2303: ,aname => 'ADDITIONAL_APPROVERS_NUMBER');
2304:

Line 2305: wf_engine.SetItemAttrNumber (itemtype => p_item_type,

2301: (itemtype => p_item_type
2302: ,itemkey => p_item_key
2303: ,aname => 'ADDITIONAL_APPROVERS_NUMBER');
2304:
2305: wf_engine.SetItemAttrNumber (itemtype => p_item_type,
2306: itemkey => p_item_key,
2307: aname => 'ADDITIONAL_APPROVERS_NUMBER',
2308: avalue => 0);
2309: end if;

Line 2328: lv_approver_deleted := wf_engine.GetItemAttrText

2324: lv_default_approver := 'Y';
2325: ELSE
2326: lv_default_approver := 'N';
2327: -- check if this additional index has been removed by the user
2328: lv_approver_deleted := wf_engine.GetItemAttrText
2329: (itemtype => p_item_type,
2330: itemkey => p_item_key,
2331: aname => lv_item_name);
2332: lv_approver_deleted := NVL(lv_approver_deleted,' ');

Line 2348: ln_person_id := wf_engine.GetItemAttrNumber

2344: grt_approver_details_table(I).job_title := gv_error_table(ln_error_count).job_title;
2345: grt_approver_details_table(I).error_exists:= gv_error_table(ln_error_count).error_exists;
2346: ln_error_count := ln_error_count + 1;
2347: ELSE
2348: ln_person_id := wf_engine.GetItemAttrNumber
2349: (itemtype => p_item_type,
2350: itemkey => p_item_key,
2351: aname => lv_item_name);
2352:

Line 2688: wf_engine.GetItemAttrNumber(itemtype => p_item_type,

2684:
2685: -- get all the additional approvers
2686: -- get number of additional approvers
2687: gn_additional_approvers :=
2688: wf_engine.GetItemAttrNumber(itemtype => p_item_type,
2689: itemkey => p_item_key,
2690: aname => 'ADDITIONAL_APPROVERS_NUMBER');
2691:
2692:

Line 2719: lv_valid_approver := wf_engine.GetItemAttrText

2715: -- Find the last approver , get his ID and update the flag to DELETED
2716:
2717: IF ln_curr_add_appr_index=1 AND lv_exist = 'Y' THEN
2718: -- get the status of this approver index
2719: lv_valid_approver := wf_engine.GetItemAttrText
2720: (itemtype => p_item_type,
2721: itemkey => p_item_key,
2722: aname => lv_item_name);
2723:

Line 2726: ln_from_index_id := wf_engine.GetItemAttrNumber

2722: aname => lv_item_name);
2723:
2724: IF lv_valid_approver<>'DELETED' THEN
2725: -- get the person_id for this index
2726: ln_from_index_id := wf_engine.GetItemAttrNumber
2727: (itemtype => p_item_type,
2728: itemkey => p_item_key,
2729: aname => lv_item_name);
2730:

Line 2732: wf_engine.SetItemAttrNumber

2728: itemkey => p_item_key,
2729: aname => lv_item_name);
2730:
2731: -- set the flag to DELETED and person_id to NULL
2732: wf_engine.SetItemAttrNumber
2733: (itemtype => p_item_type,
2734: itemkey => p_item_key,
2735: aname => lv_item_name,
2736: avalue => NULL);

Line 2737: wf_engine.SetItemAttrText

2733: (itemtype => p_item_type,
2734: itemkey => p_item_key,
2735: aname => lv_item_name,
2736: avalue => NULL);
2737: wf_engine.SetItemAttrText
2738: (itemtype => p_item_type,
2739: itemkey => p_item_key,
2740: aname => lv_item_name,
2741: avalue => 'DELETED');

Line 2750: ln_from_index_id := wf_engine.GetItemAttrNumber

2746: ln_curr_add_appr_index := 0;
2747: END IF;
2748: ELSIF ln_curr_add_appr_index>1 AND lv_exist = 'Y' THEN
2749: -- get the person_id for this index
2750: ln_from_index_id := wf_engine.GetItemAttrNumber
2751: (itemtype => p_item_type,
2752: itemkey => p_item_key,
2753: aname => lv_item_name);
2754: -- reset it with the new value

Line 2755: wf_engine.SetItemAttrNumber

2751: (itemtype => p_item_type,
2752: itemkey => p_item_key,
2753: aname => lv_item_name);
2754: -- reset it with the new value
2755: wf_engine.SetItemAttrNumber
2756: (itemtype => p_item_type,
2757: itemkey => p_item_key,
2758: aname => lv_item_name,
2759: avalue => ln_to_index_id);

Line 2768: wf_engine.SetItemAttrNumber

2764: END LOOP;
2765:
2766: -- reset the index for the number of additional approvers
2767: gn_additional_approvers := (gn_additional_approvers -1);
2768: wf_engine.SetItemAttrNumber
2769: (itemtype => p_item_type,
2770: itemkey => p_item_key,
2771: aname => 'ADDITIONAL_APPROVERS_NUMBER',
2772: avalue => gn_additional_approvers);

Line 2798: wf_engine.SetItemAttrNumber

2794: end if;
2795:
2796: END LOOP;
2797: hr_utility.trace('Out of ( FOR I IN 1..p_approver_name.count): '|| l_proc);
2798: wf_engine.SetItemAttrNumber
2799: (itemtype => p_item_type,
2800: itemkey => p_item_key,
2801: aname => 'ADDITIONAL_APPROVERS_NUMBER',
2802: avalue => gn_additional_approvers);

Line 3062: wf_engine.GetItemAttrNumber(itemtype => p_item_type,

3058: IF csr_wiav%notfound THEN
3059: gn_notifiers := 0;
3060: ELSE
3061: gn_notifiers :=
3062: wf_engine.GetItemAttrNumber(itemtype => p_item_type,
3063: itemkey => p_item_key,
3064: aname => 'NOTIFIERS_NUMBER');
3065: END IF;
3066: CLOSE csr_wiav;

Line 3083: ln_person_id:= wf_engine.GetItemAttrNumber

3079: IF csr_wiav%notfound THEN
3080: lv_exist := 'N';
3081: ELSE
3082: lv_exist := 'Y';
3083: ln_person_id:= wf_engine.GetItemAttrNumber
3084: (itemtype => p_item_type,
3085: itemkey => p_item_key,
3086: aname => lv_item_name
3087: );

Line 3088: lv_notify := wf_engine.GetItemAttrText

3084: (itemtype => p_item_type,
3085: itemkey => p_item_key,
3086: aname => lv_item_name
3087: );
3088: lv_notify := wf_engine.GetItemAttrText
3089: (itemtype => p_item_type,
3090: itemkey => p_item_key,
3091: aname => lv_item_name
3092: );

Line 3290: wf_engine.SetItemAttrText

3286: FETCH csr_wiav into l_dummy;
3287: IF csr_wiav%notfound THEN
3288: NULL;
3289: ELSE
3290: wf_engine.SetItemAttrText
3291: (itemtype => p_item_type,
3292: itemkey => p_item_key,
3293: aname => lv_item_name,
3294: avalue => lv_response

Line 3351: ln_num_of_add_apprs := wf_engine.GetItemAttrNumber

3347: BEGIN
3348: hr_utility.set_location('Entering: '|| l_proc,5);
3349: ln_approver_index := gn_approver_index - 1;
3350: -- get the additional approvers number
3351: ln_num_of_add_apprs := wf_engine.GetItemAttrNumber
3352: (itemtype => p_item_type,
3353: itemkey => p_item_key,
3354: aname => 'ADDITIONAL_APPROVERS_NUMBER');
3355:

Line 3378: lv_approver_deleted := wf_engine.GetItemAttrText

3374: ELSE
3375: lv_default_approver := 'N';
3376: -- check if this additional index has been removed by the user
3377:
3378: lv_approver_deleted := wf_engine.GetItemAttrText
3379: (itemtype => p_item_type,
3380: itemkey => p_item_key,
3381: aname => lv_item_name);
3382: lv_approver_deleted := NVL(lv_approver_deleted,' ');

Line 3390: ln_person_id := wf_engine.GetItemAttrNumber

3386:
3387: -- delete proper record.
3388: IF lv_default_approver <> 'Y' AND lv_approver_deleted <>'DELETED' THEN
3389: -- get the approver ID for this index
3390: ln_person_id := wf_engine.GetItemAttrNumber
3391: (itemtype => p_item_type,
3392: itemkey => p_item_key,
3393: aname => lv_item_name);
3394: IF ln_person_id IS NULL THEN

Line 3480: nvl(wf_engine.GetItemAttrNumber

3476: hr_utility.trace('In (if ( funmode = RUN )):'|| l_proc);
3477:
3478: -- get the current forward from person
3479: l_current_forward_from_id :=
3480: nvl(wf_engine.GetItemAttrNumber
3481: (itemtype => itemtype
3482: ,itemkey => itemkey
3483: ,aname => 'FORWARD_FROM_PERSON_ID'),
3484: wf_engine.GetItemAttrNumber

Line 3484: wf_engine.GetItemAttrNumber

3480: nvl(wf_engine.GetItemAttrNumber
3481: (itemtype => itemtype
3482: ,itemkey => itemkey
3483: ,aname => 'FORWARD_FROM_PERSON_ID'),
3484: wf_engine.GetItemAttrNumber
3485: (itemtype => itemtype
3486: ,itemkey => itemkey
3487: ,aname => 'CREATOR_PERSON_ID'));
3488: -- get the current forward to person

Line 3490: nvl(wf_engine.GetItemAttrNumber

3486: ,itemkey => itemkey
3487: ,aname => 'CREATOR_PERSON_ID'));
3488: -- get the current forward to person
3489: l_current_forward_to_id :=
3490: nvl(wf_engine.GetItemAttrNumber
3491: (itemtype => itemtype
3492: ,itemkey => itemkey
3493: ,aname => 'FORWARD_TO_PERSON_ID'),
3494: wf_engine.GetItemAttrNumber

Line 3494: wf_engine.GetItemAttrNumber

3490: nvl(wf_engine.GetItemAttrNumber
3491: (itemtype => itemtype
3492: ,itemkey => itemkey
3493: ,aname => 'FORWARD_TO_PERSON_ID'),
3494: wf_engine.GetItemAttrNumber
3495: (itemtype => itemtype
3496: ,itemkey => itemkey
3497: ,aname => 'CREATOR_PERSON_ID'));
3498:

Line 3501: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => itemtype ,

3497: ,aname => 'CREATOR_PERSON_ID'));
3498:
3499:
3500: -- get the AME transaction type and app id
3501: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => itemtype ,
3502: itemkey => itemkey,
3503: aname => 'HR_AME_APP_ID_ATTR');
3504:
3505:

Line 3508: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => itemtype ,

3504:
3505:
3506: c_application_id := nvl(c_application_id,800);
3507:
3508: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => itemtype ,
3509: itemkey => itemkey,
3510: aname => 'TRANSACTION_ID');
3511:
3512:

Line 3514: c_transaction_type := wf_engine.GetItemAttrText(itemtype => itemtype ,

3510: aname => 'TRANSACTION_ID');
3511:
3512:
3513:
3514: c_transaction_type := wf_engine.GetItemAttrText(itemtype => itemtype ,
3515: itemkey => itemkey,
3516: aname => 'HR_AME_TRAN_TYPE_ATTR');
3517:
3518:

Line 3536: ln_addntl_approvers := NVL(wf_engine.GetItemAttrNumber

3532: --
3533:
3534:
3535: -- get the total number of additional approvers for this transaction
3536: ln_addntl_approvers := NVL(wf_engine.GetItemAttrNumber
3537: (itemtype => itemtype
3538: ,itemkey => itemkey
3539: ,aname => 'ADDITIONAL_APPROVERS_NUMBER'),
3540: 0);

Line 3555: wf_engine.SetItemAttrNumber

3551: (p_item_type => itemtype
3552: ,p_item_key => itemkey
3553: ,p_name => 'CURRENT_APPROVER_INDEX');
3554:
3555: wf_engine.SetItemAttrNumber
3556: (itemtype => itemtype,
3557: itemkey => itemkey,
3558: aname => 'CURRENT_APPROVER_INDEX',
3559: avalue => NULL);

Line 3569: ln_current_approver_index := NVL(wf_engine.GetItemAttrNumber

3565:
3566:
3567:
3568: -- get the current_approver_index
3569: ln_current_approver_index := NVL(wf_engine.GetItemAttrNumber
3570: (itemtype => itemtype
3571: ,itemkey => itemkey
3572: ,aname => 'CURRENT_APPROVER_INDEX'),
3573: 0);

Line 3589: lv_isvalid := wf_engine.GetItemAttrText

3585: IF csr_wiav%notfound THEN
3586: lv_exists := 'N';
3587: ELSE
3588: lv_exists := 'Y';
3589: lv_isvalid := wf_engine.GetItemAttrText
3590: (itemtype => itemtype,
3591: itemkey => itemkey,
3592: aname => lv_item_name);
3593: lv_isvalid := NVL(lv_isvalid,' ');

Line 3606: wf_engine.GetItemAttrNumber

3602:
3603: IF lv_exists <>'N' AND lv_isvalid <>'DELETED' THEN
3604: hr_utility.trace('In ( IF lv_exists <>N AND lv_isvalid <>DELETED):'|| l_proc);
3605: l_forward_to_person_id :=
3606: wf_engine.GetItemAttrNumber
3607: (itemtype => itemtype,
3608: itemkey => itemkey,
3609: aname => lv_item_name
3610: );

Line 3616: ln_last_default_approver_id := wf_engine.GetItemAttrNumber

3612: ELSE
3613: hr_utility.trace('In else of ( IF lv_exists <>N AND lv_isvalid <>DELETED):'|| l_proc);
3614: -- get the last default approver index
3615:
3616: ln_last_default_approver_id := wf_engine.GetItemAttrNumber
3617: (itemtype => itemtype,
3618: itemkey => itemkey,
3619: aname => 'LAST_DEFAULT_APPROVER');
3620:

Line 3630: wf_engine.GetItemAttrNumber

3626: -- now the from column will show the last approver approved.
3627: l_forward_to_person_id :=
3628: hr_approval_custom.Get_Next_Approver
3629: (p_person_id => NVL(ln_last_default_approver_id,
3630: wf_engine.GetItemAttrNumber
3631: (itemtype => itemtype
3632: ,itemkey => itemkey
3633: ,aname => 'CREATOR_PERSON_ID')));
3634: -- set the last default approver id

Line 3636: wf_engine.SetItemAttrNumber

3632: ,itemkey => itemkey
3633: ,aname => 'CREATOR_PERSON_ID')));
3634: -- set the last default approver id
3635: -- 'LAST_DEFAULT_APPROVER'
3636: wf_engine.SetItemAttrNumber
3637: (itemtype => itemtype,
3638: itemkey => itemkey,
3639: aname => 'LAST_DEFAULT_APPROVER',
3640: avalue => l_forward_to_person_id);

Line 3652: wf_engine.SetItemAttrNumber

3648: (p_item_type => itemtype
3649: ,p_item_key => itemkey
3650: ,p_name => 'CURRENT_DEF_APPR_INDEX');
3651:
3652: wf_engine.SetItemAttrNumber
3653: (itemtype => itemtype,
3654: itemkey => itemkey,
3655: aname => 'CURRENT_DEF_APPR_INDEX',
3656: avalue => 0);

Line 3659: wf_engine.GetItemAttrNumber

3655: aname => 'CURRENT_DEF_APPR_INDEX',
3656: avalue => 0);
3657: ELSE
3658: ln_curr_def_appr_index :=
3659: wf_engine.GetItemAttrNumber
3660: (itemtype => itemtype,
3661: itemkey => itemkey,
3662: aname => 'CURRENT_DEF_APPR_INDEX'
3663: );

Line 3666: wf_engine.SetItemAttrNumber

3662: aname => 'CURRENT_DEF_APPR_INDEX'
3663: );
3664: -- increment it and update the item attribute value
3665: ln_curr_def_appr_index := ln_curr_def_appr_index + 1;
3666: wf_engine.SetItemAttrNumber
3667: (itemtype => itemtype,
3668: itemkey => itemkey,
3669: aname => 'CURRENT_DEF_APPR_INDEX',
3670: avalue => ln_curr_def_appr_index);

Line 3677: wf_engine.SetItemAttrNumber (itemtype => itemtype

3673:
3674: END IF;
3675:
3676: -- set the current_approver_index
3677: wf_engine.SetItemAttrNumber (itemtype => itemtype
3678: ,itemkey => itemkey
3679: ,aname => 'CURRENT_APPROVER_INDEX'
3680: ,avalue => (ln_current_approver_index + 1));
3681:

Line 3706: wf_engine.SetItemAttrNumber

3702: ,p_name => l_forward_to_username
3703: ,p_display_name => l_forward_to_disp_name);
3704:
3705: --
3706: wf_engine.SetItemAttrNumber
3707: (itemtype => itemtype
3708: ,itemkey => itemkey
3709: ,aname => 'FORWARD_TO_PERSON_ID'
3710: ,avalue => l_forward_to_person_id);

Line 3712: wf_engine.SetItemAttrText

3708: ,itemkey => itemkey
3709: ,aname => 'FORWARD_TO_PERSON_ID'
3710: ,avalue => l_forward_to_person_id);
3711: --
3712: wf_engine.SetItemAttrText
3713: (itemtype => itemtype
3714: ,itemkey => itemkey
3715: ,aname => 'FORWARD_TO_USERNAME'
3716: ,avalue => l_forward_to_username);

Line 3718: Wf_engine.SetItemAttrText

3714: ,itemkey => itemkey
3715: ,aname => 'FORWARD_TO_USERNAME'
3716: ,avalue => l_forward_to_username);
3717: --
3718: Wf_engine.SetItemAttrText
3719: (itemtype => itemtype
3720: ,itemkey => itemkey
3721: ,aname => 'FORWARD_TO_DISPLAY_NAME'
3722: ,avalue => l_forward_to_disp_name);

Line 3726: wf_engine.SetItemAttrNumber

3722: ,avalue => l_forward_to_disp_name);
3723: --
3724: -- set forward from to old forward to
3725: --
3726: wf_engine.SetItemAttrNumber
3727: (itemtype => itemtype
3728: ,itemkey => itemkey
3729: ,aname => 'FORWARD_FROM_PERSON_ID'
3730: ,avalue => l_current_forward_to_id);

Line 3741: wf_engine.SetItemAttrText

3737: ,p_orig_system_id => l_current_forward_to_id
3738: ,p_name => l_forward_from_username
3739: ,p_display_name => l_forward_from_disp_name);
3740: --
3741: wf_engine.SetItemAttrText
3742: (itemtype => itemtype
3743: ,itemkey => itemkey
3744: ,aname => 'FORWARD_FROM_USERNAME'
3745: ,avalue => l_forward_from_username);

Line 3747: wf_engine.SetItemAttrText

3743: ,itemkey => itemkey
3744: ,aname => 'FORWARD_FROM_USERNAME'
3745: ,avalue => l_forward_from_username);
3746: --
3747: wf_engine.SetItemAttrText
3748: (itemtype => itemtype
3749: ,itemkey => itemkey
3750: ,aname => 'FORWARD_FROM_DISPLAY_NAME'
3751: ,avalue => l_forward_from_disp_name);

Line 3818: l_creator_person_id := wf_engine.GetItemAttrNumber

3814: if ( funmode = 'RUN' ) then
3815: hr_utility.trace('In(if ( funmode = RUN )): '|| l_proc);
3816: --
3817: --
3818: l_creator_person_id := wf_engine.GetItemAttrNumber
3819: (itemtype => p_item_type
3820: ,itemkey => p_item_key
3821: ,aname => 'CREATOR_PERSON_ID');
3822: --

Line 3823: l_forward_to_person_id := wf_engine.GetItemAttrNumber

3819: (itemtype => p_item_type
3820: ,itemkey => p_item_key
3821: ,aname => 'CREATOR_PERSON_ID');
3822: --
3823: l_forward_to_person_id := wf_engine.GetItemAttrNumber
3824: (itemtype => p_item_type
3825: ,itemkey => p_item_key
3826: ,aname =>'FORWARD_TO_PERSON_ID');
3827:

Line 3830: nvl(wf_engine.GetItemAttrNumber

3826: ,aname =>'FORWARD_TO_PERSON_ID');
3827:
3828: -- get the current forward to person
3829: l_current_forward_to_id :=
3830: nvl(wf_engine.GetItemAttrNumber
3831: (itemtype => p_item_type
3832: ,itemkey => p_item_key
3833: ,aname => 'FORWARD_TO_PERSON_ID'),
3834: wf_engine.GetItemAttrNumber

Line 3834: wf_engine.GetItemAttrNumber

3830: nvl(wf_engine.GetItemAttrNumber
3831: (itemtype => p_item_type
3832: ,itemkey => p_item_key
3833: ,aname => 'FORWARD_TO_PERSON_ID'),
3834: wf_engine.GetItemAttrNumber
3835: (itemtype => p_item_type
3836: ,itemkey => p_item_key
3837: ,aname => 'CREATOR_PERSON_ID'));
3838:

Line 3841: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

3837: ,aname => 'CREATOR_PERSON_ID'));
3838:
3839:
3840:
3841: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
3842: itemkey => p_item_key,
3843: aname => 'HR_AME_APP_ID_ATTR');
3844:
3845:

Line 3847: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

3843: aname => 'HR_AME_APP_ID_ATTR');
3844:
3845:
3846: c_application_id := nvl(c_application_id,800);
3847: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
3848: itemkey => p_item_key,
3849: aname => 'TRANSACTION_ID');
3850:
3851:

Line 3853: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

3849: aname => 'TRANSACTION_ID');
3850:
3851:
3852:
3853: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
3854: itemkey => p_item_key,
3855: aname => 'HR_AME_TRAN_TYPE_ATTR');
3856:
3857: if(c_transaction_type is not null) then

Line 3904: wf_engine.SetItemAttrNumber

3900: (p_item_type => p_item_type
3901: ,p_item_key => p_item_key
3902: ,p_name => 'LAST_DEFAULT_APPROVER');
3903:
3904: wf_engine.SetItemAttrNumber
3905: (itemtype => p_item_type,
3906: itemkey => p_item_key,
3907: aname => 'LAST_DEFAULT_APPROVER',
3908: avalue => NULL);

Line 3915: ln_last_def_approver:= wf_engine.GetItemAttrNumber

3911: CLOSE csr_wiav;
3912:
3913:
3914: -- 'LAST_DEFAULT_APPROVER'
3915: ln_last_def_approver:= wf_engine.GetItemAttrNumber
3916: (itemtype => p_item_type,
3917: itemkey => p_item_key,
3918: aname => 'LAST_DEFAULT_APPROVER'
3919: );

Line 3957: ln_approval_level := wf_engine.GetItemAttrNumber

3953: FETCH csr_wiav into l_dummy;
3954: IF csr_wiav%notfound THEN
3955: ln_approval_level := 0;
3956: ELSE
3957: ln_approval_level := wf_engine.GetItemAttrNumber
3958: (itemtype => p_item_type,
3959: itemkey => p_item_key,
3960: aname => 'APPROVAL_LEVEL');
3961: END IF; -- for csr_wiav%notfound

Line 3976: ln_curr_def_appr_index := wf_engine.GetItemAttrNumber

3972: FETCH csr_wiav into l_dummy;
3973: IF csr_wiav%notfound THEN
3974: NULL;
3975: ELSE
3976: ln_curr_def_appr_index := wf_engine.GetItemAttrNumber
3977: (itemtype => p_item_type,
3978: itemkey => p_item_key,
3979: aname => 'CURRENT_DEF_APPR_INDEX');
3980: END IF;-- for csr_wiav%notfound

Line 4067: wf_engine.GetItemAttrNumber

4063: IF csr_wiav%notfound THEN
4064: ln_number_of_notifiers := 0;
4065: ELSE
4066: ln_number_of_notifiers:=
4067: wf_engine.GetItemAttrNumber
4068: (itemtype => itemtype,
4069: itemkey => itemkey,
4070: aname => 'NOTIFIERS_NUMBER'
4071: );

Line 4086: NVL( wf_engine.GetItemAttrNumber

4082: ln_current_index := 1;
4083:
4084: ELSE
4085: ln_current_index:=
4086: NVL( wf_engine.GetItemAttrNumber
4087: (itemtype => itemtype,
4088: itemkey => itemkey,
4089: aname => 'CURRENT_ONSUBMIT_INDEX')
4090: ,0);

Line 4114: lv_notify := wf_engine.GetItemAttrText

4110: IF csr_wiav%notfound THEN
4111: lv_exists := 'N';
4112: ELSE
4113: lv_exists := 'Y';
4114: lv_notify := wf_engine.GetItemAttrText
4115: (itemtype => itemtype,
4116: itemkey => itemkey,
4117: aname => lv_item_name
4118: );

Line 4203: wf_engine.GetItemAttrNumber

4199: IF csr_wiav%notfound THEN
4200: ln_number_of_notifiers := 0;
4201: ELSE
4202: ln_number_of_notifiers:=
4203: wf_engine.GetItemAttrNumber
4204: (itemtype => itemtype,
4205: itemkey => itemkey,
4206: aname => 'NOTIFIERS_NUMBER'
4207: );

Line 4222: NVL(wf_engine.GetItemAttrNumber

4218: ln_current_index := 1;
4219:
4220: ELSE
4221: ln_current_index:=
4222: NVL(wf_engine.GetItemAttrNumber
4223: (itemtype => itemtype,
4224: itemkey => itemkey,
4225: aname => 'CURRENT_ONAPPROVAL_INDEX'
4226: ),0);

Line 4253: lv_notify := wf_engine.GetItemAttrText

4249:
4250: lv_exists := 'N';
4251: ELSE
4252: lv_exists := 'Y';
4253: lv_notify := wf_engine.GetItemAttrText
4254: (itemtype => itemtype,
4255: itemkey => itemkey,
4256: aname => lv_item_name
4257: );

Line 4354: ln_notifiers := wf_engine.GetItemAttrNumber

4350: hr_utility.set_location('Entering: '|| l_proc,5);
4351: if ( funmode = 'RUN' ) then
4352: hr_utility.trace('In (if ( funmode = RUN )): '|| l_proc);
4353: -- get the total number ofnotifiers
4354: ln_notifiers := wf_engine.GetItemAttrNumber
4355: (itemtype => itemtype,
4356: itemkey => itemkey,
4357: aname => 'NOTIFIERS_NUMBER'
4358: );

Line 4362: NVL(wf_engine.GetItemAttrNumber

4358: );
4359: IF ln_notifiers > 0 THEN
4360: -- get the current index
4361: ln_current_onsubmit_index :=
4362: NVL(wf_engine.GetItemAttrNumber
4363: (itemtype => itemtype
4364: ,itemkey => itemkey
4365: ,aname => 'CURRENT_ONSUBMIT_INDEX'),0);
4366:

Line 4394: ln_person_id:= wf_engine.GetItemAttrNumber

4390: IF csr_wiav%notfound THEN
4391: lv_exists := 'N';
4392: ELSE
4393: lv_exists := 'Y';
4394: ln_person_id:= wf_engine.GetItemAttrNumber
4395: (itemtype => itemtype,
4396: itemkey => itemkey,
4397: aname => lv_item_name
4398: );

Line 4399: lv_notify := wf_engine.GetItemAttrText

4395: (itemtype => itemtype,
4396: itemkey => itemkey,
4397: aname => lv_item_name
4398: );
4399: lv_notify := wf_engine.GetItemAttrText
4400: (itemtype => itemtype,
4401: itemkey => itemkey,
4402: aname => lv_item_name
4403: );

Line 4411: wf_engine.SetItemAttrNumber

4407: IF lv_exists = 'Y' THEN
4408: hr_utility.trace('In ( IF lv_exists = Y): '|| l_proc);
4409: lv_onsubmit := SUBSTR(lv_notify,1,1);
4410: IF lv_onsubmit= 'Y' THEN
4411: wf_engine.SetItemAttrNumber
4412: (itemtype => itemtype,
4413: itemkey => itemkey,
4414: aname => 'CURRENT_ONSUBMIT_INDEX',
4415: avalue => I

Line 4454: wf_engine.SetItemAttrNumber

4450: (p_item_type => itemtype
4451: ,p_item_key => itemkey
4452: ,p_name => 'ONSUB_FWD_TO_PERSON_ID');
4453:
4454: wf_engine.SetItemAttrNumber
4455: (itemtype => itemtype
4456: ,itemkey => itemkey
4457: ,aname => 'ONSUB_FWD_TO_PERSON_ID'
4458: ,avalue => l_forward_to_person_id);

Line 4465: wf_engine.SetItemAttrText

4461: (p_item_type => itemtype
4462: ,p_item_key => itemkey
4463: ,p_name => 'ONSUB_FWD_TO_USERNAME');
4464:
4465: wf_engine.SetItemAttrText
4466: (itemtype => itemtype
4467: ,itemkey => itemkey
4468: ,aname => 'ONSUB_FWD_TO_USERNAME'
4469: ,avalue => l_forward_to_username);

Line 4476: wf_engine.SetItemAttrText

4472: hr_approval_wf.create_item_attrib_if_notexist
4473: (p_item_type => itemtype
4474: ,p_item_key => itemkey
4475: ,p_name => 'ONSUB_FWD_TO_DISPLAY_NAME');
4476: wf_engine.SetItemAttrText
4477: (itemtype => itemtype
4478: ,itemkey => itemkey
4479: ,aname => 'ONSUB_FWD_TO_DISPLAY_NAME'
4480: ,avalue => l_forward_to_disp_name);

Line 4557: ln_notifiers := wf_engine.GetItemAttrNumber

4553: if ( funmode = 'RUN' ) then
4554: hr_utility.trace('In (if ( funmode = RUN) ): '|| l_proc);
4555:
4556: -- get the total number ofnotifiers
4557: ln_notifiers := wf_engine.GetItemAttrNumber
4558: (itemtype => itemtype,
4559: itemkey => itemkey,
4560: aname => 'NOTIFIERS_NUMBER'
4561: );

Line 4566: NVL(wf_engine.GetItemAttrNumber

4562: IF ln_notifiers > 0 THEN
4563:
4564: -- get the current index
4565: ln_current_onapproval_index :=
4566: NVL(wf_engine.GetItemAttrNumber
4567: (itemtype => itemtype
4568: ,itemkey => itemkey
4569: ,aname => 'CURRENT_ONAPPROVAL_INDEX'),0);
4570:

Line 4599: ln_person_id:= wf_engine.GetItemAttrNumber

4595: IF csr_wiav%notfound THEN
4596: lv_exists := 'N';
4597: ELSE
4598: lv_exists := 'Y';
4599: ln_person_id:= wf_engine.GetItemAttrNumber
4600: (itemtype => itemtype,
4601: itemkey => itemkey,
4602: aname => lv_item_name
4603: );

Line 4604: lv_notify := wf_engine.GetItemAttrText

4600: (itemtype => itemtype,
4601: itemkey => itemkey,
4602: aname => lv_item_name
4603: );
4604: lv_notify := wf_engine.GetItemAttrText
4605: (itemtype => itemtype,
4606: itemkey => itemkey,
4607: aname => lv_item_name
4608: );

Line 4617: wf_engine.SetItemAttrNumber

4613: hr_utility.trace('In (IF lv_exists = Y): '|| l_proc);
4614: lv_onapproval := SUBSTR(lv_notify,3,3);
4615: IF lv_onapproval= 'Y' THEN
4616: hr_utility.trace('In (IF lv_onapproval = Y): '|| l_proc);
4617: wf_engine.SetItemAttrNumber
4618: (itemtype => itemtype,
4619: itemkey => itemkey,
4620: aname => 'CURRENT_ONAPPROVAL_INDEX',
4621: avalue => I

Line 4659: wf_engine.SetItemAttrNumber

4655: hr_approval_wf.create_item_attrib_if_notexist
4656: (p_item_type => itemtype
4657: ,p_item_key => itemkey
4658: ,p_name => 'ONAPPR_FWD_TO_PERSON_ID');
4659: wf_engine.SetItemAttrNumber
4660: (itemtype => itemtype
4661: ,itemkey => itemkey
4662: ,aname => 'ONAPPR_FWD_TO_PERSON_ID'
4663: ,avalue => l_forward_to_person_id);

Line 4669: wf_engine.SetItemAttrText

4665: hr_approval_wf.create_item_attrib_if_notexist
4666: (p_item_type => itemtype
4667: ,p_item_key => itemkey
4668: ,p_name => 'ONAPPR_FWD_TO_USERNAME');
4669: wf_engine.SetItemAttrText
4670: (itemtype => itemtype
4671: ,itemkey => itemkey
4672: ,aname => 'ONAPPR_FWD_TO_USERNAME'
4673: ,avalue => l_forward_to_username);

Line 4679: wf_engine.SetItemAttrText

4675: hr_approval_wf.create_item_attrib_if_notexist
4676: (p_item_type => itemtype
4677: ,p_item_key => itemkey
4678: ,p_name => 'ONAPPR_FWD_TO_DISPLAY_NAME');
4679: wf_engine.SetItemAttrText
4680: (itemtype => itemtype
4681: ,itemkey => itemkey
4682: ,aname => 'ONAPPR_FWD_TO_DISPLAY_NAME'
4683: ,avalue => l_forward_to_disp_name);

Line 4687: wf_engine.SetItemAttrNumber

4683: ,avalue => l_forward_to_disp_name);
4684: --
4685: -- set forward from to old forward to
4686: --
4687: wf_engine.SetItemAttrNumber
4688: (itemtype => itemtype
4689: ,itemkey => itemkey
4690: ,aname => 'ONAPPR_FWD_FROM_PERSON_ID'
4691: ,avalue => l_current_forward_to_id);

Line 4749: wf_engine.GetItemAttrNumber(itemtype => itemtype,

4745: --
4746: --
4747: -- get the total number of notifiers
4748: ln_notifiers :=
4749: wf_engine.GetItemAttrNumber(itemtype => itemtype,
4750: itemkey => itemkey,
4751: aname => 'NOTIFIERS_NUMBER');
4752: -- loop through the notifiers to get the first on submit notifier
4753: hr_utility.trace('Going into( FOR I IN 1..ln_notifiers): '|| l_proc);

Line 4764: ln_person_id:= wf_engine.GetItemAttrNumber

4760: IF csr_wiav%notfound THEN
4761: lv_exist := 'N';
4762: ELSE
4763: lv_exist := 'Y';
4764: ln_person_id:= wf_engine.GetItemAttrNumber
4765: (itemtype => itemtype,
4766: itemkey => itemkey,
4767: aname => lv_item_name
4768: );

Line 4769: lv_notify := wf_engine.GetItemAttrText

4765: (itemtype => itemtype,
4766: itemkey => itemkey,
4767: aname => lv_item_name
4768: );
4769: lv_notify := wf_engine.GetItemAttrText
4770: (itemtype => itemtype,
4771: itemkey => itemkey,
4772: aname => lv_item_name
4773: );

Line 4782: wf_engine.SetItemAttrNumber

4778: lv_onsubmit := SUBSTR(lv_notify,1,1);
4779: IF lv_onsubmit= 'Y' THEN
4780: hr_utility.trace('In (IF lv_onsubmit= Y): '|| l_proc);
4781: -- set the person id and start index
4782: wf_engine.SetItemAttrNumber
4783: (itemtype => itemtype,
4784: itemkey => itemkey,
4785: aname => 'ONSUBMIT_START_INDEX',
4786: avalue => I

Line 4789: wf_engine.SetItemAttrNumber

4785: aname => 'ONSUBMIT_START_INDEX',
4786: avalue => I
4787: );
4788:
4789: wf_engine.SetItemAttrNumber
4790: (itemtype => itemtype,
4791: itemkey => itemkey,
4792: aname => 'ONSUBMIT_START_PERSON_ID',
4793: avalue => ln_person_id

Line 4851: wf_engine.GetItemAttrNumber(itemtype => itemtype,

4847: --
4848: --
4849: -- get the total number of notifiers
4850: ln_notifiers :=
4851: wf_engine.GetItemAttrNumber(itemtype => itemtype,
4852: itemkey => itemkey,
4853: aname => 'NOTIFIERS_NUMBER');
4854: -- loop through the notifiers to get the first on submit notifier
4855: hr_utility.trace('Going into (FOR I IN 1..ln_notifiers): '|| l_proc);

Line 4866: ln_person_id:= wf_engine.GetItemAttrNumber

4862: IF csr_wiav%notfound THEN
4863: lv_exist := 'N';
4864: ELSE
4865: lv_exist := 'Y';
4866: ln_person_id:= wf_engine.GetItemAttrNumber
4867: (itemtype => itemtype,
4868: itemkey => itemkey,
4869: aname => lv_item_name
4870: );

Line 4871: lv_notify := wf_engine.GetItemAttrText

4867: (itemtype => itemtype,
4868: itemkey => itemkey,
4869: aname => lv_item_name
4870: );
4871: lv_notify := wf_engine.GetItemAttrText
4872: (itemtype => itemtype,
4873: itemkey => itemkey,
4874: aname => lv_item_name
4875: );

Line 4885: wf_engine.SetItemAttrNumber

4881: lv_onsubmit :=SUBSTR(lv_notify,3,3);
4882: IF lv_onsubmit= 'Y' THEN
4883: hr_utility.trace('In(IF lv_onsubmit = Y): '|| l_proc);
4884: -- set the person id and start index
4885: wf_engine.SetItemAttrNumber
4886: (itemtype => itemtype,
4887: itemkey => itemkey,
4888: aname => 'ONAPPROVAL_START_INDEX',
4889: avalue => I

Line 4892: wf_engine.SetItemAttrNumber

4888: aname => 'ONAPPROVAL_START_INDEX',
4889: avalue => I
4890: );
4891:
4892: wf_engine.SetItemAttrNumber
4893: (itemtype => itemtype,
4894: itemkey => itemkey,
4895: aname => 'ONAPPROVAL_START_PERSON_ID',
4896: avalue => ln_person_id

Line 4988: wf_engine.SetItemAttrNumber

4984: (p_item_type => itemtype
4985: ,p_item_key => itemkey
4986: ,p_name => 'CURRENT_DEF_APPR_INDEX');
4987:
4988: wf_engine.SetItemAttrNumber
4989: (itemtype => itemtype,
4990: itemkey => itemkey,
4991: aname => 'CURRENT_DEF_APPR_INDEX',
4992: avalue => 0);

Line 4994: wf_engine.SetItemAttrNumber

4990: itemkey => itemkey,
4991: aname => 'CURRENT_DEF_APPR_INDEX',
4992: avalue => 0);
4993: ELSE
4994: wf_engine.SetItemAttrNumber
4995: (itemtype => itemtype,
4996: itemkey => itemkey,
4997: aname => 'CURRENT_DEF_APPR_INDEX',
4998: avalue => 0);

Line 5154: wf_engine.SetItemAttrNumber(itemtype => itemtype ,

5150: -- local variables
5151: l_proc constant varchar2(100) := g_package || ' set_ame_attributes';
5152: begin
5153: hr_utility.set_location('Entering: '|| l_proc,5);
5154: wf_engine.SetItemAttrNumber(itemtype => itemtype ,
5155: itemkey => itemkey,
5156: aname => 'HR_AME_APP_ID_ATTR',
5157: avalue=>800);
5158:

Line 5160: wf_engine.SetItemAttrText(itemtype => itemtype ,

5156: aname => 'HR_AME_APP_ID_ATTR',
5157: avalue=>800);
5158:
5159:
5160: wf_engine.SetItemAttrText(itemtype => itemtype ,
5161: itemkey => itemkey,
5162: aname => 'HR_AME_TRAN_TYPE_ATTR',
5163: avalue=> 'SSHRMS');
5164:

Line 5204: if (funcmode <> wf_engine.eng_run) then

5200: hr_utility.set_location('Entering: '|| l_proc,5);
5201:
5202:
5203: -- Do nothing in cancel or timeout mode
5204: if (funcmode <> wf_engine.eng_run) then
5205: resultout := wf_engine.eng_null;
5206: hr_utility.set_location('Leaving: '|| l_proc,10);
5207: return;
5208: end if;

Line 5205: resultout := wf_engine.eng_null;

5201:
5202:
5203: -- Do nothing in cancel or timeout mode
5204: if (funcmode <> wf_engine.eng_run) then
5205: resultout := wf_engine.eng_null;
5206: hr_utility.set_location('Leaving: '|| l_proc,10);
5207: return;
5208: end if;
5209:

Line 5212: prole := wf_engine.GetActivityAttrText(

5208: end if;
5209:
5210:
5211: --PERFORMER
5212: prole := wf_engine.GetActivityAttrText(
5213: itemtype => itemtype,
5214: itemkey => itemkey,
5215: actid => actid,
5216: aname => 'PERFORMER');

Line 5226: avalue := upper(Wf_Engine.GetActivityAttrText(itemtype, itemkey,

5222: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
5223: end if;
5224:
5225: -- message name and expand roles will be null. Get these from attributes
5226: avalue := upper(Wf_Engine.GetActivityAttrText(itemtype, itemkey,
5227: actid, 'MESSAGE'));
5228:
5229: -- let notification_send catch a missing message name.
5230: expand_role := nvl(Wf_Engine.GetActivityAttrText(itemtype, itemkey,

Line 5230: expand_role := nvl(Wf_Engine.GetActivityAttrText(itemtype, itemkey,

5226: avalue := upper(Wf_Engine.GetActivityAttrText(itemtype, itemkey,
5227: actid, 'MESSAGE'));
5228:
5229: -- let notification_send catch a missing message name.
5230: expand_role := nvl(Wf_Engine.GetActivityAttrText(itemtype, itemkey,
5231: actid, 'EXPANDROLES'),'N');
5232:
5233: -- parse out the message type if given
5234: colon := instr(avalue, ':');

Line 5244: Wf_Engine_Util.Notification_Send(itemtype, itemkey, actid,

5240: msg := substr(avalue, colon + 1);
5241: end if;
5242:
5243: -- Actually send the notification
5244: Wf_Engine_Util.Notification_Send(itemtype, itemkey, actid,
5245: msg, msgtype, prole, expand_role,
5246: resultout);
5247:
5248:

Line 5354: /*ln_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

5350: -- Needed this for fixing bug# 2337022
5351: */
5352: -- get the creator person id
5353: hr_utility.trace('getting the creator person id from WF attr');
5354: /*ln_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
5355: itemkey => p_item_key,
5356: aname => 'CREATOR_PERSON_ID');
5357: */
5358: ln_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

Line 5358: ln_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

5354: /*ln_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
5355: itemkey => p_item_key,
5356: aname => 'CREATOR_PERSON_ID');
5357: */
5358: ln_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
5359: itemkey => p_item_key,
5360: aname => 'TRANSACTION_ID');
5361:
5362: ln_creator_person_id := hr_workflow_ss.getApprStartingPointPersonId(ln_transaction_id);

Line 5420: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

5416:
5417: BEGIN
5418: hr_utility.set_location('Entering: '|| l_proc,5);
5419: -- get AME related WF attribute values
5420: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
5421: itemkey => p_item_key,
5422: aname => 'HR_AME_APP_ID_ATTR');
5423:
5424: c_application_id := nvl(c_application_id,800);

Line 5427: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

5423:
5424: c_application_id := nvl(c_application_id,800);
5425:
5426:
5427: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
5428: itemkey => p_item_key,
5429: aname => 'TRANSACTION_ID');
5430:
5431:

Line 5433: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

5429: aname => 'TRANSACTION_ID');
5430:
5431:
5432:
5433: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
5434: itemkey => p_item_key,
5435: aname => 'HR_AME_TRAN_TYPE_ATTR');
5436:
5437:

Line 5542: wf_engine.GetItemAttrNumber(itemtype => p_item_type,

5538: IF csr_wiav%notfound THEN
5539: gn_notifiers := 0;
5540: ELSE
5541: gn_notifiers :=
5542: wf_engine.GetItemAttrNumber(itemtype => p_item_type,
5543: itemkey => p_item_key,
5544: aname => 'NOTIFIERS_NUMBER');
5545: END IF;
5546: CLOSE csr_wiav;

Line 5564: ln_person_id:= wf_engine.GetItemAttrNumber

5560: IF csr_wiav%notfound THEN
5561: lv_exist := 'N';
5562: ELSE
5563: lv_exist := 'Y';
5564: ln_person_id:= wf_engine.GetItemAttrNumber
5565: (itemtype => p_item_type,
5566: itemkey => p_item_key,
5567: aname => lv_item_name
5568: );

Line 5569: lv_notify := wf_engine.GetItemAttrText

5565: (itemtype => p_item_type,
5566: itemkey => p_item_key,
5567: aname => lv_item_name
5568: );
5569: lv_notify := wf_engine.GetItemAttrText
5570: (itemtype => p_item_type,
5571: itemkey => p_item_key,
5572: aname => lv_item_name
5573: );