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: l_enterprise_name VARCHAR2(10000);
948: BEGIN
949: IF p_is_invited = 'Y' THEN
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
1046:
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';
1129: l_itemkey := gen_wf_item_key(p_registration_id,'invite');
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';
1188: l_itemkey := gen_wf_item_key(p_registration_id,'reject');