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

5911: ,P_REQUEST_ID in varchar2
5912: ,P_MFG_REL_DATE in date default null
5913: )
5914: is
5915: l_aname wf_engine.nametabtyp;
5916: l_anumvalue wf_engine.numtabtyp;
5917: l_atxtvalue wf_engine.texttabtyp;
5918: l_adatevalue wf_engine.datetabtyp;
5919: luser_key varchar2(100);

Line 5916: l_anumvalue wf_engine.numtabtyp;

5912: ,P_MFG_REL_DATE in date default null
5913: )
5914: is
5915: l_aname wf_engine.nametabtyp;
5916: l_anumvalue wf_engine.numtabtyp;
5917: l_atxtvalue wf_engine.texttabtyp;
5918: l_adatevalue wf_engine.datetabtyp;
5919: luser_key varchar2(100);
5920: litem_key varchar2(100);

Line 5917: l_atxtvalue wf_engine.texttabtyp;

5913: )
5914: is
5915: l_aname wf_engine.nametabtyp;
5916: l_anumvalue wf_engine.numtabtyp;
5917: l_atxtvalue wf_engine.texttabtyp;
5918: l_adatevalue wf_engine.datetabtyp;
5919: luser_key varchar2(100);
5920: litem_key varchar2(100);
5921: lplanner_code mtl_system_items_vl.planner_code%type;

Line 5918: l_adatevalue wf_engine.datetabtyp;

5914: is
5915: l_aname wf_engine.nametabtyp;
5916: l_anumvalue wf_engine.numtabtyp;
5917: l_atxtvalue wf_engine.texttabtyp;
5918: l_adatevalue wf_engine.datetabtyp;
5919: luser_key varchar2(100);
5920: litem_key varchar2(100);
5921: lplanner_code mtl_system_items_vl.planner_code%type;
5922:

Line 5923: l_dname wf_engine.nametabtyp;

5919: luser_key varchar2(100);
5920: litem_key varchar2(100);
5921: lplanner_code mtl_system_items_vl.planner_code%type;
5922:
5923: l_dname wf_engine.nametabtyp;
5924: porder_no number := 2222 ;
5925: pline_no number := 1111 ;
5926:
5927: lstmt_num number ;

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

6051: litem_key := litem_key || to_char( g_error_seq ) || '1111' ;
6052:
6053: oe_debug_pub.add( 'SEND_NOTIFICATION modified item_key ' || litem_key , 1 ) ;
6054:
6055: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OID_IC');
6056:
6057: elsif( P_PROCESS = 'NOTIFY_OID_INC' ) then
6058:
6059: litem_key := litem_key || to_char( g_error_seq ) || '2222' ;

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

6060:
6061: oe_debug_pub.add( 'SEND_NOTIFICATION modified item_key ' || litem_key , 1 ) ;
6062:
6063: oe_debug_pub.add( ' going to create process 2 ' || P_PROCESS ) ;
6064: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OID_INC');
6065:
6066: elsif( P_PROCESS = 'NOTIFY_OEE_INC' ) then
6067:
6068: litem_key := litem_key || to_char( g_error_seq ) || '3333' ;

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

6070: oe_debug_pub.add( 'SEND_NOTIFICATION modified item_key ' || litem_key , 1 ) ;
6071:
6072:
6073: oe_debug_pub.add( ' going to create process 3 ' || P_PROCESS ) ;
6074: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OEE_INC');
6075:
6076: elsif( P_PROCESS = 'NOTIFY_OEE_IC' ) then
6077:
6078: litem_key := litem_key || to_char(g_error_seq ) || '4444' ;

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

6081:
6082:
6083:
6084: oe_debug_pub.add( ' going to create process 4 ' || P_PROCESS ) ;
6085: wf_engine.CreateProcess (ItemType=> 'CTOEXCP',ItemKey=>litem_key,Process=>'NOTIFY_OEE_IC');
6086:
6087: end if;
6088:
6089:

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

6087: end if;
6088:
6089:
6090: lstmt_num := 60 ;
6091: wf_engine.SetItemUserKey(ItemType=> 'CTOEXCP',ItemKey=>litem_key,UserKey=>luser_key);
6092:
6093:
6094:
6095: lstmt_num := 70 ;

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

6095: lstmt_num := 70 ;
6096:
6097: IF WF_DIRECTORY.USERACTIVE(lplanner_code) <>TRUE THEN
6098: -- Get the default adminstrator value from Workflow Attributes.
6099: lplanner_code := wf_engine.getItemAttrText(ItemType => 'CTOEXCP',
6100: ItemKey => litem_key,
6101: aname => 'WF_ADMINISTRATOR');
6102: oe_debug_pub.add('start_work_flow: ' || 'Planner code is not a valid workflow user...Defaulting to'||lplanner_code,5);
6103:

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

6119:
6120:
6121: lstmt_num := 90 ;
6122:
6123: wf_engine.SetItemAttrNumber(ItemType =>'CTOEXCP',
6124: itemkey =>litem_key,
6125: aname =>'ORDER_NUM',
6126: avalue => p_sales_order_num );
6127:

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

6125: aname =>'ORDER_NUM',
6126: avalue => p_sales_order_num );
6127:
6128: lstmt_num := 100 ;
6129: wf_engine.SetItemAttrTextArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
6130:
6131: lstmt_num := 110 ;
6132: wf_engine.SetItemAttrDateArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_dname,avalue=>l_adatevalue);
6133:

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

6128: lstmt_num := 100 ;
6129: wf_engine.SetItemAttrTextArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
6130:
6131: lstmt_num := 110 ;
6132: wf_engine.SetItemAttrDateArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_dname,avalue=>l_adatevalue);
6133:
6134:
6135: lstmt_num := 120 ;
6136: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);

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

6132: wf_engine.SetItemAttrDateArray(ItemType =>'CTOEXCP',ItemKey=>litem_key,aname=>l_dname,avalue=>l_adatevalue);
6133:
6134:
6135: lstmt_num := 120 ;
6136: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);
6137:
6138:
6139: lstmt_num := 130 ;
6140: wf_engine.StartProcess(itemtype=>'CTOEXCP',ItemKey=>litem_key);

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

6136: wf_engine.SetItemOwner(Itemtype=>'CTOEXCP',itemkey=>litem_key,owner=>lplanner_code);
6137:
6138:
6139: lstmt_num := 130 ;
6140: wf_engine.StartProcess(itemtype=>'CTOEXCP',ItemKey=>litem_key);
6141:
6142:
6143: oe_debug_pub.add( ' done till stmt ' || lstmt_num ) ;
6144: