DBA Data[Home] [Help]

APPS.OE_NOTIFY_USER_WF dependencies on WF_ENGINE

Line 55: l_header_id := wf_engine.getItemAttrNumber('OENF', p_item_key, 'HEADER_ID');

51:
52: BEGIN
53:
54: -- Fetch the item attributes
55: l_header_id := wf_engine.getItemAttrNumber('OENF', p_item_key, 'HEADER_ID');
56: l_line_id := wf_engine.getItemAttrNumber('OENF', p_item_key, 'LINE_ID');
57: l_event_type := wf_engine.getItemAttrText('OENF', p_item_key, 'STATUS_CODE');
58:
59: -- Query the header information and build the header section

Line 56: l_line_id := wf_engine.getItemAttrNumber('OENF', p_item_key, 'LINE_ID');

52: BEGIN
53:
54: -- Fetch the item attributes
55: l_header_id := wf_engine.getItemAttrNumber('OENF', p_item_key, 'HEADER_ID');
56: l_line_id := wf_engine.getItemAttrNumber('OENF', p_item_key, 'LINE_ID');
57: l_event_type := wf_engine.getItemAttrText('OENF', p_item_key, 'STATUS_CODE');
58:
59: -- Query the header information and build the header section
60: Oe_header_util.Query_Row(p_header_id => l_header_id,

Line 57: l_event_type := wf_engine.getItemAttrText('OENF', p_item_key, 'STATUS_CODE');

53:
54: -- Fetch the item attributes
55: l_header_id := wf_engine.getItemAttrNumber('OENF', p_item_key, 'HEADER_ID');
56: l_line_id := wf_engine.getItemAttrNumber('OENF', p_item_key, 'LINE_ID');
57: l_event_type := wf_engine.getItemAttrText('OENF', p_item_key, 'STATUS_CODE');
58:
59: -- Query the header information and build the header section
60: Oe_header_util.Query_Row(p_header_id => l_header_id,
61: x_header_rec =>l_header_rec);

Line 329: l_line_id := wf_engine.getItemAttrNumber('OENF', itemkey, 'LINE_ID');

325:
326: IF (funcmode = 'RUN') THEN
327:
328: -- Fetch the item attributes
329: l_line_id := wf_engine.getItemAttrNumber('OENF', itemkey, 'LINE_ID');
330: l_event_type := wf_engine.getItemAttrText('OENF', itemkey, 'STATUS_CODE'); --10277829
331:
332: -- No notifications for header events
333:

Line 330: l_event_type := wf_engine.getItemAttrText('OENF', itemkey, 'STATUS_CODE'); --10277829

326: IF (funcmode = 'RUN') THEN
327:
328: -- Fetch the item attributes
329: l_line_id := wf_engine.getItemAttrNumber('OENF', itemkey, 'LINE_ID');
330: l_event_type := wf_engine.getItemAttrText('OENF', itemkey, 'STATUS_CODE'); --10277829
331:
332: -- No notifications for header events
333:
334: IF l_line_id IS NOT NULL THEN

Line 431: l_header_id := wf_engine.getItemAttrNumber('OENF', itemkey, 'HEADER_ID');

427:
428: resultout := 'COMPLETE';
429:
430: -- Fetch the item attributes
431: l_header_id := wf_engine.getItemAttrNumber('OENF', itemkey, 'HEADER_ID');
432:
433: -- Fetch the profile setup information
434: l_cust_type := Nvl(fnd_profile.value('ONT_EXTERNAL_CUST_USAGE_TYPE'), 'CUSTOMER_ID');
435: