DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on WF_ENGINE

Line 299: l_aname wf_engine.nametabtyp;

295: v_option_num number := 0 ;
296:
297: l_new_line varchar2(10) := fnd_global.local_chr(10);
298:
299: l_aname wf_engine.nametabtyp;
300: l_anumvalue wf_engine.numtabtyp;
301: l_atxtvalue wf_engine.texttabtyp;
302: luser_key varchar2(100);
303: litem_key varchar2(100);

Line 300: l_anumvalue wf_engine.numtabtyp;

296:
297: l_new_line varchar2(10) := fnd_global.local_chr(10);
298:
299: l_aname wf_engine.nametabtyp;
300: l_anumvalue wf_engine.numtabtyp;
301: l_atxtvalue wf_engine.texttabtyp;
302: luser_key varchar2(100);
303: litem_key varchar2(100);
304: lplanner_code mtl_system_items_vl.planner_code%type;

Line 301: l_atxtvalue wf_engine.texttabtyp;

297: l_new_line varchar2(10) := fnd_global.local_chr(10);
298:
299: l_aname wf_engine.nametabtyp;
300: l_anumvalue wf_engine.numtabtyp;
301: l_atxtvalue wf_engine.texttabtyp;
302: luser_key varchar2(100);
303: litem_key varchar2(100);
304: lplanner_code mtl_system_items_vl.planner_code%type;
305:

Line 5182: l_aname wf_engine.nametabtyp;

5178:
5179:
5180:
5181: /*
5182: l_aname wf_engine.nametabtyp;
5183: l_anumvalue wf_engine.numtabtyp;
5184: l_atxtvalue wf_engine.texttabtyp;
5185:
5186: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');

Line 5183: l_anumvalue wf_engine.numtabtyp;

5179:
5180:
5181: /*
5182: l_aname wf_engine.nametabtyp;
5183: l_anumvalue wf_engine.numtabtyp;
5184: l_atxtvalue wf_engine.texttabtyp;
5185:
5186: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
5187: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);

Line 5184: l_atxtvalue wf_engine.texttabtyp;

5180:
5181: /*
5182: l_aname wf_engine.nametabtyp;
5183: l_anumvalue wf_engine.numtabtyp;
5184: l_atxtvalue wf_engine.texttabtyp;
5185:
5186: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
5187: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
5188:

Line 5186: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');

5182: l_aname wf_engine.nametabtyp;
5183: l_anumvalue wf_engine.numtabtyp;
5184: l_atxtvalue wf_engine.texttabtyp;
5185:
5186: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
5187: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
5188:
5189: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5190:

Line 5187: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);

5183: l_anumvalue wf_engine.numtabtyp;
5184: l_atxtvalue wf_engine.texttabtyp;
5185:
5186: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
5187: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
5188:
5189: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5190:
5191: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);

Line 5189: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);

5185:
5186: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
5187: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
5188:
5189: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5190:
5191: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
5192: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
5193: */

Line 5191: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);

5187: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
5188:
5189: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5190:
5191: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
5192: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
5193: */
5194:
5195:

Line 5192: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);

5188:
5189: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5190:
5191: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
5192: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
5193: */
5194:
5195:
5196: procedure send_oid_notification(

Line 5212: l_aname wf_engine.nametabtyp;

5208: ,P_NOTIFY_USER in varchar2
5209: ,P_REQUEST_ID in number
5210: )
5211: is
5212: l_aname wf_engine.nametabtyp;
5213: l_anumvalue wf_engine.numtabtyp;
5214: l_atxtvalue wf_engine.texttabtyp;
5215: luser_key varchar2(100);
5216: litem_key varchar2(100);

Line 5213: l_anumvalue wf_engine.numtabtyp;

5209: ,P_REQUEST_ID in number
5210: )
5211: is
5212: l_aname wf_engine.nametabtyp;
5213: l_anumvalue wf_engine.numtabtyp;
5214: l_atxtvalue wf_engine.texttabtyp;
5215: luser_key varchar2(100);
5216: litem_key varchar2(100);
5217: lplanner_code mtl_system_items_vl.planner_code%type;

Line 5214: l_atxtvalue wf_engine.texttabtyp;

5210: )
5211: is
5212: l_aname wf_engine.nametabtyp;
5213: l_anumvalue wf_engine.numtabtyp;
5214: l_atxtvalue wf_engine.texttabtyp;
5215: luser_key varchar2(100);
5216: litem_key varchar2(100);
5217: lplanner_code mtl_system_items_vl.planner_code%type;
5218:

Line 5240: lplanner_code := wf_engine.getItemAttrText(ItemType => 'CTOEXCP',

5236:
5237:
5238: IF WF_DIRECTORY.USERACTIVE(lplanner_code) <>TRUE THEN
5239: -- Get the default adminstrator value from Workflow Attributes.
5240: lplanner_code := wf_engine.getItemAttrText(ItemType => 'CTOEXCP',
5241: ItemKey => litem_key,
5242: aname => 'WF_ADMINISTRATOR');
5243: oe_debug_pub.add('start_work_flow: ' || 'Planner code is not a valid workflow user...Defaulting to'||lplanner_code,5);
5244:

Line 5293: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OID_INC');

5289: l_aname(12) := 'NOTIFY_USER';
5290: l_atxtvalue(12) := lplanner_code;
5291:
5292: lstmt_num := 50 ;
5293: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OID_INC');
5294:
5295: lstmt_num := 60 ;
5296: wf_engine.SetItemUserKey(ItemType=> 'CTOEXCP',ItemKey=>litem_key,UserKey=>luser_key);
5297:

Line 5296: wf_engine.SetItemUserKey(ItemType=> 'CTOEXCP',ItemKey=>litem_key,UserKey=>luser_key);

5292: lstmt_num := 50 ;
5293: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OID_INC');
5294:
5295: lstmt_num := 60 ;
5296: wf_engine.SetItemUserKey(ItemType=> 'CTOEXCP',ItemKey=>litem_key,UserKey=>luser_key);
5297:
5298: lstmt_num := 40 ;
5299:
5300: wf_engine.SetItemAttrNumber(ItemType =>'CTOEXCP',

Line 5300: wf_engine.SetItemAttrNumber(ItemType =>'CTOEXCP',

5296: wf_engine.SetItemUserKey(ItemType=> 'CTOEXCP',ItemKey=>litem_key,UserKey=>luser_key);
5297:
5298: lstmt_num := 40 ;
5299:
5300: wf_engine.SetItemAttrNumber(ItemType =>'CTOEXCP',
5301: itemkey =>litem_key,
5302: aname =>'ORDER_NUM',
5303: avalue => p_sales_order_num );
5304:

Line 5306: wf_engine.SetItemAttrTextArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);

5302: aname =>'ORDER_NUM',
5303: avalue => p_sales_order_num );
5304:
5305: lstmt_num := 70 ;
5306: wf_engine.SetItemAttrTextArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5307:
5308: lstmt_num := 80 ;
5309: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);
5310:

Line 5309: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);

5305: lstmt_num := 70 ;
5306: wf_engine.SetItemAttrTextArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5307:
5308: lstmt_num := 80 ;
5309: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);
5310:
5311:
5312: lstmt_num := 90 ;
5313: wf_engine.StartProcess(itemtype=>'CTOEXCP',ItemKey=>litem_key);

Line 5313: wf_engine.StartProcess(itemtype=>'CTOEXCP',ItemKey=>litem_key);

5309: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);
5310:
5311:
5312: lstmt_num := 90 ;
5313: wf_engine.StartProcess(itemtype=>'CTOEXCP',ItemKey=>litem_key);
5314:
5315:
5316: oe_debug_pub.add( ' done till stmt ' || lstmt_num ) ;
5317: