APPS.PO_DIFF_SUMMARY_PKG dependencies on WF_ITEMS

Line 1224: l_itemkey_like WF_ITEMS.item_key%TYPE;

1220: d_api_name CONSTANT VARCHAR2(30) := 'find_itemkey';
1221: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1222: d_position NUMBER;
1223:
1224: l_itemkey_like WF_ITEMS.item_key%TYPE;
1225: l_itemkey WF_ITEMS.item_key%TYPE;
1226:
1227: BEGIN
1228: d_position := 0;

Line 1225: l_itemkey WF_ITEMS.item_key%TYPE;

1221: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1222: d_position NUMBER;
1223:
1224: l_itemkey_like WF_ITEMS.item_key%TYPE;
1225: l_itemkey WF_ITEMS.item_key%TYPE;
1226:
1227: BEGIN
1228: d_position := 0;
1229:

Line 1238: FROM WF_ITEMS

1234: l_itemkey_like := g_ITEMKEY_PREFIX || '#' || TO_CHAR(p_draft_id) || '#%';
1235:
1236: SELECT MAX(item_key)
1237: INTO l_itemkey
1238: FROM WF_ITEMS
1239: WHERE item_type = g_ITEMTYPE
1240: AND item_key LIKE l_itemkey_like
1241: AND end_date IS NULL;
1242:

Line 1396: l_itemKey WF_ITEMS.item_key%TYPE;

1392: d_api_name CONSTANT VARCHAR2(30) := 'complete_resp_to_changes';
1393: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1394: d_position NUMBER;
1395:
1396: l_itemKey WF_ITEMS.item_key%TYPE;
1397: l_activity VARCHAR2(200);
1398: l_activity_result VARCHAR2(30);
1399:
1400: BEGIN