47: INTO l_count USING l_responsibility_id, l_application_id, rec_obj.action_param_set_id,
48: rec_obj.action_map_code, rec_obj.action_map_type_code;
49:
50: IF (l_count = 0) then
51: select IEU_wp_action_maps_S1.NEXTVAL into l_action_map_id from sys.dual;
52: x_msg_data :=x_msg_data || ' , INSERT INTO maps table with id '|| l_action_map_id;
53: sql_stmt := 'insert INTO IEU_wp_action_mapS'||
54: ' (WP_ACTION_MAP_ID,'||
55: ' OBJECT_VERSION_NUMBER,'||
903: END if;
904:
905:
906: --INSERT one RECORD WITH responsibility_id = -1
907: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
908: EXECUTE immediate
909: ' insert INTO IEU_WP_ACTION_MAPS ' ||
910: ' (WP_ACTION_MAP_ID, '||
911: ' CREATED_BY, '||
947: l_temp_map_sequence, r_dev_data_flag;
948:
949:
950: --INSERT one RECORD WITH responsibility_id IS null
951: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
952: v_responsibility_id := null;
953: EXECUTE immediate
954: ' insert INTO IEU_WP_ACTION_MAPS '||
955: ' (WP_ACTION_MAP_ID, '||
1640: FETCH c_cur2 INTO c_rec2;
1641: EXIT WHEN c_cur2%NOTFOUND;
1642: l_temp_map_sequence := 1;
1643: --INSERT one RECORD WITH responsibility_id = -1
1644: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
1645: EXECUTE immediate
1646: ' insert INTO IEU_WP_ACTION_MAPS '||
1647: ' (WP_ACTION_MAP_ID, '||
1648: ' CREATED_BY, '||