APPS.PO_DIFF_SUMMARY_PKG dependencies on WF_ITEMS

Line 1205: l_itemkey_like WF_ITEMS.item_key%TYPE;

1201: d_api_name CONSTANT VARCHAR2(30) := 'find_itemkey';
1202: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1203: d_position NUMBER;
1204:
1205: l_itemkey_like WF_ITEMS.item_key%TYPE;
1206: l_itemkey WF_ITEMS.item_key%TYPE;
1207:
1208: BEGIN
1209: d_position := 0;

Line 1206: l_itemkey WF_ITEMS.item_key%TYPE;

1202: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1203: d_position NUMBER;
1204:
1205: l_itemkey_like WF_ITEMS.item_key%TYPE;
1206: l_itemkey WF_ITEMS.item_key%TYPE;
1207:
1208: BEGIN
1209: d_position := 0;
1210:

Line 1219: FROM WF_ITEMS

1215: l_itemkey_like := g_ITEMKEY_PREFIX || '#' || TO_CHAR(p_draft_id) || '#%';
1216:
1217: SELECT MAX(item_key)
1218: INTO l_itemkey
1219: FROM WF_ITEMS
1220: WHERE item_type = g_ITEMTYPE
1221: AND item_key LIKE l_itemkey_like
1222: AND end_date IS NULL;
1223:

Line 1376: l_itemKey WF_ITEMS.item_key%TYPE;

1372: d_api_name CONSTANT VARCHAR2(30) := 'complete_resp_to_changes';
1373: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1374: d_position NUMBER;
1375:
1376: l_itemKey WF_ITEMS.item_key%TYPE;
1377: l_activity VARCHAR2(200);
1378: l_activity_result VARCHAR2(30);
1379:
1380: BEGIN