DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on WF_ENGINE

Line 5211: -- For setting WF engine threshold

5207: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.launch_flwsts_wf';
5208: lc_api_name CONSTANT VARCHAR2(30) := 'Launch_Flwsts_Wf';
5209: lc_api_version CONSTANT NUMBER := 1.0;
5210:
5211: -- For setting WF engine threshold
5212: lc_wf_negative_threshold CONSTANT NUMBER := -1;
5213:
5214: -- For WF Item Attributes
5215: lc_repair_line_id CONSTANT VARCHAR2(30) := 'CSD_REPAIR_LINE_ID';

Line 5224: l_wf_aname_TabType Wf_Engine.NameTabTyp;

5220:
5221: -- VARIABLES --
5222: l_wf_current_threshold NUMBER := NULL;
5223:
5224: l_wf_aname_TabType Wf_Engine.NameTabTyp;
5225: l_wf_avalue_TabType Wf_Engine.NumTabTyp;
5226:
5227: BEGIN
5228:

Line 5225: l_wf_avalue_TabType Wf_Engine.NumTabTyp;

5221: -- VARIABLES --
5222: l_wf_current_threshold NUMBER := NULL;
5223:
5224: l_wf_aname_TabType Wf_Engine.NameTabTyp;
5225: l_wf_avalue_TabType Wf_Engine.NumTabTyp;
5226:
5227: BEGIN
5228:
5229: -- Standard Start of API savepoint

Line 5304: l_wf_current_threshold := Wf_Engine.threshold;

5300: p_param_name => 'WF_PROCESS_NAME',
5301: p_api_name => lc_api_name);
5302:
5303: -- Get the current threshold
5304: l_wf_current_threshold := Wf_Engine.threshold;
5305:
5306: -- Defer the wf process
5307: Wf_Engine.threshold := lc_wf_negative_threshold;
5308:

Line 5307: Wf_Engine.threshold := lc_wf_negative_threshold;

5303: -- Get the current threshold
5304: l_wf_current_threshold := Wf_Engine.threshold;
5305:
5306: -- Defer the wf process
5307: Wf_Engine.threshold := lc_wf_negative_threshold;
5308:
5309: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5310: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5311: 'Calling WF_ENGINE.CreateProcess');

Line 5311: 'Calling WF_ENGINE.CreateProcess');

5307: Wf_Engine.threshold := lc_wf_negative_threshold;
5308:
5309: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5310: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5311: 'Calling WF_ENGINE.CreateProcess');
5312: END IF;
5313:
5314: Wf_Engine.CreateProcess(itemtype => p_flwsts_wf_rec.wf_item_type,
5315: itemkey => p_flwsts_wf_rec.wf_item_key,

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

5310: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5311: 'Calling WF_ENGINE.CreateProcess');
5312: END IF;
5313:
5314: Wf_Engine.CreateProcess(itemtype => p_flwsts_wf_rec.wf_item_type,
5315: itemkey => p_flwsts_wf_rec.wf_item_key,
5316: process => p_flwsts_wf_rec.wf_process_name --,
5317: -- user_key => NULL,
5318: -- owner_role => NULL

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

5334: l_wf_avalue_TabType(5) := p_flwsts_wf_rec.object_version_number;
5335:
5336: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5337: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5338: 'Calling WF_ENGINE.AddItemAttrNumberArray to add attributes');
5339: END IF;
5340:
5341: Wf_Engine.AddItemAttrNumberArray(itemtype => p_flwsts_wf_rec.wf_item_type,
5342: itemkey => p_flwsts_wf_rec.wf_item_key,

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

5337: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5338: 'Calling WF_ENGINE.AddItemAttrNumberArray to add attributes');
5339: END IF;
5340:
5341: Wf_Engine.AddItemAttrNumberArray(itemtype => p_flwsts_wf_rec.wf_item_type,
5342: itemkey => p_flwsts_wf_rec.wf_item_key,
5343: aname => l_wf_aname_TabType,
5344: avalue => l_wf_avalue_TabType
5345: );

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

5345: );
5346:
5347:
5348: /*
5349: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,
5350: itemkey => p_flwsts_wf_rec.wf_item_key,
5351: aname => lc_repair_line_id,
5352: number_value => p_flwsts_wf_rec.repair_line_id
5353: );

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

5351: aname => lc_repair_line_id,
5352: number_value => p_flwsts_wf_rec.repair_line_id
5353: );
5354:
5355: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,
5356: itemkey => p_flwsts_wf_rec.wf_item_key,
5357: aname => lc_repair_type_id,
5358: number_value => p_flwsts_wf_rec.repair_type_id
5359: );

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

5357: aname => lc_repair_type_id,
5358: number_value => p_flwsts_wf_rec.repair_type_id
5359: );
5360:
5361: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,
5362: itemkey => p_flwsts_wf_rec.wf_item_key,
5363: aname => lc_from_flow_status_id,
5364: number_value => p_flwsts_wf_rec.from_flow_status_id
5365: );

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

5363: aname => lc_from_flow_status_id,
5364: number_value => p_flwsts_wf_rec.from_flow_status_id
5365: );
5366:
5367: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,
5368: itemkey => p_flwsts_wf_rec.wf_item_key,
5369: aname => lc_to_flow_status_id,
5370: number_value => p_flwsts_wf_rec.to_flow_status_id
5371: );

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

5369: aname => lc_to_flow_status_id,
5370: number_value => p_flwsts_wf_rec.to_flow_status_id
5371: );
5372:
5373: WF_ENGINE.AddItemAttr (itemtype => p_flwsts_wf_rec.wf_item_type,
5374: itemkey => p_flwsts_wf_rec.wf_item_key,
5375: aname => lc_object_version_number,
5376: number_value => p_flwsts_wf_rec.object_version_number
5377: );

Line 5382: 'Calling WF_ENGINE.StartProcess');

5378: */
5379:
5380: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5381: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5382: 'Calling WF_ENGINE.StartProcess');
5383: END IF;
5384:
5385: -- The WF process is kicked off now in deferred mode
5386: Wf_Engine.StartProcess(itemtype => p_flwsts_wf_rec.wf_item_type,

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

5382: 'Calling WF_ENGINE.StartProcess');
5383: END IF;
5384:
5385: -- The WF process is kicked off now in deferred mode
5386: Wf_Engine.StartProcess(itemtype => p_flwsts_wf_rec.wf_item_type,
5387: itemkey => p_flwsts_wf_rec.wf_item_key
5388: );
5389:
5390:

Line 5393: Wf_Engine.threshold := l_wf_current_threshold;

5389:
5390:
5391: -- Set engine to orginal threshold.
5392: -- Otherwise all WF process in this session will be deferred.
5393: Wf_Engine.threshold := l_wf_current_threshold;
5394:
5395: -- Api body ends here
5396:
5397: -- Standard check of p_commit.

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

5775: /* - DEFERED */
5776: /* execution should be defered to background */
5777: /* - NOTIFIED[::] */
5778: /* activity has notified an external entity that this */
5779: /* step must be performed. A call to wf_engine.CompleteActivty */
5780: /* will signal when this step is complete. Optional */
5781: /* return of notification ID and assigned user. */
5782: /* - ERROR[:] */
5783: /* function encountered an error. */