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.

[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on WF_ENGINE

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

1341: --11/24/04 for bug 4026568
1342: lship_org_id oe_order_lines_all.ship_from_org_id%type;
1343: ldummy varchar2(1);
1344: lstmt number;
1345: --- Added by Renga Kannan on 03/23/2001 to implement the new bulk attribute setting calls for wf_engine
1346: l_aname wf_engine.nametabtyp;
1347: l_anumvalue wf_engine.numtabtyp;
1348: l_atxtvalue wf_engine.texttabtyp;
1349: -- End of additions.

Line 1346: l_aname wf_engine.nametabtyp;

1342: lship_org_id oe_order_lines_all.ship_from_org_id%type;
1343: ldummy varchar2(1);
1344: lstmt number;
1345: --- Added by Renga Kannan on 03/23/2001 to implement the new bulk attribute setting calls for wf_engine
1346: l_aname wf_engine.nametabtyp;
1347: l_anumvalue wf_engine.numtabtyp;
1348: l_atxtvalue wf_engine.texttabtyp;
1349: -- End of additions.
1350:

Line 1347: l_anumvalue wf_engine.numtabtyp;

1343: ldummy varchar2(1);
1344: lstmt number;
1345: --- Added by Renga Kannan on 03/23/2001 to implement the new bulk attribute setting calls for wf_engine
1346: l_aname wf_engine.nametabtyp;
1347: l_anumvalue wf_engine.numtabtyp;
1348: l_atxtvalue wf_engine.texttabtyp;
1349: -- End of additions.
1350:
1351: l_cancel_flag varchar2(1) := 'N';

Line 1348: l_atxtvalue wf_engine.texttabtyp;

1344: lstmt number;
1345: --- Added by Renga Kannan on 03/23/2001 to implement the new bulk attribute setting calls for wf_engine
1346: l_aname wf_engine.nametabtyp;
1347: l_anumvalue wf_engine.numtabtyp;
1348: l_atxtvalue wf_engine.texttabtyp;
1349: -- End of additions.
1350:
1351: l_cancel_flag varchar2(1) := 'N';
1352: l_header_id oe_order_lines_all.header_id%type;

Line 1367: l_aname_split wf_engine.nametabtyp;

1363: l_message_name VARCHAR2(30);/* 30 bytes to hold name */
1364:
1365:
1366: --- Added by ssawant for split
1367: l_aname_split wf_engine.nametabtyp;
1368: l_atxtvalue_split wf_engine.texttabtyp;
1369:
1370: v_split_line_id number ;
1371: v_split_qty number ;

Line 1368: l_atxtvalue_split wf_engine.texttabtyp;

1364:
1365:
1366: --- Added by ssawant for split
1367: l_aname_split wf_engine.nametabtyp;
1368: l_atxtvalue_split wf_engine.texttabtyp;
1369:
1370: v_split_line_id number ;
1371: v_split_qty number ;
1372: v_split_index number ;

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

1680: -- Loop through the change type pl/sql record and set the workflow attributes according to the
1681: -- changes from Order Management
1682:
1683: lstmt := 60;
1684: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
1685: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
1686:
1687: -- Check if the planner code is a valid workflow user. If not
1688: -- Assigne the adminstartor uesr to planner code

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

1681: -- changes from Order Management
1682:
1683: lstmt := 60;
1684: wf_engine.CreateProcess (ItemType=> 'CTOCHORD',ItemKey=>litem_key,Process=>'CHGNOTIFY');
1685: wf_engine.SetItemUserKey(ItemType=> 'CTOCHORD',ItemKey=>litem_key,UserKey=>luser_key);
1686:
1687: -- Check if the planner code is a valid workflow user. If not
1688: -- Assigne the adminstartor uesr to planner code
1689:

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

1692: -- getting the adminstrator value from attributes.
1693:
1694: IF WF_DIRECTORY.USERACTIVE(lplanner_code) <>TRUE THEN
1695: -- Get the default adminstrator value from Workflow Attributes.
1696: lplanner_code := wf_engine.getItemAttrText(ItemType => 'CTOCHORD',
1697: ItemKey => litem_key,
1698: aname => 'WF_ADMINISTRATOR');
1699: IF PG_DEBUG <> 0 THEN
1700: oe_debug_pub.add('start_work_flow: ' || 'Planner code is not a valid workflow user...Defaulting to'||lplanner_code,5);

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

1962: END IF;
1963:
1964: lstmt := 70;
1965:
1966: wf_engine.SetItemAttrNumber(ItemType =>'CTOCHORD',
1967: itemkey =>litem_key,
1968: aname =>'SO_NUMBER',
1969: avalue =>porder_no);
1970:

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

2109: --ENDED CODE FOR ML SUPPLY
2110:
2111:
2112: lstmt := 81;
2113: wf_engine.SetItemAttrTextArray(ItemType =>'CTOCHORD',ItemKey=>litem_key,aname=>l_aname,avalue=>l_atxtvalue);
2114:
2115: -- Added by Renga on 02/17/01
2116: -- Set the special text attribute to null in case of SL/SO. This special text needs to be
2117: -- Displayed only in the case of ML/MO. In the case of ML/MO we need not set this attribute . This

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

2122: oe_debug_pub.add('start_work_flow: ' || 'Single level single org model, Special text is set to Null',5);
2123: END IF;
2124:
2125: lstmt := 82;
2126: wf_engine.SetItemAttrText(ItemType=>'CTOCHORD',itemkey=>litem_key,aname=>'SPL_TEXT',avalue=>'');
2127:
2128: END IF;
2129:
2130: -- Calling the work flow

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

2131: lstmt := 80;
2132: IF PG_DEBUG <> 0 THEN
2133: oe_debug_pub.add('start_work_flow: ' || 'Starting the workflow...',2);
2134: END IF;
2135: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
2136: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
2137:
2138: IF PG_DEBUG <> 0 THEN
2139: oe_debug_pub.add('start_work_flow: ' || 'success from ..... notification....',5);

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

2132: IF PG_DEBUG <> 0 THEN
2133: oe_debug_pub.add('start_work_flow: ' || 'Starting the workflow...',2);
2134: END IF;
2135: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
2136: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
2137:
2138: IF PG_DEBUG <> 0 THEN
2139: oe_debug_pub.add('start_work_flow: ' || 'success from ..... notification....',5);
2140: END IF;