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
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,
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);
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:
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
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: