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

Line 5519: -- For setting WF engine threshold

5515: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.launch_flwsts_wf';
5516: lc_api_name CONSTANT VARCHAR2(30) := 'Launch_Flwsts_Wf';
5517: lc_api_version CONSTANT NUMBER := 1.0;
5518:
5519: -- For setting WF engine threshold
5520: lc_wf_negative_threshold CONSTANT NUMBER := -1;
5521:
5522: -- For WF Item Attributes
5523: lc_repair_line_id CONSTANT VARCHAR2(30) := 'CSD_REPAIR_LINE_ID';

Line 5532: l_wf_aname_TabType Wf_Engine.NameTabTyp;

5528:
5529: -- VARIABLES --
5530: l_wf_current_threshold NUMBER := NULL;
5531:
5532: l_wf_aname_TabType Wf_Engine.NameTabTyp;
5533: l_wf_avalue_TabType Wf_Engine.NumTabTyp;
5534:
5535: BEGIN
5536:

Line 5533: l_wf_avalue_TabType Wf_Engine.NumTabTyp;

5529: -- VARIABLES --
5530: l_wf_current_threshold NUMBER := NULL;
5531:
5532: l_wf_aname_TabType Wf_Engine.NameTabTyp;
5533: l_wf_avalue_TabType Wf_Engine.NumTabTyp;
5534:
5535: BEGIN
5536:
5537: -- Standard Start of API savepoint

Line 5612: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing

5608: p_param_name => 'WF_PROCESS_NAME',
5609: p_api_name => lc_api_name);
5610:
5611: -- Get the current threshold
5612: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing
5613: -- l_wf_current_threshold := Wf_Engine.threshold;
5614:
5615: -- Defer the wf process
5616: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing

Line 5613: -- l_wf_current_threshold := Wf_Engine.threshold;

5609: p_api_name => lc_api_name);
5610:
5611: -- Get the current threshold
5612: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing
5613: -- l_wf_current_threshold := Wf_Engine.threshold;
5614:
5615: -- Defer the wf process
5616: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing
5617: -- Wf_Engine.threshold := lc_wf_negative_threshold;

Line 5616: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing

5612: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing
5613: -- l_wf_current_threshold := Wf_Engine.threshold;
5614:
5615: -- Defer the wf process
5616: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing
5617: -- Wf_Engine.threshold := lc_wf_negative_threshold;
5618:
5619: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5620: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

Line 5617: -- Wf_Engine.threshold := lc_wf_negative_threshold;

5613: -- l_wf_current_threshold := Wf_Engine.threshold;
5614:
5615: -- Defer the wf process
5616: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing
5617: -- Wf_Engine.threshold := lc_wf_negative_threshold;
5618:
5619: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5620: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5621: 'Calling WF_ENGINE.CreateProcess');

Line 5621: 'Calling WF_ENGINE.CreateProcess');

5617: -- Wf_Engine.threshold := lc_wf_negative_threshold;
5618:
5619: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5620: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5621: 'Calling WF_ENGINE.CreateProcess');
5622: END IF;
5623:
5624: Wf_Engine.CreateProcess(itemtype => p_flwsts_wf_rec.wf_item_type,
5625: itemkey => p_flwsts_wf_rec.wf_item_key,

Line 5624: Wf_Engine.CreateProcess(itemtype => p_flwsts_wf_rec.wf_item_type,

5620: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5621: 'Calling WF_ENGINE.CreateProcess');
5622: END IF;
5623:
5624: Wf_Engine.CreateProcess(itemtype => p_flwsts_wf_rec.wf_item_type,
5625: itemkey => p_flwsts_wf_rec.wf_item_key,
5626: process => p_flwsts_wf_rec.wf_process_name --,
5627: -- user_key => NULL,
5628: -- owner_role => NULL

Line 5648: 'Calling WF_ENGINE.AddItemAttrNumberArray to add attributes');

5644: l_wf_avalue_TabType(5) := p_flwsts_wf_rec.object_version_number;
5645:
5646: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5647: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5648: 'Calling WF_ENGINE.AddItemAttrNumberArray to add attributes');
5649: END IF;
5650:
5651: Wf_Engine.AddItemAttrNumberArray(itemtype => p_flwsts_wf_rec.wf_item_type,
5652: itemkey => p_flwsts_wf_rec.wf_item_key,

Line 5651: Wf_Engine.AddItemAttrNumberArray(itemtype => p_flwsts_wf_rec.wf_item_type,

5647: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5648: 'Calling WF_ENGINE.AddItemAttrNumberArray to add attributes');
5649: END IF;
5650:
5651: Wf_Engine.AddItemAttrNumberArray(itemtype => p_flwsts_wf_rec.wf_item_type,
5652: itemkey => p_flwsts_wf_rec.wf_item_key,
5653: aname => l_wf_aname_TabType,
5654: avalue => l_wf_avalue_TabType
5655: );

Line 5659: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,

5655: );
5656:
5657:
5658: /*
5659: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,
5660: itemkey => p_flwsts_wf_rec.wf_item_key,
5661: aname => lc_repair_line_id,
5662: number_value => p_flwsts_wf_rec.repair_line_id
5663: );

Line 5665: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,

5661: aname => lc_repair_line_id,
5662: number_value => p_flwsts_wf_rec.repair_line_id
5663: );
5664:
5665: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,
5666: itemkey => p_flwsts_wf_rec.wf_item_key,
5667: aname => lc_repair_type_id,
5668: number_value => p_flwsts_wf_rec.repair_type_id
5669: );

Line 5671: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,

5667: aname => lc_repair_type_id,
5668: number_value => p_flwsts_wf_rec.repair_type_id
5669: );
5670:
5671: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,
5672: itemkey => p_flwsts_wf_rec.wf_item_key,
5673: aname => lc_from_flow_status_id,
5674: number_value => p_flwsts_wf_rec.from_flow_status_id
5675: );

Line 5677: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,

5673: aname => lc_from_flow_status_id,
5674: number_value => p_flwsts_wf_rec.from_flow_status_id
5675: );
5676:
5677: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,
5678: itemkey => p_flwsts_wf_rec.wf_item_key,
5679: aname => lc_to_flow_status_id,
5680: number_value => p_flwsts_wf_rec.to_flow_status_id
5681: );

Line 5683: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,

5679: aname => lc_to_flow_status_id,
5680: number_value => p_flwsts_wf_rec.to_flow_status_id
5681: );
5682:
5683: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,
5684: itemkey => p_flwsts_wf_rec.wf_item_key,
5685: aname => lc_object_version_number,
5686: number_value => p_flwsts_wf_rec.object_version_number
5687: );

Line 5692: 'Calling WF_ENGINE.StartProcess');

5688: */
5689:
5690: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5691: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5692: 'Calling WF_ENGINE.StartProcess');
5693: END IF;
5694:
5695: -- The WF process is kicked off now in deferred mode
5696: Wf_Engine.StartProcess(itemtype => p_flwsts_wf_rec.wf_item_type,

Line 5696: Wf_Engine.StartProcess(itemtype => p_flwsts_wf_rec.wf_item_type,

5692: 'Calling WF_ENGINE.StartProcess');
5693: END IF;
5694:
5695: -- The WF process is kicked off now in deferred mode
5696: Wf_Engine.StartProcess(itemtype => p_flwsts_wf_rec.wf_item_type,
5697: itemkey => p_flwsts_wf_rec.wf_item_key
5698: );
5699:
5700:

Line 5703: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing

5699:
5700:
5701: -- Set engine to orginal threshold.
5702: -- Otherwise all WF process in this session will be deferred.
5703: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing
5704: -- Wf_Engine.threshold := l_wf_current_threshold;
5705:
5706: -- Api body ends here
5707:

Line 5704: -- Wf_Engine.threshold := l_wf_current_threshold;

5700:
5701: -- Set engine to orginal threshold.
5702: -- Otherwise all WF process in this session will be deferred.
5703: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing
5704: -- Wf_Engine.threshold := l_wf_current_threshold;
5705:
5706: -- Api body ends here
5707:
5708: -- Standard check of p_commit.

Line 6090: /* step must be performed. A call to wf_engine.CompleteActivty */

6086: /* - DEFERED */
6087: /* execution should be defered to background */
6088: /* - NOTIFIED[::] */
6089: /* activity has notified an external entity that this */
6090: /* step must be performed. A call to wf_engine.CompleteActivty */
6091: /* will signal when this step is complete. Optional */
6092: /* return of notification ID and assigned user. */
6093: /* - ERROR[:] */
6094: /* function encountered an error. */