APPS.INV_LOT_SERIAL_DATE_PKG dependencies on WF_ITEM

Line 8: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'INVDATNT';

4: FUNCTION date_rule (p_subscription_guid IN RAW,
5: p_event IN OUT NOCOPY wf_event_t) RETURN VARCHAR2
6: IS
7:
8: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'INVDATNT';
9: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := p_event.getEventKey;
10:
11: l_errname VARCHAR2(30);
12: l_errmsg VARCHAR2(2000);

Line 9: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := p_event.getEventKey;

5: p_event IN OUT NOCOPY wf_event_t) RETURN VARCHAR2
6: IS
7:
8: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'INVDATNT';
9: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := p_event.getEventKey;
10:
11: l_errname VARCHAR2(30);
12: l_errmsg VARCHAR2(2000);
13: l_errstack VARCHAR2(32000);

Line 27: IF (WF_ITEM.ITEM_EXIST (l_itemtype, l_itemkey)) THEN

23:
24: /*Check if the workflow data exists and remove the same for the itemtype and itemkey
25: combination */
26: BEGIN
27: IF (WF_ITEM.ITEM_EXIST (l_itemtype, l_itemkey)) THEN
28:
29: /* Check item status */
30: WF_ENGINE.ITEMSTATUS ( itemtype => l_itemtype,
31: itemkey => l_itemkey,

Line 35: -- wf_item_activity_status.root_status (l_itemtype, l_itemkey, l_status, l_result);

31: itemkey => l_itemkey,
32: status => l_status,
33: result => l_result);
34:
35: -- wf_item_activity_status.root_status (l_itemtype, l_itemkey, l_status, l_result);
36: /* If it is not completed then abort the process */
37: IF (l_status <> 'COMPLETE')THEN
38:
39: WF_ENGINE.ABORTPROCESS (itemtype=> l_itemtype,