319: p_email IN VARCHAR2,
320: p_language_code IN VARCHAR2
321: )
322: IS
323: l_local_user_name wf_local_users.name%TYPE;
324: l_display_name wf_local_users.display_name%TYPE;
325: l_nls_lang fnd_languages.nls_language%TYPE;
326: BEGIN
327:
320: p_language_code IN VARCHAR2
321: )
322: IS
323: l_local_user_name wf_local_users.name%TYPE;
324: l_display_name wf_local_users.display_name%TYPE;
325: l_nls_lang fnd_languages.nls_language%TYPE;
326: BEGIN
327:
328: SELECT nls_language
1037: )
1038: IS
1039: l_itemtype wf_items.item_type%TYPE;
1040: l_itemkey wf_items.item_key%TYPE;
1041: l_local_user_name wf_local_users.name%TYPE;
1042: l_process wf_process_activities.process_name%TYPE;
1043: is_osn VARCHAR2(1);
1044: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE;
1045: BEGIN
1120: )
1121: IS
1122: l_itemtype wf_items.item_type%TYPE;
1123: l_itemkey wf_items.item_key%TYPE;
1124: l_local_user_name wf_local_users.name%TYPE;
1125: l_process wf_process_activities.process_name%TYPE;
1126: BEGIN
1127:
1128: l_itemtype := 'POSREGV2';
1179: )
1180: IS
1181: l_itemtype wf_items.item_type%TYPE;
1182: l_itemkey wf_items.item_key%TYPE;
1183: l_local_user_name wf_local_users.name%TYPE;
1184: l_process wf_process_activities.process_name%TYPE;
1185: BEGIN
1186:
1187: l_itemtype := 'POSREGV2';