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
949: l_process := 'SEND_APPRV_INV_USER_NTF';
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;
1027: BEGIN
1028:
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:
1110: l_itemtype := 'POSREGV2';
1111: l_itemkey := gen_wf_item_key(p_registration_id,'invite');
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:
1169: l_itemtype := 'POSREGV2';
1170: l_itemkey := gen_wf_item_key(p_registration_id,'reject');