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.IGIDOSL dependencies on WF_ENGINE

Line 132: l_work_item_org_id := wf_engine.GetItemAttrNumber

128: -- the workflow safely
129:
130: fnd_profile.get (name=>'ORG_ID', val=> l_session_org_id);
131:
132: l_work_item_org_id := wf_engine.GetItemAttrNumber
133: (itemtype,
134: itemkey,
135: 'ORG_ID');
136:

Line 148: l_user_id := wf_engine.GetItemAttrNumber

144: END IF;
145:
146: ELSIF funcmode = 'SET_CTX'
147: THEN
148: l_user_id := wf_engine.GetItemAttrNumber
149: (itemtype,
150: itemkey,
151: 'USER_ID');
152: l_resp_id := wf_engine.GetItemAttrNumber

Line 152: l_resp_id := wf_engine.GetItemAttrNumber

148: l_user_id := wf_engine.GetItemAttrNumber
149: (itemtype,
150: itemkey,
151: 'USER_ID');
152: l_resp_id := wf_engine.GetItemAttrNumber
153: (itemtype,
154: itemkey,
155: 'RESPONSIBILITY_ID');
156: l_appl_id := wf_engine.GetItemAttrNumber

Line 156: l_appl_id := wf_engine.GetItemAttrNumber

152: l_resp_id := wf_engine.GetItemAttrNumber
153: (itemtype,
154: itemkey,
155: 'RESPONSIBILITY_ID');
156: l_appl_id := wf_engine.GetItemAttrNumber
157: (itemtype,
158: itemkey,
159: 'RESP_APPL_ID');
160:

Line 308: Wf_Engine.CreateProcess ( itemtype => ItemType,

304: /* =============== END DEBUG LOG ================== */
305:
306: -- Workflow Initiation
307: --4124934 added Process parameter
308: Wf_Engine.CreateProcess ( itemtype => ItemType,
309: itemkey => ItemKey,
310: process => 'DOSFLOWE');
311:
312: /* =============== START DEBUG LOG ================ */

Line 323: Wf_Engine.SetItemAttrNumber ( itemtype => ItemType,

319: --
320: -- Assign workflow item attribute values
321: --
322:
323: Wf_Engine.SetItemAttrNumber ( itemtype => ItemType,
324: itemkey => ItemKey,
325: aname => 'DOSSIER_ID',
326: avalue => Dossier_Id);
327:

Line 333: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

329: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg10',
330: ' Dossier id --> ' || Dossier_id);
331: /* =============== END DEBUG LOG ================== */
332:
333: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
334: itemkey => ItemKey,
335: aname => 'DOSSIER_NUM',
336: avalue => Dossier_Num);
337:

Line 343: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

339: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg11',
340: ' Dossier Num --> ' || Dossier_num);
341: /* =============== END DEBUG LOG ================== */
342:
343: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
344: itemkey => ItemKey,
345: aname => 'INITIAL_ENTRY_FLAG',
346: avalue => 'TRUE');
347:

Line 353: Wf_Engine.SetItemAttrNumber ( itemtype => ItemType,

349: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg12',
350: ' Initial entry flag --> ' || 'TRUE');
351: /* =============== END DEBUG LOG ================== */
352:
353: Wf_Engine.SetItemAttrNumber ( itemtype => ItemType,
354: itemkey => ItemKey,
355: aname => 'PACKET_ID',
356: avalue => Packet_Id);
357:

Line 363: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

359: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg13',
360: ' Packet id --> ' || Packet_id);
361: /* =============== END DEBUG LOG ================== */
362:
363: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
364: itemkey => ItemKey,
365: aname => 'CREATOR_NAME',
366: avalue => User_Name);
367:

Line 373: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

369: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg14',
370: ' CREATOR_NAME --> ' || User_Name);
371: /* =============== END DEBUG LOG ================== */
372:
373: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
374: itemkey => ItemKey,
375: aname => 'DOSSIER_TRANSACTION_NAME',
376: avalue => Dossier_Transaction_Name);
377:

Line 383: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

379: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg15',
380: ' DOSSIER_TRANSACTION_NAME --> ' || Dossier_Transaction_Name);
381: /* =============== END DEBUG LOG ================== */
382:
383: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
384: itemkey => ItemKey,
385: aname => 'DOSSIER_DESCRIPTION',
386: avalue => Dossier_Description);
387:

Line 399: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

395: CLOSE c_source_total;
396: -- Bug 5138221 .. Start
397: l_formatted_total_amount := TO_CHAR(l_total_amount, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
398: -- Bug 5138221 .. End
399: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
400: itemkey => ItemKey,
401: aname => 'TOTAL',
402: avalue => l_formatted_total_amount);
403:

