939: p_user_name IN VARCHAR2,
940: p_password IN VARCHAR2
941: )
942: IS
943: l_itemtype wf_items.item_type%TYPE;
944: l_itemkey wf_items.item_key%TYPE;
945: l_process wf_process_activities.process_name%TYPE;
946: is_osn VARCHAR2(1);
947: BEGIN
940: p_password IN VARCHAR2
941: )
942: IS
943: l_itemtype wf_items.item_type%TYPE;
944: l_itemkey wf_items.item_key%TYPE;
945: l_process wf_process_activities.process_name%TYPE;
946: is_osn VARCHAR2(1);
947: BEGIN
948: IF p_is_invited = 'Y' THEN
1017: p_vendor_name IN VARCHAR2,
1018: p_approver_role IN VARCHAR2
1019: )
1020: IS
1021: l_itemtype wf_items.item_type%TYPE;
1022: l_itemkey wf_items.item_key%TYPE;
1023: l_local_user_name wf_local_users.name%TYPE;
1024: l_process wf_process_activities.process_name%TYPE;
1025: is_osn VARCHAR2(1);
1018: p_approver_role IN VARCHAR2
1019: )
1020: IS
1021: l_itemtype wf_items.item_type%TYPE;
1022: l_itemkey wf_items.item_key%TYPE;
1023: l_local_user_name wf_local_users.name%TYPE;
1024: l_process wf_process_activities.process_name%TYPE;
1025: is_osn VARCHAR2(1);
1026: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE;
1100: p_note IN VARCHAR2,
1101: p_invitation_key IN VARCHAR2
1102: )
1103: IS
1104: l_itemtype wf_items.item_type%TYPE;
1105: l_itemkey wf_items.item_key%TYPE;
1106: l_local_user_name wf_local_users.name%TYPE;
1107: l_process wf_process_activities.process_name%TYPE;
1108: BEGIN
1101: p_invitation_key IN VARCHAR2
1102: )
1103: IS
1104: l_itemtype wf_items.item_type%TYPE;
1105: l_itemkey wf_items.item_key%TYPE;
1106: l_local_user_name wf_local_users.name%TYPE;
1107: l_process wf_process_activities.process_name%TYPE;
1108: BEGIN
1109:
1159: p_email IN VARCHAR2,
1160: p_language_code IN VARCHAR2
1161: )
1162: IS
1163: l_itemtype wf_items.item_type%TYPE;
1164: l_itemkey wf_items.item_key%TYPE;
1165: l_local_user_name wf_local_users.name%TYPE;
1166: l_process wf_process_activities.process_name%TYPE;
1167: BEGIN
1160: p_language_code IN VARCHAR2
1161: )
1162: IS
1163: l_itemtype wf_items.item_type%TYPE;
1164: l_itemkey wf_items.item_key%TYPE;
1165: l_local_user_name wf_local_users.name%TYPE;
1166: l_process wf_process_activities.process_name%TYPE;
1167: BEGIN
1168: