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);
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;
906: l_sec_attr_numbers po_tbl_number;
907: l_enterprise_name hz_parties.party_name%TYPE;
908: lv_exception_msg VARCHAR2(32000);
909: lv_status VARCHAR2(240);
910: l_itemtype wf_items.item_type%TYPE;
911: l_itemkey wf_items.item_key%TYPE;
912: l_process wf_process_activities.process_name%TYPE;
913: l_user_in_oid VARCHAR2(1);
914:
907: l_enterprise_name hz_parties.party_name%TYPE;
908: lv_exception_msg VARCHAR2(32000);
909: lv_status VARCHAR2(240);
910: l_itemtype wf_items.item_type%TYPE;
911: l_itemkey wf_items.item_key%TYPE;
912: l_process wf_process_activities.process_name%TYPE;
913: l_user_in_oid VARCHAR2(1);
914:
915: BEGIN