Line 410: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

406: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg16',
407: ' TOTAL_AMOUNT --> ' || l_formatted_total_amount);
408: /* =============== END DEBUG LOG ================== */
409:
410: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
411: itemkey => ItemKey,
412: aname => 'DOCUMENT_ID',
413: avalue => itemtype||':'||itemkey);
414:

Line 420: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

416: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg17',
417: ' DOCUMENT_ID --> ' || itemtype||':'||itemkey);
418: /* =============== END DEBUG LOG ================== */
419:
420: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
421: itemkey => ItemKey,
422: aname => 'DOSSIER_TRANSACTION_DETAIL',
423: avalue => 'plsqlclob:igidosl.dossier_transaction_detail/'||itemtype||':'||itemkey);
424:

Line 431: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

427: ' DOSSIER_TRANSACTION_DETAIL --> ' ||
428: 'plsqlclob:igidosl.dossier_transaction_detail/'||itemtype||':'||itemkey);
429: /* =============== END DEBUG LOG ================== */
430:
431: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
432: itemkey => ItemKey,
433: aname => 'USER_ID',
434: avalue => User_Id);
435:

Line 441: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

437: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg19',
438: ' USER_ID --> ' || User_Id );
439: /* =============== END DEBUG LOG ================== */
440:
441: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
442: itemkey => ItemKey,
443: aname => 'RESPONSIBILITY_ID',
444: avalue => Responsibility_Id);
445:

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

455: p_display_name => l_preparer_display_name );
456:
457:
458: -- Copy username to Workflow
459: wf_engine.SetItemAttrText( itemtype => itemtype,
460: itemkey => itemkey,
461: aname => 'PREPARER_NAME',
462: avalue => l_preparer_display_name );
463:

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

466: ' PREPARER_NAME --> ' || l_preparer_display_name );
467: /* =============== END DEBUG LOG ================== */
468:
469: -- Copy displayed username to Workflow
470: wf_engine.SetItemAttrText( itemtype => itemtype,
471: itemkey => itemkey,
472: aname => 'PREPARER_LOGIN_NAME',
473: avalue => l_preparer_name );
474:

Line 489: Wf_Engine.SetItemOwner ( itemtype => ItemType,

485: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg23',
486: ' Setting process attributes ');
487: /* =============== END DEBUG LOG ================== */
488:
489: Wf_Engine.SetItemOwner ( itemtype => ItemType,
490: itemkey => ItemKey,
491: owner => User_name);
492:
493: Wf_Engine.SetItemUserKey ( itemtype => ItemType,

Line 493: Wf_Engine.SetItemUserKey ( itemtype => ItemType,

489: Wf_Engine.SetItemOwner ( itemtype => ItemType,
490: itemkey => ItemKey,
491: owner => User_name);
492:
493: Wf_Engine.SetItemUserKey ( itemtype => ItemType,
494: itemkey => ItemKey,
495: userkey => UserKey);
496:
497: /* =============== START DEBUG LOG ================ */

Line 504: wf_engine.SetItemAttrText ( itemtype => ItemType,

500: /* =============== END DEBUG LOG ================== */
501:
502: -- Set user id, responsibility id , org id and application id context values
503: -- Bug 4124934 , Start
504: wf_engine.SetItemAttrText ( itemtype => ItemType,
505: itemkey => ItemKey,
506: aname => 'ORG_ID',
507: avalue => FND_PROFILE.VALUE('ORG_ID'));
508:

Line 509: wf_engine.SetItemAttrText ( itemtype => ItemType,

505: itemkey => ItemKey,
506: aname => 'ORG_ID',
507: avalue => FND_PROFILE.VALUE('ORG_ID'));
508:
509: wf_engine.SetItemAttrText ( itemtype => ItemType,
510: itemkey => ItemKey,
511: aname => 'USER_ID',
512: avalue => FND_PROFILE.VALUE('USER_ID'));
513:

Line 514: wf_engine.SetItemAttrText ( itemtype => ItemType,

510: itemkey => ItemKey,
511: aname => 'USER_ID',
512: avalue => FND_PROFILE.VALUE('USER_ID'));
513:
514: wf_engine.SetItemAttrText ( itemtype => ItemType,
515: itemkey => ItemKey,
516: aname => 'RESPONSIBILITY_ID',
517: avalue => FND_PROFILE.VALUE('RESP_ID'));
518:

Line 519: wf_engine.SetItemAttrText ( itemtype => ItemType,

515: itemkey => ItemKey,
516: aname => 'RESPONSIBILITY_ID',
517: avalue => FND_PROFILE.VALUE('RESP_ID'));
518:
519: wf_engine.SetItemAttrText ( itemtype => ItemType,
520: itemkey => ItemKey,
521: aname => 'RESP_APPL_ID',
522: avalue => FND_PROFILE.VALUE('RESP_APPL_ID'));
523: -- Bug 4124934 End

Line 528: Wf_Engine.StartProcess ( itemtype => ItemType,

524:
525: --
526: -- Kick-off the workflow process instance
527: --
528: Wf_Engine.StartProcess ( itemtype => ItemType,
529: itemkey => ItemKey);
530:
531: COMMIT;
532:

Line 578: l_picked_role := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

574:
575: RETURN;
576: END IF;
577:
578: l_picked_role := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
579: itemkey => itemkey,
580: aname => 'PICKED_ROLE');
581:
582: /* =============== START DEBUG LOG ================ */

Line 587: Wf_Engine.SetItemAttrText ( itemtype => itemtype,

583: DEBUG_LOG_STRING (l_proc_level, 'setrole.Msg3',
584: ' l_picked_role --> '|| l_picked_role);
585: /* =============== END DEBUG LOG ================== */
586:
587: Wf_Engine.SetItemAttrText ( itemtype => itemtype,
588: itemkey => itemkey,
589: aname => 'ROLE_NAME',
590: avalue => l_picked_role);
591:

Line 597: Wf_Engine.SetItemAttrText ( itemtype => itemtype,

593: DEBUG_LOG_STRING (l_proc_level, 'setrole.Msg4',
594: ' setting l_picked_role to ROLE_NAME ');
595: /* =============== END DEBUG LOG ================== */
596:
597: Wf_Engine.SetItemAttrText ( itemtype => itemtype,
598: itemkey => itemkey,
599: aname => 'SELECTED_USER_NAME',
600: avalue => l_picked_role);
601:

Line 637: := Wf_Engine.GetItemAttrText (itemtype => itemtype,

633: result OUT NOCOPY VARCHAR2)
634: IS
635:
636: l_creator_name wf_notifications.responder%TYPE
637: := Wf_Engine.GetItemAttrText (itemtype => itemtype,
638: itemkey => itemkey,
639: aname => 'CREATOR_NAME');
640:
641: l_initial_entry VARCHAR2(5)

Line 642: := Wf_Engine.GetItemAttrText (itemtype => itemtype,

638: itemkey => itemkey,
639: aname => 'CREATOR_NAME');
640:
641: l_initial_entry VARCHAR2(5)
642: := Wf_Engine.GetItemAttrText (itemtype => itemtype,
643: itemkey => itemkey,
644: aname => 'INITIAL_ENTRY_FLAG');
645:
646: l_pos_struct_element_id per_pos_structure_elements.pos_structure_element_id%TYPE

Line 647: := Wf_Engine.GetItemAttrNumber (itemtype => itemtype,

643: itemkey => itemkey,
644: aname => 'INITIAL_ENTRY_FLAG');
645:
646: l_pos_struct_element_id per_pos_structure_elements.pos_structure_element_id%TYPE
647: := Wf_Engine.GetItemAttrNumber (itemtype => itemtype,
648: itemkey => itemkey,
649: aname => 'POS_STRUCTURE_ELEMENT_ID');
650:
651: l_dossier_id igi_dos_doc_types.dossier_id%TYPE

Line 652: :=Wf_Engine.GetItemAttrNumber (itemtype => ItemType,

648: itemkey => itemkey,
649: aname => 'POS_STRUCTURE_ELEMENT_ID');
650:
651: l_dossier_id igi_dos_doc_types.dossier_id%TYPE
652: :=Wf_Engine.GetItemAttrNumber (itemtype => ItemType,
653: itemkey => ItemKey,
654: aname => 'DOSSIER_ID');
655:
656: l_picked_role wf_notifications.responder%TYPE;

Line 841: Wf_Engine.SetItemAttrText (itemtype => ItemType,

837: DEBUG_LOG_STRING (l_proc_level, 'getparentposition.Msg6',
838: ' Setting attribute text ');
839: /* =============== END DEBUG LOG ================== */
840:
841: Wf_Engine.SetItemAttrText (itemtype => ItemType,
842: itemkey => ItemKey,
843: aname => 'CURRENT_POSITION_ID',
844: avalue => l_position_id);
845:

Line 852: Wf_Engine.SetItemAttrText (itemtype => ItemType,

848: ' l_position_id - CURRENT_POSITION_ID --> ' || l_position_id );
849: /* =============== END DEBUG LOG ================== */
850:
851:
852: Wf_Engine.SetItemAttrText (itemtype => ItemType,
853: itemkey => ItemKey,
854: aname => 'BUSINESS_GROUP_ID',
855: avalue => l_business_group_id);
856:

Line 862: Wf_Engine.SetItemAttrText (itemtype => ItemType,

858: DEBUG_LOG_STRING (l_proc_level, 'getparentposition.Msg8',
859: ' l_business_group_id - BUSINESS_GROUP_ID --> ' || l_business_group_id );
860: /* =============== END DEBUG LOG ================== */
861:
862: Wf_Engine.SetItemAttrText (itemtype => ItemType,
863: itemkey => ItemKey,
864: aname => 'ORGANIZATION_ID',
865: avalue => l_organization_id);
866:

Line 872: Wf_Engine.SetItemAttrText (itemtype => ItemType,

868: DEBUG_LOG_STRING (l_proc_level, 'getparentposition.Msg9',
869: ' l_organization_id - ORGANIZATION_ID --> ' || l_organization_id );
870: /* =============== END DEBUG LOG ================== */
871:
872: Wf_Engine.SetItemAttrText (itemtype => ItemType,
873: itemkey => ItemKey,
874: aname => 'CURRENT_USER_NAME',
875: avalue => l_current_user_name);
876:

Line 905: Wf_Engine.SetItemAttrText (itemtype => ItemType,

901: /* =============== END DEBUG LOG ================== */
902: RAISE pos_hier_not_found;
903: END;
904:
905: Wf_Engine.SetItemAttrText (itemtype => ItemType,
906: itemkey => ItemKey,
907: aname => 'POS_STRUCTURE_ID',
908: avalue => l_hierarchy_id);
909:

Line 939: Wf_Engine.SetItemAttrText (itemtype => ItemType,

935: /* =============== END DEBUG LOG ================== */
936: RAISE pos_hier_ver_not_found;
937: END;
938:
939: Wf_Engine.SetItemAttrText (itemtype => ItemType,
940: itemkey => ItemKey,
941: aname => 'POS_STRUCTURE_VERSION_ID',
942: avalue => l_hierarchy_version_id);
943:

Line 975: Wf_Engine.SetItemAttrText (itemtype => ItemType,

971: /* =============== END DEBUG LOG ================== */
972: RAISE top_pos_not_found;
973: END;
974:
975: Wf_Engine.SetItemAttrText (itemtype => ItemType,
976: itemkey => ItemKey,
977: aname => 'TOP_POSITION_ID',
978: avalue => l_top_position_id);
979:

Line 996: Wf_Engine.SetItemAttrText (itemtype => ItemType,

992: ' l_position_id --> ' || l_position_id || ' = ' ||
993: ' l_top_position_id --> ' || l_top_position_id );
994: /* =============== END DEBUG LOG ================== */
995:
996: Wf_Engine.SetItemAttrText (itemtype => ItemType,
997: itemkey => ItemKey,
998: aname => 'PARENT_POSITION_ID',
999: avalue => l_position_id);
1000:

Line 1039: Wf_Engine.SetItemAttrText (itemtype => ItemType,

1035: /* =============== END DEBUG LOG ================== */
1036: RAISE par_pos_not_found;
1037: END;
1038:
1039: Wf_Engine.SetItemAttrText (itemtype => ItemType,
1040: itemkey => ItemKey,
1041: aname => 'PARENT_POSITION_ID',
1042: avalue => l_parent_position_id);
1043:

Line 1061: Wf_Engine.SetItemAttrText (itemtype => itemtype,

1057: /* =============== END DEBUG LOG ================== */
1058:
1059: -- Flip the initial entry flag as subsequent entries will not be initial
1060: l_initial_entry := 'FALSE';
1061: Wf_Engine.SetItemAttrText (itemtype => itemtype,
1062: itemkey => itemkey,
1063: aname => 'INITIAL_ENTRY_FLAG',
1064: avalue => l_initial_entry);
1065:

Line 1079: l_position_id := Wf_Engine.GetItemAttrText (itemtype => ItemType,

1075: ' Not initial entry INTO GetParentPosition ');
1076: /* =============== END DEBUG LOG ================== */
1077:
1078: -- FETCH the parent position id as the current position id
1079: l_position_id := Wf_Engine.GetItemAttrText (itemtype => ItemType,
1080: itemkey => ItemKey,
1081: aname => 'PARENT_POSITION_ID');
1082:
1083: /* =============== START DEBUG LOG ================ */

Line 1089: l_top_position_id := Wf_Engine.GetItemAttrText (itemtype => ItemType,

1085: ' GetItemAttrText PARENT_POSITION_ID --> ' || l_position_id);
1086: /* =============== END DEBUG LOG ================== */
1087:
1088:
1089: l_top_position_id := Wf_Engine.GetItemAttrText (itemtype => ItemType,
1090: itemkey => ItemKey,
1091: aname => 'TOP_POSITION_ID');
1092:
1093: /* =============== START DEBUG LOG ================ */

Line 1118: Wf_Engine.GetItemAttrNumber ( itemtype => ItemType,

1114: ' l_position_id --> ' || l_position_id);
1115: /* =============== END DEBUG LOG ================== */
1116:
1117: l_hierarchy_version_id :=
1118: Wf_Engine.GetItemAttrNumber ( itemtype => ItemType,
1119: itemkey => ItemKey,
1120: aname => 'POS_STRUCTURE_VERSION_ID');
1121:
1122: /* =============== START DEBUG LOG ================ */

Line 1128: Wf_Engine.GetItemAttrNumber ( itemtype => ItemType,

1124: ' GetItemAttrNumber - POS_STRUCTURE_VERSION_ID --> ' || TO_CHAR(l_hierarchy_version_id));
1125: /* =============== END DEBUG LOG ================== */
1126:
1127: l_business_group_id :=
1128: Wf_Engine.GetItemAttrNumber ( itemtype => ItemType,
1129: itemkey => ItemKey,
1130: aname => 'BUSINESS_GROUP_ID');
1131:
1132: /* =============== START DEBUG LOG ================ */

Line 1159: Wf_Engine.SetItemAttrText (itemtype => ItemType,

1155: /* =============== END DEBUG LOG ================== */
1156: RAISE par_pos_not_found;
1157: END;
1158:
1159: Wf_Engine.SetItemAttrText (itemtype => ItemType,
1160: itemkey => ItemKey,
1161: aname => 'PARENT_POSITION_ID',
1162: avalue => l_parent_position_id);
1163:

Line 1170: Wf_Engine.GetItemAttrText (itemtype => ItemType,

1166: ' l_parent_position_id - PARENT_POSITION_ID --> ' || TO_CHAR(l_parent_position_id));
1167: /* =============== END DEBUG LOG ================== */
1168:
1169: l_current_user_name :=
1170: Wf_Engine.GetItemAttrText (itemtype => ItemType,
1171: itemkey => ItemKey,
1172: aname => 'SELECTED_USER_NAME');
1173:
1174: /* =============== START DEBUG LOG ================ */

Line 1179: Wf_Engine.SetItemAttrText (itemtype => ItemType,

1175: DEBUG_LOG_STRING (l_proc_level, 'getparentposition.Msg32',
1176: ' GetItemAttrText SELECTED_USER_NAME --> ' || l_current_user_name);
1177: /* =============== END DEBUG LOG ================== */
1178:
1179: Wf_Engine.SetItemAttrText (itemtype => ItemType,
1180: itemkey => ItemKey,
1181: aname => 'CURRENT_USER_NAME',
1182: avalue => l_current_user_name);
1183:

Line 1282: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1278: l_trx_status VARCHAR2(30);
1279: l_sob_id NUMBER;
1280:
1281: l_dossier_num VARCHAR2(255)
1282: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => 'DOSSIER_NUM');
1285:
1286: l_user_id VARCHAR2(30) -- Changed FROM NUM to TEXT by bug 1635667

Line 1287: := Wf_Engine.GetItemAttrText( itemtype => itemtype,

1283: itemkey => itemkey,
1284: aname => 'DOSSIER_NUM');
1285:
1286: l_user_id VARCHAR2(30) -- Changed FROM NUM to TEXT by bug 1635667
1287: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1288: itemkey => itemkey,
1289: aname => 'USER_ID');
1290:
1291: l_responsibility_id VARCHAR2(30) -- Changed FROM NUM to TEXT by bug 1635667

Line 1292: := Wf_Engine.GetItemAttrText( itemtype => itemtype,

1288: itemkey => itemkey,
1289: aname => 'USER_ID');
1290:
1291: l_responsibility_id VARCHAR2(30) -- Changed FROM NUM to TEXT by bug 1635667
1292: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => 'RESPONSIBILITY_ID');
1295: encumbrance_error EXCEPTION;
1296:

Line 1422: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1418: IS
1419: l_trx_status VARCHAR2(80);
1420:
1421: l_dossier_id VARCHAR2(255)
1422: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1423: itemkey => itemkey,
1424: aname => 'DOSSIER_NUM');
1425:
1426: l_creator_name wf_notifications.responder%TYPE

Line 1427: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1423: itemkey => itemkey,
1424: aname => 'DOSSIER_NUM');
1425:
1426: l_creator_name wf_notifications.responder%TYPE
1427: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1428: itemkey => itemkey,
1429: aname => 'CREATOR_NAME');
1430: BEGIN
1431:

Line 1499: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1495: result OUT NOCOPY VARCHAR2)
1496: IS
1497:
1498: l_creator_name wf_notifications.responder%TYPE
1499: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1500: itemkey => itemkey,
1501: aname => 'CREATOR_NAME');
1502:
1503: l_nid NUMBER ;

Line 1534: , 'WF_ENGINE.CB'

1530: l_creator_name
1531: , itemtype
1532: ,'ALL_APPROVED'
1533: , null
1534: , 'WF_ENGINE.CB'
1535: , itemtype||':'||itemkey||':'||to_char(actid)
1536: ,'Send The Dossier Approved Message To The Creator.'
1537: , null
1538: ) ;

Line 1597: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1593: result OUT NOCOPY VARCHAR2)
1594: IS
1595:
1596: l_creator_name wf_notifications.responder%TYPE
1597: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1598: itemkey => itemkey,
1599: aname => 'CREATOR_NAME');
1600:
1601: l_nid NUMBER ;

Line 1633: , 'WF_ENGINE.CB'

1629: l_creator_name
1630: , itemtype
1631: ,'AUTHORISER_REJECTION'
1632: , null
1633: , 'WF_ENGINE.CB'
1634: , itemtype||':'||itemkey||':'||to_char(actid)
1635: ,'Send The Dossier Rejection Message To The Creator.'
1636: , null
1637: ) ;

Line 1700: := Wf_Engine.GetItemAttrText( itemtype => itemtype,

1696:
1697: l_user_name fnd_user.user_name%TYPE;
1698:
1699: l_next_position per_positions.name%TYPE
1700: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1701: itemkey => itemkey,
1702: aname => 'NEXT_POSITION');
1703:
1704: l_parent_position_id per_positions.position_id%TYPE

Line 1705: := Wf_Engine.GetItemAttrText (itemtype => ItemType,

1701: itemkey => itemkey,
1702: aname => 'NEXT_POSITION');
1703:
1704: l_parent_position_id per_positions.position_id%TYPE
1705: := Wf_Engine.GetItemAttrText (itemtype => ItemType,
1706: itemkey => ItemKey,
1707: aname => 'PARENT_POSITION_ID');
1708:
1709: l_business_group_id hr_all_positions_f.business_group_id%TYPE

Line 1710: := Wf_Engine.GetItemAttrText( itemtype => itemtype,

1706: itemkey => ItemKey,
1707: aname => 'PARENT_POSITION_ID');
1708:
1709: l_business_group_id hr_all_positions_f.business_group_id%TYPE
1710: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1711: itemkey => itemkey,
1712: aname => 'BUSINESS_GROUP_ID');
1713:
1714: l_organization_id hr_all_positions_f.organization_id%TYPE

Line 1715: := Wf_Engine.GetItemAttrText( itemtype => itemtype,

1711: itemkey => itemkey,
1712: aname => 'BUSINESS_GROUP_ID');
1713:
1714: l_organization_id hr_all_positions_f.organization_id%TYPE
1715: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1716: itemkey => itemkey,
1717: aname => 'ORGANIZATION_ID');
1718:
1719: CURSOR c_user_list

Line 1814: Wf_Engine.SetItemAttrText (itemtype => Itemtype,

1810: /* =============== END DEBUG LOG ================== */
1811: RAISE e_user_list_not_found;
1812: END;
1813:
1814: Wf_Engine.SetItemAttrText (itemtype => Itemtype,
1815: itemkey => Itemkey,
1816: aname => 'USER_LIST',
1817: avalue => l_list);
1818:

Line 1835: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,

1831: DEBUG_LOG_STRING (l_proc_level, 'CreateList.Msg7',
1832: ' result --> ' || result);
1833: /* =============== END DEBUG LOG ================== */
1834:
1835: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,
1836: itemkey => Itemkey,
1837: aname => 'PICKED_ROLE',
1838: avalue => l_list) ;
1839:

Line 1878: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1874: IS
1875:
1876:
1877: l_user_list VARCHAR2(250)
1878: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1879: itemkey => itemkey,
1880: aname => 'USER_LIST');
1881:
1882: l_next_position per_positions.name%TYPE;

