APPS.OKC_REP_WF_PVT dependencies on WF_ITEMS

Line 479: l_item_key wf_items.item_key%TYPE;

475: l_item_sources ame_util.longStringList;
476: l_user_name varchar2(4000);
477: l_role_name varchar2(4000);
478: l_role_display_name varchar2(4000);
479: l_item_key wf_items.item_key%TYPE;
480: l_notified_count number;
481:
482: BEGIN
483:

Line 1831: SELECT item_key FROM wf_items

1827: l_item_sources ame_util.longStringList;
1828: l_user_names varchar2(4000);
1829:
1830: CURSOR wf_process_csr IS
1831: SELECT item_key FROM wf_items
1832: WHERE item_type=itemtype
1833: AND item_key like itemkey || '_' || '%'
1834: and end_date is null;
1835:

Line 2005: l_master_key wf_items.user_key%TYPE;

2001: l_api_name VARCHAR2(30);
2002: l_return_status VARCHAR2(1);
2003: l_msg_count NUMBER;
2004: l_msg_data VARCHAR2(2000);
2005: l_master_key wf_items.user_key%TYPE;
2006:
2007: BEGIN
2008:
2009: l_api_name := 'complete_notification';

Line 2099: l_master_key wf_items.user_key%TYPE;

2095: l_api_name VARCHAR2(30);
2096: l_return_status VARCHAR2(1);
2097: l_msg_count NUMBER;
2098: l_msg_data VARCHAR2(2000);
2099: l_master_key wf_items.user_key%TYPE;
2100: l_value VARCHAR2(1);
2101:
2102:
2103: BEGIN

Line 2191: l_master_key wf_items.user_key%TYPE;

2187: l_api_name VARCHAR2(30);
2188: l_return_status VARCHAR2(1);
2189: l_msg_count NUMBER;
2190: l_msg_data VARCHAR2(2000);
2191: l_master_key wf_items.user_key%TYPE;
2192: l_value VARCHAR2(1);
2193:
2194: CURSOR contract_attachment_exists(l_contract_id IN NUMBER,l_contract_type IN VARCHAR2, l_con_req_id IN NUMBER) IS
2195: select 'Y'