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

Line 5939: l_aname wf_engine.nametabtyp;

5935: ,P_REQUEST_ID in varchar2
5936: ,P_MFG_REL_DATE in date default null
5937: )
5938: is
5939: l_aname wf_engine.nametabtyp;
5940: l_anumvalue wf_engine.numtabtyp;
5941: l_atxtvalue wf_engine.texttabtyp;
5942: l_adatevalue wf_engine.datetabtyp;
5943: luser_key varchar2(100);

Line 5940: l_anumvalue wf_engine.numtabtyp;

5936: ,P_MFG_REL_DATE in date default null
5937: )
5938: is
5939: l_aname wf_engine.nametabtyp;
5940: l_anumvalue wf_engine.numtabtyp;
5941: l_atxtvalue wf_engine.texttabtyp;
5942: l_adatevalue wf_engine.datetabtyp;
5943: luser_key varchar2(100);
5944: litem_key varchar2(100);

Line 5941: l_atxtvalue wf_engine.texttabtyp;

5937: )
5938: is
5939: l_aname wf_engine.nametabtyp;
5940: l_anumvalue wf_engine.numtabtyp;
5941: l_atxtvalue wf_engine.texttabtyp;
5942: l_adatevalue wf_engine.datetabtyp;
5943: luser_key varchar2(100);
5944: litem_key varchar2(100);
5945: lplanner_code mtl_system_items_vl.planner_code%type;

Line 5942: l_adatevalue wf_engine.datetabtyp;

5938: is
5939: l_aname wf_engine.nametabtyp;
5940: l_anumvalue wf_engine.numtabtyp;
5941: l_atxtvalue wf_engine.texttabtyp;
5942: l_adatevalue wf_engine.datetabtyp;
5943: luser_key varchar2(100);
5944: litem_key varchar2(100);
5945: lplanner_code mtl_system_items_vl.planner_code%type;
5946:

Line 5947: l_dname wf_engine.nametabtyp;

5943: luser_key varchar2(100);
5944: litem_key varchar2(100);
5945: lplanner_code mtl_system_items_vl.planner_code%type;
5946:
5947: l_dname wf_engine.nametabtyp;
5948: porder_no number := 2222 ;
5949: pline_no number := 1111 ;
5950:
5951: lstmt_num number ;

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

6075: litem_key := litem_key || to_char( g_error_seq ) || '1111' ;
6076:
6077: oe_debug_pub.add( 'SEND_NOTIFICATION modified item_key ' || litem_key , 1 ) ;
6078:
6079: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OID_IC');
6080:
6081: elsif( P_PROCESS = 'NOTIFY_OID_INC' ) then
6082:
6083: litem_key := litem_key || to_char( g_error_seq ) || '2222' ;

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

6084:
6085: oe_debug_pub.add( 'SEND_NOTIFICATION modified item_key ' || litem_key , 1 ) ;
6086:
6087: oe_debug_pub.add( ' going to create process 2 ' || P_PROCESS ) ;
6088: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OID_INC');
6089:
6090: elsif( P_PROCESS = 'NOTIFY_OEE_INC' ) then
6091:
6092: litem_key := litem_key || to_char( g_error_seq ) || '3333' ;

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

6094: oe_debug_pub.add( 'SEND_NOTIFICATION modified item_key ' || litem_key , 1 ) ;
6095:
6096:
6097: oe_debug_pub.add( ' going to create process 3 ' || P_PROCESS ) ;
6098: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OEE_INC');
6099:
6100: elsif( P_PROCESS = 'NOTIFY_OEE_IC' ) then
6101:
6102: litem_key := litem_key || to_char(g_error_seq ) || '4444' ;

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

6105:
6106:
6107:
6108: oe_debug_pub.add( ' going to create process 4 ' || P_PROCESS ) ;
6109: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OEE_IC');
6110:
6111: end if;
6112:
6113:

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

6111: end if;
6112:
6113:
6114: lstmt_num := 60 ;
6115: wf_engine.SetItemUserKey(ItemType=> 'CTOEXCP',ItemKey=>litem_key,UserKey=>luser_key);
6116:
6117:
6118:
6119: lstmt_num := 70 ;

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

6119: lstmt_num := 70 ;
6120:
6121: IF WF_DIRECTORY.USERACTIVE(lplanner_code) <>TRUE THEN
6122: -- Get the default adminstrator value from Workflow Attributes.
6123: lplanner_code := wf_engine.getItemAttrText(ItemType => 'CTOEXCP',
6124: ItemKey => litem_key,
6125: aname => 'WF_ADMINISTRATOR');
6126: oe_debug_pub.add('start_work_flow: ' || 'Planner code is not a valid workflow user...Defaulting to'||lplanner_code,5);
6127:

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

6143:
6144:
6145: lstmt_num := 90 ;
6146:
6147: wf_engine.SetItemAttrNumber(ItemType =>'CTOEXCP',
6148: itemkey =>litem_key,
6149: aname =>'ORDER_NUM',
6150: avalue => p_sales_order_num );
6151:

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

6149: aname =>'ORDER_NUM',
6150: avalue => p_sales_order_num );
6151:
6152: lstmt_num := 100 ;
6153: wf_engine.SetItemAttrTextArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
6154:
6155: lstmt_num := 110 ;
6156: wf_engine.SetItemAttrDateArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_dname,avalue=>l_adatevalue);
6157:

Line 6156: wf_engine.SetItemAttrDateArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_dname,avalue=>l_adatevalue);

6152: lstmt_num := 100 ;
6153: wf_engine.SetItemAttrTextArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
6154:
6155: lstmt_num := 110 ;
6156: wf_engine.SetItemAttrDateArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_dname,avalue=>l_adatevalue);
6157:
6158:
6159: lstmt_num := 120 ;
6160: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);

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

6156: wf_engine.SetItemAttrDateArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_dname,avalue=>l_adatevalue);
6157:
6158:
6159: lstmt_num := 120 ;
6160: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);
6161:
6162:
6163: lstmt_num := 130 ;
6164: wf_engine.StartProcess(itemtype=>'CTOEXCP',ItemKey=>litem_key);

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

6160: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);
6161:
6162:
6163: lstmt_num := 130 ;
6164: wf_engine.StartProcess(itemtype=>'CTOEXCP',ItemKey=>litem_key);
6165:
6166:
6167: oe_debug_pub.add( ' done till stmt ' || lstmt_num ) ;
6168: