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 5494: l_aname wf_engine.nametabtyp;

5490:
5491:
5492:
5493: /*
5494: l_aname wf_engine.nametabtyp;
5495: l_anumvalue wf_engine.numtabtyp;
5496: l_atxtvalue wf_engine.texttabtyp;
5497:
5498: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');

Line 5495: l_anumvalue wf_engine.numtabtyp;

5491:
5492:
5493: /*
5494: l_aname wf_engine.nametabtyp;
5495: l_anumvalue wf_engine.numtabtyp;
5496: l_atxtvalue wf_engine.texttabtyp;
5497:
5498: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
5499: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);

Line 5496: l_atxtvalue wf_engine.texttabtyp;

5492:
5493: /*
5494: l_aname wf_engine.nametabtyp;
5495: l_anumvalue wf_engine.numtabtyp;
5496: l_atxtvalue wf_engine.texttabtyp;
5497:
5498: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
5499: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
5500:

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

5494: l_aname wf_engine.nametabtyp;
5495: l_anumvalue wf_engine.numtabtyp;
5496: l_atxtvalue wf_engine.texttabtyp;
5497:
5498: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
5499: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
5500:
5501: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5502:

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

5495: l_anumvalue wf_engine.numtabtyp;
5496: l_atxtvalue wf_engine.texttabtyp;
5497:
5498: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
5499: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
5500:
5501: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5502:
5503: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);

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

5497:
5498: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
5499: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
5500:
5501: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5502:
5503: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
5504: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
5505: */

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

5499: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
5500:
5501: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5502:
5503: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
5504: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
5505: */
5506:
5507:

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

5500:
5501: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5502:
5503: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
5504: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
5505: */
5506:
5507:
5508: procedure send_oid_notification(

Line 5524: l_aname wf_engine.nametabtyp;

5520: ,P_NOTIFY_USER in varchar2
5521: ,P_REQUEST_ID in number
5522: )
5523: is
5524: l_aname wf_engine.nametabtyp;
5525: l_anumvalue wf_engine.numtabtyp;
5526: l_atxtvalue wf_engine.texttabtyp;
5527: luser_key varchar2(100);
5528: litem_key varchar2(100);

Line 5525: l_anumvalue wf_engine.numtabtyp;

5521: ,P_REQUEST_ID in number
5522: )
5523: is
5524: l_aname wf_engine.nametabtyp;
5525: l_anumvalue wf_engine.numtabtyp;
5526: l_atxtvalue wf_engine.texttabtyp;
5527: luser_key varchar2(100);
5528: litem_key varchar2(100);
5529: lplanner_code mtl_system_items_vl.planner_code%type;

Line 5526: l_atxtvalue wf_engine.texttabtyp;

5522: )
5523: is
5524: l_aname wf_engine.nametabtyp;
5525: l_anumvalue wf_engine.numtabtyp;
5526: l_atxtvalue wf_engine.texttabtyp;
5527: luser_key varchar2(100);
5528: litem_key varchar2(100);
5529: lplanner_code mtl_system_items_vl.planner_code%type;
5530:

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

5548:
5549:
5550: IF WF_DIRECTORY.USERACTIVE(lplanner_code) <>TRUE THEN
5551: -- Get the default adminstrator value from Workflow Attributes.
5552: lplanner_code := wf_engine.getItemAttrText(ItemType => 'CTOEXCP',
5553: ItemKey => litem_key,
5554: aname => 'WF_ADMINISTRATOR');
5555: oe_debug_pub.add('start_work_flow: ' || 'Planner code is not a valid workflow user...Defaulting to'||lplanner_code,5);
5556:

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

5601: l_aname(12) := 'NOTIFY_USER';
5602: l_atxtvalue(12) := lplanner_code;
5603:
5604: lstmt_num := 50 ;
5605: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OID_INC');
5606:
5607: lstmt_num := 60 ;
5608: wf_engine.SetItemUserKey(ItemType=> 'CTOEXCP',ItemKey=>litem_key,UserKey=>luser_key);
5609:

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

5604: lstmt_num := 50 ;
5605: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OID_INC');
5606:
5607: lstmt_num := 60 ;
5608: wf_engine.SetItemUserKey(ItemType=> 'CTOEXCP',ItemKey=>litem_key,UserKey=>luser_key);
5609:
5610: lstmt_num := 40 ;
5611:
5612: wf_engine.SetItemAttrNumber(ItemType =>'CTOEXCP',

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

5608: wf_engine.SetItemUserKey(ItemType=> 'CTOEXCP',ItemKey=>litem_key,UserKey=>luser_key);
5609:
5610: lstmt_num := 40 ;
5611:
5612: wf_engine.SetItemAttrNumber(ItemType =>'CTOEXCP',
5613: itemkey =>litem_key,
5614: aname =>'ORDER_NUM',
5615: avalue => p_sales_order_num );
5616:

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

5614: aname =>'ORDER_NUM',
5615: avalue => p_sales_order_num );
5616:
5617: lstmt_num := 70 ;
5618: wf_engine.SetItemAttrTextArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5619:
5620: lstmt_num := 80 ;
5621: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);
5622:

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

5617: lstmt_num := 70 ;
5618: wf_engine.SetItemAttrTextArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
5619:
5620: lstmt_num := 80 ;
5621: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);
5622:
5623:
5624: lstmt_num := 90 ;
5625: wf_engine.StartProcess(itemtype=>'CTOEXCP',ItemKey=>litem_key);

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

5621: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);
5622:
5623:
5624: lstmt_num := 90 ;
5625: wf_engine.StartProcess(itemtype=>'CTOEXCP',ItemKey=>litem_key);
5626:
5627:
5628: oe_debug_pub.add( ' done till stmt ' || lstmt_num ) ;
5629: