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.OE_ORDER_WF_UTIL dependencies on WF_ITEM

Line 49: and nvl(wf_assign.wf_item_type, OE_GLOBALS.G_WFI_HDR) = OE_GLOBALS.G_WFI_HDR;

45: and header.order_type_id = wf_assign.order_type_id
46: and sysdate >= wf_assign.start_date_active
47: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)
48: and wf_assign.line_type_id IS NULL
49: and nvl(wf_assign.wf_item_type, OE_GLOBALS.G_WFI_HDR) = OE_GLOBALS.G_WFI_HDR;
50: /* NEED UPGRADE ON NEW COLUMN? */
51:
52: CURSOR find_LineProcessname is
53: SELECT wf_assign.process_name

Line 74: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_NGO

70: WHERE header.header_id = to_number(itemkey)
71: and header.order_type_id = wf_assign.order_type_id
72: and sysdate >= wf_assign.start_date_active
73: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)
74: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_NGO
75: and wf_assign.line_type_id IS NULL;
76:
77: CURSOR find_BktNgoHdrProcessname(itemkey varchar2) is
78: SELECT wf_assign.process_name

Line 85: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_NGO

81: WHERE header.header_id = to_number(itemkey)
82: and header.order_type_id = wf_assign.order_type_id
83: and sysdate >= wf_assign.start_date_active
84: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)
85: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_NGO
86: and wf_assign.line_type_id IS NULL;
87:
88: CURSOR find_BlanketHdrProcessname(itemkey varchar2) is
89: SELECT wf_assign.process_name

Line 96: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_BKT

92: WHERE blanket.header_id = to_number(itemkey)
93: and blanket.order_type_id = wf_assign.order_type_id
94: and sysdate >= wf_assign.start_date_active
95: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)
96: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_BKT
97: and wf_assign.line_type_id IS NULL;
98:
99: --
100: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 206: FROM wf_item_activity_statuses

202: -- if viewing method is through URL
203: -- fix bug 1332384
204: SELECT item_key
205: INTO l_header_id
206: FROM wf_item_activity_statuses
207: where notification_id = to_number(document_id);
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: -- if viewing method is email

Line 283: FROM wf_item_activity_statuses

279: -- if viewing method is through URL
280: -- fix bug 1332384
281: SELECT item_key
282: INTO l_line_id
283: FROM wf_item_activity_statuses
284: where notification_id = to_number(document_id);
285: EXCEPTION
286: WHEN NO_DATA_FOUND THEN
287: -- if viewing method is email

Line 517: FROM wf_items

513: -- For OENH
514: -- Check if a OENH flow exists, if so set the parent
515: SELECT count(1)
516: INTO l_count
517: FROM wf_items
518: WHERE item_type=OE_GLOBALS.G_WFI_NGO
519: AND item_key =to_char(p_header_rec.header_id);
520:
521: IF l_count > 0 THEN

Line 522: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_HDR,

518: WHERE item_type=OE_GLOBALS.G_WFI_NGO
519: AND item_key =to_char(p_header_rec.header_id);
520:
521: IF l_count > 0 THEN
522: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_HDR,
523: to_char(p_header_rec.header_id),
524: OE_GLOBALS.G_WFI_NGO,
525: to_char(p_header_rec.header_id), '');
526: END IF;

Line 693: l_item_type := OE_Order_Wf_Util.get_wf_item_type(p_line_rec);

689: END IF;
690: CreateStart_LineFork(p_Line_rec);
691: ELSE -- Regular Flow creation
692: -- Get Wf itme type
693: l_item_type := OE_Order_Wf_Util.get_wf_item_type(p_line_rec);
694: IF l_debug_level > 0 THEN
695: oe_debug_pub.add( 'IN CREATESTART_LINEPROCESS' ) ;
696: END IF;
697: Create_LineWorkItem(p_Line_rec, l_item_type);

Line 858: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,

854: , l_aname2
855: , l_avaluetext
856: );
857:
858: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,
859: to_char(p_Line_rec.line_id),
860: OE_GLOBALS.G_WFI_HDR,
861: to_char(p_Line_rec.header_id), '',
862: true);

Line 935: FUNCTION Get_Wf_Item_type

931: END IF;
932:
933: END Create_LineFork;
934:
935: FUNCTION Get_Wf_Item_type
936: ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type
937: ) RETURN VARCHAR2
938: IS
939: l_item_rec OE_ORDER_CACHE.item_rec_type;

Line 1027: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_WF_ITEM_TYPE');

1023: RETURN 'SERVICE';
1024:
1025: ELSE
1026:
1027: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_WF_ITEM_TYPE');
1028: OE_MSG_PUB.ADD;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031:

Line 1039: 'Get_Wf_Item_Type'

1035: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1036: THEN
1037: OE_MSG_PUB.Add_Exc_Msg
1038: ( G_PKG_NAME ,
1039: 'Get_Wf_Item_Type'
1040: );
1041: END IF;
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043:

Line 1044: END Get_Wf_Item_type;

1040: );
1041: END IF;
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043:
1044: END Get_Wf_Item_type;
1045:
1046:
1047: -- This procedure starts flows for all the Header and Line records created in a Process Order
1048: -- Transaction. The WF item has been created when the record is written to the db - post_write

Line 1048: -- Transaction. The WF item has been created when the record is written to the db - post_write

1044: END Get_Wf_Item_type;
1045:
1046:
1047: -- This procedure starts flows for all the Header and Line records created in a Process Order
1048: -- Transaction. The WF item has been created when the record is written to the db - post_write
1049: -- processing.
1050: PROCEDURE Start_All_Flows
1051: IS
1052:

Line 1175: l_item_type := OE_Order_Wf_Util.get_wf_item_type(l_line_rec);

1171: OE_Line_Util.Query_Row
1172: ( p_line_id => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id
1173: ,x_line_rec => l_line_rec);
1174:
1175: l_item_type := OE_Order_Wf_Util.get_wf_item_type(l_line_rec);
1176:
1177: Create_LineWorkItem(l_line_rec, l_item_type);
1178:
1179: END IF; -- if post_write_ato_line_id <> l_ato_line_id

Line 1342: from wf_items

1338: docommit => false);
1339:
1340: select count(1)
1341: into l_count
1342: from wf_items
1343: where item_type=OE_GLOBALS.G_WFI_NGO
1344: and item_key=to_char(p_id);
1345:
1346: IF l_count > 0 THEN

Line 1371: oe_debug_pub.add( 'PURGING WF ITEM' ) ;

1367: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_LIN,
1368: itemkey => p_id);
1369: END IF;
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'PURGING WF ITEM' ) ;
1372: END IF;
1373: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_LIN,
1374: itemkey => p_id,
1375: force => TRUE,

Line 1389: oe_debug_pub.add( 'PURGING WF ITEM - Negotiate') ;

1385: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_NGO,
1386: itemkey => p_id);
1387: END IF;
1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add( 'PURGING WF ITEM - Negotiate') ;
1390: END IF;
1391: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_NGO,
1392: itemkey => p_id,
1393: force => TRUE,

Line 1405: oe_debug_pub.add( 'PURGING WF ITEM - BLANKET') ;

1401: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_BKT,
1402: itemkey => p_id);
1403: END IF;
1404: IF l_debug_level > 0 THEN
1405: oe_debug_pub.add( 'PURGING WF ITEM - BLANKET') ;
1406: END IF;
1407: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_BKT,
1408: itemkey => p_id,
1409: force => TRUE,

Line 1414: from wf_items

1410: docommit => false);
1411:
1412: select count(1)
1413: into l_count
1414: from wf_items
1415: where item_type=OE_GLOBALS.G_WFI_NGO
1416: and item_key=to_char(p_id);
1417:
1418: IF l_count > 0 THEN

Line 2778: FROM wf_items

2774: -- For OEBH
2775: -- Check if a OENH flow exists, if so set the parent
2776: SELECT count(1)
2777: INTO l_count
2778: FROM wf_items
2779: WHERE item_type=OE_GLOBALS.G_WFI_NGO
2780: AND item_key =to_char(p_header_id);
2781:
2782: IF l_count > 0 THEN

Line 2783: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_BKT,

2779: WHERE item_type=OE_GLOBALS.G_WFI_NGO
2780: AND item_key =to_char(p_header_id);
2781:
2782: IF l_count > 0 THEN
2783: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_BKT,
2784: to_char(p_header_id),
2785: OE_GLOBALS.G_WFI_NGO,
2786: to_char(p_header_id), '');
2787: END IF;

Line 3045: -- from wf_item_activity_statuses_v

3041: BEGIN
3042:
3043: -- select ITEM_KEY, ITEM_TYPE
3044: -- into l_item_key, l_item_type
3045: -- from wf_item_activity_statuses_v
3046: -- where NOTIFICATION_ID = to_number(document_id);
3047:
3048: -- replaced with this. see bug#4930449
3049: select ITEM_KEY, ITEM_TYPE

Line 3051: from WF_ITEM_ACTIVITY_STATUSES

3047:
3048: -- replaced with this. see bug#4930449
3049: select ITEM_KEY, ITEM_TYPE
3050: into l_item_key, l_item_type
3051: from WF_ITEM_ACTIVITY_STATUSES
3052: where NOTIFICATION_ID = to_number(document_id);
3053:
3054:
3055: -- Get the Sales Document Type

Line 3832: from wf_item_activity_statuses s,

3828: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3829:
3830: CURSOR c_eligible_activity IS
3831: select pa.activity_name
3832: from wf_item_activity_statuses s,
3833: wf_process_activities pa, wf_lookups l,
3834: wf_activities_vl act
3835: where s.activity_status = l.lookup_code
3836: and l.lookup_type = l_wfeng_status

Line 3852: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

3848: and act.function = l_standard_block;
3849:
3850: CURSOR book_eligible IS
3851: SELECT 'Y'
3852: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
3853: , WF_PROCESS_ACTIVITIES WPA
3854: WHERE WIAS.item_type = 'OEOH'
3855: AND WIAS.item_key = p_header_id
3856: AND WIAS.activity_status = 'NOTIFIED'

Line 3862: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

3858: AND WPA.instance_id = WIAS.process_activity;
3859:
3860: CURSOR book_deferred IS
3861: SELECT 'Y'
3862: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
3863: , WF_PROCESS_ACTIVITIES WPA
3864: WHERE WIAS.item_type = 'OEOH'
3865: AND WIAS.item_key = p_header_id
3866: AND WIAS.activity_status = 'DEFERRED'