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);
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;
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:
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');
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);
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:
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:
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);
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: */
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:
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(
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);
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;
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:
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:
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:
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',
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:
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:
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);
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: