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 52: AND NVL (wf_assign.wf_item_type, oe_globals.g_wfi_hdr) =

48: AND header.order_type_id = wf_assign.order_type_id
49: AND SYSDATE >= wf_assign.start_date_active
50: AND TRUNC (SYSDATE) <= NVL (wf_assign.end_date_active, SYSDATE)
51: AND wf_assign.line_type_id IS NULL
52: AND NVL (wf_assign.wf_item_type, oe_globals.g_wfi_hdr) =
53: oe_globals.g_wfi_hdr;
54:
55: /* NEED UPGRADE ON NEW COLUMN? */
56: CURSOR find_lineprocessname

Line 82: AND wf_assign.wf_item_type = oe_globals.g_wfi_ngo

78: WHERE header.header_id = TO_NUMBER (itemkey)
79: AND header.order_type_id = wf_assign.order_type_id
80: AND SYSDATE >= wf_assign.start_date_active
81: AND TRUNC (SYSDATE) <= NVL (wf_assign.end_date_active, SYSDATE)
82: AND wf_assign.wf_item_type = oe_globals.g_wfi_ngo
83: AND wf_assign.line_type_id IS NULL;
84:
85: CURSOR find_bktngohdrprocessname (itemkey VARCHAR2)
86: IS

Line 94: AND wf_assign.wf_item_type = oe_globals.g_wfi_ngo

90: WHERE header.header_id = TO_NUMBER (itemkey)
91: AND header.order_type_id = wf_assign.order_type_id
92: AND SYSDATE >= wf_assign.start_date_active
93: AND TRUNC (SYSDATE) <= NVL (wf_assign.end_date_active, SYSDATE)
94: AND wf_assign.wf_item_type = oe_globals.g_wfi_ngo
95: AND wf_assign.line_type_id IS NULL;
96:
97: CURSOR find_blankethdrprocessname (itemkey VARCHAR2)
98: IS

Line 106: AND wf_assign.wf_item_type = oe_globals.g_wfi_bkt

102: WHERE blanket.header_id = TO_NUMBER (itemkey)
103: AND blanket.order_type_id = wf_assign.order_type_id
104: AND SYSDATE >= wf_assign.start_date_active
105: AND TRUNC (SYSDATE) <= NVL (wf_assign.end_date_active, SYSDATE)
106: AND wf_assign.wf_item_type = oe_globals.g_wfi_bkt
107: AND wf_assign.line_type_id IS NULL;
108:
109: --
110: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 242: FROM wf_item_activity_statuses

238: -- if viewing method is through URL
239: -- fix bug 1332384
240: SELECT item_key, item_type
241: INTO l_item_key, l_item_type --l_header_id ame er 16084377
242: FROM wf_item_activity_statuses
243: WHERE notification_id = TO_NUMBER (document_id);
244: EXCEPTION
245: WHEN NO_DATA_FOUND
246: THEN

Line 251: FROM wf_item_activity_statuses_h

247: -- Begin Changes for bug 8570400
248: BEGIN
249: SELECT item_key, item_type
250: INTO l_item_key, l_item_type --l_header_id ame er 16084377
251: FROM wf_item_activity_statuses_h
252: WHERE notification_id = TO_NUMBER (document_id);
253: EXCEPTION
254: WHEN TOO_MANY_ROWS
255: THEN

Line 376: FROM wf_item_activity_statuses

372: -- if viewing method is through URL
373: -- fix bug 1332384
374: SELECT item_key
375: INTO l_line_id
376: FROM wf_item_activity_statuses
377: WHERE notification_id = TO_NUMBER (document_id);
378: EXCEPTION
379: WHEN NO_DATA_FOUND
380: THEN

Line 385: FROM wf_item_activity_statuses_h

381: -- Begin Changes for bug 8570400
382: BEGIN
383: SELECT item_key
384: INTO l_line_id
385: FROM wf_item_activity_statuses_h
386: WHERE notification_id = TO_NUMBER (document_id);
387: EXCEPTION
388: WHEN TOO_MANY_ROWS
389: THEN

Line 613: FROM wf_items

609: -- For OENH
610: -- Check if a OENH flow exists, if so set the parent
611: SELECT COUNT (1)
612: INTO l_count
613: FROM wf_items
614: WHERE item_type = oe_globals.g_wfi_ngo
615: AND item_key = TO_CHAR (p_header_rec.header_id);
616:
617: IF l_count > 0

Line 619: wf_item.set_item_parent (oe_globals.g_wfi_hdr,

615: AND item_key = TO_CHAR (p_header_rec.header_id);
616:
617: IF l_count > 0
618: THEN
619: wf_item.set_item_parent (oe_globals.g_wfi_hdr,
620: TO_CHAR (p_header_rec.header_id),
621: oe_globals.g_wfi_ngo,
622: TO_CHAR (p_header_rec.header_id),
623: ''

Line 792: l_item_type := oe_order_wf_util.get_wf_item_type (p_line_rec);

788:
789: createstart_linefork (p_line_rec);
790: ELSE -- Regular Flow creation
791: -- Get Wf itme type
792: l_item_type := oe_order_wf_util.get_wf_item_type (p_line_rec);
793:
794: IF l_debug_level > 0
795: THEN
796: oe_debug_pub.ADD ('IN CREATESTART_LINEPROCESS');

Line 972: wf_item.set_item_parent (oe_globals.g_wfi_lin,

968: p_line_rec.line_id,
969: l_aname2,
970: l_avaluetext
971: );
972: wf_item.set_item_parent (oe_globals.g_wfi_lin,
973: TO_CHAR (p_line_rec.line_id),
974: oe_globals.g_wfi_hdr,
975: TO_CHAR (p_line_rec.header_id),
976: '',

Line 1042: FUNCTION get_wf_item_type (p_line_rec IN oe_order_pub.line_rec_type)

1038: RAISE fnd_api.g_exc_unexpected_error;
1039: END IF;
1040: END create_linefork;
1041:
1042: FUNCTION get_wf_item_type (p_line_rec IN oe_order_pub.line_rec_type)
1043: RETURN VARCHAR2
1044: IS
1045: l_item_rec oe_order_cache.item_rec_type;
1046: --

Line 1135: fnd_message.set_name ('ONT', 'OE_INVALID_WF_ITEM_TYPE');

1131: ELSIF (p_line_rec.item_type_code = oe_globals.g_item_service)
1132: THEN
1133: RETURN 'SERVICE';
1134: ELSE
1135: fnd_message.set_name ('ONT', 'OE_INVALID_WF_ITEM_TYPE');
1136: oe_msg_pub.ADD;
1137: RAISE fnd_api.g_exc_error;
1138: END IF;
1139: EXCEPTION

Line 1144: oe_msg_pub.add_exc_msg (g_pkg_name, 'Get_Wf_Item_Type');

1140: WHEN OTHERS
1141: THEN
1142: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
1143: THEN
1144: oe_msg_pub.add_exc_msg (g_pkg_name, 'Get_Wf_Item_Type');
1145: END IF;
1146:
1147: RAISE fnd_api.g_exc_unexpected_error;
1148: END get_wf_item_type;

Line 1148: END get_wf_item_type;

1144: oe_msg_pub.add_exc_msg (g_pkg_name, 'Get_Wf_Item_Type');
1145: END IF;
1146:
1147: RAISE fnd_api.g_exc_unexpected_error;
1148: END get_wf_item_type;
1149:
1150: -- This procedure starts flows for all the Header and Line records created in a Process Order
1151: -- Transaction. The WF item has been created when the record is written to the db - post_write
1152: -- processing.

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

1147: RAISE fnd_api.g_exc_unexpected_error;
1148: END get_wf_item_type;
1149:
1150: -- This procedure starts flows for all the Header and Line records created in a Process Order
1151: -- Transaction. The WF item has been created when the record is written to the db - post_write
1152: -- processing.
1153: PROCEDURE start_all_flows
1154: IS
1155: ctr NUMBER;

Line 1304: oe_order_wf_util.get_wf_item_type (l_line_rec);

1300: (ctr).line_id,
1301: x_line_rec => l_line_rec
1302: );
1303: l_item_type :=
1304: oe_order_wf_util.get_wf_item_type (l_line_rec);
1305: create_lineworkitem (l_line_rec, l_item_type);
1306: END IF; -- if post_write_ato_line_id <> l_ato_line_id
1307: END IF; -- item_type = CLASS
1308:

Line 1478: FROM wf_items

1474: THEN
1475: -- Start of 12609242
1476: SELECT COUNT (1)
1477: INTO l_count
1478: FROM wf_items
1479: WHERE item_type = oe_globals.g_wfi_hdr AND item_key = TO_CHAR (p_id);
1480:
1481: IF l_count > 0
1482: THEN

Line 1506: FROM wf_items

1502: END IF; --12609242
1503:
1504: SELECT COUNT (1)
1505: INTO l_count
1506: FROM wf_items
1507: WHERE item_type = oe_globals.g_wfi_ngo AND item_key = TO_CHAR (p_id);
1508:
1509: IF l_count > 0
1510: THEN

Line 1529: FROM wf_items

1525: THEN
1526: -- Start of 12609242
1527: SELECT COUNT (1)
1528: INTO l_count
1529: FROM wf_items
1530: WHERE item_type = oe_globals.g_wfi_lin
1531: AND item_key = TO_CHAR (p_id);
1532:
1533: IF l_count > 0

Line 1552: oe_debug_pub.ADD ('PURGING WF ITEM');

1548: END IF;
1549:
1550: IF l_debug_level > 0
1551: THEN
1552: oe_debug_pub.ADD ('PURGING WF ITEM');
1553: END IF;
1554:
1555: wf_purge.items (itemtype => oe_globals.g_wfi_lin,
1556: itemkey => p_id,

Line 1567: FROM wf_items

1563: THEN
1564: --Start of 13020709
1565: SELECT COUNT (1)
1566: INTO l_count
1567: FROM wf_items
1568: WHERE item_type = oe_globals.g_wfi_ngo AND item_key = TO_CHAR (p_id);
1569:
1570: IF l_count > 0
1571: THEN

Line 1588: oe_debug_pub.ADD ('PURGING WF ITEM - Negotiate');

1584: END IF;
1585:
1586: IF l_debug_level > 0
1587: THEN
1588: oe_debug_pub.ADD ('PURGING WF ITEM - Negotiate');
1589: END IF;
1590:
1591: wf_purge.items (itemtype => oe_globals.g_wfi_ngo,
1592: itemkey => p_id,

Line 1602: FROM wf_items

1598: THEN
1599: -- Bug 8537639
1600: SELECT COUNT (1)
1601: INTO l_count
1602: FROM wf_items
1603: --where item_type=OE_GLOBALS.G_WFI_NGO
1604: WHERE item_type = oe_globals.g_wfi_bkt --13020709
1605: AND item_key = TO_CHAR (p_id);
1606:

Line 1625: oe_debug_pub.ADD ('PURGING WF ITEM - BLANKET');

1621: END IF;
1622:
1623: IF l_debug_level > 0
1624: THEN
1625: oe_debug_pub.ADD ('PURGING WF ITEM - BLANKET');
1626: END IF;
1627:
1628: wf_purge.items (itemtype => oe_globals.g_wfi_bkt,
1629: itemkey => p_id,

Line 1638: FROM wf_items

1634: /* Bug 8537639 */
1635: --Uncommented below Select clause for bug 13020709
1636: SELECT COUNT (1)
1637: INTO l_count
1638: FROM wf_items
1639: WHERE item_type = oe_globals.g_wfi_ngo
1640: AND item_key = TO_CHAR (p_id);
1641:
1642: IF l_count > 0

Line 3542: FROM wf_items

3538: -- For OEBH
3539: -- Check if a OENH flow exists, if so set the parent
3540: SELECT COUNT (1)
3541: INTO l_count
3542: FROM wf_items
3543: WHERE item_type = oe_globals.g_wfi_ngo
3544: AND item_key = TO_CHAR (p_header_id);
3545:
3546: IF l_count > 0

Line 3548: wf_item.set_item_parent (oe_globals.g_wfi_bkt,

3544: AND item_key = TO_CHAR (p_header_id);
3545:
3546: IF l_count > 0
3547: THEN
3548: wf_item.set_item_parent (oe_globals.g_wfi_bkt,
3549: TO_CHAR (p_header_id),
3550: oe_globals.g_wfi_ngo,
3551: TO_CHAR (p_header_id),
3552: ''

Line 3812: -- from wf_item_activity_statuses_v

3808: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3809: BEGIN
3810: -- select ITEM_KEY, ITEM_TYPE
3811: -- into l_item_key, l_item_type
3812: -- from wf_item_activity_statuses_v
3813: -- where NOTIFICATION_ID = to_number(document_id);
3814:
3815: -- replaced with this. see bug#4930449
3816: BEGIN

Line 3819: FROM wf_item_activity_statuses

3815: -- replaced with this. see bug#4930449
3816: BEGIN
3817: SELECT item_key, item_type
3818: INTO l_item_key, l_item_type
3819: FROM wf_item_activity_statuses
3820: WHERE notification_id = TO_NUMBER (document_id);
3821: EXCEPTION
3822: WHEN NO_DATA_FOUND
3823: THEN

Line 3826: FROM wf_item_activity_statuses_h

3822: WHEN NO_DATA_FOUND
3823: THEN
3824: SELECT item_key, item_type
3825: INTO l_item_key, l_item_type
3826: FROM wf_item_activity_statuses_h
3827: WHERE notification_id = TO_NUMBER (document_id);
3828: END;
3829:
3830: /* 9047023: End */

Line 4983: FROM wf_item_activity_statuses s,

4979:
4980: CURSOR c_eligible_activity
4981: IS
4982: SELECT pa.activity_name
4983: FROM wf_item_activity_statuses s,
4984: wf_process_activities pa,
4985: wf_lookups l,
4986: wf_activities_vl act
4987: WHERE s.activity_status = l.lookup_code

Line 5006: FROM wf_item_activity_statuses wias, wf_process_activities wpa

5002:
5003: CURSOR book_eligible
5004: IS
5005: SELECT 'Y'
5006: FROM wf_item_activity_statuses wias, wf_process_activities wpa
5007: WHERE wias.item_type = 'OEOH'
5008: AND wias.item_key = p_header_id
5009: AND wias.activity_status = 'NOTIFIED'
5010: AND wpa.activity_name = 'BOOK_ELIGIBLE'

Line 5016: FROM wf_item_activity_statuses wias, wf_process_activities wpa

5012:
5013: CURSOR book_deferred
5014: IS
5015: SELECT 'Y'
5016: FROM wf_item_activity_statuses wias, wf_process_activities wpa
5017: WHERE wias.item_type = 'OEOH'
5018: AND wias.item_key = p_header_id
5019: AND wias.activity_status = 'DEFERRED'
5020: AND wpa.activity_name = 'BOOK_DEFER'