Line 1885: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1881:
1882: l_next_position per_positions.name%TYPE;
1883:
1884: l_parent_position_id hr_all_positions_f.position_id%TYPE
1885: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1886: itemkey => itemkey,
1887: aname => 'PARENT_POSITION_ID');
1888:
1889: l_next_authoriser wf_notifications.responder%TYPE ;

Line 1913: l_next_authoriser := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1909:
1910: -- The returned value is held in item attribute which is the same name as
1911: -- the workflow message attribute with source 'Respond'.
1912:
1913: l_next_authoriser := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1914: itemkey => itemkey,
1915: aname => 'NEXT_AUTHORISER');
1916:
1917: l_next_authoriser := UPPER(l_next_authoriser) ;

Line 1951: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,

1947: /* =============== END DEBUG LOG ================== */
1948:
1949: END IF ;
1950:
1951: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,
1952: itemkey => Itemkey,
1953: aname => 'PICKED_ROLE',
1954: avalue => l_next_authoriser) ;
1955:

Line 1961: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,

1957: DEBUG_LOG_STRING (l_proc_level, 'CheckList.Msg7',
1958: ' l_next_authoriser - PICKED_ROLE --> ' || l_next_authoriser);
1959: /* =============== END DEBUG LOG ================== */
1960:
1961: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,
1962: itemkey => Itemkey,
1963: aname => 'SELECTED_USER_NAME',
1964: avalue => l_next_authoriser) ;
1965:

Line 2019: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

2015: IS
2016: l_trx_status VARCHAR2(30);
2017:
2018: l_trx_number VARCHAR2(30)
2019: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2020: itemkey => itemkey,
2021: aname => 'DOSSIER_NUM');
2022: l_user_id VARCHAR2(30)
2023: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

Line 2023: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

2019: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2020: itemkey => itemkey,
2021: aname => 'DOSSIER_NUM');
2022: l_user_id VARCHAR2(30)
2023: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2024: itemkey => itemkey,
2025: aname => 'USER_ID');
2026:
2027: l_responsibility_id VARCHAR2(30)

Line 2028: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

2024: itemkey => itemkey,
2025: aname => 'USER_ID');
2026:
2027: l_responsibility_id VARCHAR2(30)
2028: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2029: itemkey => itemkey,
2030: aname => 'RESPONSIBILITY_ID');
2031: l_sob_id number;
2032: unreserve_error EXCEPTION ;

Line 2390: := Wf_Engine.GetItemAttrText ( itemtype => l_itemtype,

2386: /* =============== END DEBUG LOG ================== */
2387:
2388:
2389: l_dossier_num
2390: := Wf_Engine.GetItemAttrText ( itemtype => l_itemtype,
2391: itemkey => l_itemkey,
2392: aname => 'DOSSIER_NUM');
2393:
2394: /* =============== START DEBUG LOG ================ */

Line 2400: := Wf_Engine.GetItemAttrNumber ( itemtype => l_itemtype,

2396: ' l_dossier_num --> ' || l_dossier_num);
2397: /* =============== END DEBUG LOG ================== */
2398:
2399: l_dossier_id
2400: := Wf_Engine.GetItemAttrNumber ( itemtype => l_itemtype,
2401: itemkey => l_itemkey,
2402: aname => 'DOSSIER_ID');
2403:
2404: /* =============== START DEBUG LOG ================ */

Line 2610: Wf_Engine.GetItemAttrText ( itemtype => itemtype,

2606: result OUT NOCOPY VARCHAR2 ) IS
2607:
2608: l_trx_status igi_lookups.meaning%TYPE;
2609: l_dossier_num igi_dos_trx_headers.trx_number%TYPE :=
2610: Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2611: itemkey => itemkey,
2612: aname => 'DOSSIER_NUM');
2613:
2614: CURSOR c_meaning IS

Line 2685: l_user_id NUMBER(15) := Wf_Engine.GetItemAttrText

2681: result OUT NOCOPY VARCHAR2 ) IS
2682:
2683: l_emp_id NUMBER(15);
2684:
2685: l_user_id NUMBER(15) := Wf_Engine.GetItemAttrText
2686: ( itemtype => itemtype,
2687: itemkey => itemkey,
2688: aname => 'USER_ID');
2689:

Line 2728: Wf_Engine.SetItemAttrText ( itemtype => itemtype,

2724: result := 'COMPLETE:N';
2725:
2726: ELSE
2727: -- Save the employee id for subsequent validations
2728: Wf_Engine.SetItemAttrText ( itemtype => itemtype,
2729: itemkey => itemkey,
2730: aname => 'EMPLOYEE_ID',
2731: avalue => l_emp_id);
2732:

Line 2808: l_emp_id NUMBER(15) := Wf_Engine.GetItemAttrText

2804: l_position_name hr_all_positions_f.name%TYPE;
2805: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2806: l_organization_id hr_all_positions_f.organization_id%TYPE;
2807:
2808: l_emp_id NUMBER(15) := Wf_Engine.GetItemAttrText
2809: ( itemtype => itemtype,
2810: itemkey => itemkey,
2811: aname => 'EMPLOYEE_ID');
2812:

Line 2847: Wf_Engine.SetItemAttrText (itemtype => ItemType,

2843:
2844: result := 'COMPLETE:N';
2845: ELSE
2846:
2847: Wf_Engine.SetItemAttrText (itemtype => ItemType,
2848: itemkey => ItemKey,
2849: aname => 'CURRENT_POSITION_ID',
2850: avalue => l_position_id);
2851:

Line 2857: Wf_Engine.SetItemAttrText (itemtype => ItemType,

2853: DEBUG_LOG_STRING (l_proc_level, 'HasPosition.Msg4',
2854: ' SetItemAttrText CURRENT_POSITION_ID -> ' || l_position_id );
2855: /* =============== END DEBUG LOG ================== */
2856:
2857: Wf_Engine.SetItemAttrText (itemtype => ItemType,
2858: itemkey => ItemKey,
2859: aname => 'BUSINESS_GROUP_ID',
2860: avalue => l_business_group_id);
2861:

Line 2867: Wf_Engine.SetItemAttrText (itemtype => ItemType,

2863: DEBUG_LOG_STRING (l_proc_level, 'HasPosition.Msg5',
2864: ' SetItemAttrText BUSINESS_GROUP_ID -> ' || l_business_group_id);
2865: /* =============== END DEBUG LOG ================== */
2866:
2867: Wf_Engine.SetItemAttrText (itemtype => ItemType,
2868: itemkey => ItemKey,
2869: aname => 'ORGANIZATION_ID',
2870: avalue => l_organization_id);
2871:

Line 2917: Wf_Engine.GetItemAttrText (itemtype => ItemType,

2913: funcmode IN VARCHAR2,
2914: result OUT NOCOPY VARCHAR2 ) IS
2915:
2916: l_position_id hr_all_positions_f.position_id%TYPE :=
2917: Wf_Engine.GetItemAttrText (itemtype => ItemType,
2918: itemkey => ItemKey,
2919: aname => 'CURRENT_POSITION_ID');
2920:
2921: l_business_group_id hr_all_positions_f.business_group_id%TYPE :=

Line 2922: Wf_Engine.GetItemAttrText (itemtype => ItemType,

2918: itemkey => ItemKey,
2919: aname => 'CURRENT_POSITION_ID');
2920:
2921: l_business_group_id hr_all_positions_f.business_group_id%TYPE :=
2922: Wf_Engine.GetItemAttrText (itemtype => ItemType,
2923: itemkey => ItemKey,
2924: aname => 'BUSINESS_GROUP_ID');
2925:
2926: l_organization_id hr_all_positions_f.organization_id%TYPE :=

Line 2927: Wf_Engine.GetItemAttrText (itemtype => ItemType,

2923: itemkey => ItemKey,
2924: aname => 'BUSINESS_GROUP_ID');
2925:
2926: l_organization_id hr_all_positions_f.organization_id%TYPE :=
2927: Wf_Engine.GetItemAttrText (itemtype => ItemType,
2928: itemkey => ItemKey,
2929: aname => 'ORGANIZATION_ID');
2930:
2931: l_dossier_id igi_dos_doc_types.dossier_id%TYPE :=

Line 2932: Wf_Engine.GetItemAttrNumber (itemtype => ItemType,

2928: itemkey => ItemKey,
2929: aname => 'ORGANIZATION_ID');
2930:
2931: l_dossier_id igi_dos_doc_types.dossier_id%TYPE :=
2932: Wf_Engine.GetItemAttrNumber (itemtype => ItemType,
2933: itemkey => ItemKey,
2934: aname => 'DOSSIER_ID');
2935:
2936: l_valid BOOLEAN := TRUE;

Line 3009: Wf_Engine.SetItemAttrText (itemtype => ItemType,

3005:
3006: IF (c_pos_hier%NOTFOUND) THEN
3007: l_valid := FALSE;
3008: ELSE
3009: Wf_Engine.SetItemAttrText (itemtype => ItemType,
3010: itemkey => ItemKey,
3011: aname => 'POS_STRUCTURE_ID',
3012: avalue => l_hierarchy_id);
3013:

Line 3059: Wf_Engine.SetItemAttrText (itemtype => ItemType,

3055: /* =============== END DEBUG LOG ================== */
3056:
3057: ELSE
3058:
3059: Wf_Engine.SetItemAttrText (itemtype => ItemType,
3060: itemkey => ItemKey,
3061: aname => 'POS_STRUCTURE_VERSION_ID',
3062: avalue => l_hierarchy_version_id);
3063: