DBA Data[Home] [Help]

APPS.POS_USER_ADMIN_PKG dependencies on WF_ITEMS

Line 14: l_itemkey wf_items.item_key%TYPE;

10: , x_msg_data OUT NOCOPY VARCHAR2
11: )
12: IS
13: l_process wf_process_activities.process_name%TYPE;
14: l_itemkey wf_items.item_key%TYPE;
15: l_itemtype wf_items.item_type%TYPE;
16:
17: l_unencrypted_password VARCHAR2(30);
18: l_enterprise_name VARCHAR2(240);

Line 15: l_itemtype wf_items.item_type%TYPE;

11: )
12: IS
13: l_process wf_process_activities.process_name%TYPE;
14: l_itemkey wf_items.item_key%TYPE;
15: l_itemtype wf_items.item_type%TYPE;
16:
17: l_unencrypted_password VARCHAR2(30);
18: l_enterprise_name VARCHAR2(240);
19: l_resetpass BOOLEAN;

Line 956: l_itemtype wf_items.item_type%TYPE;

952: l_sec_attr_numbers po_tbl_number;
953: l_enterprise_name hz_parties.party_name%TYPE;
954: lv_exception_msg VARCHAR2(32000);
955: lv_status VARCHAR2(240);
956: l_itemtype wf_items.item_type%TYPE;
957: l_itemkey wf_items.item_key%TYPE;
958: l_process wf_process_activities.process_name%TYPE;
959: l_user_in_oid VARCHAR2(1);
960:

Line 957: l_itemkey wf_items.item_key%TYPE;

953: l_enterprise_name hz_parties.party_name%TYPE;
954: lv_exception_msg VARCHAR2(32000);
955: lv_status VARCHAR2(240);
956: l_itemtype wf_items.item_type%TYPE;
957: l_itemkey wf_items.item_key%TYPE;
958: l_process wf_process_activities.process_name%TYPE;
959: l_user_in_oid VARCHAR2(1);
960:
961: BEGIN

Line 1370: l_item_type wf_items.item_type%TYPE;

1366: l_email VARCHAR2(1000) := '';
1367: l_username VARCHAR2(500) := '';
1368: l_password VARCHAR2(100) := '';
1369: l_disp_type VARCHAR2(20) := 'text/plain';
1370: l_item_type wf_items.item_type%TYPE;
1371: l_item_key wf_items.item_key%TYPE;
1372:
1373: BEGIN
1374:

Line 1371: l_item_key wf_items.item_key%TYPE;

1367: l_username VARCHAR2(500) := '';
1368: l_password VARCHAR2(100) := '';
1369: l_disp_type VARCHAR2(20) := 'text/plain';
1370: l_item_type wf_items.item_type%TYPE;
1371: l_item_key wf_items.item_key%TYPE;
1372:
1373: BEGIN
1374:
1375: l_item_type := substr(p_document_id, 1, instr(p_document_id, ':') - 1);