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_CHANGE_ORDER_PK dependencies on WF_ENGINE

Line 1365: --- Added by Renga Kannan on 03/23/2001 to implement the new bulk attribute setting calls for wf_engine

1361: --11/24/04 for bug 4026568
1362: lship_org_id oe_order_lines_all.ship_from_org_id%type;
1363: ldummy varchar2(1);
1364: lstmt number;
1365: --- Added by Renga Kannan on 03/23/2001 to implement the new bulk attribute setting calls for wf_engine
1366: l_aname wf_engine.nametabtyp;
1367: l_anumvalue wf_engine.numtabtyp;
1368: l_atxtvalue wf_engine.texttabtyp;
1369: -- End of additions.

Line 1366: l_aname wf_engine.nametabtyp;

1362: lship_org_id oe_order_lines_all.ship_from_org_id%type;
1363: ldummy varchar2(1);
1364: lstmt number;
1365: --- Added by Renga Kannan on 03/23/2001 to implement the new bulk attribute setting calls for wf_engine
1366: l_aname wf_engine.nametabtyp;
1367: l_anumvalue wf_engine.numtabtyp;
1368: l_atxtvalue wf_engine.texttabtyp;
1369: -- End of additions.
1370:

Line 1367: l_anumvalue wf_engine.numtabtyp;

1363: ldummy varchar2(1);
1364: lstmt number;
1365: --- Added by Renga Kannan on 03/23/2001 to implement the new bulk attribute setting calls for wf_engine
1366: l_aname wf_engine.nametabtyp;
1367: l_anumvalue wf_engine.numtabtyp;
1368: l_atxtvalue wf_engine.texttabtyp;
1369: -- End of additions.
1370:
1371: l_cancel_flag varchar2(1) := 'N';

Line 1368: l_atxtvalue wf_engine.texttabtyp;

1364: lstmt number;
1365: --- Added by Renga Kannan on 03/23/2001 to implement the new bulk attribute setting calls for wf_engine
1366: l_aname wf_engine.nametabtyp;
1367: l_anumvalue wf_engine.numtabtyp;
1368: l_atxtvalue wf_engine.texttabtyp;
1369: -- End of additions.
1370:
1371: l_cancel_flag varchar2(1) := 'N';
1372: l_header_id oe_order_lines_all.header_id%type;

Line 1387: l_aname_split wf_engine.nametabtyp;

1383: l_message_name VARCHAR2(30);/* 30 bytes to hold name */
1384:
1385:
1386: --- Added by ssawant for split
1387: l_aname_split wf_engine.nametabtyp;
1388: l_atxtvalue_split wf_engine.texttabtyp;
1389:
1390: v_split_line_id number ;
1391: v_split_qty number ;

Line 1388: l_atxtvalue_split wf_engine.texttabtyp;

1384:
1385:
1386: --- Added by ssawant for split
1387: l_aname_split wf_engine.nametabtyp;
1388: l_atxtvalue_split wf_engine.texttabtyp;
1389:
1390: v_split_line_id number ;
1391: v_split_qty number ;
1392: v_split_index number ;

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

1881: -- Loop through the change type pl/sql record and set the workflow attributes according to the
1882: -- changes from Order Management
1883:
1884: lstmt := 60;
1885: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
1886: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
1887:
1888: -- Check if the planner code is a valid workflow user. If not
1889: -- Assigne the adminstartor uesr to planner code

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

1882: -- changes from Order Management
1883:
1884: lstmt := 60;
1885: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
1886: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
1887:
1888: -- Check if the planner code is a valid workflow user. If not
1889: -- Assigne the adminstartor uesr to planner code
1890:

Line 1897: lplanner_code := wf_engine.getItemAttrText(ItemType => 'CTOCHORD',

1893: -- getting the adminstrator value from attributes.
1894:
1895: IF WF_DIRECTORY.USERACTIVE(lplanner_code) <>TRUE THEN
1896: -- Get the default adminstrator value from Workflow Attributes.
1897: lplanner_code := wf_engine.getItemAttrText(ItemType => 'CTOCHORD',
1898: ItemKey => litem_key,
1899: aname => 'WF_ADMINISTRATOR');
1900: IF PG_DEBUG <> 0 THEN
1901: oe_debug_pub.add('start_work_flow: ' || 'Planner code is not a valid workflow user...Defaulting to'||lplanner_code,5);

Line 2167: wf_engine.SetItemAttrNumber(ItemType =>'CTOCHORD',

2163: END IF;
2164:
2165: lstmt := 70;
2166:
2167: wf_engine.SetItemAttrNumber(ItemType =>'CTOCHORD',
2168: itemkey =>litem_key,
2169: aname =>'SO_NUMBER',
2170: avalue =>porder_no);
2171:

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

2346: --ENDED CODE FOR ML SUPPLY
2347:
2348:
2349: lstmt := 81;
2350: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
2351:
2352: -- Added by Renga on 02/17/01
2353: -- Set the special text attribute to null in case of SL/SO. This special text needs to be
2354: -- Displayed only in the case of ML/MO. In the case of ML/MO we need not set this attribute . This

Line 2363: wf_engine.SetItemAttrText(ItemType=>'CTOCHORD',itemkey=>litem_key,aname=>'SPL_TEXT',avalue=>'');

2359: oe_debug_pub.add('start_work_flow: ' || 'Single level single org model, Special text is set to Null',5);
2360: END IF;
2361:
2362: lstmt := 82;
2363: wf_engine.SetItemAttrText(ItemType=>'CTOCHORD',itemkey=>litem_key,aname=>'SPL_TEXT',avalue=>'');
2364:
2365: END IF;
2366:
2367: -- Calling the work flow

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

2368: lstmt := 80;
2369: IF PG_DEBUG <> 0 THEN
2370: oe_debug_pub.add('start_work_flow: ' || 'Starting the workflow...',2);
2371: END IF;
2372: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
2373: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
2374:
2375: IF PG_DEBUG <> 0 THEN
2376: oe_debug_pub.add('start_work_flow: ' || 'success from ..... notification....',5);

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

2369: IF PG_DEBUG <> 0 THEN
2370: oe_debug_pub.add('start_work_flow: ' || 'Starting the workflow...',2);
2371: END IF;
2372: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
2373: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
2374:
2375: IF PG_DEBUG <> 0 THEN
2376: oe_debug_pub.add('start_work_flow: ' || 'success from ..... notification....',5);
2377: END IF;