DBA Data[Home] [Help]

APPS.JTF_BRM_PVT dependencies on WF_ENGINE

Line 82: wf_engine.CreateProcess(

78: END IF;
79: --
80: l_itemkey := to_char(itemkey);
81: --
82: wf_engine.CreateProcess(
83: itemtype => l_itemtype,
84: itemkey => l_itemkey,
85: process => 'MONITOR_RULES');
86: --

Line 87: wf_engine.SetItemAttrText(

83: itemtype => l_itemtype,
84: itemkey => l_itemkey,
85: process => 'MONITOR_RULES');
86: --
87: wf_engine.SetItemAttrText(
88: itemtype => l_itemtype,
89: itemkey => l_itemkey,
90: aname => 'WF_ADMINISTRATOR',
91: avalue => l_admin);

Line 93: wf_engine.SetItemOwner(

89: itemkey => l_itemkey,
90: aname => 'WF_ADMINISTRATOR',
91: avalue => l_admin);
92: --
93: wf_engine.SetItemOwner(
94: itemtype => l_itemtype,
95: itemkey => l_itemkey,
96: owner => l_admin);
97: --

Line 98: wf_engine.SetItemAttrText(

94: itemtype => l_itemtype,
95: itemkey => l_itemkey,
96: owner => l_admin);
97: --
98: wf_engine.SetItemAttrText(
99: itemtype => l_itemtype,
100: itemkey => l_itemkey,
101: aname => 'UOM_TYPE',
102: avalue => uom_type);

Line 104: wf_engine.SetItemAttrText(

100: itemkey => l_itemkey,
101: aname => 'UOM_TYPE',
102: avalue => uom_type);
103: --
104: wf_engine.SetItemAttrText(
105: itemtype => l_itemtype,
106: itemkey => l_itemkey,
107: aname => 'UOM_CODE',
108: avalue => uom_code);

Line 110: wf_engine.SetItemAttrNumber(

106: itemkey => l_itemkey,
107: aname => 'UOM_CODE',
108: avalue => uom_code);
109: --
110: wf_engine.SetItemAttrNumber(
111: itemtype => l_itemtype,
112: itemkey => l_itemkey,
113: aname => 'TIMER_UNITS',
114: avalue => timer_units);

Line 116: wf_engine.SetItemAttrDate(

112: itemkey => l_itemkey,
113: aname => 'TIMER_UNITS',
114: avalue => timer_units);
115: --
116: wf_engine.SetItemAttrDate(
117: itemtype => l_itemtype,
118: itemkey => l_itemkey,
119: aname => 'MONITOR_START_TIME',
120: avalue => SYSDATE);

Line 122: wf_engine.StartProcess(

118: itemkey => l_itemkey,
119: aname => 'MONITOR_START_TIME',
120: avalue => SYSDATE);
121: --
122: wf_engine.StartProcess(
123: itemtype => l_itemtype,
124: itemkey => l_itemkey);
125: --
126: COMMIT;

Line 186: wf_engine.SetItemAttrText(

182: -- RUN mode - normal process execution
183: --
184: IF (funcmode = 'RUN') THEN
185: --
186: wf_engine.SetItemAttrText(
187: itemtype => itemtype,
188: itemkey => itemkey,
189: aname => 'SUBPROCESS_NAME',
190: avalue => 'START_MONITOR');

Line 192: wf_engine.SetItemAttrText(

188: itemkey => itemkey,
189: aname => 'SUBPROCESS_NAME',
190: avalue => 'START_MONITOR');
191: --
192: wf_engine.SetItemAttrText(
193: itemtype => itemtype,
194: itemkey => itemkey,
195: aname => 'COMMAND_TYPE',
196: avalue => 'JTF_BRM_WF_COMMAND_TYPE');

Line 198: wf_engine.SetItemAttrText(

194: itemkey => itemkey,
195: aname => 'COMMAND_TYPE',
196: avalue => 'JTF_BRM_WF_COMMAND_TYPE');
197: --
198: wf_engine.SetItemAttrText(
199: itemtype => itemtype,
200: itemkey => itemkey,
201: aname => 'COMMAND_CODE',
202: avalue => 'START');

Line 204: wf_engine.SetItemAttrText(

200: itemkey => itemkey,
201: aname => 'COMMAND_CODE',
202: avalue => 'START');
203: --
204: wf_engine.SetItemAttrText(
205: itemtype => itemtype,
206: itemkey => itemkey,
207: aname => 'COMMAND',
208: avalue => 'START');

Line 210: wf_engine.SetItemAttrText(

206: itemkey => itemkey,
207: aname => 'COMMAND',
208: avalue => 'START');
209: --
210: wf_engine.SetItemAttrText(
211: itemtype => itemtype,
212: itemkey => itemkey,
213: aname => 'PROCESS_ID',
214: avalue => itemkey);

Line 331: wf_engine.SetItemAttrText(

327: -- RUN mode - normal process execution
328: --
329: IF (funcmode = 'RUN') THEN
330: --
331: wf_engine.SetItemAttrText(
332: itemtype => itemtype,
333: itemkey => itemkey,
334: aname => 'SUBPROCESS_NAME',
335: avalue => 'CALCULATE_INTERVAL');

Line 339: l_uom_type := wf_engine.GetItemAttrText(

335: avalue => 'CALCULATE_INTERVAL');
336: --
337: -- Get the timer unit of measure, and the number of units.
338: --
339: l_uom_type := wf_engine.GetItemAttrText(
340: itemtype => itemtype,
341: itemkey => itemkey,
342: aname => 'UOM_TYPE');
343: --

Line 344: l_uom_code := wf_engine.GetItemAttrText(

340: itemtype => itemtype,
341: itemkey => itemkey,
342: aname => 'UOM_TYPE');
343: --
344: l_uom_code := wf_engine.GetItemAttrText(
345: itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'UOM_CODE');
348: --

Line 349: l_timer_units := wf_engine.GetItemAttrNumber(

345: itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'UOM_CODE');
348: --
349: l_timer_units := wf_engine.GetItemAttrNumber(
350: itemtype => itemtype,
351: itemkey => itemkey,
352: aname => 'TIMER_UNITS');
353: --

Line 381: wf_engine.SetItemAttrNumber(

377: result := 'COMPLETE:CRITICAL';
378: RETURN;
379: END IF;
380: --
381: wf_engine.SetItemAttrNumber(
382: itemtype => itemtype,
383: itemkey => itemkey,
384: aname => 'TIMER_INTERVAL',
385: avalue => l_timer_interval);

Line 502: wf_engine.SetItemAttrText(

498: -- RUN mode - normal process execution
499: --
500: IF (funcmode = 'RUN') THEN
501: --
502: wf_engine.SetItemAttrText(
503: itemtype => itemtype,
504: itemkey => itemkey,
505: aname => 'SUBPROCESS_NAME',
506: avalue => 'PROCESS_RULES');

Line 508: wf_engine.SetItemAttrDate(

504: itemkey => itemkey,
505: aname => 'SUBPROCESS_NAME',
506: avalue => 'PROCESS_RULES');
507: --
508: wf_engine.SetItemAttrDate(
509: itemtype => itemtype,
510: itemkey => itemkey,
511: aname => 'PROCESS_RULES_START_TIME',
512: avalue => l_now);

Line 538: l_save_threshold := WF_ENGINE.threshold;

534: --
535: -- Temporarily overriding the defer threshold to make sure
536: -- the process is executed in the background.
537: --
538: l_save_threshold := WF_ENGINE.threshold;
539: WF_ENGINE.threshold := -1;
540: --
541: wf_engine.CreateProcess(
542: itemtype => i.workflow_item_type,

Line 539: WF_ENGINE.threshold := -1;

535: -- Temporarily overriding the defer threshold to make sure
536: -- the process is executed in the background.
537: --
538: l_save_threshold := WF_ENGINE.threshold;
539: WF_ENGINE.threshold := -1;
540: --
541: wf_engine.CreateProcess(
542: itemtype => i.workflow_item_type,
543: itemkey => l_activity_id,

Line 541: wf_engine.CreateProcess(

537: --
538: l_save_threshold := WF_ENGINE.threshold;
539: WF_ENGINE.threshold := -1;
540: --
541: wf_engine.CreateProcess(
542: itemtype => i.workflow_item_type,
543: itemkey => l_activity_id,
544: process => i.workflow_process_name);
545: --

Line 546: wf_engine.SetItemUserKey(

542: itemtype => i.workflow_item_type,
543: itemkey => l_activity_id,
544: process => i.workflow_process_name);
545: --
546: wf_engine.SetItemUserKey(
547: itemtype => i.workflow_item_type,
548: itemkey => l_activity_id,
549: userkey => l_object_type || to_char(l_object_id));
550: --

Line 551: wf_engine.SetItemAttrText(

547: itemtype => i.workflow_item_type,
548: itemkey => l_activity_id,
549: userkey => l_object_type || to_char(l_object_id));
550: --
551: wf_engine.SetItemAttrText(
552: itemtype => i.workflow_item_type,
553: itemkey => l_activity_id,
554: aname => 'PROCESS_ID',
555: avalue => itemkey);

Line 557: wf_engine.SetItemAttrText(

553: itemkey => l_activity_id,
554: aname => 'PROCESS_ID',
555: avalue => itemkey);
556: --
557: wf_engine.SetItemAttrText(
558: itemtype => i.workflow_item_type,
559: itemkey => l_activity_id,
560: aname => 'SUBPROCESS_NAME',
561: avalue => 'PROCESS_RULES');

Line 563: wf_engine.SetItemAttrText(

559: itemkey => l_activity_id,
560: aname => 'SUBPROCESS_NAME',
561: avalue => 'PROCESS_RULES');
562: --
563: wf_engine.SetItemAttrText(
564: itemtype => i.workflow_item_type,
565: itemkey => l_activity_id,
566: aname => 'OBJECT_TYPE',
567: avalue => l_object_type);

Line 569: wf_engine.SetItemAttrText(

565: itemkey => l_activity_id,
566: aname => 'OBJECT_TYPE',
567: avalue => l_object_type);
568: --
569: wf_engine.SetItemAttrText(
570: itemtype => itemtype,
571: itemkey => itemkey,
572: aname => 'OBJECT_TYPE',
573: avalue => l_object_type);

Line 575: wf_engine.SetItemAttrNumber(

571: itemkey => itemkey,
572: aname => 'OBJECT_TYPE',
573: avalue => l_object_type);
574: --
575: wf_engine.SetItemAttrNumber(
576: itemtype => i.workflow_item_type,
577: itemkey => l_activity_id,
578: aname => 'OBJECT_ID',
579: avalue => l_object_id);

Line 581: wf_engine.SetItemAttrNumber(

577: itemkey => l_activity_id,
578: aname => 'OBJECT_ID',
579: avalue => l_object_id);
580: --
581: wf_engine.SetItemAttrNumber(
582: itemtype => itemtype,
583: itemkey => itemkey,
584: aname => 'OBJECT_ID',
585: avalue => l_object_id);

Line 587: wf_engine.SetItemAttrNumber(

583: itemkey => itemkey,
584: aname => 'OBJECT_ID',
585: avalue => l_object_id);
586: --
587: wf_engine.SetItemAttrNumber(
588: itemtype => i.workflow_item_type,
589: itemkey => l_activity_id,
590: aname => 'RULE_ID',
591: avalue => i.rule_id);

Line 593: wf_engine.StartProcess(

589: itemkey => l_activity_id,
590: aname => 'RULE_ID',
591: avalue => i.rule_id);
592: --
593: wf_engine.StartProcess(
594: itemtype => i.workflow_item_type,
595: itemkey => l_activity_id);
596: --
597: -- Restoring the defer threshold

Line 599: WF_ENGINE.threshold := l_save_threshold;

595: itemkey => l_activity_id);
596: --
597: -- Restoring the defer threshold
598: --
599: WF_ENGINE.threshold := l_save_threshold;
600:
601: END LOOP;
602: CLOSE c_object;
603: END LOOP;

Line 605: wf_engine.SetItemAttrDate(

601: END LOOP;
602: CLOSE c_object;
603: END LOOP;
604: --
605: wf_engine.SetItemAttrDate(
606: itemtype => itemtype,
607: itemkey => itemkey,
608: aname => 'PROCESS_RULES_STOP_TIME',
609: avalue => SYSDATE);

Line 679: wf_engine.SetItemAttrText(

675: -- RUN mode - normal process execution
676: --
677: IF (funcmode = 'RUN') THEN
678: --
679: wf_engine.SetItemAttrText(
680: itemtype => itemtype,
681: itemkey => itemkey,
682: aname => 'SUBPROCESS_NAME',
683: avalue => 'CHECK_INTERVAL');

Line 688: l_start_time := wf_engine.GetItemAttrDate(

684: --
685: -- Get the start time and the actual interval and compute the
686: -- difference between the timer interval and the actual interval.
687: --
688: l_start_time := wf_engine.GetItemAttrDate(
689: itemtype => itemtype,
690: itemkey => itemkey,
691: aname => 'PROCESS_RULES_START_TIME');
692: --

Line 693: l_timer_interval := wf_engine.GetItemAttrNumber(

689: itemtype => itemtype,
690: itemkey => itemkey,
691: aname => 'PROCESS_RULES_START_TIME');
692: --
693: l_timer_interval := wf_engine.GetItemAttrNumber(
694: itemtype => itemtype,
695: itemkey => itemkey,
696: aname => 'TIMER_INTERVAL');
697: --

Line 705: wf_engine.SetItemAttrNumber(

701: END IF;
702: --
703: l_difference := l_timer_interval - (SYSDATE - l_start_time);
704: --
705: wf_engine.SetItemAttrNumber(
706: itemtype => itemtype,
707: itemkey => itemkey,
708: aname => 'INTERVAL_DIFF',
709: avalue => l_difference);

Line 722: wf_engine.SetItemAttrNumber(

718: --
719: -- Time allotted was enough or more than enough. Set the time to wait
720: -- before processing the next set of rules.
721: --
722: wf_engine.SetItemAttrNumber(
723: itemtype => itemtype,
724: itemkey => itemkey,
725: aname => 'WAIT_TIME',
726: avalue => l_difference);

Line 808: wf_engine.SetItemAttrText(

804: -- RUN mode - normal process execution
805: --
806: IF (funcmode = 'RUN') THEN
807: --
808: wf_engine.SetItemAttrText(
809: itemtype => itemtype,
810: itemkey => itemkey,
811: aname => 'SUBPROCESS_NAME',
812: avalue => 'GET_BRM_COMMAND');

Line 824: wf_engine.SetItemAttrText(

820: IF NOT l_found THEN
821: result := 'COMPLETE:CRITICAL';
822: RETURN;
823: ELSE
824: wf_engine.SetItemAttrText(
825: itemtype => itemtype,
826: itemkey => itemkey,
827: aname => 'COMMAND_TYPE',
828: avalue => l_command_type);

Line 830: wf_engine.SetItemAttrText(

826: itemkey => itemkey,
827: aname => 'COMMAND_TYPE',
828: avalue => l_command_type);
829: --
830: wf_engine.SetItemAttrText(
831: itemtype => itemtype,
832: itemkey => itemkey,
833: aname => 'COMMAND_CODE',
834: avalue => l_command_code);

Line 844: wf_engine.SetItemAttrText(

840: --
841: IF NOT l_found THEN
842: result := 'COMPLETE:CRITICAL';
843: ELSE
844: wf_engine.SetItemAttrText(
845: itemtype => itemtype,
846: itemkey => itemkey,
847: aname => 'COMMAND',
848: avalue => l_meaning);

Line 916: wf_engine.SetItemAttrText(

912: -- RUN mode - normal process execution
913: --
914: IF (funcmode = 'RUN') THEN
915: --
916: wf_engine.SetItemAttrText(
917: itemtype => itemtype,
918: itemkey => itemkey,
919: aname => 'SUBPROCESS_NAME',
920: avalue => 'STOP_MONITOR');

Line 922: l_command := wf_engine.GetItemAttrText(

918: itemkey => itemkey,
919: aname => 'SUBPROCESS_NAME',
920: avalue => 'STOP_MONITOR');
921: --
922: l_command := wf_engine.GetItemAttrText(
923: itemtype => itemtype,
924: itemkey => itemkey,
925: aname => 'COMMAND_CODE');
926: --

Line 928: wf_engine.SetItemAttrDate(

924: itemkey => itemkey,
925: aname => 'COMMAND_CODE');
926: --
927: IF l_command = 'STOP' THEN
928: wf_engine.SetItemAttrDate(
929: itemtype => itemtype,
930: itemkey => itemkey,
931: aname => 'MONITOR_STOP_TIME',
932: avalue => SYSDATE);